Course Details

In this course on Structured Query Language (SQL) , you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. You will also learn the following:
•    Traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.
•    How to use SQL to sort and retrieve data from tables and how to use SQL to filter retrieved data.
•    How to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns.
•    How to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.
•    How to use SQL to create and maintain tables, create and use views to simplify complex queries, summarize data, and manipulate data stored in tables.
•    How transaction processing, constraints, and indexes are implemented in SQL and how stored processes
•    How stored procedures, triggers, and cursors are implemented in SQL.