Orange Coast Database Associates Database Training, Design and Programming Course Listing Page

Course Description

News and special offers from Orange Coast Database Associates
News

 Home-->Courses-->sql202s

Group Training

Individual Training

Scheduled Classes

Programming and Consulting

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Current Category

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

Contact Us

SQL202S: Accelerated Introduction to SQL Queries using SQL Server

Book List | Course Links

Tuition: $295.00 per student

Length: 1 day

Synopsis: Introduction to SQL queries using Microsoft SQL Server. Intensive, hands-on SQL class focusing on SQL data retrieval. Same as first two modules of SQL202. This course is ideal for business analysts looking to acquire SQL skills.

Formats: Corporate groups (min. 2 students) at your facility or ours in San Juan Capistrano, Orange County, California. Single individuals may take a regularly scheduled class or arrange a private one.

Scheduling: Flexible. Group and private training can be scheduled to suit your needs. See calendar for scheduled classes.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

 

Format this document for printing

Session 1Introduction & Basic SQL Data Retrieval3.0 Hours
 
  • Relational database foundations
  • Using the Query Analyzer or Management Studio
  • Basic SQL data retrieval operations, DML
  • SQL Select statement
  • SQL Predicates, SQL Where clause
  • Operators
  • Sorting
  • Calculated fields, Concatenation
 
Session 2SQL Functions, Multi-table Retrieval3.0 Hours
 
  • String Manipulation
  • Date Functions, Etc.
  • SQL Aggregate functions (SUM, AVG, etc.)
  • Group by
  • Having
  • Inner join, outer joins, self join
  • Single and multi-valued subqueries
  • Correlated subqueries
  • Unions
 

Materials: Manual with PowerPoint slides, text book, and training certificate.

 

Location: Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.

Related Services

Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.


Privacy Statement | Contact Information | FAQ's | Site Map | Back | Home | Top