Java Database

Основната цел на курса – "Java Database" е да даде на курсистите отлични теоретични знания и практически умения, необходими в работата им като софтуерни Java разработчици.

Обучението е подходящо за всички, които освен отлично използване на езика за програмиране на Java и обектно-ориентираното програмиране имат умения за работа с Java платформата, Java APIs, Swing и GUI приложения.

Програма на курса

1.Relational Databases – Fundamental Concepts

Basic database concepts - RDBMS, tables, relationships, multiplicity, primary keys, foreign keys,
E/R diagrams,
Normalization
Constraints
Indexes
Views
Triggers
Transactions

2. Data Modeling with E/R Diagrams

Database modeling and entity/relationship diagrams
E/R modeling tools
Oracle data types
Working with CASE Studio / Toad Data Modeler

3. Oracle Database – Introduction

Introduction to Oracle Database (Oracle 10g Express Edition) – Installing and Configuring;
Oracle Database XE Web Based Administration; Oracle SQL Developer, SQL*Plus

4. Introduction to SQL – Basics

SQL language – introduction
SELECT statement
Restrictions: WHERE clause
Ordering: ORDER BY clause
Set operations: UNION / INTERSECT / MINUS
Table joins: NATURAL, INNER, OUTER, FULL, CROSS joins

5. Introduction to SQL – Advanced Topics

Aggregate functions, GROUP BY and HAVING
Built-in SQL functions
DML: INSERT, UPDATE and DELETE statements
DDL: CREATE, ALTER, DROP
Execution plan and query analysis / optimization
Creating and using sequences

6. Data Access with JDBC

Basic classes (DriverManager, Connection, Statement, ResultSet, PreparedStatement, CallableStatement, DatabaseMetadata, ResultSetMetadata)
Accessing Oracle database
Transaction management
Best practices using JDBC

7. Introduction to XML

Basic XML concepts
Well-formed XML, namespaces
XML schemas: DTD and XSD

8. Hibernate: Mapping Classes and Relationships

Foundations of data persistence and object-relational mapping technologies
Hibernate and Java Persistence API (JPA)
Hibernate object persistence engine – overview and architecture
Installing and configuring Hibernate
Mapping POJO classes to database tables: mapping fields and relationships between classes

9. Hibernate: Manipulating Entities

Configuring Hibernate and establishing Hibernate session
Manipulating persistent entity objects: creating, reading, modifying and deleting persistent entities (CRUD actions)
Using HQL queries
Transactions in Hibernate
Building data access layer based on Hibernate (DAO classes)

10. Java Persistence API