Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
Other Assets
Flashcards
SQL Primer
Log in
Create free account
fullName
User profile menu open
Open user profile menu
fullName
Dashboard
My Profile
Payment & Billing
Log out
MENU
CLOSE
Courses
Pricing
For Students
Articles
Cookbook
Cheat Sheets
Flashcards
SQL Primer
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
25 Apr 2023
Alexandre Bruffa
Learn SQL in 10 Minutes
SQL, or Structured Query Language, is a programming language used to communicate with databases. With SQL, you can retrieve data from a database, insert new data, and update or delete existing data. You can even modify the structure of a database: you can add or delete tables or columns and change the relationships between tables. SQL is a standard, meaning it is a reference. Read about the history of the SQL standard in our article “The History of SQL Standards.
Read more
20 Apr 2023
Jill Thornhill
CTE vs. Subquery in SQL: What’s the Difference?
What are Common Table Expressions (CTEs)? Are they the same as subqueries? When would you need to use CTEs? This article looks at the similarities and differences between CTE vs subquery. When I introduce a student to Common Table Expressions, their first reaction is “That’s just a subquery! Why do I need to learn that?”. Let’s answer this question by looking at what you can do with an SQL subquery and what extra advantages there are in using a CTE.
Read more
18 Apr 2023
Tihomir Babic
10 Beginner SQL Practice Exercises With Solutions
Solve these ten SQL practice problems and test where you stand with your SQL knowledge! This article is all about SQL practice. It’s the best way to learn SQL. We show you ten SQL practice exercises where you need to apply essential SQL concepts. If you’re an SQL rookie, no need to worry – these examples are for beginners. Use them as a practice or a way to learn new SQL concepts.
Read more
17 Apr 2023
LearnSQL.com Team
Earth Day 2023
On Earth Day 2023, join hundreds of thousands of people around the world in fighting for the climate. You might be asking yourself ‘wait, why am I reading about this on the LearnSQL.com blog?’ Well, because it's important! Let's take care of our planet, it's our only home! "Invest in our planet." This is the official slogan of this year's Earth Day. We don't know about you, but this sentence motivates us a lot.
Read more
13 Apr 2023
Crystal Frazier
How I Used SQL to Advance in My Career
SQL has become increasingly valuable in today’s job market. In this article, I will share my personal experience with SQL. I hope it will inspire you to grow in your career and achieve your own goals! A few years ago, I felt stuck in a job that I didn’t fully enjoy. Sure, there were aspects of my job that I appreciated, like building budgets, analyzing the performance of promotional programs, and watching my team grow professionally.
Read more
11 Apr 2023
Nicole Darnley
The Best SQL Blogs to Follow
In this article, you’ll find a list of the best SQL blogs and why they’re worth checking out. SQL (short for Structured Query Language) has been around since the 1970s. It’s still a wildly popular coding language. It is based on the idea that data can be structured and built through relations. If you’re familiar with SQL, you’ve likely heard the term “relational database.” This means that the tables of the database have pre-defined relationships between them: One field in one table will match another field in another table.
Read more
6 Apr 2023
Maria Durkin
Best PostgreSQL Courses for Beginners
So you want to learn PostgreSQL but aren't sure how to get started? In this article, we look at some of the best online courses available on the Internet for learning PostgreSQL, so you can get started right away! What Is PostgreSQL? PostgreSQL is used in major companies such as Apple and Instagram. You may be wondering: should I learn PostgreSQL? PostgreSQL is a popular dialect of SQL, or Structured Query Language, a programming language for accessing and managing data in relational databases.
Read more
4 Apr 2023
Maria Durkin
How to Learn SQL in a Week
Need to learn SQL in a hurry? In this article, we’ll give you a learning path that will help you learn SQL in a week! So you want to learn SQL but don't know where to begin, how long it will take, or even if you have the time. In this article, we'll show you how you can learn SQL within a week using some resources that will get your SQL journey started in no time!
Read more
1 Apr 2023
Jakub Romanowski
Free SQL Course of the Month – Creating Basic SQL Reports in PostgreSQL
If you are looking for a course that takes your PostgreSQL skills to a completely different level, you've come to the right place. You can learn for free in April! We chose SQL Reporting in PostgreSQL for our Free SQL Course of the Month. It's just awesome – I'll tell you why. Do you want to be even better at SQL? Do you know the basics and want your SQL reports to be even more sophisticated?
Read more
31 Mar 2023
LearnSQL.com Team
New Monthly SQL Practice for April 2023!
In our April 2023 SQL Practice, you’ll meet Emma, a host of game development tournaments called game jams. She needs your help in creating a reliable database structure and queries for the platform. Can you use your SQL skills to help her? It shouldn’t be too hard if you have finished our SQL Basics course or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice.
Read more
««
«
1
2
3
7
8
9
78
»
»»