SQL - Querying 2

Download PDF

Next Dates:

Wed, 28. Mar. 2012
Fri, 01. Jun. 2012
Fri, 31. Aug. 2012
Tue, 11. Dec. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 550

Target audience & Prerequisites:

2012-06-05 2012-08-09 Participants should have basic knowledge of SQL.

Learning objectives:

On completion of course, participants will know how to perform advanced queries, add, update, and delete data, tables, views, and indexes

Course Outline:

QUERYING WITH UNIONS AND ADVANCED JOINS

Querying multiple tables with unions
Advanced Joins
Calculating with COMPUTE

QUERYING WITH SUBQUERIES

Subqueries

ADDING DATA

Inserting data
Select Into

UPDATING AND REMOVING DATA

Updating Tables
Deleting Records
Deleting the Contents of Tables
Adding and Removing Views

MANIPULATING TABLES AND VIEWS

Creating Tables
Modifying Tables
Deleting Tables
Adding and Removing Views

MANIPULATING INDEXES

Adding and Removing Indexes

ENSURING DATA INTEGRITY WITH TRANSACTIONS

Transactions

CREATING DATABASES

Creating a database with SQL
Deleting a Database

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List