Advanced SQL Practice: Manage Tables
13mAdvanced2025-02-10
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
Get ready to practice advanced SQL table management techniques using the database of a sample chat application. In this course, designed for intermediate to advanced SQL users, instructor Scott Simpson guides you through the essentials of managing tables in SQL.
Learning objectives
Apply real-world task requests to an existing complex database.
Explain how table management operations work in SQL and what considerations to keep in mind when modifying tables.
Perform table management operations safely.
Learning objectives
Apply real-world task requests to an existing complex database.
Explain how table management operations work in SQL and what considerations to keep in mind when modifying tables.
Perform table management operations safely.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Let's practice managing tables
- 02 - CoderPad tour
1. Managing Tables
- 03 - Solution - Build the Contacts table
- 04 - Solution - Build the Messages table
- 05 - Solution - Build the Conversations table
- 06 - Solution - Build the Attachments table
- 07 - Solution - Build the Reactions table
Conclusion
- 08 - Next steps in advanced SQL