There are two main components of this SQL practice work. The folders 'Universities_Data' and 'Gravity_Bookstore_Data' contain files that generate and practice SQL concepts different databasestar dummy datasets: https://www.databasestar.com/sample-bookstore-database/ for the Gravity bookstore ; https://www.databasestar.com/sample-database-university-rankings/ for the University data.
Several LinkedIn Learning courses have been used to learn and adapt different SQL concepts of varying complexity to the above datasets: “SQL Server Fundamentals: Master Basic Query Techniques” for the 'Universities_Data' in the RMD "01_Basic_Query_Statements"; “SQL for Data Analysis” for the 'Gravity_Bookstore_Data' in the RMD "02_SQL_for_Data_Analysis"; “Intermediate SQL for Data Scientists” for the 'Gravity_Bookstore_Data' in the RMD "03_Intermediate_SQL_for_Data_Scientists".
In addition to this self-direct learning
Details of the files in the different folders:
- Universities_Data - Work pertaining to