Name	Name	Last commit message	Last commit date
Latest commit History 2 Commits
10.1 Importing Data into MySQL.sql	10.1 Importing Data into MySQL.sql
10.2 Exporting Data to CSV.sql	10.2 Exporting Data to CSV.sql
11.2 Removing Duplicates.sql	11.2 Removing Duplicates.sql
11.3Standardizing Data.sql	11.3Standardizing Data.sql
11.4 Breaking out Column into Multiple Columns.sql	11.4 Breaking out Column into Multiple Columns.sql
11.5 Working with NULL Values.sql	11.5 Working with NULL Values.sql
11.6 Deleting Unused Columns.sql	11.6 Deleting Unused Columns.sql
13.1 World Life Expectancy Data Cleaning.sql	13.1 World Life Expectancy Data Cleaning.sql
13.2 World Life Expectancy Exploratory Data Analysis.sql	13.2 World Life Expectancy Exploratory Data Analysis.sql
13.3 US Income Data Cleaning.sql	13.3 US Income Data Cleaning.sql
13.4 US Income Exploratory Data Analysis.sql	13.4 US Income Exploratory Data Analysis.sql
2.5 create-bakery-db.sql	2.5 create-bakery-db.sql
3.10 LIMIT Clause.sql	3.10 LIMIT Clause.sql
3.11 Order BY Clause.sql	3.11 Order BY Clause.sql
3.12 Aliasing.sql	3.12 Aliasing.sql
3.2 Querying Basics.sql	3.2 Querying Basics.sql
3.3 Select Statement.sql	3.3 Select Statement.sql
3.4 Where Clause.sql	3.4 Where Clause.sql
3.5 Comparison Operators.sql	3.5 Comparison Operators.sql
3.6 Logical Operators.sql	3.6 Logical Operators.sql
3.7 IN Operator.sql	3.7 IN Operator.sql
3.8 Between Operator.sql	3.8 Between Operator.sql
3.9 Like Operator.sql	3.9 Like Operator.sql
4.2 Numeric Functions.sql	4.2 Numeric Functions.sql
4.3 String Functions.sql	4.3 String Functions.sql
4.4 Date Functions.sql	4.4 Date Functions.sql
4.5 IF Function.sql	4.5 IF Function.sql
4.6 Case Statement.sql	4.6 Case Statement.sql
4.7Cast and Convert Functions.sql	4.7Cast and Convert Functions.sql
5.2 Group By Basics.sql	5.2 Group By Basics.sql
5.3 Aggregate Functions.sql	5.3 Aggregate Functions.sql
5.4 Having vs Where Clause.sql	5.4 Having vs Where Clause.sql
5.5 Rollup.sql	5.5 Rollup.sql
6.10 Unions.sql	6.10 Unions.sql
6.11 Join Use Cases.sql	6.11 Join Use Cases.sql
6.2 Inner Join.sql	6.2 Inner Join.sql
6.3 Joining Multiple Tables.sql	6.3 Joining Multiple Tables.sql
6.4 Joining on Multiple Conditions.sql	6.4 Joining on Multiple Conditions.sql
6.5 Outer Joins.sql	6.5 Outer Joins.sql
6.6 Self Joins.sql	6.6 Self Joins.sql
6.7 Cross Joins.sql	6.7 Cross Joins.sql
6.8 Natural Joins.sql	6.8 Natural Joins.sql
6.9 Using Keyword.sql	6.9 Using Keyword.sql
7.2 Subqueries.sql	7.2 Subqueries.sql
7.3 Any and All Statements.sql	7.3 Any and All Statements.sql
7.4 Exists Operator.sql	7.4 Exists Operator.sql
7.5 Subqueries in Select and From Statements.sql	7.5 Subqueries in Select and From Statements.sql
8.2 Over + Partition By.sql	8.2 Over + Partition By.sql
8.3 Row_Number.sql	8.3 Row_Number.sql
8.4 Rank and Dense_rank.sql	8.4 Rank and Dense_rank.sql
8.5 Lag and Lead.sql	8.5 Lag and Lead.sql
9.2 Regular Expression Methods.sql	9.2 Regular Expression Methods.sql
9.3 Regular Expression Metacharacters.sql	9.3 Regular Expression Metacharacters.sql
README.md	README.md

Name

Last commit message

Last commit date

2 Commits

10.1 Importing Data into MySQL.sql

10.2 Exporting Data to CSV.sql

11.2 Removing Duplicates.sql

11.3Standardizing Data.sql

11.4 Breaking out Column into Multiple Columns.sql

11.5 Working with NULL Values.sql

11.6 Deleting Unused Columns.sql

13.1 World Life Expectancy Data Cleaning.sql