| |
 |
|
Intro to SQL for Elite
Sample Agenda
DAY ONE
Morning: Introduction & Overview
-
Welcome and Introduction
-
Purpose of Class
-
Overview of Elite
EPBS Tables
- Overview of Tables
-
Master Tables
-
Summary Tables
-
Transaction Tables
Afternoon: Introduction to Query Analyzer, ISQLw, dbaccess
SQL Statements
-
Origins of SQL
-
General Statements using SELECT, FROM, and *
-
Limiting Data using WHERE, DISTINCT, mathematical operators, and IS (NOT) NULL
|
DAY TWO
Morning: SQL Statements (Continued)
- Review of General Statements
- More on Limiting Data
- Inserting Aliases for Column Names
- Combining Limits using AND, OR and IN
- Organizing Data using GROUP BY and ORDER BY, with HAVING
Afternoon: SQL Statements (Continued)
- Querying on Multiple Tables using JOINs
- Totaling and Sub-Totaling with SUM, COUNT and other Aggregates
- Caveats, Warnings and What Lies Ahead
|
|
|
"We had an Intro to SQL class here last week. 6 people from our firm attended the class (taught by Allan Rousselle). I have heard nothing but rave reviews and compliments regarding the class. Even our in-house trainer commented that as she walked by, she was amazed at the interest level she could see and how into the class everyone seemed. She said that this was very unusual to see. Anyway, just wanted you both to know how pleased we were with everything Allan did."
Ken Koehn
Former Director of Finance
Much Shelist
"Instructor is enthusiastic and communicated well with students. Course content met stated objectives. Good course. I would recommend it to others."
Erin Searfuss
Latham & Watkins
"May not use all the info as I'm just taking the course since our Controller is leaving and was apprehensive as I don't know Elite. But this was a terrific class and was extremely well presented. I learned so much in a short time that it should put me in a good position to troubleshoot problems. This was one of the best taught courses I've taken."
Diane R. Stoudt
Systems Administrator
Wingert Grebing Brubaker & Ryan
"Good class. I think it will be more helpful than I anticipated. Great instructor!"
Jane Burton
Scribner Hall & Thompson
"I feel that I have learned a tremendous amount in only 2 days and I feel very confident that I will be able to practice what I've learned."
Andrea Cooper
Elite Project Coordinator
Stinson, Mag & Fizzell |
|
