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.
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.
Table of contents
- The Reason Databases Exist 5m
- The Evolution of Relational Database Management Systems 3m
- The Point of Every Database 2m
- Entities and Tables 4m
- Rows and Columns 3m
- The Importance of Data Types 5m
- Dealing with NULL Values 2m
- Primary Keys 3m
- Foreign Keys and Relationships 2m
- Database Naming Conventions 3m
- The SQL SELECT Statement 3m
- Sidebar: Where Do You Write SQL? 5m
- Filtering Data Using WHERE 5m
- Creating More Complex WHERE Conditions 5m
- Searching Multiple Values with BETWEEN and IN 4m
- Sidebar: Is SQL Case Sensitive? 3m
- Sidebar: SQL and Whitespace 2m
- Using LIKE to Match Patterns 4m
- Using NULL in a SELECT Statement 2m