Mastering SQL: From Basics to Advanced Techniques

Our dynamic course takes you on an immersive journey, unveiling the intricacies of SQL and its vast applications. From mastering the fundamentals to exploring advanced techniques, SQL Mastery ensures you gain the expertise needed for success in today's data-driven landscape. Begin with SQL basics, learning data retrieval, manipulation, and database management. Progress to advanced topics such as joins, subqueries, stored procedures, and optimization techniques. Explore practical applications in data analytics, reporting, and database administration, gaining hands-on experience. This course offers comprehensive training in SQL's principles and applications.

What's Inside

Course Curriculum

Introduction to SQL

Introduction to SQL - 18:30
Start

MYSQL Workbench Installation

Importing SQL files in Workbench

Importing SQL files in Workbench - 3:25
Start

Create Database

Create Database - 33:51
Start

Import Export - DB Backup

Import Export - DB Backup - 17:38
Start

Alter

Alter - 16:51
Start

Select

Select - 31:47
Start

SQL Functions - Order By, Limit

SQL Functions - Order By, Limit - 5:02
Start

Group By

Group By - 4:05
Start

Having

Having - 3:59
Start

Union

Union - 4:17
Start

Insert

Insert - 8:46
Start

Update and Delete Document

Update and Delete Document - 6:14
Start

Like and ILike (Wildcards)

Like and ILike (Wildcards) - 6:30
Start

SQL Joins

SQL Joins - 4:58
Start

Joins

Joins - 13:23
Start

Inner Join

Inner Join - 7:47
Start

Full Outer Join

Full Outer Join - 4:08
Start

Left Outer Join

Left Outer Join - 5:27
Start

Right Outer Join

Right Outer Join - 4:18
Start

SQL Query Optimization

SQL Query Optimization - 8:40
Start

Common Table Expression (CTE)

Common Table Expression (CTE) - 4:24
Start

Clustered and Non Clustered Index

Clustered and Non Clustered Index - 3:28
Start

Aggregate Functions in SQL

Aggregate functions in SQL - 5:21
Start

Numeric and Temporal Functions

Numeric and Temporal Functions - 21:40
Start

String Functions

String Functions - 26:48
Start

Window Functions

Subqueries

Subqueries - 5:24
Start

Temporary Tables

Temporary Tables - 5:47
Start

Types of Normal Forms

Collections and Documents

Collections and Documents - 11:56
Start

Coalesce & IFnull

Coalesce & IFnull - 4:31
Start

AWS RDS

AWS RDS - 19:08
Start

Database Normalization

Database Normalization - 5:48
Start

Introduction to MongoDB (Installation)

Introduction to MongoDB (Installation) - 12:15
Start

Datatypes, Insert and Query Documents in MongoDB Database

Datatypes, Insert and Query Documents in MongoDB Database - 9:11
Start

Introduction to NoSQL and its Significance

Introduction to NoSQL and its Significance - 10:57
Start

Introduction to Reliability

Introduction to Reliability - 34:03
Start

JSON & its Features

JSON & its Features - 9:31
Start

JSON Datatypes

JSON Datatypes - 11:04
Start

Large Databases and Clustering

Large Databases and Clustering - 29:15
Start

Metadata

Metadata - 29:15
Start

Privileges and Roles

Privileges and Roles - 14:55
Start

Server Client Configurations

Server Client Configurations - 18:48
Start

SQL Views

SQL Views - 5:23
Start

Transactions and Locking

Triggers

Cloud Exposure Fetching data

Cloud Exposure Fetching data - 7:59
Start

Case Statement

Case Statement - 6:41
Start

Quiz

Quiz
Start

Get started now!