You could start with the SQL section of w3schools.com. It's a big picture overview of SQL and it has some pages focused on how to accomplish things specific to different database programs. Get comfortable with that first. The rarely spoken truth is that SQL isn't very hard to pick up. Your value will largely depend on your ability to translate business logic into SQL. Practice. Pick an industry/type of business. It might be best to start with one you're very familiar with on your first run through. Set up your database environment. Securely store all the information required in your set up. Ex: authentication type, administrator account user/pass, database name, etc Gather information on what the business would need to store in a database. Ex: an animal shelter would need a pet table, a kennel/cage table, immunization/medical information table, license/tag table, a table to store people who surrender or adopt .. you get the picture. Make it as detailed as you can, if it's realistic, talk to someone in that line of work, but don't get caught up in making it perfect. 5-10 tables should be enough for the first time around. Design the tables in the database. Pay attention to data types as you go. You'll want to consider the data as it is today, and accommodate for growth. Ex: your table has a field, char(10) as the data type. The data stored is currently 10 characters long. Business needs change, and this field now needs to store 12 characters. Save yourself the headache and start with making it varchar(20) at creation. Also pay attention to keys and how you intend to join tables. I strongly advise putting primary keys on every table and setting them to auto-increment. This gives you a quick out when it comes to duplicate records. Generate data for your tables. Google "data generator" and find the one you like the best. I've used https://generatedata.com/ in the past, it's not terrible but I recall a lot of tweaking to get exactly what I needed. Research. Chances are there's something easier out there. If dropping money on it is not an issue, Regate has a SQL Data Generator for a yearly subscription price of $264. Probably easier to work with. Load your data into the database. Ideally, the data generator provided you with a SQL script that runs a bunch of inserts, one click and done. But it's possible you got a csv or Excel file. Most dbms's come with an import tool of some kind, this the perfect opportunity to learn how to use it. The rest is the fun part. Conjure up potential business scenarios your business might encounter. In the animal shelter example, a couple things might happen: animal adoption, animal surrender, kennel change, new license/tag, etc. Consider what would be most important if you needed to report on these situations, put some queries together, maybe create some views. When you're pretty comfortable with that, start looking into how you'd update data. An animal surrender wouldn't just be entering into the pet table, you'd also want to store the person who surrendered the animal and assign them a kennel. Also: retaining historical data for record changes is a valid business requirement. If it didn't come up in your original design, figuring out how to implement it is good practice. Sorry so long, but it should get you started and introduce you to some situations you're going to encounter later on. Lots of luck! Answer from Deleted User on reddit.com
🌐
Reddit
reddit.com › r/sql › best resources to learn sql and what should i focus on to get a job?
r/SQL on Reddit: Best resources to learn SQL and what should I focus on to get a job?
September 28, 2023 -

I'm currently learning SQL in my spare time, polishing up on my Excel skills and after SQL, I want to learn PowerBI. I have NO EXPERIENCE in SQL.

Which books, mock test, website, youtube channel would you recommend? I want to learn from basic to expert level no matter how much time it takes?

