Skip to content

Practicing SQL LinkedIn learning courses on dummy 'databasestar' data using SQLite in RStudio. Also using Python to generate dummy Marathon data and writing example problems for this dataset.

Notifications You must be signed in to change notification settings

georgemelrose/SQL_Practice

Repository files navigation

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

About

Practicing SQL LinkedIn learning courses on dummy 'databasestar' data using SQLite in RStudio. Also using Python to generate dummy Marathon data and writing example problems for this dataset.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages