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...
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...