My favorite SQL practice website (sql-practice.com)

I think I just found my new favorite SQL practice website.

The website is called sql-practice.com and it is completely free. 

SQL-Practice.com Homepage

This all-in-one website offers SQL training, as well as SQL practice questions.

The list of SQL topics covered in SQL-practice.com
SQL Learning

SQL-practice.com has a section called "Learning resources" that includes tutorials for basic SQL queries, filtering, functions (Aggregate, Window, String, etc.), and table manipulation. The tutorials are pretty basic, but work great as a refresher. But if you're just starting out, I still recommend starting with an interactive course like Udacity or SoloLearn. 


SQL Practice 

SQL-practice.com is also a great place to practice and test your SQL skills. 

It lets you write and run SQL code against two different sample databases.

One database has data related to hospital patients and has four tables, and the other one has sample sales data for a fictitious company called Northwind Traders and has eleven tables.

You're able to see the schemas for the databases, as well as the data types and column names for all the tables. 

The database schema for the northwind traders database in sql-practice.com
The database schema for the Northwind traders practice database


You can write simple select queries to pull data from a single table, test your JOIN skills to combine data from multiple tables into one result, or filter, sort, and aggregate data as you see fit. 



There are also over 50 guided questions you can use to practice against these databases to sharpen your skills.

I recently spent a couple of days going through all the questions and I had a blast! 

Now, I still recommend doing the SQL interview practice questions from DataLemur, LeetCode, and HackerRank as those are closer to what you'll see in a real SQL interview but I can't not tell you about this website as it makes practicing so much more accessible.

So give this website a try and become a SQL expert!

Reach out on TikTok if you have any questions, and stay tuned for more data content! 





Popular posts from this blog

How to get started with SQL

I think SQL is the most important tech skill for a Data Analyst to know. It allows you to find and manipulate data without waiting on an IT team or a Data Engineer to find and manipulate data for you. You can watch this video to learn more about why SQL is so important for a Data Analyst.  Below are my favorite FREE  SQL learning resources: SQL for Data Analysis | Free Courses | Udacity : This free course from Udacity covers everything a beginner Data Analyst should know. It covers SQL Basics (SELECT, FROM, WHERE), Joins, Aggregations, Data Cleaning, and Window Functions. It has a mix of video and written lectures along with quizzes to help you master the content. They advertise that it takes about 4 weeks to complete the course, but I think it's completely worth the time investment.  Sololearn: Introduction to SQL : Sololearn offers a great introductory SQL course that covers all the basics from SELECT statements to SQL best practices and creating/deleting tables....
Read more

How to become a Data Analyst

 Here is everything I would learn if I were trying to break into an entry-level data analyst role today. Just as a disclaimer, I don't think you necessarily need a college degree to be a data analyst, but a degree (in anything) certainly helps! @datawithluis Replying to @Eljay This is everything I would learn if I were trying to become a data analyst without any experience. -Excel -SQL -Data Visualization -Tableau -Networking All the links are in my bio, let me know if you have any questions, and follow me for more data content #DataAnalytics   #DataAnalyst   #SQL   #Tableau   #alteryx   #python   #PowerBI   #excel #careeradvice #breakintotech #jobtok #STEM ♬ original sound - Luis - Data Analyst Intermediate Excel (Lookups (V, X, H), Pivot Tables, String Functions, Statistical Functions) W3 Schools Excel Tutorial Youtube: FreeCodeCamp TikTok: MissExcel Intermediate SQL (Data Types, Joins, Group By, Aggregate Functions, Window Functions, Data Preparation, Perf...
Read more

How to get started with Power BI

Power BI is one of the top data visualization tools to have in your arsenal as a data analyst. By mastering Power BI, data analysts can efficiently process, transform, and visualize data, enabling them to uncover valuable insights and trends. Power BI's interactive dashboards and reports empower analysts to present complex information in a user-friendly manner, fostering effective communication and understanding among stakeholders. Additionally, Power BI's integration with other Microsoft tools and its wide adoption in the industry make it a valuable skill that can boost a data analyst's career prospects and opportunities. Here are my favorite FREE resources to get started with Power BI: Download PowerBI -  Downloads | Microsoft Power BI Microsoft Learn:  Microsoft Learn offers traditional e-learning, finish the following learning paths to learn all the theory and best practices for Power BI directly from Microsoft.  Get started building with Power BI - Training | M...
Read more