Top answer
1 of 18
17
You could start with the SQL section of w3schools.com. It's a big picture overview of SQL and it has some pages focused on how to accomplish things specific to different database programs. Get comfortable with that first. The rarely spoken truth is that SQL isn't very hard to pick up. Your value will largely depend on your ability to translate business logic into SQL. Practice. Pick an industry/type of business. It might be best to start with one you're very familiar with on your first run through. Set up your database environment. Securely store all the information required in your set up. Ex: authentication type, administrator account user/pass, database name, etc Gather information on what the business would need to store in a database. Ex: an animal shelter would need a pet table, a kennel/cage table, immunization/medical information table, license/tag table, a table to store people who surrender or adopt .. you get the picture. Make it as detailed as you can, if it's realistic, talk to someone in that line of work, but don't get caught up in making it perfect. 5-10 tables should be enough for the first time around. Design the tables in the database. Pay attention to data types as you go. You'll want to consider the data as it is today, and accommodate for growth. Ex: your table has a field, char(10) as the data type. The data stored is currently 10 characters long. Business needs change, and this field now needs to store 12 characters. Save yourself the headache and start with making it varchar(20) at creation. Also pay attention to keys and how you intend to join tables. I strongly advise putting primary keys on every table and setting them to auto-increment. This gives you a quick out when it comes to duplicate records. Generate data for your tables. Google "data generator" and find the one you like the best. I've used https://generatedata.com/ in the past, it's not terrible but I recall a lot of tweaking to get exactly what I needed. Research. Chances are there's something easier out there. If dropping money on it is not an issue, Regate has a SQL Data Generator for a yearly subscription price of $264. Probably easier to work with. Load your data into the database. Ideally, the data generator provided you with a SQL script that runs a bunch of inserts, one click and done. But it's possible you got a csv or Excel file. Most dbms's come with an import tool of some kind, this the perfect opportunity to learn how to use it. The rest is the fun part. Conjure up potential business scenarios your business might encounter. In the animal shelter example, a couple things might happen: animal adoption, animal surrender, kennel change, new license/tag, etc. Consider what would be most important if you needed to report on these situations, put some queries together, maybe create some views. When you're pretty comfortable with that, start looking into how you'd update data. An animal surrender wouldn't just be entering into the pet table, you'd also want to store the person who surrendered the animal and assign them a kennel. Also: retaining historical data for record changes is a valid business requirement. If it didn't come up in your original design, figuring out how to implement it is good practice. Sorry so long, but it should get you started and introduce you to some situations you're going to encounter later on. Lots of luck!
2 of 18
14
W3 schools is a great resource and it is free so you can explore all you want before focusing on ay flavor of SQL.
🌐
Rivery
rivery.io › home › blog › 10 best resources to learn sql for free
10 Best Resources To Learn SQL For Free (2026) | Rivery
March 4, 2025 - Students can use this resource with the previously discussed interactive coding courses to take their skills to the next level. If you’re looking for a basic, introductory look at how to use SQL, Datacamp’s Introduction to SQL Course is perfect. Founded in 2013, the course includes guides, tutorials, and cheat sheets. Datacamp also has short video exercises and coding challenges to ensure you never feel bored. Thousands of learners at 2500 companies use Datacamp, including Google PayPal, EY, Uber, eBay, and Microsoft.
Discussions

