Gain the fundamental SQL skills you need to interact with and query your data. SQL is a powerful language used by data-driven businesses, large and small, to explore and manipulate their data to extract meaningful insights. In this playlist, you'll learn the SQL fundamentals you need to level up your data skills. With additional hands-on exercises on DataCamp, you’ll discover SQL basics, such as how to structure and query relational databases. As you progress, you’ll use these foundations to quickly summarize and join tables and use window functions and built-in PostgreSQL functions to analyze your data.
Aulas do Curso
(19 vídeos)
0 de 19 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Introduction to SQL Databases: Relational Databases Basics
In this video, you'll explore the fundamentals of databases, the backbone of data organization. Learn how databases stor…
1
Understanding SQL Tables: Records, Fields, and Unique Identifiers
In this video, we explore the core of database design: SQL tables. Learn how tables are structured with rows and columns…
2
Understanding SQL Data Types: Strings, Integers, and Floats Explained
In this video, learn how different SQL data types like strings, integers, and floats are crucial for efficient database …
3
Introduction to SQL Queries: SELECTing Rows FROM Your Data
In this video, learn how to use SQL to extract meaningful insights from your database with the SELECT statement. Underst…
4
SQL Queries for Beginners: Aliasing, DISTINCT, and Views
In this video, we enhance your SQL query skills by introducing key concepts like aliasing, using the DISTINCT keyword, a…
5
Understanding SQL Flavors: PostgreSQL vs SQL Server Explained
In this video, we break down the nuances of popular SQL flavors like PostgreSQL and SQL Server. Learn how these flavors …
6
SQL Query Techniques: Using COUNT and DISTINCT in PostgreSQL
In this video, we explore intermediate SQL querying techniques in PostgreSQL, focusing on the SQL COUNT function and DIS…
7
Intermediate SQL: Understanding SQL's Order of Execution and Debugging Errors
In this video, we explore the intricacies of SQL Query Execution, including the processing order and essential debugging…
8
SQL Style Essentials: Best Practices & Semicolon Usage Explained
In this video, we explore the essential aspects of SQL style, focusing on formatting techniques and best practices that …
9
Filtering Numbers in SQL: A Guide to the WHERE Clause
In this video, you will learn how to efficiently filter data using the SQL WHERE clause and various comparison operators…
10
Advanced SQL Filtering: OR, AND, and BETWEEN Explained
In this video, we explore how to enhance your SQL filtering skills by using multiple criteria with the WHERE clause. Lea…
11
SQL Text Filtering Explained: WHERE Clause and Wildcards
In this video, we shift our focus from filtering numbers to mastering text filtering in SQL. Learn how to effectively us…
12
Handling Missing Values in SQL: Using IS NULL and IS NOT NULL
In this video, you'll learn how to handle NULL values in SQL, crucial for filtering and analyzing real-world databases. …
13
SQL Summarizing Data with COUNT, SUM, AVG, MIN, and MAX Functions
In this video, you'll learn how to summarize data using SQL's powerful functions like COUNT, SUM, AVG, MIN, and MAX. Und…
14
SQL Data Filtering: Using WHERE and Aggregate Functions
In this video, enhance your SQL skills by combining aggregate functions with the WHERE clause to extract valuable insigh…
15
Intermediate SQL: A Guide to SQL Aliasing and Arithmetic
In this video, you will see how to effectively use arithmetic symbols and understand the importance of parentheses in SQ…
16
SQL Sorting: ORDER BY, ASC, DESC Explained
In this video, you'll learn how to effectively use the ORDER BY SQL keyword to sort your query results for easier data a…
17
GROUP BY in SQL: Handling Errors and Multiple Fields
This video will guide you through grouping data using SQL, applying it with aggregate functions, and handling common err…
18
Understanding HAVING vs WHERE in SQL: Filter Grouped Data
In this video, we explore the HAVING clause in SQL and its role in filtering grouped data, a key concept for intermediat…