About Course

Structured query language (SQL) is the language of databases. Whether you run reports or provide a dynamic website, you need to know SQL to add, delete, edit and view records. Databases organize and collect your data, and the SQL language is the liaison between you and the data. The role of database administrator includes several functions that you should know. You should know how to create and design tables, manipulate your data and run reports, create small programs (stored procedures) and use more advanced concepts such as transactional support and cursors
his course provides a step-by-step overview and instructions that help you get started with the SQL language. We use MySQL, but you can use this course to get started with understanding data structures and techniques for all SQL engines including Access, Oracle and MSSQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT. Then, we show you how to create and design tables. We show you how to create stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.

Whether you’re new to database administration or want to create customized, personal reports for your online business, this course shows you how to get started and helps you understand the SQL language from the ground up.

Show More

What Will You Learn?

  • Demonstrate retrieving data.
  • Demonstrate updating data.
  • Demonstrate inserting data.
  • Demonstrate deleting data.
  • Demonstrate sorting and filtering data.
  • Demonstrate summarizing data.
  • Demonstrate grouping data.
  • Demonstrate using sub-queries.
  • Demonstrate joining tables.
  • Demonstrate using views. Demonstrate using stored procedures, cursors, and transactions
  • Demonstrate mastery of lesson content at levels of 70% or higher.
  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and MySQL on their resume
  • Learn to perform GROUP BY statements
  • Replicate real-world situations and query reports

Course Content

Gives the overview of the the course and database environment

  • Introduction to DBMS
  • What is DBMS
  • Setting up the Environment for MySQL
  • Introduction to SQL Quiz

SQL Database
Guide into how to create and modify the database using SQL

SQL statements
Gives the indepth understanding for SQL programming languages

Student Ratings & Reviews

No Review Yet
No Review Yet
ZK250 ZK350

Material Includes

  • Videos
  • Articles
  • Quiz


  • Internet Connection
  • Basic Knowledge of Computers
  • Dedication


  • Students learning DBMS
  • Database Administrators
  • Website Designers and programmers
  • Anyone with interest to learn programming with SQL

Want to receive push notifications for all major on-site activities?