Best resources for learning SQL? - Databases & Queries - Spiceworks Community
Hello All, Whilst looking to see what tech skills are currently in demand I noticed that SQL Server is mentioned a lot. I’m looking to eventually work towards becoming a Network Admin and reckon that SQL might be a good skill to have. I have a subscription to Pluralsight that has some SQL ... More on community.spiceworks.com
🌐 community.spiceworks.com
8
January 25, 2016
Best course to learn SQL?
LearnSQL.com. They have a complete SQL learning path that takes you from the basics to advanced topics like window functions and CTE. They have courses in different dialects: standard, SQL Server, MySQL, and others. They have a lot of practice courses. When it comes to SQL, it’s the most complete learning platform. More on reddit.com
🌐 r/learnSQL
12
24
June 6, 2024
What are some good free youtube courses for SQL to get to intermediate level?
Alex The Analyst More on reddit.com
🌐 r/dataanalysis
12
35
April 8, 2023
What is the quickest crash course/resource to learning SQL?
SQL Bootcamp by Jose Portilla on Udemy. Hands down the best course. More on reddit.com
🌐 r/SQL
21
19
August 29, 2024
🌐
W3Schools
w3schools.com › sql
SQL Tutorial
Data types and ranges for Microsoft Access, MySQL and SQL Server. ... Complete the W3Schools coding course, strengthen your knowledge, and earn a certificate you can add to your CV, portfolio, and LinkedIn profile. ... Learn it. Practice it.
🌐
Medium
medium.com › dev-genius › sql-roadmap-learning-resources-4e2789b84151
SQL Roadmap & Learning resources. List of resources to learn SQL | by Amit Singh Rathore | Medium
July 24, 2025 - Learning SQL by Alan Beaulieu is a free e-book. This book provides helpful context regarding the language’s history and current usage, offers an overview of query and table architecture, and covers more complex SQL subjects than the abovementioned courses. ... SQLFlow — a great tool to visualize SQL queries.
🌐
SQLBolt
sqlbolt.com
SQLBolt - Learn SQL - Introduction to SQL
SQLBolt provides a set of interactive lessons and exercises to help you learn SQL
Find elsewhere
🌐
Estuary
estuary.dev › blog › best-free-sql-learning-resources
11 Best Free Resources to Learn SQL (2025 Guide)
April 7, 2025 - Master SQL for free with these 11 top-rated beginner resources. From hands-on platforms to expert tutorials—start your SQL journey today.
🌐
Roadmap
roadmap.sh › sql
SQL Roadmap
February 26, 2026 - Step by step guide to learning SQL in 2026
🌐
Coursera
coursera.org › courses
Best SQL Courses & Certificates [2026]
Please use a modern browser with JavaScript enabled to use Coursera.
🌐
Medium
katiehuangx.medium.com › the-ultimate-sql-resources-82a7f7a137c4
The Ultimate List of SQL Resources | by Katie Huang Xiemin | Medium
June 15, 2022 - Sharing my tried-and-tested SQL resources and handpicked several of my personal favourites for you.
🌐
Codecademy
codecademy.com › learn › learn-sql
Learn SQL | Codecademy
I learned SQL in my college course but I liked they way codecademy taught it a lot better! I liked the visual graphics of how the tables transform when they merge together since I have issues visualizing the actual changes.
Rating: 4.6 ​ - ​ 26.7K votes
🌐
SQLZoo
sqlzoo.net › wiki › SQL_Tutorial
SQLZoo
Responses from students on their learning experience. ... Online copies of implementation specific user manuals. ... How to connect to the server and execute SQL statements.
🌐
Quora
quora.com › What-are-some-good-resources-to-learn-SQL-for-connecting-a-database-to-a-web-app
What are some good resources to learn SQL for connecting a database to a web app? - Quora
Answer: You seem to have a web app, and you want to connect to a database in order to save (create) and/or retrieve (read) data, right? Obviously, you will also want to modify (edit or update) and delete data too. Welcome to CRUD (Create, Read, Update, Delete), which is the basic foundation of y...
🌐
Microsoft Learn
learn.microsoft.com › en-us › training › paths › get-started-querying-with-transact-sql
Query and modify data with Transact-SQL - Training | Microsoft Learn
Learn how to use Transact-SQL (T-SQL) to interact with relational databases by querying and modifying data. This course covers essential operations such as inserting, updating, deleting, and merging data across tables. You'll also explore how to generate automatic values and apply changes ...
🌐
Quora
quora.com › How-do-I-learn-SQL-What-are-some-good-online-resources-like-websites-blogs-or-videos
How to learn SQL? What are some good online resources, like websites, blogs, or videos - Quora
Answer (1 of 123): Here are some basic steps and resources to learn SQL: 1.Assessing/Refreshing Your Background Knowledge * [OPTIONAL] It helps to understand the mathematical (formal) background of SQL: try taking a look at relational algebra and relational calculus: * * http://infolab.stan...
🌐
HackerNoon
hackernoon.com › my-favorite-resources-to-learn-sql-in-depth
My Favorite Resources to Learn SQL in Depth | HackerNoon
August 7, 2023 - Practicing SQL online on sites like SQLZoo or SQLFiddle will help you keep up-to-date and improve your SQL skills.
🌐
Spiceworks
community.spiceworks.com › programming & development › databases & queries
Best resources for learning SQL? - Databases & Queries - Spiceworks Community
January 25, 2016 - Hello All, Whilst looking to see what tech skills are currently in demand I noticed that SQL Server is mentioned a lot. I’m looking to eventually work towards becoming a Network Admin and reckon that SQL might be a good skill to have. I have a subscription to Pluralsight that has some SQL ...