Database Design
=====
Course Id: DATA-DSGN
Duration: 24 Hours
Overview
—–
* Database is a collection of related data organised,so that data can be easily accessed, managed and updated
* Database Design is a basic step for building any software application
* In this course you will gain the knowledge needed to work with database management systems and to create applications using current database models
Pre-Requisites
——-
* Participants should have the basic understanding of computer programming
Training Objectives
——
* Learn to analyze a business problem and develop data management requirements
* How to develop a conceptual model to meet the problem requirements, using an Entity-Relationship diagram or another conceptual modeling tool (UML)
* How to apply normalization to reduce/eliminate redundancy in database design
* How to implement the conceptual model in a commercial relational database, such as MS Access, Oracle, MySQL
Course Structure
—–
* We provide more focus on hands-on in our technical courses (typically 80% hands-on/20% theory)
* Students get the capability to apply the material they learn to real-world problems
Materials Provided
—–
* All participants receive
* PDF of slides
* PDF of handson
* Access to instance with lab environment
Software Requirements
—–
Any of the following
* Any current internet browser
* vnc client
* rdp client
Hardware Requirements
—–
* Processor: 1.2 GHz+
* RAM: 512 MB+
* Disk space: 1 GB+
* Network Connection with low latency (<250ms) to Internet
## Daywise Course Outline
—–
## Day 1
—–
* Unit 1 : Database Fundamentals
## Day 2
—–
* Unit 2 : Database Design
* Unit 3 : Database Management
## Day 3
—–
* Unit 4 : Database Processing Applications
* Unit 5 : Business Intelligence Systems
## Detailed Outline
—–
Unit 1 : Database Fundamentals
—–
* Advantages of database
* Relational database design
* Modify CRM database for Normalization
* Create MS Access CRM database with
* Tables
* Form
* Reports
* Structured query language
* Create SQL database with tables, queries, and views
Unit 2 : Database Design
—–
* Requirements analysis
* Data modeling and entity-relationship model
* Transforming data model into database design
Unit 3 : Database Management
—–
* Database administration
* Control, security, and reliability
* Create a database security plan
Unit 4 : Database Processing Applications
—–
* Triggers and stored procedures
* Set-up Web database processing
Unit 5 : Business Intelligence Systems
—–
* Examine basic concepts of data warehousing
* Data marts
* Dimensional databases
* Data mining