Unlock full accessUpgrade plan
Projects in SQL
All projects in SQL
Project Type
All Projects
Project Progress
All Progress
42 projects
- Portfolio ProjectSQL • Computer scienceIt's time to combine all of your PostgreSQL knowledge to design and implement a database that is secure, fast, and useful to your users! You will need to work locally on your own computer. We’ll provide you with high-level tasks to guide your project to completion, but you will be responsible for deciding how to implement them in your code. There are many possible ways to correctly fulfill all of these requirements, and you should expect to use the internet, Codecademy, and other resources when you encounter a problem that you cannot easily solve. Note that there are hints that can assist you, but they will only provide one potential implementation. Do not worry if your project looks different from ours!
A Complete Database
Independent, 2 hrsPortfolio Ready - Practice ProjectSQL • Data scienceUse AI and SQL to analyze the rise of AI.
Analyze AI Systems with SQL
More guidance, 60 min - Practice ProjectSQL • Data analytics • Data visualization • Data scienceQuery Hacker News data using SQL to discover trends.
Analyze Hacker News Trends
More guidance, 36 min - Practice ProjectSQL • Data engineering • Data science • PythonUse PySpark SQL and DataFrames to analyze Wikipedia clickstream data
Analyzing Wikipedia Clickstreams with PySpark
More guidance, - Practice ProjectData analytics • SQL • Data visualization • Data scienceAnswer business questions about the performance of marketing campaigns for CoolTShirts.com, an innovative apparel shop.
Attribution Queries
More guidance, 21 min - Practice ProjectSQL • Computer science • Data scienceIn this project, we'll look at an online bookseller's database and think about how to improve it using indexes.
Book Store Indexes
More guidance, 45 min - Practice ProjectSQL • Web development • Data scienceThis project is a step-by-step guide to create a restaurant menu database schema using PostgreSQL that closely models a real-life restaurant.
Build A Menu For Bytes Of China
More guidance, 60 min - Practice ProjectSQL • Computer science • Data scienceThis project is an overview of all material covered in the PostgreSQL constraints lesson and asks learners to apply different datatypes, nullability constraints, check constraints, unique constraints, and primary and foreign key constraints on new and existing tables.
Building an Inventory Database with PostgreSQL
More guidance, 60 min - Practice ProjectSQL • Data analytics • Data visualization • Data sciencePractice calculating churn rates using SQL.
Calculating Churn Rates
More guidance, 30 min