Skip navigation
Courses
Pricing
For Students
SQL Library
Articles
Cookbook
Cheat Sheets
For Beginners
Best Way to Learn SQL
SQL Primer
Flashcards
Guides
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
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
Best Way to Learn SQL
SQL Primer
Flashcards
SQL Practice
GROUP BY and Aggregate Functions
SQL JOINs
Numeric Functions
Dashboard
My Profile
Payment & Billing
Log in
Create free account
Log out
Articles
Cookbook
11 Mar 2021
Rebecca McKeown
SQL Training - Exercises That Will Help You Be Successful!
If you’re starting to dip your toes in the waters of learning SQL, you’ve probably been wondering about the best places to do your SQL training. We’ve rounded up exactly where to train for SQL and how to train for SQL so you can make some informed decisions about your learning journey. So how important is it to flex your SQL training muscles? Well, very. To be precise.
Read more
10 Mar 2021
Jakub Romanowski
Where Can I Find Good Courses to Practice MS SQL Server?
Updated on: April 6, 2024 Begin your journey to mastering MS SQL Server with the finest practice exercises out there. Whether you are a beginner or seeking to improve your T-SQL skills, explore the top destinations for the most engaging and interactive MS SQL practice courses online. You've started learning MS SQL Server. Maybe you've done a course, watched some YouTube tutorials, and feel pretty confident in your knowledge. What now?
Read more
9 Mar 2021
Kateryna Koidan
Why the SQL WITH Clause Is Awesome
If you’re not using WITH clauses yet, it’s definitely time to start! SQL WITH clauses, or common table expressions, help improve the structure of SQL queries by making them more readable. That’s already a lot, but WITH clauses have many more benefits. Let’s see together! The WITH clause was introduced in SQL:1999 to define views that are only valid for the query they belong to. Also known as common table expressions (CTEs), WITH clauses allow us to improve the structure of an SQL statement without polluting the database namespace.
Read more
5 Mar 2021
Tihomir Babic
How to Get Descendants of a Parent in SQL
Want to learn how to handle family trees and find descendants of a parent? By reading this article, you’ll learn how to handle hierarchical data. Finding descendants from a parent is a common problem in SQL. If you imagine a family tree, the basic building block that forms the relationships within it is the parent-child relationship. The parent-child relationship is precisely what defines all hierarchical data. Another example of hierarchical data is the manager-employee relationship.
Read more
4 Mar 2021
Andrew Bone
What Do the Operators LIKE and NOT LIKE Do?
The SQL LIKE and NOT LIKE operators are used to find matches between a string and a given pattern. They are part of standard SQL and work across all database types, making it essential knowledge for all SQL users. Gaining an understanding of these operators will allow you to write better queries and demonstrate to potential employers that you have the skills required to filter through expansive data sets.
Read more
3 Mar 2021
Kateryna Koidan
How to JOIN Tables in SQL
Do you need to display data stored in different tables? Then it’s time to use SQL JOINs! This can be a challenging topic for beginners, so I’ve prepared this comprehensive step-by-step guide on joining tables in SQL. Often, the information that you want to display is stored in several tables. In such cases, you’ll need to join these tables by specifying which rows should be combined with other rows. That’s exactly what JOIN does.
Read more
1 Mar 2021
LearnSQL.com Team
Free SQL Course of the Month – Window Functions
Are you looking for a good SQL window functions course? What if I told you that throughout March, you could access the best window functions course in the world for absolutely FREE? You read that right: you won't pay a dime! Hurry up! Time is running out! But wait – why is LearnSQL.com giving you a free SQL course? Well, we believe sometimes you just have to be good to others.
Read more
1 Mar 2021
LearnSQL.com Team
New Monthly SQL Practice for March 2021!
Are you ready to use your SQL skills to create reports and help resolve business problems? You can do this with our new SQL Practice on LearnSQL.com! The March SQL Practice is at an advanced level. You will test your SQL skills by creating reports with data about language courses in the U.S. If this is the first time you’ve come across our Monthly SQL Practices, LearnSQL.com offers one free SQL Practice each month (at the basic level in the even months and at the advanced level in the odd months).
Read more
26 Feb 2021
Martyna Sławińska
MS SQL Server vs. PostgreSQL: Which to Choose?
Choosing the DBMS you will use for a new project is a very important and difficult decision. Two popular choices are MS SQL Server and PostgreSQL. To help you decide which would be best for you, I'll compare their features, list pros and cons, and give you some examples. Your selection of database management system (DBMS) depends on the type of business or project you're implementing. First, you need to know:
Read more
25 Feb 2021
Timothy Edison
How Much SQL Practice Do You Need to Become a Pro?
Are you wondering how long it will take to learn and practice SQL before you can call yourself a pro? In this article, I will try to help you answer this question. Being a pro in SQL can mean many different things. Some people would say that being a professional is about mastery of advanced SQL, i.e. window functions or complex subqueries. For other people, being a professional means getting paid for your skills.
Read more
««
«
1
2
3
44
45
46
80
»
»»