Course Content
00.01 Welcome to the course
00.02 Introduction to Data Science
00.03 Before you begin…
01.01 Introduction to Databases
0/2
What is a Database
20:52
Tables and Keys
20:41
01.02 Introduction to SQL
0/3
What is SQL
09:14
MySQL Window Installation
09:52
MySQL Mac Installation
14:10
01.03 Building Tables
0/3
Creating Tables
15:36
Inserting Data
07:31
Constraints
10:13
01.04 Basic SQL Queries
0/2
Update and Delete
08:19
Basic Queries
12:45
02.01 Company Database
0/3
Company Database Intro
00:00
Creating Company Database
13:41
More Basic Queries
06:17
02.02 SQL Data Manipulation
0/4
Functions
09:07
Wildcards
08:59
Union
08:02
Joins
00:00
02.03 Nesting and Triggers
0/3
Nested Queries
00:00
On Delete
00:00
Triggers
00:00
02.04 ER Diagrams
0/3
ER Diagrams Intro
14:01
ER Diagram Design
00:00
ER Diagram Mapping
00:00
03.01 Final Project (Capstone)
03.02 Next Steps
0/3
Join our Data Science pathway
00:00
Explore PowerBI data visualisation
00:00
Additional SQL Resources
00:00
SQL Data Science Foundations
Previous
Next
0% Complete
Ask ChatGPT
Set ChatGPT API key
Find your Secret API key in your ChatGPT User settings and paste it here to connect ChatGPT with your Tutor LMS website.