The delegates will practise:
Who will the Course Benefit?
Anyone who needs to understand and use SQL to manipulate a database.
There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure to information technology in general would be useful.
To provide the knowledge and skills needed to retrieve and update data held in a relational database.
There is an overlap between the content of this 1 day Introduction to SQL course and the content on the suggested follow-on Oracle and MySQL/MariaDB courses. You may wish to review the content of the 3 day Oracle SQL course, the 3 day Introduction to MySQL course or the 3 day Introduction to MariaDB course and if more suitable to your training needs attend one of those courses rather than this 1 day Introduction to SQL course.
Some previous programming or database experience would be useful.
NOTE: Course technical content is subject to change without notice.
Course Contents - DAY 1
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions
Session 1: RELATIONAL DATABASE CONCEPTS
What is a Relational Database?
Relational Database Structures
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
The Data Dictionary
Session 2: RETRIEVING DATA WITH THE SELECT STATEMENT
The Select Statement
The Select and From Clauses
Conditions and the Where Clause
Other Conditional Operators
The Order By Clause
Precedence of Operators
Session 3: AGGREGATE FUNCTIONS
Overview of Built in Aggregate Functions
The Group By Clause
The Having Clause
Session 4: JOINING TABLES
Overview of Table Joins
ANSI Join Syntax
Session 5: BASIC SUBQUERIES AND SET OPERATORS
Overview of Subqueries
|Course Duration||1 Day|