-
Course
- Data
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 | 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
About the author
With over three decades of software development experience, Simon has programmed in every discipline: from finance to transportation, nuclear reactors to game development. His first video course released back in 2002: since then, his popular courses have been viewed by hundreds of thousands of developers. Simon obsesses on making complicated subjects accessible, memorable, and easier to learn.
More Courses by Simon