Intro to SQL
MS303.01
(May 1 - 28, 2006)
E-mail our teacher: Thuy Le
E-mail this student: Jon
Slate
Instructor:
Thuy Le
Thuy
Le has a Master degree in Information Systems. She has had experience using
MS SQL Server, MS Access, Oracle and 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
:
Introduction
Week
:
Setting Conditions
- LIKE and wildcards
- AND and OR
- BETWEEN
- IN and NOT IN
Week
:
Advanced Queries
Week
:
Manipulating Tables
- Create and delete tables
- create
- Modify and delete existing fields
- Create, update and delete records
- update
- delete
- Create indexes
©2006
Thuy Le. All Rights Reserved.
Lessons, messages, assignments, files, and other content of this site cannot
be reproduced or published without the express written consent of the original
author.
