lynda SQL Queries Made Easy

Video Introducing this tutorial


Introduction :
Making a statement with SQL
How to use the exercise files

1. Creating Tables in Databases :
What is a table and naming conventions?
Database table types
Datatypes for columns in tables

2. Manipulating Data :
Add rows in tables
Modify rows and columns in tables
Delete rows in tables
Merge rows in tables

3. Transaction Control :
Committing database changes
Rollback in database changes

4. Data Definition Language :
Different ways to create tables
Alter tables
Drop, rename, and truncate tables

Conclusion :
Next steps

©2021 | All rights reserved.