SQL - Course List
Course Search
Course ID Course Name Hours Price Content Schedule
0399-125-ZZ-Z
Course Number: 0399-125-ZZ-Z
Course Name: Data Modeling: Logical Database Design
# of class dates: 10
Description: This course provides a solid basis from which one can successfully implement relational database, multidimensional data warehouse and business intelligence (BI) technologies. The principal objective of this initial course volume is to convey a practical and common sense guide to the theory and concepts of data modeling. Using these sophisticated techniques one can create an elegant logical design of a database. Within this course we discuss not only the premier modeling theories from the best industry experts but also present the practical and real-world experience of the past 20-years of data design practitioners. The methodologies discussed are applicable to any relational database environment, including IBM DB2, the Oracle database, Microsoft SQL Server, the open-source MySQL and PostgreSQL databases as well as other RDBMS platforms. They are also applicable to other database technologies, such as object databases and legacy IMS and IDMS databases. Finally, while we use the free Oracle SQL Developer Data Modeler product as a demonstration modeling tool, one can complete the exercises of this course and apply the techniques learned using any other popular data model diagramming tool, such as IBM InfoSphere Data Architect, CA ErWin Data Modeler, Embarcadero ER/Studio and others.
Data Modeling: Logical Database Design
Course Number: 0399-125-ZZ-Z
Course Name: Data Modeling: Logical Database Design

# of class dates: 10

Description: This course provides a solid basis from which one can successfully implement relational database, multidimensional data warehouse and business intelligence (BI) technologies. The principal objective of this initial course volume is to convey a practical and common sense guide to the theory and concepts of data modeling. Using these sophisticated techniques one can create an elegant logical design of a database. Within this course we discuss not only the premier modeling theories from the best industry experts but also present the practical and real-world experience of the past 20-years of data design practitioners. The methodologies discussed are applicable to any relational database environment, including IBM DB2, the Oracle database, Microsoft SQL Server, the open-source MySQL and PostgreSQL databases as well as other RDBMS platforms. They are also applicable to other database technologies, such as object databases and legacy IMS and IDMS databases. Finally, while we use the free Oracle SQL Developer Data Modeler product as a demonstration modeling tool, one can complete the exercises of this course and apply the techniques learned using any other popular data model diagramming tool, such as IBM InfoSphere Data Architect, CA ErWin Data Modeler, Embarcadero ER/Studio and others.
21 $1199.00
1401-430-55-W
Course Number: 1401-430-55-W
Course Name: MySQL Administration
# of class dates: 0
Description: This 2-day class walks the admin through the basics of MySQL administration. Included are an introduction to the available MySQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning.
MySQL Administration
Course Number: 1401-430-55-W
Course Name: MySQL Administration

# of class dates: 0

Description: This 2-day class walks the admin through the basics of MySQL administration. Included are an introduction to the available MySQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning.
14 $999.00
1401-432-55-W
Course Number: 1401-432-55-W
Course Name: MySQL Administration and Development
# of class dates: 0
Description: This 4-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers.
MySQL Administration and Development
Course Number: 1401-432-55-W
Course Name: MySQL Administration and Development

# of class dates: 0

Description: This 4-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers.
28 $1999.00
1401-431-55-W
Course Number: 1401-431-55-W
Course Name: MySQL Development
# of class dates: 0
Description: This 3-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, and learn about optimization.
MySQL Development
Course Number: 1401-431-55-W
Course Name: MySQL Development

# of class dates: 0

Description: This 3-day class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, and learn about optimization.
21 $1499.00
1580-100-00-W
Course Number: 1580-100-00-W
Course Name: SQ1000: SQL Cross Platform SQL Essentials
# of class dates: 10
Description: Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. Audience: Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.
SQ1000: SQL Cross Platform SQL Essentials
Course Number: 1580-100-00-W
Course Name: SQ1000: SQL Cross Platform SQL Essentials

# of class dates: 10

Description: Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. Audience: Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.
14 $1125.00
1580-200-10-W
Course Number: 1580-200-10-W
Course Name: SQ1010: SQL Cross Platform SQL - Dealing with Complex Queries
# of class dates: 10
Description: Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. Audience: Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.
SQ1010: SQL Cross Platform SQL - Dealing with Complex Queries
Course Number: 1580-200-10-W
Course Name: SQ1010: SQL Cross Platform SQL - Dealing with Complex Queries

# of class dates: 10

Description: Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. Audience: Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.
21 $1875.00
0310-001-70-W
Course Number: 0310-001-70-W
Course Name: SQL Level 1 for Windows
# of class dates: 22
Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables & present query results in a report.
SQL Level 1 for Windows
Course Number: 0310-001-70-W
Course Name: SQL Level 1 for Windows

# of class dates: 22

Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables & present query results in a report.
7 $399.00
0310-002-70-W
Course Number: 0310-002-70-W
Course Name: SQL Level 2 for Windows
# of class dates: 20
Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views & index data.
SQL Level 2 for Windows
Course Number: 0310-002-70-W
Course Name: SQL Level 2 for Windows

# of class dates: 20

Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views & index data.
7 $399.00