Course Information
Course Schedule
|
Training Policies
|
Course:
|
SQL Level 1 - Introduction To SQL |
|
Start Date: |
11/16/2009
End Date: 11/16/2009 |
|
Check-In: |
8:30 AM
Starts at:
9:00 AM
|
|
Duration: |
8 Hours 1st Day:
Monday |
|
Location: |
Result Data Training Center |
|
Type: |
SQL Training |
|
Price: |
$485 |
Other Dates for this Course:
Introduction to SQL
Duration: 1 Day
$485.00
COURSE DESCRIPTION:
This one day workshop is designed to provide the student with a solid understanding of database concepts and the basics of the SQL language. It includes review of database structures, application architecture, SQL constructs and client-server fundamentals. The course utilizes a series of hands on activities where the student writes, executes and examines SQL statements using 92ANSI compliant (multi-vendor) SQL syntax. The exercises are progressive adding more sophisticated elements of SQL on to existing work. The course is taught by an experienced consultant with a SQL development and programming background and substantial real world exposure.
TOPICS COVERED:
-Database Fundamentals & Vocabulary
-Database Types (Sequential vs. Relational)
-Relational Concepts Overview (RI, PK, FK)
-Installing & Configuring a Database Client
-ODBC/ADO Overview
-SQL constructs
-Basic Select Statements
-Selecting Distinctly (distinct)
-The Where and Order By clauses
-Multi-Table Joining (inner & outer joins explained & tested)
-Aggregate Functions (Sum, Count etc.)
-Group By
-Deleting Data Conditionally
-Updating Data Conditionally
-Inserting Data
MATERIALS:
This course includes a free copy of a leading published SQL text, a student workbook, a free copy of the RDC Info Assistant software (via download). Slides and other course materials are available to students in electronic format (via download).
WHO SHOULD ATTEND:
Individuals with little or no SQL experience. This course is targeted at users who will need to write, analyze and use SQL statements. It's ideal for database administrators, analysts, consultants, programmers, business people or anyone seeking to have a greater understanding of the SQL language.
PREREQUISTITES:
No prior database experience is necessary (but it's helpful). A firm understanding of MS-Windows and Windows applications is mandatory. The course is best suited for people who have used spreadsheets and word processing applications for several years and wish to learn about databases and the SQL language.
MORE INFORMATION:
Call us at 614.505.0770 for more information or to find out if this course covers specific information that you are looking for. Click here for course schedules.
(c) 2001 Result Data Consulting, Ltd - All Rights Reserved. - Course Content is subject to change.
|
Pre-Registration for this Course
Submit to request a seat in this course on:
11/16/2009
|
First Name: |
|
|
Last Name: |
|
|
Company: |
|
|
Job Title: |
|
|
Email: |
|
|
Work Phone: |
|
|
Cell Phone: |
|
|
Street 1: |
|
|
Street 2: |
|
|
City: |
|
|
State-Zip: |
|
|
Note: |
|
|
|
Sending, please wait...
Some fields are required, click the button to submit your pre-registration request
|
This pre-registration does not confirm your seat, but will hold your place in line if there is a waiting list. You will
be contacted within one business day after submitting your pre-registration request. Confirmation occurs once you have
arranged for payment (applies to paid-events such as training courses only).
If you are not contacted within one business day or your are experiencing problems, please call us at 614-505-0770 to
confirm your seat at this event.
|
|
|
|
Announcements
Whether a current or prospective user, this event will provide an in-depth look into the world of QlikView. From case studies, contests, workshops, training and the first public deep dive into QlikView 10.
|
|
Attend the SQL Server User Group meeting on September 10th to learn, share and discover information about SQL Server and related Microsoft software.
|
|
Crystal Reports and all SAP BusinessObjects courses offered by Result Data now qualify for Continuing Professional Education (CPE) credits through National Association of State Boards of Accountancy (NASBA). Call us for more information.
|
|
|
|
 | Loading… |
|
|