point10.1.2007
PHP With MySQL Programming remains the #1 selling course of 2007!

point related info
point1.8.2007
PHP/MySQL course ends the year in dramatic fashion by outselling all other courses in the final quarter of 2006.

point related info
newsletter icon
Enter valid email address to
receive our monthly newsletter
Email:

Name:
spacer
 

The SQL Language


Course Description:

This two day SQL course introduces students to the basics of Database Management Systems (DBMS) and application programming using SQL. The course covers the SQL Data Definition Language (DDL) used to define and create databases and tables, and Data Manipulation Language (DML) used to manipulate data.

The SELECT construct and its operators are explained in detail. Also covered are Update, Insert, and Delete constructs. At the conclusion of this course participants will have the skills necessary to do basic SQL programming.


Course Duration: 2-days
more info
email:
name:
phone: - -
message:

Prerequisites and Assumptions:

Students should be familiar with Windows and database application basics.

Recommended Follow-up/RelatedCourses

Introduction to DBMS

  • What is a Database Management System (DBMS)?
  • Data Models
  • Relational Model
  • Relational Algebra
  • Keys
  • Types of Users

Introduction to SQL

  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • SELECT Construct
  • Boolean Operators

Basic SQL-SELECT Construct

  • SELECT Clause
  • IN Operator
  • BETWEEN Operator
  • LIKE Operator
  • Aggregate Operators
  • Calculated Attributes
  • DISTINCT Operator
  • Sorting Results From SELECT

More SQL-Data Manipulation
  • Subselects
  • GROUP BY HAVING
  • UPDATE
  • INSERT
  • DELETE
  • CREATE/DROP/ALTER TABLE
  • Data Types
  • Introduction to Views

Advanced SQL
  • Finding the nth element in a list
  • Finding the median
  • Correlated subquery

   
php logomysql logo

home | training | courseware | consulting | mentoring
contact us | about us | clients | news | policies

Copyright © 2005 by Ambrose King Company. All rights reserved.