Introduction to SQL (Using MySQL)

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
None
Requirements
MySQL database and access to MySQL command line or PHPMyAdmin or any other MySQL administration tools to run queries. (Note that you do not need to know MySQL. But you need to have access to MySQL database. Usually you have access to MySQL databases and PHPMyAdmin if you have an Unix web hosting account. If you want to use MS Access for the course, take the MS303 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.

1977

Price: $180.00
IWA-HWG Price: $80.00
Course No.: MS304
Instructor: Thuy Le
Co-instructor/TA:
CEUs: 2
Duration: 4 weeks
Open Courses:
Start Date: Apr 02, 2012
(Register by: Apr 05, 2012)
Start Date: Jun 11, 2012
(Register by: Jun 14, 2012)
Start Date: Sep 17, 2012
(Register by: Sep 20, 2012)
Start Date: Nov 12, 2012
(Register by: Nov 15, 2012)

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
"It was a very good course led by a very helpful instructor. I enjoyed it a lot and managed to learn more than expected in the given time period. I like the way eClasses works, I'll definitely be trying out some more courses. Thanks a lot." - Jacob Bruce
"I had fun with this class. I found the class very easy and the lessons easy to understand. It is worth taking if you plan to work on the web. I would recommend this class to all." - Sanjay Shetty
"Straight-forward 4-week introduction to MySQL with clear and concise lectures, and with prompt teacher responses to student work and questions." - Stewart Moore
"Enjoyed the introductory course to SQL - the lecture notes were concise and clear, which helped making the learning much more smoothly. The instructor was very encouraging, supportive, responding with comments and feedback in a timely manner. Great course - Thank You!" - Dana Mah
"I thought the assignments covered things that we would likely need to do when working with databases." - Letitia Wetterauer
"phpMyAdmin gave me a headache but after this class I feel comfortable with it - and of course with Thuy's help I really got there. Thanks Thuy you were a great help. " - Dorothy Wegmueller-Ngudle
"Thuy Le responded so quickly to problems in my assignments that it was hard to keep up (I mean this in a good way). His comments were diplomatic and always helpful, and the lectures were informative enough to justify the class not having a required text. I really enjoyed the class." - Scott Guhse
"I think we could use having a book for reference (or online materials). One section was particularly tough, and that was how to do joins. The last exercise was particularly good in that we had to make up our own data. We had to really think about the way the query language actually works." - Tamara Peace
"Good way to learn MySQL if you have a full time job." - Kevin (Xiao) Wang
"beginning of class was a little bit basic...I think maybe the first two weeks worth of assignments could be rolled into one...then you would have an extra week to go over all the material introduced in the third and fourth weeks (which were more challenging)...overall a nice course... " - John Petroshius
"I found this course exactly the right level for me - each lecture taught me something new and the assignments were challenging without being too difficult." - Emily Tarrant
"I used the SQL/MySQL course to brush up on SQL before continuing to the database design and MySQL courses. The lectures were well structured and easy to understand, and we got good and clear answers to our questions from the instructor, who also answered amazingly fast. A nice and very useful course." - Susanne Layla Petersen
"I enjoyed the class and liked the direct approach Thuy took in the lectures and assignments." - Paula Grigsby