Instructor Led Structured Query Language Training Classes

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. Audience:Technical developers with a need to implement SQL in a more...

Introduction to IBM DB2 Universal Database for Sybase Developers Provides the student that has prior SQL or Sybase ASE experience with the necessary basic skills and fundamental knowledge of IBM DB2 UDB. It includes information on the overall architecture of DB2 UDB, basic to advanced DB2 UDB SQL syntax, creating and using SQL Stored Procedures, and an overview of basic administrative tasks including creation of databases, tables, views, indexes, the extraction more...

Design & Implementation Of SQL Server 2000 The course starts with an introduction to client-server architecture. It introduces the Structured Query Language and builds on the complexity of query handling in SQL Server 2000.In addition it also introduces the comparison between SQL server 2000 and SQL server 2005. It includes the manipulation of Extensible Markup Language data (XML Data). This course covers data modeling, database objects, more...

CIW Database Specialist Part 3: Database Interaction and JDBC ...ries (87056 and 87057). Objective Identify features of Structured Query Language (SQL). Match the SQL data types with their characteristics. Match data definition language (DDL) commands with their functions. Identify the fundamental operations in relational algebra. Identify characteristics of the selection operation. Identify characteristics of the projection operation. more...

Microsoft SQL Server 2000 Database Development ...tudent to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; building transactions & more...

CIW Database Specialist Part 2: Logical and Physical Design ... Identify keywords used in DDL. Access the Interactive Structured Query Language (SQL) Window. Create an InterBase relation. Identify guidelines for creating enterprise constraints. Identify guidelines for determining referential constraints. Identify features of secondary indexes. Identify features of denormalization. Identify guidelines for creating user views. Identify more...

DB2 Application programming ...se and some of the associated jargon. Code queries using Structured Query Language (SQL) via SPUFI. Code Application Programs that access DB2 databases using SQL. Test a Basic COBOL or PL/I Programs, creating the appropriate test data. Contents: DB2 introduction Basic and Advanced SQL Creating DB2 Objects Application programming to read and update tables Description of Logical more...

SQL - Structured Query Language Students will learn what SQL is and how it can help them query a database to answer business questions. Students will also learn advanced queries and how to add, update, and delete data, tables, views, and indexes. During this course, including computer lab time, students will be provided with the information necessary to complete the following objectives: Recognize proper syntax for an SQL more...

Oracle Database 10g Administration Workshop I ...e Database Creation Assistant Database interfaces Use structured query language (SQL) Use Procedural Language/Structured Query Language (PL/SQL) Use Java Use the Oracle C++ Call Interface (OCCI) Controlling the database Start and stop the agent Start and stop the enterprise manager database console Start and stop the listener Startup and shutdown the database Storage Structures more...