MicroKnowledge Inc.
Contact | Driving Directions | Home
Current Course Calendar
Featured Micro-Sessions
Course Descriptions
Featured Micro-Sessions
Basic Skills
Business Programs
Business Skills
Databases
Desktop Publishing & Graphics
Internet and Communications
Operating Systems
Presentations
Programming
Report Writing
Spreadsheets
Web Page Design
Word Processing
Free Events
Register for a Class
Customized Training
Proprietary Technology Training
On Site Training
About On Site Training
MobileKnowledge
Consulting Services
Technical Writing
Employment Opportunities
About Us
Site Map
Create Profile
Request Information
Support
Download Course Training Files

SQL Fundamentals

Explore the SQL environment, retrieve data, use operators and functions, join tables and add subqueries.

Recommended Preparation: Access 2003 Intermediate or equivalent knowledge

Register for a class
Personalized training and consulting is available upon request.

Lesson 1: Introducing SQL

  • Understanding SQL

Lesson 2: Retrieving data from a table

  • Selecting records
  • Selecting columns
  • Summarizing data

Lesson 3: Using operators

  • Using logical operators
  • Using list operators

Lesson 4: Using functions

  • Using string functions

Lesson 5: Using joins

  • Joining tables

Lesson 6: Using subqueries

  • Using subqueries

 

 

 

 

 

 

Dates:
November 5
8:30-4:30

December 8
8:30-4:30

January 12
8:30-4:30

March 10
8:30-4:30


Price:
$199 for open enrollment courses, when available.

Length: 8 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile

Get Directions