SQL - Querying 1

Download PDF

Next Dates:

Mon, 26. Mar. 2012
Tue, 05. Jun. 2012
Thu, 09. Aug. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 325

Target audience & Prerequisites:

This Course is designed for participants who have a basic knowledge of networking and database design. This Course is designed for participants who have a basic knowledge of networking and database design. Participants should have basic knowledge of Windows, Access and Networking.

Learning objectives:

On completion of course, participants will be familiar with SQL, move around and query a database to answer various questions. On completion of course, participants will be familiar with SQL, move around and query a database to answer various questions.

Course Outline:

INTRODUCTION TO DATABASES AND SQL

Database concepts
Understanding SQL terminology

INTRODUCTION TO THE SELECT STATEMENTCALCULATING DATA

Aggregate functions
Column aliases
Performing calculations
Date functions

SELECTING SPECIFIC ROWS

The WHERE clause
The ORDER BY clause

WORKING WITH OTHER OPERATORS

Searching for text
Logical operators
NULLs

GROUPING DATA

The GROUP BY clause
The HAVING clause
Comparing the WHERE and HAVING clauses

MULTI-TABLE QUERIES

Joins
Joining tables
Outer joins

QUERYING A DATABASE USING ACCESS

Connecting to a database
Querying a database
Generating a report of the data

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