Course Name: Introduction to SQL Course Number: TT410 Description: This course describes a relational database and states its benefits. The course will describe SQL statements to retrieve data, based on specific criteria along with SQL statements to insert, modify, and delete data from a table. This course is set up to be used in conjunction with the demo relational database provided with CA-IDMS. There are also discussions on the data description language of SQL. Topics of discussion include: Relational database concepts What is SQL? Retrieving data Using conditional retrieval Using aggregate functions Accessing multiple tables Nesting SELECT statements Updating a table Data description language Duration: 1 day Prerequisites: None Target Audience: Programmers and others who will be accessing a relational database. Objectives: Upon completion of this course, student will be able to: Describe the characteristics of a relational database Access data in relational tables with both simple and complex queries Update data in relational tables Have an understanding of how to define a relational database