Dates Offered (click on the desired date to register):

This course is currently not scheduled for the near future.

Course Number:  DBSQL

Course Description:  This course presents methodologies and principles of database analysis and design. Conceptual modeling and specifications of databases, database design process and tools, functional analysis and methodologies for database design, entity relationship model and advanced semantic modeling methods are discussed. An introduction of SQL is also covered.

Objectives:  Participants will be able to: Understand the user requirements Initiate the database design process Analyze the functional dependencies Find the database structure Evaluate the database design Normalize the database design Create the database extension Implement the design in quel Implement the design in sql Analyze the relational operations

Benefits: 

Target Audience: 

Prerequisites:  Working experience using computers and operating systems such as Windows or UNIX to solve business problems.

Course Length:  3 days

CourseTopics:

Introduction Overview and Architecture of a Database System DBMS Concepts and Architecture Data Abstraction and Data Models The Three Schema Architecture and Data Independence DBMS Modules and Interfaces Classifications of DBMS Relational Data Model Domains, Tuples, Attributes and Relations Key attributes of a Relation Relation Schema and Relational Database Schema Integrity Constraints Relational Algebra and Operations Recursive Closure Semantic Data Modeling Entity-Relationship Data Model Entity, Relationship Type and Instances Constraints on Relationship Type ER Schema and ER Diagrams ER Schema to Relational Schema Mapping Relational Database Language Structure Query Languages (SQL) Data Definition Language (DDL) Data Manipulation Language (DML) Queries, Update (Insert, Delete, and Update), and View Index Structures for Physical Files Primary, Clustering, and Secondary Indexes Multilevel Indexes Dynamic Multilevel Indexes Using B-Trees and B+-Trees Relational Calculus Tuple Relational Calculus and Domain Relational Calculus Universal and Existential Quantifier Other Issues in Relational Calculus Relational Database Design Functional Dependencies Informal Design Guidelines for Relation Schemas Normal Forms, 1NF, 2NF, 3NF, and BCNF Relational Database Design Algorithms Algorithms for the Design of a Relational Database Schema Relation Decomposition and Insufficiency of Normal Forms Decomposition and Dependency Preservation Decomposition and Lossless (Non additive) Joins Hierarchical Data Model Hierarchical Database Structures and Schema Parent-Child Relationship Hierarchical Occurrence Tree Virtual Parent-Child Relationships Integrity Constraint in the Hierarchical Model Data Definition and Manipulation in the Hierarchical Model ER Schema to Hierarchical Schema Mapping Network Data Model Network Database Structures Set Type and Set Instances Constraints on Set Membership Representations of Set Instances. Special Types of Sets Defining and Manipulating a Network Database ER Schema to Network Schema Mapping Query Processing and Optimization Algorithms for Executing Query Operations Heuristics in Query Optimization Cost Estimates in Query Optimization Semantic Query Optimization Transaction Processing Concepts Transaction and System Concepts Desirable Property of Transactions Schedules and Recoverability Serializability of Schedules