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 |