SQL for Data Science
Pre-Course Survey
SQL Discussion Forum
Introduction and Getting Yourself Ready
2 Topics
|
1 Quiz
1.1 Why SQL?
1A Introduction to DBMS and SQL
SQL Quiz 1
Getting Yourself Ready
8 Topics
|
1 Quiz
2.1 Database We will Use
2.2 Data Types and RDMS We will Use
2.3 Setting up IBM DB2 and DB2 Interface
2.4-Setting Up MySQL
2.5 MySQL Workbench
Download Data and Script Files
2.6 Running Wamp Server & Changing Password
2.7 Creating Database and Importing Database in Wamp Server
SQL Quiz 2
SQL Fundamentals – Part 1
10 Topics
|
1 Quiz
3.1 Create and Insert Into Statement
3.2 Table Creation and Importing Data in IBM DB2
3.3 Table Creation and Importing Data in MySQL
3.4 Writing Your First Query-Select and From
3.5 Select and From – Part 2
3.5 Extra – Running SQL Query in Wamp Server
3.6 Drop-Update-Delete
3.7 Alter & Drop Data Example in MySQL
3.8 Update Data Example in MySQL
3.9 Delete Data Example in MySQL
SQL Quiz 3
SQL Fundamentals – Part 2
13 Topics
|
7 Quizzes
4.1 Distinct
4.2 Limit
4.3 Order By
SQL Quiz 4A
4.4 Where – Part 1
4.5 Where – Part 2
4.6 Where – Part 3
4.7 Where – Part 4
SQL Quiz 4B
4.8 Derived Column
SQL Quiz 4C
4.9 Like
SQL Quiz 4D
4.10 Not
SQL Quiz 4E
4.11 And
4.12 Or
SQL Quiz 4F
4.13 Between
SQL Quiz 4G
Relational Database and SQL Join
4 Topics
|
1 Quiz
5.1 Relational Database and ERD
5.2 Join Types
5.3 Join Example – Part 1
5.4 Join Example – Part 2
SQL Quiz 5
Aggregations of SQL
12 Topics
|
7 Quizzes
6.1 Sum
SQL Quiz 6A
6.2 Min and Max
SQL Quiz 6B
6.3 Average
SQL Quiz 6C
6.4 Count
6.5 Group By – Part 1
6.6 Group By – Part 2
SQL Quiz 6D
6.7 Having
SQL Quiz 6E
6.8 Date and Time – Part 1
6.9 Date and Time – Part 2
6.10 Date and Time – Part 3
SQL Quiz 6F
6.11 Case – Part 1
6.12 Case – Part 2
SQL Quiz 6G
Subquery and Temporary Table
2 Topics
|
2 Quizzes
7.1 SubQuery
SQL Quiz 7A
7.2 Temporary Table
SQL Quiz 7B
Data Cleaning in SQL
7 Topics
|
1 Quiz
8.1 Data Cleaning intro
8.2 Left-Right-Upper-Lower
8.3 Length
8.4 Position, Strpos and Substring
8.5 Concat
SQL Quiz 8
8.6 Coalesce
8.7 Cast
SQL Advanced: Union and Join
2 Topics
|
1 Quiz
9.1 Union
9.2 Self Join
SQL Quiz 9
SQL Advanced: Window
5 Topics
|
4 Quizzes
10.1 Window Function
SQL Quiz 10A
10.2 Row number and Rank
SQL Quiz 10B
10.3 Window Function Mania
10.4 Lag and Lead
SQL Quiz 10C
Ntiles
SQL Quiz 10D
SQL Performance Optimization
2 Topics
|
1 Quiz
11.1 Performance Tuning
SQL Quiz – Performance Tuning
11.2 Final Thoughts
User Feedback on This Course
Previous Topic
1A Introduction to DBMS and SQL
SQL for Data Science
Introduction and Getting Yourself Ready
1A Introduction to DBMS and SQL
Lesson Progress
0% Complete
Previous Topic
Back to Lesson
×
Cart
Log In
Good to see you again!
Username
Password
Remember Me
Login
Forgot your password? Get help
Privacy Policy
Or log in with
Login with
Facebook
Login with
Google
Login with
LinkedIn
Not a member?
Sign up
Create An Account
It's super easy. And it's FREE.
Your username
Your email
Password
Confirm Password
Register
Or register with
Login with
Facebook
Login with
Google
Login with
LinkedIn
Privacy Policy
Already a member?
Sign in
Reset Password
Submit your email address
Username or E-mail
Request Reset Password Link
A password reset link will be e-mailed to you.
Privacy Policy
Back to
Login
×