SQL Training

SQL Training - Learn SQL Technology Online
Class Name

Introduction to SQL

Learn the basics from a simple SQL (Structured Query Language) statement to more complex 3-table join. Inserts, updates, deletes, inner joins and outer joins are thoroughly covered in this course.
Outline
Week 1
  • Introduction to setting up a relational database.
  • Set up your own Access database table in a new database.
  • Learn about clauses and how they are used.
  • Design a SQL statement to obtain records from a database.
  • Use parameterized queries.
Week 2
  • Learn more complex transact SQL.
  • Use in and not in statements.
  • Find out about wildcards and the like clause.
  • Set up where clauses with date fields and built-in date functions.
  • Insert new rows into your tables.
Week 3
  • Order by and group by statements.
  • Aggregate statements and their use with group by statements.
  • Calculations in queries.
  • Delete statement and how deletes affect a database.
Week 4
  • How to add a 2nd table to your database.
  • What is a 2-table join?
  • How to use 2-table aggregate statements.
  • You will learn about the use of database indexes.
  • Also covered are inner joins.
  • You will see how to update a row in your table.
Week 5
  • Add a 3rd table to your database.
  • Design 3-table joins.
  • Work with outer joins: full, right and left.
Week 6
  • Set up a view.
  • How to set up a self join.
  • See an overview of simple stored procedures
  • Learn ADO basics and test a simple Active Server Pages example.
  • Work on a final project.
Prerequisites
None
Requirements
Access 97 or later version installed on a Windows computer.
Class Books
No book required.
Suggested Book: Special Edition Using SQL [
]
Course Price
  • Price: $80.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: All Online Class fees are only refundable or creditable during the first week of class. A processing fee of five dollars ($5.00) will be charged for each refund request. If you have any questions please contact us

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

Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy section.

Instructor: Barbara Kaporch
Barbara KaporchBarbara Kaporch has over 5 years experience working with SQL statements on Oracle, Sybase, SQL Server, and Access databases. She currently works at an actuarial firm as a Visual Basic programmer.

Testimonial:
'This class has given me the foundation to understand how to properly form my own sql statements and how to read sql statements created by others. '--Stacy Sherman


Special Edition Using SQL book
4 Web Study Certificates

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

Other Topics of Our Web Training Program: