arrow_back
Course Introduction
Course Introduction
Course Curriculum overview
Overview of Databases
SQL Environment Setup
MySQL Installation
MySQL Workbench Installation
Connecting to MySQL using Console
SQL Statement Basics
Overview of Challenges
SQL Statement Basic
Select Statement
Select Distinct
Column AS Statement
Count function
Filtering Data rows for Analysis
Select Where Here Clause – One
Select Where Clause – Two
Order by
Limit
Between
In Operator
Like and ILike
GROUP BY Statements
Overview of Group by
Aggregation function Sum()
Aggregation Min() and Max()
Group By - One
Group By – Two
Having Clause
Task on Having
Sol of Task on Having
Assessment Test 1
Overview Assessment
Join Assignment
Solution for Joins Assignment
JOINS
Overview of JOINS
Introduction to JOINS
AS Statement table
Inner Join
Full Outer Join
Left Outer Join
Right Join
Union
Advanced SQL Commands
Basic of Advanced SQL Commands
Timestamps
Extract from timestamp
Mathematical Functions
String Functions
Subquery
Creating Database and Tables
Basic of Database and Tables
DataTypes
Primarykey and Foreignkey
Create Table in SQL Script
MySQL CRUD Operations
Insert
Update
Delete
Alter Table
Drop Table
MySQL Constraints
Not Null Constraint
Unique Constraint
Databases and Tables
Overview of Databases and Tables
Backup database using phpMyAdmin
Restoring a Database