Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/include/func/func.logging.php on line 510
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/include/logging.php on line 54
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/include/logging.php on line 60
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/init.php on line 481
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/sessions.php on line 74
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/sessions.php on line 76
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/sessions.php on line 85
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/sessions.php on line 86
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/sessions.php on line 93
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/func/func.core.php on line 1836
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/cron.php on line 105
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/include/func/func.logging.php on line 49
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/include/func/func.logging.php on line 79
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/include/func/func.logging.php on line 86
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/include/get_language.php on line 165
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/include/func/func.logging.php:510) in /var/www/html/product.php on line 63
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/product.php on line 82
INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_BIG_SELECTS=1' at line 1
SQL QUERY FAILURE:SET OPTION SQL_BIG_SELECTS=1
INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_BIG_SELECTS=1' at line 1
SQL QUERY FAILURE:SET OPTION SQL_BIG_SELECTS=1
eClasses.org�::�Course Catalog�::�Introduction to SQL (Using Access)
eClasses.org :: Course Catalog :: Introduction to SQL (Using Access)

Introduction to SQL (Using Access) (MS303)

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.

Applicable Job Roles: web programmers, web application developers, database administrator, webmasters, and web project managers.

Course Objectives: at the end of this course, you will be able to:

  • Write queries to get information from the database
  • Change your queries based on specific requirements to produce ad hoc reports
  • Create and modify tables based on specific business needs
  • Understand basic queries written in php or asp pages or other web programming languages
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.

Introduction to SQL (Using Access)
Price: $180.00
Item No.: MS303
Instructor: Open Position
Open Courses: No other sessions are scheduled for this course. You can add to your wish list and you will be notified when other sessions are scheduled.

Testimonials
Instructor's ProfileInstructor
We are looking for an instructor to teach this course. To apply please visit the Teach Online section for more information.
Before you register for this class, please read the Outline, Prerequisites, Requirements, Books, and Refund Policy sections carefully.
 

Testimonials

Rating

  • "I really enjoyed this class! The instructor was well organized and prompt. I learned a lot and plan to take more SQL classes." - Barbara Bradley

  • "I enjoyed this course and learned a great deal from a very wonderful instructor. I look forward to may more classes through eClasses.
    " - Debra Mack

  • "Excellent class that refreshed my knowledge & skills of this topic. Many thanks." - Patsy James

  • "The Intro to SQL (using Access) was really helpful and I still use what I learned from the class in my position. It's helped me become more comfortable working with SQL and I am excited to take more classes! Thank you so much for this great class experience at such an affordable price" - Nichole Browning

  • "This SQL class gave me exactly what I needed for a solid introduction to SQL queries. I printed out and bound the lecture notes and, six months later, it's still the first place I go when I have questions about writing a SQL query. I'm very happy I took the class. Just wish there was an advanced class!" - Julie Cole

  • "Good Introduction course to SQL. I knew nothing before this class. I now feel I have an understanding of SQL. The lectures covered all basic SQL information, and the assignmets challenged me to actually learn what was presented." - Alan Yeckley

  • "Very good lectures and exercises! Thuy is a wonderful instructor." - Patricia Davidson

  • "Wonderful instructor, informative class, good place to start for learning SQL." - Karen Webster

  • "I appreciated the clear examples in the lectures and the assignments that supported concepts we were learning. Everything was relevant and I am able to start applying what I learned on my job. The instructor was always helpful." - Joan Schwimmer

  • "Great class! Look forward to taking more classes with Thuy!" - Sherri Sullivan

  • "This class was very helpful for me as a beginner. It helped build me a solid foundation from which to go on and learn more." - Janine Henderson

  • "Assignments were easy to understand. The assignments have enough information to make them worth while but not so much that it was difficult to complete them. Thuy Le responded to questions quickly." - Kelly Looney

  • "It was very easy to follow and understand." - Raelene Morin

  • "Thuy presented concise, to-the-point lectures that covered the course topics well. She was prompt in responding to questions and offered excellent examples and pointers. Thuy was patient and responsive. Great instructor and useful introduction to SQL." - Susan Bellomo

  • "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

  • "I liked that Thuy was able to take complex concepts and simplify them for the beginner. The lectures covered the information clearly." - Cindi Falker

  • "As an introductory course: I like the fact that it is simply illustrated, simple concepts, easy to adapt into for a subject that can be quite complex. I also like the fact that MS Access was used, since it was convienient and readily available. It's quick, no nonesense intro to SQL. As an introductory course to SQL for first timers of Databases, I highly recommended." - Alex Tai

  • "It gave the core knowledge needed to work with any SQL based database. Thuy Le is a wonderful instructor. The shorter length of the class was also a great benefit to my busy schedule." - Joel Ostrander

  • "Intro to SQL Course seemed to be a fresh and interesting approach of an intro. course to SQL which beforehand had seemed quite the mystery. Now, when the need calls for it, I can write quite a few SQL statements with no mystery at all." - Jon Slate

  • "Online format is great for people with busy schedules. You can read the lectures anytime and anywhere you have access to the Internet. The lectures were laid out well. It was great to have many examples to use when completing each assignment." - Elizabeth Eitter

  • "I think the class was well structured and sized, i.e. the lectures had great examples and the assignments were enough to teach me, but not overwhelm me since I also have a job to do. Taking courses like this enables me to fit the training in at work which I appreciate. This course was a great $ value for what I learned." - Edward Smith

  • "I liked that the good explanation and examples for everything." - Andrea Walker

  • "The instructor, Thuy was excellent in answering questions - giving explanations, tutoring, etc. Truely the best course I have done so far (ok admittingly this was only my 2nd one)!" - Julie Stekelenburg

  • "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

  • "Using SQL to do something I needed to do that I couldn't figure out how to do in Access." - Adell Daugherty

  • "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

  • "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

  • "Great beginners class. Instructor did not assume anything about the students and helped every way possible. Would recommend this course to others." - Dennis Copple

  • "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