SQL Foundation Course

Is it right for me?

Our SQL Foundation course is aimed at those who need to create queries and extract data from an RDBMS. The course is aimed at users of Oracle and Microsoft SQL Server.

The course will run using the Oracle SQL developer tool. ANSI standard code is used wherever possible as this can be applied to virtually all databases, but variances specific to Oracle and SQL Server are shown in the accompanying course manual.

What will I get out of it?

By the end of the course participants will be able to:

• Create and modify tables
• Create and edit queries
• Sort and group data
• Use text and date functions
• Create basic conditional statements
• Create basic Pivot Data Tables

Versions Available

Oracle

Related courses in our range

• Access Database Design - Advanced
• Crystal Reports Module 1 & 2 - Creating and Modifying Reports

What does it cover?

A brief history of databases and SQL

• The development of SQL
• SQL dialects
• ANSI standard SQL

Creating and modifying data tables

• Setting field data types
• Altering table structures
• Deleting tables

Entering data into tables

• Adding new records to tables
• Deleting individual records
• Deleting all records from tables

Creating SELECT statements

• SELECT, FROM, WHERE
• Using aliases

Sorting data in queries

• Sorting a single column
• Sorting on multiple columns

Linking tables in queries

• Inner joins
• Natural joins
• Left outer joins
• Right outer joins
• Full outer joins
• Building queries on multiple tables
• Creating subqueries

Text functions

• Concentrating text strings
• Using wildcards to find text
• Using UPPER, LOWER, TRIM and SUBSTR functions

Date functions

• Current date
• Extracting portions of date fields
• Date calculations

Conditional statements

• Using CASE ... WHEN

Pivot data

• Introduction to pivoting data