SQL for Data Science - Level I
Go to main | Course Page
Section 1: Introduction to SQL
- Why you should learn SQL
- Resources for the "SQL for Data Science - Level 1"
- Types of SQL Servers
- Create new table from existing table
- Course Review
Section 2: Setting up Environments
- Setup Python Environment for SQL
- Import necessary libraries and create sample data
- Create DB and Run SQL in Jupyter Environment
- Data Wrangling iin SQL vs Python
- Setup MySQL Workbench
Section 3: Creating and Deleting Data
- Create a Table Manually in DB
- Exercise Create orders tables from raw data
- Create new table from existing table
- Show Table from existing database
- SQL DELETE - Delete rows in an existing dataset using where condition
- Delete a Table
Section 4: Selecting Data and Update Tables
- SQL Update Update rows-columns in an existing dataset
- Exercise 2: Updating Table
- SQL SELECT - Select Data required variables from a Dataset
- SQL Comments
- Limit the number of rows returned from a query
Section 5: Filtering Data
- Select Distinct Identify and delete duplicates in a dataset
- SQL Where Filtering rows
- SQL order by Sort the data in ascending or descending order
- SQL Having Filter rows after aggregating
Section 6: Merging Dataset
- Joining Datasets
- Exercise 4: Joining Exercise
- SQL DateTime Operations