Database Design And Programming With SQL – Course Description - Danang

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 10, 2018 (All day) to October 11, 2018 (All day)

Da Nang University of Science and Technology, 54 Nguyen Luong Bang St., Da Nang

Oct
10
When: Oct 10, 2018 - Oct 11, 2018, (All day)
Where:

Da Nang University of Science and Technology, 54 Nguyen Luong Bang St., Da Nang

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