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
1 Jul 2021
LearnSQL.com Team
New Monthly SQL Practice for July 2021!
If you are a more advanced SQL user who is comfortable writing complex JOINs, you can check your knowledge with July’s SQL Practice. Every month on LearnSQL.com, you‘ll find a new challenge to solve. Maybe this is the first time you’ve come across our Monthly SQL Practices. LearnSQL.com offers one free SQL Practice each month: basic levels on even-numbered months and advanced levels on odd-numbered months. Each SQL Practice takes about an hour (or less!
Read more
30 Jun 2021
Zahin Rahman
Top 15 SQL Interview Questions in 2021
If you are on the lookout for a job in the field of data, you’re almost guaranteed to face SQL interview questions. You might even be asked to complete some kind of SQL coding test. According to KDnuggets, irrespective of the specific role in data – data analyst, data engineer, data scientist, or business intelligence analyst – SQL lands in the top three skills found in postings across Indeed, SimplyHired, and Monster.
Read more
29 Jun 2021
Kate Stolarek
Skills Every Data Analyst Should Have
If you’re a student looking for career advice or a specialist seeking new job opportunities, find out if a data analyst job is something worth considering. In today's article, I explain the essential skills required for data analysts and benefits that come from performing such a job. What Is a Data Analyst? Let’s start by defining exactly what a data analyst is. A data analyst is someone who uses their skills to collect, analyze, and report insights from company data.
Read more
25 Jun 2021
András Novoszáth
Data Analyst vs. Data Engineer: A Full Comparison
Do you want to become a data analyst? Or maybe you dream about being a data engineer? Can't make up your mind? I'll help you. Read about the two roles’ history, their market situation, and the skills you need to become one. You already know that it's a good idea to enter the data world and work with databases. But how to do it? Behind which door is the better career waiting for you?
Read more
24 Jun 2021
Jakub Romanowski
New Basic SQL Practice Course on LearnSQL.com
Hey, did you hear that there’s a brand-new Basic SQL Practice course on LearnSQL.com? This is a great opportunity to refresh your SQL, write some queries, and take your analytical skills to the next level. We’re proud to introduce Basic SQL Practice: A Store! Where did the idea for this new SQL practice course come from? From our users! They’ve let us know that they need more hands-on SQL exercises at a beginner level.
Read more
23 Jun 2021
Kateryna Koidan
Do You Need to Learn SQL To Become a Programmer?
SQL is primarily used by database administrators (DBAs), business analysts, and data analysts. But what about other programming roles? In this article, I’ll show how software engineers, web developers, and app developers use SQL and why you need to learn SQL to become a programmer. Like many other aspiring programmers, you are probably wondering “Do I need SQL?”. To answer this question, you should know that you’ll encounter data everywhere in software development.
Read more
22 Jun 2021
Himanshu Kathuria
Why Does Your Company Need Data Analysis?
Data is the new gold. That is what the biggest in the business say, knowing the value of the data, the analyses, and the conclusions they bring. If you are wondering why your company needs data analysis and what value it could bring to your business, then this article is for you. Historically, many companies have gone into analytics mainly through financial and accounting data to improve revenue, reduce costs, and eventually increase profitability.
Read more
18 Jun 2021
Martyna Sławińska
An Overview of PostgreSQL Data Types
It’s vital to know what you actually store in your database. That’s why every column has its data type. There are numerous PostgreSQL data types across various categories. Read on to see which data type suits which use case! In this article, we’ll go through the most common data types used in PostgreSQL. PostgreSQL, also called Postgres, is a well-known open-source object-relational database management system (DBMS). It is SQL-compliant, extensible, and includes all standard relational database features, such as database constraints, transactions, views, triggers, stored procedures, and more.
Read more
17 Jun 2021
Kamila Ostrowska
SQL Terms Beginners Should Know - Part 4
Here it is – another batch of must-know SQL terms. In the first two parts, we covered tables, relational databases, queries, aliases, SQL JOINs, primary keys, and subqueries. Last time, we moved to more advanced terms like INSERT INTO, GROUP BY, and HAVING. Are you ready to dive deeper into SQL terminology? This is the fourth installment of our series on basic SQL terms for beginners (and everyone else). Don’t worry if you missed the previous articles; you can find Part 1 (essential SQL terms), Part 2, and Part 3 in our blog.
Read more
16 Jun 2021
Tihomir Babic
Business SQL: How to Calculate Revenue Growth in SQL
Can you use SQL in business? Of course you can! For example, you can calculate revenue growth in SQL – here’s how. As someone who works with data, you already know that SQL is the most used tool in data analysis. But how is SQL helpful in business use? Well, the answer is obvious: analyze business data using SQL! However, there are some specifics with business data that can be tricky if you’re not used to it.
Read more
««
«
1
2
3
38
39
40
80
»
»»