IT TRAINING SOLUTIONS
Productivity By Design
 
 

SQL Training

Affinity IT SQL Training at all experience levels from novice to expert. With extensive real-world database experience, our Instructors are well prepared to teach SQL and SQL Best Practices and improve your programming productivity.

Training Strategic Skills

We typically customize training content and delivery to accomodate our clients. Whether you require novice or experienced level training, common or specialized topics, we will custom design a SQL training program to fit your specific needs.

Click on a course below to view its details and outline, or contact us if you don't see a SQL programming topic that interests you.

  
"The nice thing about standards is that there are so many to choose from"
-- Anonymous

TitleDescriptionDurationOutline
Introduction To MySQL Learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL extensions, and gain hands-on experience using MYSQL databases. You will also learn the special features and functions of the MYSQL, such as automatic recovery of transactions, stored procedures, triggers, and cursors. In addition, you will learn to use good programming techniques and develop strategies for writing efficient applications.

Level: Introduction
5 Days
Microsoft SQL Server 2008 Integration Services Learn how to use the Integration Services of SQL Server 2008

Level: Introduction
3 days
Microsoft SQL Server 2008 for Developers Learn about the steps to install, and/or upgrade to SQL Server 2008 and configuring the server.

Level: Introduction
5 days
Oracle Database 11g: SQL Fundamentals - Complete Coverage The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.

Level: Introduction
5 Days
Oracle Database 11g: SQL Fundamentals I This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available.

Level: Introduction
3 Days
Relational Database Design This course is one common starting point for the entire database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques.

Level: Introduction
2 or 3 Days
SSAS Using Microsoft SQL Server 2008 Learn how to use the SQL Server 2008 Analysis Services

Level: Introduction
2 days
Structured Query Language (SQL) Using Sybase Provides an introduction to all standard SQL statements and constructs. Treatment of SQL is platform neutral, but will be delivered in the Sybase environment. Coverage of Sybase ASE provides an introduction to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers. Delivery format is a combination of Lectures and Labs.

Level: Introduction
2 Days
Transact-SQL Server 2008 Learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server

Level: Introduction
4 days
Oracle Database 11g: SQL Fundamentals II The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. This enhanced and expanded revision includes many new and expanded conceptual subjects.

Level: Intermediate
3 Days
SQL Server 2008 for Developers This course shows how to code SQL and PL/SQL statements with and without the SQL Developer tool. It also covers database design and implementation. It uses the Oracle database.

Level: Intermediate
3 days

Contact us today to discuss your IT Training needs !

 
 
J2SE Training, Java2 Training: Learn J2SE, Best Java2 Training Courses

©2009 Affinity IT Training LLC.