In this course you will gain hands on experience working with SQL, on how to CREATE Tables in a Relational Database RDMS, using PRIMARY and FOREIGN Key’s. You will also learn how to modify the existing database, to either ALTER or UPDATE the information. This is a SQL programming course with extensive training and practice. The objective of this course is to teach you SQL, and prepare you to become a skillful SQL Developer by working with a Relational Database.
- Creating Table & Relational Database in SQL
- SQL SELECT Statemet
- Aggregate Functions Part 1
- Aggregate Functions Part 2: GROUP BY and ORDER BY
- JOINS: Aggregate Functions
- Special Features in SQL
- Course Conclusion