Training
Provided by 123-CBT Computer Based Training
This is the third course in a four part series that teaches students about SQL, relational algebra, transactions and database security, and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins, transactions and database security, and using JDBC drivers and executing SQL statements.
Learn To:
o Identify features of Structured Query Language (SQL). o Match the SQL data types with their characteristics. o Match data definition language (DDL) commands with their functions. o Identify the fundamental operations in relational algebra. o Identify characteristics of the selection operation. o Identify characteristics of the projection operation. o Identify features of a transaction. o Identify features of concurrency control. o Identify features of concurrency control methods. o Identify features of a Java system architecture. o Identify features of JDBC. o Match JDBC driver types with their functions.
Audience
The intended audiences for this course include individuals who design, implement, and maintain database schemas; design and develop database client applications and components; and perform database administration and maintenance, database developers, enterprise developers, application developers, software engineers, and Web developers. Recommend competency in object-oriented theory and Java programming. This course is mapped to the Master CIW Enterprise Developer certification program and exam 1D0-441. In addition, students should have taken the first two parts of this series (87056 and 87057).
Unit 1: SQL 2 hours o Identify features of SQL. o Match the SQL data types with their characteristics. o Match DDL commands with their functions. o Identify features of inserting a value into a relation. o Identify features of updating a value in a relation. o Match simple SQL keywords with their functions. o Match basic queries for filtering with their functions. o Match special predicates with their functions. o Identify features of the ORDER BY clause. o Identify functions of the GRANT statement. o
Training Avaliability and Delivery
This is primarily online training
This is an online eLearning or CBT training program
This program may be available on CD
Contact 123-CBT Computer Based Training for more information
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More N A Training from 123-CBT Computer Based Training