SQL Fundamentals

Upon completion of this course, attendees will be able to:

• Know the different database management systems in the market place (E.g. Oracle, SQL Server)
• Have an understanding of different types of databases.
• Understand the basic structure of a database specifically for relational databases.
• Be able to do a basic select statement.
• Understand how to do basic calculations as part of the select statement.
• Know how to create aliases in a select statement
• Be able to expand the select statement to find specific data on the tables using the where clause.
• Understand how to select data from different tables in one select statement

The course covers the following areas:

What is SQL ?

• What is a database ?
• Types of databases
• What is a logical data model?
• What is relational data model?
• Keys
• Primary Keys
• Foreign Keys
• Common Data Types
• Example of a relational data mode

Normalisation and Database design

• Description of Normalisation
• First, second and third Normal Forms
• Other Normalisation Forms

The SELECT Statement

• Basic SELECT
• Select DISTINCT
• Select with formulas/calculations
• WHERE
• Other

Joins and other keywords

• Outer Joins
• Inner Join
• Full Join
• Group By Clause
• Having Clause

There are no specific prerequisites for this SQL course.

Test Managers, Developers, Functional Testers, Agile Testers, Test Automation Specialists, Performance Test Specialists 

• Learn the most up-to-date methodology
• Deliver increased efficiency and effectiveness to your team
• Learn through best practices and real examples
• Learn  with trainers who have proven track records
• Flexible delivery with online learning options
• Train with the world’s leading quality specialist for digital business