Course Content
Getting Started
0/6
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
0/5
Creating and Deleting Databases
07:00
Understanding about database tables
05:40
Creating database tables
09:29
Changing the structure of the table
08:00
Creating All Demo Databases
02:08
Retrieving data from single table
0/11
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
0/12
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
0/10
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
0/4
Group By Clause
04:17
Aggregate Functions
08:24
Having Clause
03:14
Rollup Operator
02:00
Writing Complex Query
0/4
Subqueries
07:36
IN Operator
09:00
JOIN vs SUBQUERY
14:40
ALL Keyword
05:36
Essential MySQL Functions
0/5
Numeric Functions
05:10
String Methods
15:14
Date and Time Functions
05:10
Formatting Date and Time
04:34
Date and Time Calculation
04:22
Views
0/4
Understanding Views
04:41
Creating Views
06:20
Dropping or Altering A Views
05:30
Updatable Views
11:18
Stored Procedures
0/5
Creating and Using Stored Procedure
07:22
Dropping Stored Procedure
02:46
Using Parameters
12:13
Default Parameters
03:39
Parameter Validation
13:55
SQL Mastering Training Course
Previous
Next
0% Complete