- Course
Introduction to SQL
Learn SQL from scratch and master practical database querying, including using Generative AI tools. Whether you need SQL for data analysis, software development, or better business insights, we'll cover all the fundamentals of real-world SQL skills.
- Course
Introduction to SQL
Learn SQL from scratch and master practical database querying, including using Generative AI tools. Whether you need SQL for data analysis, software development, or better business insights, we'll cover all the fundamentals of real-world SQL skills.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
In this engaging, fast-paced course, you'll learn the fundamentals of SQL and gain practical skills for querying databases, including leveraging the latest Generative AI tools for SQL. We'll begin with a quick crash course on relational database fundamentals to ensure you have a solid foundation. From there, we'll dive into the essential concepts and syntax of SQL, building upon them to explore more advanced topics. You'll discover how to create and manipulate tables, retrieve and filter data using SELECT statements, and perform more complex queries with joins, subqueries, and aggregations. Throughout the course, we'll focus on helping you change your thought process to make writing queries more intuitive and efficient. We'll explore common questions people have when learning SQL, cover real-world best practices, and even dig into how you can now use Generative AI to supercharge your SQL skills. By the end of this course, you'll have a solid understanding of SQL and the practical skills to effectively manipulate and analyze data in various domains.
Introduction to SQL
-
The Reason Databases Exist | 4m 40s
-
The Evolution of Relational Database Management Systems | 2m 43s
-
The Point of Every Database | 1m 50s
-
Entities and Tables | 3m 54s
-
Rows and Columns | 2m 58s
-
The Importance of Data Types | 4m 39s
-
Dealing with NULL Values | 1m 33s
-
Primary Keys | 2m 37s
-
Foreign Keys and Relationships | 2m 13s
-
Database Naming Conventions | 3m 12s
-
The SQL SELECT Statement | 2m 49s
-
Sidebar: Where Do You Write SQL? | 4m 37s
-
Filtering Data Using WHERE | 4m 36s
-
Creating More Complex WHERE Conditions | 4m 39s
-
Searching Multiple Values with BETWEEN and IN | 3m 43s
-
Sidebar: Is SQL Case Sensitive? | 3m 20s
-
Sidebar: SQL and Whitespace | 1m 55s
-
Using LIKE to Match Patterns | 3m 41s
-
Using NULL in a SELECT Statement | 1m 34s