Course Description

Course Name:	C17 - Structured Query Language (SQL) Crash Course
Time & Date:	6:15 PM - 9:30 PM, May 15, 29, June 5 (Note: New Dates!
Location:	Holiday Inn Select Hotel, 15 Middlesex Canal Park Road, Woburn, MA
Speaker:	Jeffrey Goldberg, Qualware Instructional Services
Text:	Sams Teach Yourself SQL in 10 Minutes (3rd Edition), Author: Ben Forta

Class Description:

A fast paced, three evening, 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 Java, to dynamic web page generation incorporating information retrieved from the company databases. At least half of the class will be devoted to demonstrations running on MySQL, the world’s most popular open source database. If enough attendees bring their labtops and we get a usable wireless internet connection, some class time will be dedicated to labwork experimentation.

Since Unix platforms, rather than Microsoft platforms, are typically the server of choice for large scalable enterprise systems such as “eBay”, this course will teach and demonstrate the use of these services from the rarely taught Unix/Linux point of view, making use of open source software whenever possible.

Prerequisite:

Just a willingness to learn the technology in a fast paced classroom enviroment. Exposure to some level of programming,and some knowledge of command line Unix would be helpful, but not required. Personal laptop computers, although not required,can be brought to class to take advantage of class time dedicated to labs for experimentation.

Targeted for:

Individuals wishing a quick introduction to enterprise Databases fundamentals and wanting to become proficient with using SQL to perform simple queries on their enterprise data, or simple wish to make use of a database for dynamic web content on their personal web pages.

Handouts:

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

Topics one can expect to learn from this course:

Database Basic Terminology
Database History Models
How SQL Fits In With DBMS
MySQL Command Line Interface
Syntax of SQL Select Statement
Introduction to Select
Comparison Operators
Retrieving Data: Select Statement (2)
Filtering Data: Where Clause (4,5)
Sorting Retrieved Data: (3)
Wildcarding: Like Operator (6)
Creating Calculated Fields: (7)
Sample SQL Build-in Scalar Functions
Using Data Manipulation Functions:(8)
SQL Aggregate Functions
Summarizing Data: (9)
Grouping Data: (10)
SQL Language Divisions: DML, DCL, and DDL Understanding Constraints, Indexes (22) Database Supported Data Types (Appendix D) Creating Tables Inserting Data: Insert Statement (15) Updating Data: Update Statement (16) Creating and Manipulating Tables: (17) Discussion on Cross Table Joins (12)

Optional topics that may be covered if there is interest and time permitting:

Overview of Views, Stored Procedures, Parameterized Queries, Triggers Understanding Transaction Processing, Cursors when products like MS/VB Compare and Contrast` Oracle with MySQL Demonstration of Integrating SQL in PHP Dynamic Web Pages.

Controlling user database access using MySQL as an example.

Setting up a MySQL Service on Linux or Unix.

SQL Secruity Issues when creating and using Web Forms.

PRELIMINARY AGENDA:

Topics and order are subject to change depending on abilities and needs of attendees.

Class 1 - Database Basics

Database Terminology, Models, DBMS, Tools and Environment Fundamentals of SQL The Select Statement for Retrieving Data Sorting Retrieved Data (3) Filtering Data: Where Clause (w/ conditionals 4 , logicals 5)

Wildcarding: Like Operator (6)

Calculated or Derived Fields and Aliases (7) Build-in Scalar Functions for Data Field Manipulation (8) Aggregate Functions and Grouping Data (9. 10)

Class 2 - Intermediate SQL

SQL Language Divisions: DML, DCL, and DDL Understanding Constraints, Indexes (22) Database Data Types (Appendix D) Creating and Manipulating Tables (17) Inserting Data: Insert Statement (15) Updating Data: Update Statement (16)

Class 3 - Advanced SQL

Cross Table Joins (12), explain self-joins (13) Group By and Having Statements (10) Overview of Advanced SQL Concepts Subqueries and Ways Around Subqueries, time permitting.

Overview of Views, Stored Procedures, Parameterized Queries, Triggers Understanding Transaction Processing and Locking Optional Demonstration of Integrating SQL in PHP Dynamic Web Pages.

Database Security

For more info:

email to jeffg@qualware.com or call 781-229-1530 x2.

Lecturer’s biography:

Jeffrey M. Goldberg, of Qualware Instructional Services is a long time innovative user of UNIX and Internet services. Mr. Goldberg currently develops and delivers customized corporate training classes along with very flexible scheduling, to avoid project disruption, in the fields of IT operations, operating system and computer languages. Specialties include UNIX Fundamentals, Perl and Shell Scripting, Linux/UNIX System Administration and TCP/IP Networking, Web Technologies such as Visual Basic, Java Script, PHP Apache, C++, Java and SQL Database Access, Computer and Network Security.

copywrite 2012 Qualware Instructional Services and Jeffrey Goldberg.

Decision (Run/Cancel) Date for this Courses is Monday, May 7, 2012

Payment received by May 4: IEEE Members $360

Payment received by May 4: Non-members $385

Payment received after May 4: IEEE Members $385

Payment received after May 4: Non-members $415