Hands-On Introduction: SQL

Get the tools, techniques, and know-how to write SQL queries through hands-on lessons where you’ll code along with the instructor.

Introduction

• Introduction to SQL
• Using GitHub Codespaces with this course

1. The Select Statement

• Fetch data
• Filtering data
• Types of functions, part 1
• Types of functions, part 2
• Using multiple tables

2. New Tables and Data

• Create new tables
• Change table structure
• Add new rows to a table
• Delete rows in a table
• Commit and rollback

3. Modifying Existing Tables

• Modify rows and columns in tables
• Merge rows in a table
• Drop or truncate a table
• Rename a table

Conclusion

• Next steps