Structured Query Language (SQL) is the most popular language used to communicate with Relational Databases. SQL statements are used to perform tasks such as defining, loading, updating or retrieving data from a database. SQL supports a number of advanced features that make your queries more intelligent and efficient.
This course will provide delegates with the SQL skills needed to build simple or complex interactive queries against data which is stored in DB2 (or similar) databases. A progressive series of hands-on exercises provide the student with experience in using the language.
Anyone who will be using SQL to extract data from DB2 or other Relational Database Management System.
Delegates for this course should have a good working knowledge of the SQL SELECT statements.
Course Objectives:Exhibit SQL knowledge and literacy
Develop and use of SQL to an advanced level
Apply SQL performance related practices to their code
Apply knowledge with relevant practical exercises
After completing this course, the delegate should be able to:
Assessments are done throughout the course in the form of practical assignments that the delegates are required to complete as part of the course content.
Key Topics:Relational Database Systems
SQL for Basic Data Retrieval
Using the SQL Built-in Functions
JOIN Review and JOIN Techniques
CASE, CAST and Summary Tables
Using Temporary Tables
Common Table Expressions and Recursive SQL
Last modified: 13-Dec-2017