This SQL programming course teaches students relational database fundamentals and SQL programming skills.  You will learn real life SQL programming to take your skill set to the next level. Topics covered include relational database basics, Database design (schema, tables, and views) and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language.

 

Write SQL code based on ANSI/ISO standards to build and maintain database structures

Update database content with SQL and transaction handling

Retrieve data from single or multiple tables

Process data with row and aggregate functions

Manipulate data with correlated and non-correlated sub queries

Apply views to break down problems and enhance security

SQL forms the cornerstone of all relational database operations. The ability to write the SQL language is essential for those who develop database applications. This course provides a solid foundation of the SQL programming language that enables you to build, query and manipulate databases. Working in Oracle 10g or SQL Server throughout this course, you compare the ANSI/ISO standard with the SQL implementations of these two common database products.

This course is valuable for anyone who needs to learn SQL programming. An understanding of relational database and basic programming concepts is helpful.

In this course, you gain hands-on experience programming with SQL in Oracle Database 10g or Microsoft SQL Server 2005 environments. Exercises include:

Creating and modifying tables, constraints and indexes

Modifying table contents

Retrieving data from tables

Joining multiple tables

Applying row and aggregate functions

Embedding sub queries within statements

 

Contact:  Velocityz@sbcglobal.net