Overview
-
Get up and running with database tables using SQL. This course helps beginners not only learn key concepts, but also practice working on real-world business scenarios.
Syllabus
-
Introduction
- Making a statement with SQL
- How to use the exercise files
- What is a table and naming conventions?
- Database table types
- Datatypes for columns in tables
- Add rows in tables
- Modify rows and columns in tables
- Delete rows in tables
- Merge rows in tables
- Committing database changes
- Rollback in database changes
- Different ways to create tables
- Alter tables
- Drop, rename, and truncate tables
- Next steps
