SQL Fundamentals This course also available online.
Author: Manta Technologies
Availability: Ships within 72 hours. SKU: 3095
Course Description: Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database, such as the DB2 UDB database found on an OS/400 system. This course provides an introduction to SQL and describes the SQL statements to:
· Define queries
· Change the contents of a file
· Create and delete libraries and files
You will also see how to use Interactive SQL to enter and run SQL statements.
After completing this course, you should be able to: • Identify the components of the DB2 Query Manager and SQL Development Kit • Use and define SQL terminology • Identify the DB2 UDB objects to which SQL terms are mapped • Use Interactive SQL to execute an SQL statement • Use the SQL SELECT statement to define a query • Code the SQL statements required to create libraries and files • Code the SQL statements required to delete libraries and files
Audience: This course is intended primarily for programmers, but can be taken by anyone interested in learning how to use SQL to work with a DB2 UDB database.
Prerequisites: This course assumes that you have a basic knowledge of DB2 UDB. You can satisfy this prerequisite by successfully completing the course Introduction to DB2 UDB. In addition, the second and third courses
Course Outline: Introduction to SQL Defining and Running a Basic Query Advanced Querying Capabilities Making Changes to the Contents of a File Creating and Deleted SQL Objects
Course Details:
Length:
90 minutes
Materials:
A Student Reference Guide is available for this series.
Publisher:
Manta
SQL Fundamentals This course also available online.
SQL Fundamentals
