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.


Additional information:

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 might be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

How eClasses Work:Instructors post lectures (text-based, no video or audio), 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.

2004
Price: $180.00
Course No.: MS303
Instructor: Thuy Le
Co-instructor/TA:
CEUs: 2
Duration: 4 weeks
Open Courses:
Start Date: Nov 08, 2010
Register by: Nov 11, 2010

Testimonials

Instructor's Profile:
InstructorThuy Le has a Master's degree in Computer Information Systems. She has had experiences using SQL Server, MS Access, Oracle and MySQL.
Before you register for this class, please read the Outline, Prerequisites, Requirements, Books, and Refund Policy sections carefully.
 

 Testimonials

Ratings
"This was my first on line education experience. I found it to be as good if not better than many class room experiences I've had at our local college." - Jackie Gilliam
"Great beginners class. Instructor did not assume anything about the students and helped every way possible. Would recommend this course to others." - Dennis Copple
"I felt the lectures were easy to understand and provided good examples to reinforce the concepts that were being taught. I definitely learned some new SQL concepts and commands that will help in using SQL at my job. Also, the instructor was clear and concise in the answers to the questions we had as a class." - Christopher Schmit
"The best part of any class is usually the professor and this class was great. I thought Thuy really made herself available to help and her lessons were Super. I had no trouble following along." - Sherrie Fowler
"Using SQL to do something I needed to do that I couldn't figure out how to do in Access." - Adell Daugherty