SQL Training
SQL TRAINING
The course provides a foundation of the principles of SQL Query and the type of reports that can be extracted from a SMS. Regardless if your using Oracle or Microsoft Databases this training will help your non-technical power users to extract meaningful reports from your Student Management System.
Training Schedule
|
Day 1
- Session 1
- Introduction to Relational Databases/SQL/Tables
- Logic & Value
- Precedence & Parenthesis
- Exercises testing the above knowledge
- Session 2
- String Functions
- Number Functions
- Exercises testing the above knowledge
- Session 3
- Date Functions
- Conversion and Transformation Functions
- Exercises testing the above knowledge
|
Day 2
- Session 1
- Group Functions
- Exercises testing the above knowledge
- Session 2
- Joins
- Exercises testing the above knowledge
- Session 3
- Decode and Case Statements
- Insert/update/delete statements
- Other Database Concepts
- Exercises testing the above knowledge
|
Preparation Day
A preparation day is required to tailor training to customer site and to gain access to site related data within the institutes SMS to ensure queries relate to existing table structure.
< back to our products