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
13 Feb 2020
Rebecca McKeown
How Long Does It Take to Learn SQL?
Is it hard to learn SQL? How long does SQL mastery take? This article will answer those questions and get you started with the most useful SQL commands. How long does it take to learn SQL? If you’ve ever dabbled in Spanish or French, you know that learning a new language is tough and can take years. Luckily, mastering SQL is a much faster journey than conquering por/para or un, deux, trois.
Read more
11 Feb 2020
Kamila Ostrowska
How to Study Online: 5 Steps to Effective Learning
If you suffer from procrastination or lack of motivation, you’re not alone. We have some online learning tips to make your learning journey smoother and more enjoyable. One of the best things about being an adult is that we can do what we want: go to sleep late at night, party until morning, eat junk food. Besides all those small pleasures, as adults we are responsible for ourselves, our choices, and our mistakes.
Read more
6 Feb 2020
Ignacio L. Bisso
HAVING vs. WHERE in SQL: What You Should Know
This article is about SQL’s WHERE and HAVING clauses. Both clauses are part of the foundations of the SQL SELECT command. They have similar uses, but there are also important differences that every person who uses SQL should know. Let’s see what’s behind the HAVING vs. WHERE debate. In this article, we’ll suppose we work for a government social agency supporting people or families whose income is below a certain threshold.
Read more
28 Jan 2020
Jakub Romanowski
How to Practice SQL
Updated on: December 5th, 2023 Are you familiar with SQL's core concepts like aggregation functions, JOINs, GROUP BY, and ORDER BY? That's a great start. But to truly master SQL – especially for data analyst roles and job interviews – it's crucial to understand how to practice SQL effectively. This article provides a comprehensive guide to the best methods to practice SQL. You’re here because you're eager to enhance your SQL skills and become an independent database user.
Read more
3 Jan 2020
Rebecca McKeown
SQL INSERT, SQL UPDATE, SQL DELETE – Oh My!
Need to understand SQL INSERT, UPDATE, or DELETE? We'll get you up to speed with a comprehensive How-To and useful examples! SQL INSERT, UPDATE, and DELETE statements—what are they all about? If you're a data engineer, a database administrator, or even just your average data fanboy or girl, one day you're going to find yourself with a database that becomes your "baby." Charged with this special bundle of joy, you're going to need to feed and change the little fella.
Read more
24 Dec 2019
Jakub Romanowski
SQL, Databases, and Hollywood Movies
Policemen, doctors, lawyers, scientists, teachers: These are the professions that we often see in Hollywood movies. But are movies also trying to show what the work of data analysts looks like? Here is a list of six movies in which screenwriters, directors, and producers decided to cast SQL and databases in the main roles. Data analysis is most often associated with business, reporting, and making key decisions for the company.
Read more
10 Dec 2019
Shanika Wickramasinghe
Difference between GROUP BY and ORDER BY in Simple Words
For someone who is learning SQL, one of the most common places to get stuck is when learning the GROUP BY command. GROUP BY and ORDER BY are two important keywords in SQL that we use to organize data. The difference between GROUP BY and ORDER BY is that ORDER BY is more simple than GROUP BY and is usually introduced early in an SQL course. Sometimes, people are quite confused over these two concepts (SQL ORDER BY vs.
Read more
15 Nov 2019
Jakub Romanowski
Join us on Facebook–We Can Learn More Together
We are so happy that you have joined us to learn and develop your SQL skills! We want to invite you to a new Facebook group, We Learn SQL. It is a great place for anyone interested in meeting like-minded people who also want to learn about database-related concepts. Learning together is easier, don't you think? Joining this group is a great opportunity to begin sharing your learning experiences with others.
Read more
13 Nov 2019
Belma Mesihovic
Grouping Data in SQL Server
People who work with data know that data grouping can sometimes be a chore. If you struggle and waste hours with Excel, OpenOffice, or some other tool trying to group various sets of data, take a look at this article and learn how to do the work much quicker and easier by using SQL. You often find yourself in a situation where you need to analyze data and present the results in a form other than the one in which the data is stored.
Read more
8 Oct 2019
Ignacio L. Bisso
SQL Order of Operations
SQL is not a traditional programming language in which you write a sequence of instructions in a given order of execution. Instead, SQL is a "declarative" language, which means that by writing a SQL query, you declare what data you expect as a result of the query, but you don't indicate how to obtain it. Six Operations to Order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY By using examples, we will explain the execution order of the six most common operations or pieces in an SQL query.
Read more
««
«
1
2
3
64
65
66
78
»
»»