Hands-On Introduction: SQL
1h 21mIntermediate2022-11-09
Authors
Deepa Maddala
Experienced Consultant and PL/SQL Developer in Information Technology
Course details
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.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
Introduction
- Introduction to SQL
- Using GitHub Codespaces with this course
The Select Statement
- Fetch data
- Filtering data
- Types of functions, part 1
- Types of functions, part 2
- Using multiple tables
New Tables and Data
- Create new tables
- Change table structure
- Add new rows to a table
- Delete rows in a table
- Commit and rollback
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