SQL Mastering Training Course

Categories: database, Featured

Course Content

Getting Started

Database and Database Management System

05:32
What is MySQL?

02:22
What is SQL?

03:30
Different ways we can setup a MySQL Environment

07:12
Downloading and Installing MySQL Server and Workbench

13:00
Downloading and Installing XAMPP Server

08:44

Databases and Tables

Retrieving data from single table

Select Statement

05:37
Using SQL Expressions

06:02
WHERE clause

09:28
Logical Operators (AND, OR, & NOT)

00:00
IN Operator

05:35
Between Operator

04:11
Like Operator

12:30
REGEXP – Regular Expressions

13:00
IS NULL

04:30
ORDER BY Clause

09:24
Limit Clause

06:11

Retrieving Data From Multiple Tables

Inner Join

15:00
Joining Across Databases

03:00
Self Join

06:45
Joining Multiple Tables

12:47
Implicit Join Syntax

03:00
Outer Join (Left / Right)

09:16
Outer Join on Multiple Tables

16:00
Self Outer Join

05:44
Using Clause

10:23
Natural Join

02:31
Cross Join

07:27
Union Operator

05:00

Inserting, Updating, and Deleting Data

Insert Single Row – Method 1

10:26
Insert Single Row Method -2

06:14
Insert Multiple Rows

05:00
Insert Hierarchical Data

08:00
Creating Copy of a table

03:00
Subqueries with Insert

02:18
Updating a Row

04:49
Update Multiple Rows

06:51
Update with Subquery

05:25
Deleting a Row

02:44

Summarizing Data

Writing Complex Query

Essential MySQL Functions

Views

Stored Procedures