|
SQL-100/
200
Course Length: 2 Days
Tuition:
$800
What Past Students
Have to Say:
Exceptional "Real World"
examples and scenarios. Instructor is very attentive to student needs.
Instructor shows very high degree of technical knowledge but can make
the material easy to understand. GREAT CLASS! ~B.H.\ Allied Swiss Screw
Products
Overview:
Students will learn what SQL is and how it can help them query a
database to answer questions.
Prerequisites:
Windows 95: Introduction or Windows 98: Introduction or equivalent
knowledge.
Performance-based
objectives
- Define what a relational
database is and identify some uses for the SQL language.
- Recognize proper syntax for an
SQL statement.
- Use aggregate functions,
column aliases, and mathematical expressions in a query statement.
- Use the WHERE clause to select
specific rows of information from a database.
- Search for specific character
strings or numeric data in a database.
- Write queries that return both
aggregate and non-aggregate information simultaneously.
- Write queries that select
information from two tables simultaneously.
- Generate a query and its
report using Access 97.
Course
Content
Introduction
to databases and SQL
·
Database concepts
·
Understanding SQL concepts
Introduction
to the SELECT command
·
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
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 97
·
Connecting to a database
·
Querying a database
·
Generating a report of the data
DAY
TWO
Performance-based
objectives
·
Use advanced techniques for querying a database.
·
Query with subqueries.
·
Add data to a database.
·
Change and delete data from a database.
·
Create, alter, and delete tables, and create, use, and delete
views.
·
Create and delete indexes.
·
Manage how data is altered through the use of transactions.
·
Create and drop databases.
Course
Content
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 records
·
Deleting records
·
Deleting the contents of tables
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
|
