SQL Deep Dive

By Landon Fowler

Learn about SQL and how to leverage it, including selecting, updating, and deleting information and creating and altering database objects.

3 hours
  • 32 Lessons
  • 3 Hands-On Labs

About the course

SQL is a powerful language for data retrieval and manipulation. Utilized in databases of every size, it is an industry-standard for working with data. In this course, we are going to discover what SQL is and how to leverage it. This includes selecting, updating, and deleting information, as well as creating and altering database objects.

Familiarity with the SQL language is an asset to your career, whether you’re a programmer, sysadmin, DBA, or analyst. And it’s quite fun! I look forward to diving into SQL with you.

  • Chapter 1 3 Lessons Getting Started 3:53

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    Course Introduction

    1:46

    About the Training Architect

    0:48
  • Chapter 2 1 Lesson Database Setup 4:18

    Creating an Azure SQL Database

    4:18
  • Chapter 3 1 Lesson Client Setup 3:08

    Setting Up Visual Studio Code

    3:08
  • Chapter 4 2 Lessons Database Basics 6:29

    What Is an RDBMS?

    3:44

    What Is ANSI SQL (and What Is It Not)?

    2:45
  • Chapter 5 5 Lessons Retrieving Data (Basic) 16:08

    Selecting

    3:37

    `WHERE` Clauses

    5:12

    `HAVING` Clauses

    2:12

    Sorting Results

    2:49

    `NULL` Values

    2:18
  • Chapter 6 8 Lessons Retrieving Data (Advanced) 1:39:44

    Selecting Ranges

    6:54

    Fuzzy Lookups

    3:27

    `WHERE` Operators

    3:03

    Aliases

    7:33

    Joins

    7:56

    Joins (Advanced)

    8:05

    Logic Conditions

    2:46

    Using SQL to Retrieve Data

    1:00:00 Hands-On Lab
  • Chapter 7 4 Lessons Changing Data 43:24

    Inserting

    6:34

    Updating

    3:38

    Deleting

    3:12

    Using SQL to Change Data

    30:00 Hands-On Lab
  • Chapter 8 5 Lessons Manipulating Objects 48:09

    Database

    2:07

    Table

    7:53

    Index

    4:41

    View

    3:28

    Using SQL to Manage Database Objects

    30:00 Hands-On Lab
  • Chapter 9 2 Lessons Safeguarding Our Database 17:57

    SQL Injection

    3:28

    Performance

    14:29
  • Chapter 10 1 Lesson Final Steps 1:37

    What's Next

    1:37

What you will need

  • A basic understanding of databases and table layouts will help you pick up the concepts more quickly, but anyone interested in working with data is welcome! We will start with the basics and work up from there.

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!