Description |
This 54-hour hands-on instructor-led course, "Querying Relational Databases", is designed to help students learn advanced techniques for working with data in relational databases. Relational database management systems are the most common type of database currently in use, and this course provides labs, lectures, demonstrations, and hands-on practice for using Structured Query Language (SQL) to retrieve data and manipulate data in a modern relational database.
During the course, students will learn how to write complex SQL queries, use subqueries and joins to combine data from multiple tables, and work with aggregate functions to calculate summaries of data. Additionally, they will learn how to manipulate data by using INSERT, UPDATE, and DELETE statements, as well as create and manage tables and indexes. Students will also learn how to work with views, stored procedures, and functions, as well as how to use transactions to ensure data consistency.
The lab scenarios in this course are designed to support and demonstrate the structure of various application scenarios, and students will be able to practice their skills in a real-world environment. By the end of this course, students will have a solid understanding of advanced SQL techniques for working with data in relational databases, and they will be well-prepared to apply these skills in their professional careers.
|