Hands-On Introduction: SQL

Hands-On Introduction: SQL

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 21m | 215 MB

Join instructor Deepa Maddala as she uses hands-on lessons to teach you the tools, techniques, and know-how that you need to start using SQL from day one. Deepa guides you through using the Select statement to fetch and filter data, creating and adding to tables and data, modifying existing tables, and what to use in different scenarios. She includes simple examples with each topic she covers.

The best way to learn a language is to use it in practice. That’s why this course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace. Check out the “Using GitHub Codespaces with this course” video to learn how to get started.

Table of Contents

1 Introduction to SQL
2 Using GitHub Codespaces with this course

The Select Statement
3 Fetch data
4 Filtering data
5 Types of functions, part 1
6 Types of functions, part 2
7 Using multiple tables

New Tables and Data
8 Create new tables
9 Change table structure
10 Add new rows to a table
11 Delete rows in a table
12 Commit and rollback

Modifying Existing Tables
13 Modify rows and columns in tables
14 Merge rows in a table
15 Drop or truncate a table
16 Rename a table

17 Next steps