Oracle PL/SQL Programming, Developing SQL Queries
Student handout
CONTACT US: 020 8795 1200
Exam: JAVA – Database Programming
Duration: 10days Flexible (5 days a week or 5 weekends
Fees: £1,200 (+ VAT)
Introduction:
|
Application developers
Programmers
System designers
|
Knowledge of database principles is preferred but not required. Experience with the Java programming language is required |
Description:
This course trains developers and designers in the art and science of database application development using the application programming interface (API) provided by Java, JDBC 2.0. In this course, attendees will learn about installing and managing database drivers in Java, using the DDL and DML functionality of JDBC, formulating simple and complex queries, using compiled queries and stored procedures, handling and formatting the results of queries and transaction management primitives. Extensive hands-on lab exercises reinforce various concepts and techniques as they are introduced.
While this is not a full course on database systems, fundamental database concepts are covered briefly with a special emphasis on relational databases. An overview of the Structured Query Language (SQL) will be provided.
The course consists of 50% instruction and 50% lab exercises.
Objectives:
This course teaches a developer to use JDBC to design and implement Java database solutions. On completion of this course, students will be able to:
1. Master the JDBC 2.0 API
2. Use various database drivers, including the JDBC-ODBC bridge
3. Use the DDL features to define relational tables, and update data
4. Formulate and execute complex queries in SQL using the API
5. Use the MetaData facilities to parse and format the results
Course Outline
Fundamentals of Database Concepts
Various models of data storage
Data Definition Language (DDL)
Data Manipulation Language (DML)
Relational Databases
The relational model of data storage
Relational algebra
Normalization
Structured Query Language (SQL)
|
Database Programming in Java using JDBC
JDBC concepts
Database drivers
Connection objects
Defining and creating databases and tables
Updating database records
Query formulation using Statements objects
Using compiled queries and stored procedures
Using the ResultSet and MetaData objects with query results
Datasources
Transaction processing: Commit, Rollback, etc.
Connection Pooling
|
Pre – Requisites:
Previous Educational Background & at least one Computer Language Required.
Course Benefits and Prospectus in UK and other countries
Being a part of Java means being a part of one of the most successful computer technologies in the world, a recognized market leader. It also means being challenged like never before, taking risks, growing, and succeeding. The day you have a Java qualification is the day you begin playing a key role in making our customers' businesses the best-run businesses in the world.
Also on this course we offer the following:
Hands on Experience / Real Time project work / Interview based Training.
CALL US FOR MORE DETAILS ON: 020 8795 1200
To enquire further about the course schedule and fee structure please use 'Request Callback' form and leave your details or contact us directly at admin@lsastudies.org.
