Sorry, we do not have any courses matching your criteria
What time shall I arrive at the venue?
Please arrive at the venue for 08:45am
What are the pre-requisites?
Some previous programming or database experience would be useful
The Knowledge Academy
Course Introduction
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions
Relational Database Concepts
What is a Relational Database?
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Data Types
The Data Dictionary
Getting Started
SQL Language Essentials
The Select Statement
The Select and From Clauses
Conditions and the Where Clause
The Order By Clause
Arithmetic Operations
Column Aliases
Practical Exercises
Summarising and Grouping Data
Aggregate Functions
The Group By Clause
The Having Clause
Practical Exercises
Querying Multiple Tables
Joining Tables
Inner Joins
Column Qualification and Table Aliases
Outer Joins
- The Knowledge Academy Courseware Book
- Manual
- Certificate
- Experienced Instructor
- Refreshments
There hasn't been any testimonials submitted to this topic
We do not currently have a video for this topic
