Database Design And Programming With SQL – Course Description - Hanoi

Registration Information

Pre online registration for this workshop is required. Registration is limited and will be accepted on a first come basis. Register for this workshop at Oracle Website to secure your spot. 

Registration Open: Now

Registration Close: September 15, 2018

To register, read the guide below.

REGISTRATION GUIDE

October 15, 2018 (All day) to October 16, 2018 (All day)
Oct
15
When: Oct 15, 2018 - Oct 16, 2018, (All day)
Where:

This course engages participants to:

  • analyze complex business scenarios; and
  • create a data model—a conceptual representation of an organization’s information.

Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges participants to design, implement, and demonstrate a database solution for a business or organization. More importantly, faculties will learn to utilize Oracle Academy curriculum in teaching and supporting students in achieving Oracle certificate.

Agenda

TimeDetails
DAY 1:DATABASE DESIGN
8:30 am - 17:00 pmIntroduction
Entities and Attributes
Relationship Basics
Super/Sub Types and Business Rules
Sharing & reflection
DAY 2:
8:30 am - 17:00 pmRelationship Fundamentals
UIDs and Normalization
Arcs, Hierarchies, and Recursive Modeling
Changes and Historical Modeling
Sharing & reflection
DAY 3:
8:30 am - 17:00 pmMapping
Creating Database Projects
Presenting Database Projects
DAY 4:DATABASE PROGRAMMING WITH SQL
8:30 am - 17:00 pmIntroduction
SELECT and WHERE
WHERE, ORDER BY, and Intro to Functions
Single Row Functions Part I
Discussion and reflect
DAY 5:
8:30 am - 17:00 pmAdvanced features
Privileges and Regular Expressions
TCL
Ensuring quality queries
Final Project and Exam Review