Course:  Structured Query Language (SQL)
Lab Crash Course - No longer includes a One Hour Intensive HTML Language Review

On-line registration has closed. Please contact the office at 781-229-1530 Ext 2 for more information.

This course also serves as a prerequisite course for Dynamic Web Pages using PHP & Apache Server

Objective: This is an newly created, intensive, fast paced one day mini-course covering everything one needs to understand and use modern-day enterprise relational databases such as Oracle and MySQL. After reviewing database fundamentals, this course introduces the Structured Query Language (SQL) and emphasizes its generic use in accessing modern-day database engines from multiple sources, such as command line and scripted queries, programmatic access from languages such as Perl and C, to dynamic web page generation incorporating information retrieved from the company databases. At least half of the class will be devoted to lab exercises in SQL and lab demonstrations. Since Unix platforms, rather than Microsoft platforms, are typically the server of choice for  large scalable systems such as “eBay”, this course will also teach and demonstrate the use of these services from the rarely taught Unix/Linux point of view using making useof open source software whenever possible.

Targetted for: Individuals that need to understand and/or use relational databases in their upcoming projects, as well as those individuals currently using SQL who need to advance their abilities to include more complicated and efficient queries. For those individuals interested in dynamic HTML web page generation but not fluent in SQL, it is highly recommended that you attend this course prior to signing up for the “Dynamic Web Pages using PHP and Apache Server” mini-course scheduled for November 15.

Prerequisite: Some previous experience in any modern structural programming or scripting language would be helpful but not required.

Handouts: Copies of the course outline slides will be provided along with relevant handouts when appropriate.

For more info: Email to courses@qualware.com or jeffg@qualware.com

PRELIMINARY AGENDA:

Database Basics

Database Data Types

Fundamentals of SQL

Retrieving Data: Select Statement

Filtering Data: Where Clause

Sorting Retrieved Data

Wildcarding: Like Operator

Calculated Fields

Build-in Scalar Functions for Data Field Manipulation

Aggregate Functions and Grouping Data

SQL Language Divisions: DML, DCL, and DDL

Creating Tables

Understanding Constraints, Indexes

Inserting Data: Insert Statement

Updating Data: Update Statement

Manipulating Tables

Cross Table Joins

Database Access

Subqueries and Ways Around Subqueries

Overview of Views, Stored Procedures, Parameterized Queries, Triggers

Understanding Transaction Processing, Cursors when products like MS/VB

Compare and Constast Oracle with MySQL

Time permitting, Demonstration of Integrating SQL in PHP Dynamic Web Pages.

Lecturer’s biograraphy: Jeffrey Goldberg is a long time innovative user of UNIX and Internet services.Mr. Goldberg currently develops and teaches courses on Unix Fundamentals, Shell and Perl Programming, Unix System Administration and Security, TCP/IP Network Administration in a Multi-Platform Environment, Introduction to Programming, Basic and Advanced Visual Basic Programming incorporating SQL Database Access, Web Technologies such as VB Script, Java Script, Java, Visual ‘C’ and ‘C++’, for Worcester Polytechnic Institute and Boston University. Mr. Goldberg is continually adding new cutting-edge technology to his curriculum, and accepts requests for customized on-site corporate training classes. New course available this fall: Development of Dynamic Web Pages Using PHP and Apache Server.

Besides operating Qualware Instructional Services, Mr. Goldberg is also a principal of Qualware Consulting Group, which designs electronics for fault tolerant networks, specialized network adapter hardware and embedded customized controller cards. Mr. Goldberg has recently form a new company called Qualware Internet Services specializing in Internet/Intranet security, application servers, web hosting, and dynamic web applications. For more information, e-mail to training@qualware.com  or contact Mr. Goldberg at 781-229-1530 or j.goldberg@ieee.org or www.consultme.com/qualware

Mr. Goldberg has recently form a new company called Qualware Internet Services specializing in Internet/Intranet security, application  servers, web hosting, and dynamic web applications. For more information,  e-mail to training@qualware.com or contact Mr. Goldberg at 781-229-1530 (Qualware MBox) or j.goldberg@ieee.org or www.consultme.com/qualware

Copywrite 2003 Qualware Instructional Services and Jeffrey Goldberg.

Course Fee Schedule:

On-line Registration and Payment

On-line registration has closed. Please contact the office at 781-229-1530 Ext 2 for more information.

[ Home ] [ Accounting ] [ Amplifier Design ] [ Dynamic Web ] [ Engenomics ] [ First Level Security ] [ JAVA ] [ LINUX ] [ Models ] [ OWL ] [ Perl ] [ Quality Assurance ] [ Radar ] [ RDF ] [ Root Cause ] [ Schedules ] [ SQL ] [ SW Med Device ] [ Software V & V ] [ Wireless LAN ] [ Writing SW Req ] [ XML ] [ Nanotechnology ]

Copyright © 2003 IEEE Boston Section. All rights reserved.
Maintained by R M Stelting