|
|
|
SQL Training: Microsoft Mainframe Environment Training Online Course
SQL Training: Microsoft Mainframe Environment Training Online Course Total Time: 11 hour(s)
This online training course provides an overview of SQL, including basic concepts and terms related to database and table design. The basic tasks of creating a new table in a database, using the INSERT statement, and managing and deleting SQL tables and table data are covered, as well as a comprehensive discussion of database objects, which includes creating, changing, and deleting table views, table spaces, storage groups, indexes, index spaces, and databases. An introduction to basic query techniques is provided, along with an overview of using SQL to join tables.
| |
Try A Free Demo
|
Live Labs Available
|
24/7 Tutor Available
|
Need help? Click Here
|
| |
 |
 |
 |
 |
 |
SQL Training: Microsoft Mainframe Environment Training Online Course Lessons:
1 Database Maintenance
Describe how data is stored in a relational database
Explain the concepts of primary and foreign keys, and parent/dependent relationships
Create a new table in a database
Use the INSERT statement to add data to a table
Manage and delete SQL tables and table data
|
Duration 2 hours |
2 Database Objects
Describe the function of table views
Explain how all of the objects in a database are related
Distinguish between the two types of table spaces
Use the SQL system catalog
Create, modify, and delete database objects
|
Duration 2 hours |
3 Query Techniques
Understand basic SQL query concepts
Select columns and rows to create reports
Sort and compare rows using various conditions and clauses
Use SQL's built-in functions for reporting
Combine tables and calculate column values
Select date and time columns using various conditions and clauses
Parse date and time columns, and perform arithmetic functions on them
|
Duration 3 hours |
4 Joining Tables
Understand relational concepts
Use course tables
Describe SQL concepts
Define theory about joining and merging tables
Use outer joins
Understand how to merge tables
Design merging tables in a workshop
Code a subquery
Use a nested table expression
Code a simple subquery
Manage subqueries returning several rows
|
Duration 4 hours |
|
Telephone: 0871 222 8790 (Hotline Available NOW 24 hours a day, 7 days a week!)
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL
|
|
|
