Analyzer Mode
Where Data Meets Intelligence
Home
Courses
Log in
Sign up
Meet The Analyzer
Home
Data & AI Courses
Learn SQL
Learn SQL
Curriculum
8 Sections
33 Lessons
10 Weeks
Expand all sections
Collapse all sections
Course Intro
4
1.1
1 Introduction to SQL
1.2
2 mysql database
1.3
3 client server architecture
1.4
4 relational modeling
SQL Work Environment
3
2.1
5 SQL work environment
2.2
6 mysql workbench
2.3
7 SQL language components
Data Definition Language
5
3.1
8 SQL DDL Data Definition language
3.2
9 mysql Datatypes
3.3
10 SQL Create table statement
3.4
11 SQL tables constraints explained
3.5
12 SQL database views explanation
Data Manipulation Language
5
4.1
13 quick recap on what happened last lecture
4.2
14 Quick recap on SQL language components
4.3
15 SQL DML data manipulation language – records insert command
4.4
16 SQL data manipulation language – records delete command
4.5
17 – SQL data manipulation language – records update command
Data Query Language
11
5.1
18 SQL data query – select and view records command
5.2
19 SQL data query – filter and view records command
5.3
20 SQL data query language – group functions
5.4
21 Intro to Lecture 3 in SQL
5.5
22 Recap on what happened on SQL lectures 1 & 2
5.6
23 Recap on SQL language components lectures 1 & 2
5.7
24 Reminder on SQL Data manipulation language DML
5.8
25 Explaining SQL Tables joining operations.
5.9
26 Explaining SQL Tables joining types
5.10
27 Explaining SQL Tables self join connection method
5.11
29 How to combine SQL DML and DQL and DDL in one command
SQL Functions
3
6.1
30 Introducing SQL string functions
6.2
31 what are the SQL numerical functions
6.3
32 what are the sql date functions
Data Control Language
1
7.1
33 SQL data control language – users and roles
SQL Interview Questions
1
8.1
34 TOP 50 SQL Interview Questions.
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content