Choose your language:

France
Germany
Hong Kong
India
Ireland
Japan
Malaysia
Netherlands
New Zealand
Singapore
Sweden
United Kingdom
United States

SQL Techniques

Course Code

RT691

Duration

2 Days

Basic computer skills
In this course, participants will compose SQL queries to retrieve desired information from a database.
This course is designed for individuals who are developers, testers and analysts.

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

  • Connect to the database and execute a simple query.
  • Include a search condition in a query.
  • Use various functions based on the data types to perform calculations on data.
  • Retrieve data by combining information from multiple tables.
  • Summarizing, grouping and combining data to obtain more meaningful query results
  • Managing data within tables using the SQL Data Manipulation Language (DML)
1. Introduction
Relational Databases
Client-Server
Tables, Columns, Rows
Structured Query Language
ANSI SQL

2. Oracle Tools
SQL*Plus
SQL Developer

3. MS SQL Server Tools
sqlcmd
Management Studio

4. Select Statement
Connecting to the database
Select
From
Correlation Names
Column Aliases

5. Where Clause
Logical Operators
Equality Operator
Between Operator
In Operator
Is [not] Null Operator
Finding Text Strings
[not] Like Operator

6. Sorting Data
Order By Clause
Multiple Column Sorts
Specifying the Sort Sequence
About Null Values Within Sorts
Using Column Aliases

7. Aggregating Data
Aggregate (Column) Functions
SUM
COUNT
MIN, MAX
AVG
Grouping
Having
Distinct

8. Set Operators
UNION
UNION ALL
INTERSECT
EXCEPT (MINUS)

9. Joining Tables
About Joins
SQL99 Join
Multiple Tables
Additional Conditions

10. Subqueries
About Subqueries
Where Clause =
In Clause
Column Subquery
Subquery or Join

11. Manipulate Data
Insert Statement
Update Statement
Delete Statement
Truncate Table
Transactions
Rollback
Commit

12. Security Overview
Users
Schemas, Databases
Permissions
Grant, Revoke

13. Advanced Techniques
Write outer joins
Execute self-joins
Execute correlated subqueries
Use the case expression

14. (Optional) Oracle Specific Topics
Dual Table
Describe
Rowid, Rownum
Oracle Functions
Copy Table
PL/SQL

15. (Optional) MS SQL Server Specific Topics
Transact-SQL
Update, Delete Joins
System Stored Procedures
sp_help
select into
Send Us a Message
Choose one