No. of Projects: 4
In this mini-project, we’ll be working with a modified version of a database called Chinook. The Chinook database contains information about a fictional digital music shop - kind of like a mini-iTunes store. It contains information about the artists, songs, and albums from the music shop, as well as information on the shop’s employees, customers, and the customers purchases.
We’ll provide solutions to few Business Questions by analysing data from Chinook Database.
Skills: Pandas, Matplotlib, SQLite3, SQL (SELECT, FROM, WITH _ AS, CASE, WHEN, THEN, EXCEPT, THEN, JOIN, COUNT, CAST, GROUP BY, LIMIT)
In this mini-project, we will be working with a CSV File.
We will convert it into a SQL Database with following features:
Have data stored in normalised tables.
Have data stored in a Storage Efficient Way.
Have Users that can update, read, and insert data into a table of the database.
Have Users that can only read from a table.
Skills: Pandas, PostgreSQL (connect, cursor, execute, autocommit, mogrify), SQL (CREATE TABLE, USER _ WITH PASSWORD, GROUP, GRANT, REVOKE, DROP _ IF EXISTS, INSERT INTO)
In this mini-project, we will be working with a file of Major League Baseball games from Retrosheet.
We will design and create a Database with normalised tables by compiling data from various sources.
Skills: Pandas, SQLite3, SQL (SELECT, FROM, CREATE, JOIN, ALTER, UPDATE, INSERT, UNION, DROP, CASE, WHEN, THEN, LIMIT, GROUP BY)
In this mini-project, we will explore the CIA Factbook Database using Python SQLite and Pandas.
We will learn to explore, analyse and visualise data from a database.
Skills; Pandas (read_sql_query), Matplotlib, SQLite, SQL (SELECT, FROM, CAST, WHERE, MAX, MIN, ORDER BY, LIMIT)