Structured Query Language (SQL) Training
SQL Training
The course provides a foundation of the principles of Structured Query Language (SQL) queries and the type of reports that can be extracted from a Student Management System (SMS). Regardless if you are using an Oracle or Microsoft Database this training will help your non-technical power users to extract meaningful reports from your SMS.
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 the customer site and to gain access to site related data within the customer's SMS to ensure queries relate to existing table structure.
For more information, email info@s1consulting.com.au or telephone +61 2 9887 3980.
< back to our products