Courses Information

This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle.This course teaches you everything you need to know to begin working with databases today!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - MySQL . These skills are also applicable to any other major SQL database, such as PostgreSQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Curriculum

Module 1 - Introduction to Basic Database Concepts

Module 2 – Introduction to SQL

Module 3 – DDL and DML Statements

Module 4 – Working with Queries (DQL)

Module 5 – Aggregate Functions

Module 6 – Joins and Set Operations

Module 7 – Implementing Views

Module 8 – Data Control language (DCL)

Module 9 – Working with Indexes

Module 10 – Transaction Control Language (TCL)

Module 11 – Working with Stored Procedures

Module 12 – Implementing Triggers

Module 13 – Built-in functions in SQL

Module 14 – Backup and Restore

Module 15 – Introduction to PL/SQL

Module 16 – PL/SQL Program Structure

Module 17 – Loop

Module 18 – Exception Handlers

Module 19 – Data Retrieval

Module 20 – Procedures, Functions, and Parameters

Module 21 – Triggers

Module 22 – Using and Managing Packages

Module 23 - Debugging PL/SQL Programs