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
Next Topic

3.4 Writing Your First Query-Select and From

SQL for Data Science SQL Fundamentals – Part 1 3.4 Writing Your First Query-Select and From
Lesson Progress
0% Complete

 

Problem: Write a statement to return all the columns from accounts table.

Solution Code:

SELECT * FROM accounts;
Previous Topic
Back to Lesson
Next Topic
×

Cart