SQL Queries Made Easy

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.

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