Intermediate SQL (Structured Query Language in Maze)
Duration:
4 Hours
Course Description:
The content of this course assumes that the participant has an advanced knowledge of using Maze and a basic understanding of SQL.
*Pre-Requisite Completion of Beginners SQL (Worksheets & Quicklists) Course
Course Outline:
A Database |
Data Storage |
Structured Query Language (SQL) |
SQL Help |
SQL Code Creation |
Advanced WHERE Statements |
Retrieving Data from more than one Table |
Grouping Summary and Aggregate Functions: |
Date and Time Functions |
String (Character) Functions |
System Functions |
Reducing Result Sets |
Advanced SQL Queries |
Appendix I Formatting SQL |
Appendix 2 Optimising SQL Queries |
Appendix 3 Mathematical Functions |