SQL Practice: Managing Tables with CREATE, ALTER, and DROP

41mIntermediate2024-11-04

Authors

Walter Shields

Tech Educator and Best-Selling Author

Course details

This course provides an introduction on how to create and alter tables in SQL. Learn how to define table structures, create new tables, and modify existing ones using SQL statements. Instructor Walter Shields covers the implementation of basic constraints to ensure data integrity. Check out this course to gain the tools to design and modify database schemas effectively.

This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice alongside the course content to advance your programming skills.

Learning objectives
Define the structure and purpose of SQL tables.
Create new SQL tables using CREATE TABLE statements.
Modify existing SQL tables using ALTER TABLE statements.
Understand and implement basic constraints such as PRIMARY KEY and FOREIGN KEY.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Course introduction
02 - What you should know
03 - How to use CoderPad

1. Introduction to Table Management

04 - Overview of table management

2. Creating Tables

05 - Solution - Basics of CREATE TABLE
06 - Solution - Defining data types and constraints

3. Altering Tables

07 - Solution - Basics of ALTER TABLE
08 - Solution - Adding and dropping columns

4. Dropping Tables

09 - Solution - Basics of DROP TABLE
10 - Solution - Dropping constraints

5. Practical Exercises and Assessments

11 - Solution - Create and alter tables
12 - Solution - Drop tables and cleanup