Introduction to SQL

Focused View

Simon Allardice

2:18:09

83 View

1. Introduction

1. Introduction.mp4

04:56

2. Before You Write Any SQL.mp4

03:23

3. Sidebar - SQL vs. [Sequel].mp4

02:00

02. Database Fundamentals

01. The Reason Databases Exist.mp4

04:40

02. The Evolution of Relational Database Management Systems.mp4

02:43

03. The Point of Every Database.mp4

01:50

04. Entities and Tables.mp4

03:54

05. Rows and Columns.mp4

02:58

06. The Importance of Data Types.mp4

04:39

07. Dealing with NULL Values.mp4

01:33

08. Primary Keys.mp4

02:37

09. Foreign Keys and Relationships.mp4

02:13

10. Database Naming Conventions.mp4

03:12

3. Writing SQL Queries

1. The SQL SELECT Statement.mp4

02:49

2. Sidebar - Where Do You Write SQL.mp4

04:37

3. Filtering Data Using WHERE.mp4

04:36

4. Creating More Complex WHERE Conditions.mp4

05:01

5. Searching Multiple Values with BETWEEN and IN.mp4

03:43

6. Sidebar - Is SQL Case Sensitive.mp4

03:20

7. Sidebar - SQL and Whitespace.mp4

01:55

8. Using LIKE to Match Patterns.mp4

03:41

9. Using NULL in a SELECT Statement.mp4

01:34

4. Ordering, Grouping, and Aggregate Functions

1. Sorting Results with ORDER BY.mp4

01:39

2. The Power of Aggregate Functions.mp4

04:57

3. Summarizing Data with GROUP BY.mp4

03:42

4. Using GROUP BY and HAVING.mp4

02:45

5. Ignoring Duplicate Values with DISTINCT.mp4

01:59

6. Improving Your SQL Thinking.mp4

04:29

5. How to JOIN Tables

1. How to JOIN Tables in a Query.mp4

05:41

2. Using OUTER JOINs LEFT, RIGHT, and FULL.mp4

04:15

3. Using NATURAL JOIN.mp4

02:43

4. Table Aliases in SQL.mp4

02:38

6. Subqueries and Sets

1. Creating a Subquery.mp4

03:21

2. Using Column Aliases with AS.mp4

02:32

3. Combining Data with UNION and UNION ALL.mp4

03:38

4. Sidebar - UNION vs. JOIN.mp4

01:27

7. Adding, Updating, and Deleting Data

1. How to INSERT New Data.mp4

02:41

2. How to UPDATE Data.mp4

01:56

3. How to Delete Rows from a Table.mp4

02:17

8. Additional Topics

1. Understanding DML, DDL, and DCL.mp4

06:41

2. SQL and Generative AI.mp4

04:25

3. Where to Go from Here.mp4

02:29

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Microsoft SQL

SQLite

Simon Allardice

Instructor's Courses

Simon is Creative Director and Principal Author at Pluralsight. With over three decades of software development experience, he's programmed in every discipline: from finance to transportation, nuclear reactors to game development. Prior to joining Pluralsight, Simon was the principal developer author at lynda.com. His first video course released back in 2002: since then, his popular courses have been viewed by hundreds of thousands of developers. His current focus is both on the new — the latest iOS and Mac development technologies — and on the old: fundamental computer science topics. He obsesses on making complicated subjects accessible, memorable, and easier to learn.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.