SQL Training

Online SQL Training
Class Name

Introduction to SQL (Using Access)

Structured Query Language (SQL) is a very important data manipulation language. It is used in many different types of DBMS such as MySQL, Oracle, DB2, Microsoft SQL Server, and Microsoft Access. In this course, students will learn how to use SQL to retrieve, store or update data in Microsoft Access. The SQL syntax and data types may be different in other databases but students would manage to learn them very quickly once they have the foundation knowledge gained from this SQL course. Weekly lectures provide practical examples, illustration images, and detailed explanations. Weekly assignments will help students practice and go beyond what they have learned in the class.
Outline
Week 1: Introduction
  • Database basics
  • Structured Query Language (SQL)
  • SELECT statement
  • ORDER BY clause
Week 2: Setting Conditions
  • LIKE and wildcards
  • AND and OR
  • BETWEEN
  • IN and NOT IN
Week 3: Advanced Queries
  • Multitable joins
  • Union queries
  • Built-in functions
  • GROUP BY
  • HAVING
Week 4: Manipulating Tables
  • Create and delete tables
  • Modify and delete existing fields
  • Create, update and delete records
  • Create indexes
Prerequisites
Familiar with Microsoft Access is useful but not required.
Requirements
Microsoft Access 2000, 2003 or 2007 is required for this class. If you want to use MySQL for the course, take the MS304 course instead.
Class Books
No book is required.
[
]
Course Price
  • Member Price: $80.00 US
  • Non-Member Price: $180.00 US
[Register Now]

Additional Information:
This online course is limited to 100 participants. Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page. To get the start date of other courses, click on Open Class List link on the top navigation bar.

How eClasses Work:The classroom environment is based on Lundeen & Associates Web Crossing technology, a threaded messaging system. Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

  • Member Price: $80.00 US
  • Non-Member Price: $180.00 US
  • Course Duration: 4 weeks
  • CEUs: 2.0
  • Web Course No: MS303
  • Course Instructor: Thuy Le
  • Co-Instructor/TA:
  • Session Open for Registration
Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.

Instructor: Thuy Le
Thuy Le has a Master's degree in Computer Information Systems. She has had experiences using SQL Server, MS Access, Oracle and MySQL.

Testimonials:
'The course outline was straightforward. I knew what was expected at the end of each week. The lesson notes were clear. The examples reinforced information from the notes. Thuy gave prompt feedback and this in itself added to my energy on the lessons. Today, I am more confident around database queries and information presentation. I find that I can follow up and relate to explanations provided by database administrators.' -- Rosanna Burgess

'Two things: One, the lectures were finely focused. Short, clear, and concise. Thuy explained concepts and terms that I hadn't understood reading about from long winded authors. Two, was the emphasis on practical exercises. It is in the doing that I gained so much more understanding.' -- Michael Rook


4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Main Topics of Our Web Training Program: