Skip to content
/ My-SQL-data-Analytics Public

SQL data analytics step by step learning and final project

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

James-Lagda/My-SQL-data-Analytics

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
1. Beginner - Parks_and_Rec_Create_db.sql
1. Beginner - Parks_and_Rec_Create_db.sql
 
 
10. Case Statements.sql
10. Case Statements.sql
 
 
11. Subqueries.sql
11. Subqueries.sql
 
 
12. Windows Function.sql
12. Windows Function.sql
 
 
13. CTE's.sql
13. CTE's.sql
 
 
14. Temporay Table.sql
14. Temporay Table.sql
 
 
15. Stored Procedures.sql
15. Stored Procedures.sql
 
 
16. Trigger and Events.sql
16. Trigger and Events.sql
 
 
17. Data Cleaning Project.sql
17. Data Cleaning Project.sql
 
 
18. Exploratory Data Analysis.sql
18. Exploratory Data Analysis.sql
 
 
2. Select Statement.sql
2. Select Statement.sql
 
 
3. Where Statements.sql
3. Where Statements.sql
 
 
4. Group and Order by.sql
4. Group and Order by.sql
 
 
5. Having and Where Statements.sql
5. Having and Where Statements.sql
 
 
6. Limit and Alliasing.sql
6. Limit and Alliasing.sql
 
 
7. Joins.sql
7. Joins.sql
 
 
8. Union.sql
8. Union.sql
 
 
9. String Functions.sql
9. String Functions.sql
 
 
README.md
README.md
 
 
layoffs.xlsx
layoffs.xlsx
 
 

Repository files navigation

My-SQL-data-Analytics

To run the files you need to download My SQL and add the My SQL work bench for it to work or maybe you can just figure something out. For the dateset the no.1 file is where the datasets are, you are gonna make sa database using it from scratch you can change and manipulate it as well to your liking.

About

SQL data analytics step by step learning and final project

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published