Calendrier

Mai 2012 Juin 2012
Lu Ma Me Je Ve Sa Di
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31

Search

Search

SQL 1
Download PDF

Prochaines Dates:
Mar, 05. Jui. 2012
Jeu, 09. Auo. 2012
Jeu, 13. Sep. 2012

Choisissez une date:



Mode:

Durée:
1 journée

Emplacement:
Ottawa

Langue du cours:
EE

Nombre maximal de participants:
10

Prix:
$ 325

Clientèle cible et pré-requis:
Participants should have basic knowledge of Windows, Access and Networking.This Course is designed for participants who have a basic knowledge of networking and database design.

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

Aperçu du cours:

INTRODUCTION TO DATABASES AND SQL
• Database concepts
• Understanding SQL terminology
INTRODUCTION TO THE SELECT STATEMENT
• An overview of the SELECT statement
• Syntax rules you’ll want to know
CALCULATING 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

• 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


N'oubliez pas que nous bâtissons les horaires en fonction de vos demandes. Visitez la liste de cours, et appellez-nous au (613) 235-6161 ou envoyez-nous un courriel à training@compuease.ca: