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

অ্যান্ড্রয়েড অ্যাপ ডেভেলপমেন্ট ক্যারিয়ার ট্র্যাকের ১ম ব্যাচের রেজিস্ট্রেশন শুরু হয়ে গেছে। প্রথম ২০০ জন ভর্তি হতে পারবেন ৳১০,০০০ ৳৭,০০০ দিয়ে। বিস্তারিত জানুন Dismiss