SQL Training Course

About Course

This comprehensive SQL course is designed to equip you with the knowledge and skills to work confidently with databases. It covers topics from basic SQL commands to advanced querying techniques.

Whether you are a beginner or a professional seeking to enhance your skill, this course provides hands-on approaches to help you apply your learning. By the end of this course, you will be able to create and manage databases, extract meaningful insights from data, and advance your career in data-driven field.

Training Course Features

Comprehensive lessons: The training course covers basic to advanced topics like SQL syntax and basic queries, data manipulation, aggregation, filtering, grouping, SQL joins, subqueries, among others, with hands-on exercises and real-world examples.

Self-paced learning: The training course offers flexible online access to fit your schedule and learning pace.

Expert instructors: Through the training course, you will learn from industry professionals with years of experience.

Certificate of completion: With the certificate that we will offer to you after successfully completing the training course, you can showcase your SQL proficiency to boost your career.

Accessible exercise files: In the training course, you will be granted access to some exercise files which will help you to practise your learnings.

Course Content

Lesson 1: Introduction to SQL
Lesson 2: MySQL Software for Database Management
Lesson 3: How to Download and Install MySQL
Lesson 4a: Common Terms in SQL- Part 1
Lesson 4b: Common Terms in SQL- Part 2
Lesson 4c: Common Terms in SQL- Part 3
Lesson 5: Comments in SQL
Lesson 6: Operators in SQL
Lesson 7: Data Types in SQL
Lesson 8: Overview of MySQL Workbench Interface
Lesson 9: How to Create and Remove a Database in MySQL
Lesson 10: How to Create, Modify and Delete a Table in MySQL
Lesson 11: How to Insert Data or Records into a Table in MySQL
Lesson 12: How to Update the Data or Records in a Table
Lesson 13: How to Delete Data or Record from a Table
Lesson 14: Querying or Retrieving Data using SELECT Statement with LIMIT and DISTINCT Keywords
Lesson 15: Using SELECT Statement with Aggregate Functions (COUNT, MAX, MIN, AVG, SUM)
Lesson 16: Using DISTINCT with COUNT keyword in SELECT statement
Lesson 17: The GROUP BY clause
Lesson 18: Sorting Records using the ORDER BY Clause
Lesson 19: Using HAVING keyword with the GROUP BY clause
Lesson 20: Filtering Results Using the WHERE Statement
Lesson 21: Using Logical Operators (AND, OR) with WHERE Statement
Lesson 22: Using BETWEEN, IN, IS NULL and IS NOT NULL Operators with WHERE Clause
Lesson 23: Using LIKE Operator with WHERE Clause for Pattern Matching
Lesson 24: Using JOIN Clause to Combine or Merge Tables (Part 1)
Lesson 25: Using JOIN Clause to Combine or Merge Tables (Part 2)
Lesson 26: Using JOIN Clause to Combine or Merge Tables (Part 3)
Lesson 27: How to Import Dataset into MySQL
Lesson 28: Modifying the Table Structure of Imported Dataset in MySQL
Lesson 29: Using “UNION” and “UNION ALL” in SQL
Lesson 30: Saving SQL Script and Exporting Result Output
Quiz: SQL Training Course

About Course

What Will You Learn?

Course Content

SQL Training Course

Lesson 1: Introduction to SQL

Lesson 2: MySQL Software for Database Management

Lesson 3: How to Download and Install MySQL

Lesson 4a: Common Terms in SQL- Part 1

Lesson 4b: Common Terms in SQL- Part 2

Lesson 4c: Common Terms in SQL- Part 3

Lesson 5: Comments in SQL

Lesson 6: Operators in SQL

Lesson 7: Data Types in SQL

Lesson 8: Overview of MySQL Workbench Interface

Lesson 9: How to Create and Remove a Database in MySQL

Lesson 10: How to Create, Modify and Delete a Table in MySQL

Lesson 11: How to Insert Data or Records into a Table in MySQL

Lesson 12: How to Update the Data or Records in a Table

Lesson 13: How to Delete Data or Record from a Table

Lesson 14: Querying or Retrieving Data using SELECT Statement with LIMIT and DISTINCT Keywords

Lesson 15: Using SELECT Statement with Aggregate Functions (COUNT, MAX, MIN, AVG, SUM)

Lesson 16: Using DISTINCT with COUNT keyword in SELECT statement

Lesson 17: The GROUP BY clause

Lesson 18: Sorting Records using the ORDER BY Clause

Lesson 19: Using HAVING keyword with the GROUP BY clause

Lesson 20: Filtering Results Using the WHERE Statement

Lesson 21: Using Logical Operators (AND, OR) with WHERE Statement

Lesson 22: Using BETWEEN, IN, IS NULL and IS NOT NULL Operators with WHERE Clause

Lesson 23: Using LIKE Operator with WHERE Clause for Pattern Matching

Lesson 24: Using JOIN Clause to Combine or Merge Tables (Part 1)

Lesson 25: Using JOIN Clause to Combine or Merge Tables (Part 2)

Lesson 26: Using JOIN Clause to Combine or Merge Tables (Part 3)

Lesson 27: How to Import Dataset into MySQL

Lesson 28: Modifying the Table Structure of Imported Dataset in MySQL

Lesson 29: Using “UNION” and “UNION ALL” in SQL

Lesson 30: Saving SQL Script and Exporting Result Output

Quiz: SQL Training Course