This course is for : Beginner
Average time Duration : 2 Months (2hrs/day)
This course provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization.
In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.
- Introduction : Introduction to DBMS, Data Processing Vs. Data Management Systems, File Oriented Approach, Database Oriented Approach to Data Management, Characteristics of Database, Advantages and Disadvantages of a DBMS, Instances and Schemas, Data Models, Database Languages, Data Dictionary, Database Administrators and Database, Users, DBMS Architecture and Data Independence, Types of Database System
- Data Modeling Using Entity-Relationship Approach : Introduction, Data Modeling In the Context of Database Design, The Entity-Relationship Model, Data Modeling As Part of Database Design, Steps In Building the Data Model, Developing the Basic Schema
- SQL : Introduction and History, What is SQL?, SQL Commands, Data Definition Language (DDL) in SQL, Data Manipulation Language in SQL (DML), Transaction Control Language in SQL(TCL), Constraints in SQL, Indexes in SQL
- Relational Database Design and Normalization : Introduction, Informal Design Guidelines for Relational Schemas, Functional Dependencies, Multivalued Dependencies, Relational Database, First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form, Lossless Join Decomposition, Dependency Preservation Decomposition
- Query Processing : Introduction, Query Optimization, Heuristic in Query optimization, Basic Algorithms for Executing Query Operations
- Concurrency Control Techniques : Introduction, Transaction properties, Concurrency Control, Locking, Deadlock, Locking Techniques for Concurrency Control Based On Time Stamp Ordering, Multiversion Concurrency Control Techniques (MVCC)
- Database RecoveryTechniques : Introduction, Recovery Concepts, Recovery Techniques Based On Deferred Update, Recovery Techniques Based On Immediate Update, Shadow Paging, Database Backup And Recovery From Catastrophic Failures
- Distributed Databases and Client-Server Architectures : Introduction, Distributed Database Concepts, Data Fragmentation, Replication, And Allocation Techniques For Distributed, Database Design, Types of Distributed Database Systems, Query Processing in Distributed Databases, An Overview of Client-Server Architecture
- Conventional Data Models and Systems : Network Data Modeling Concepts, Constraints in the Network Model, Data Manipulation in a Network Database, Hierarchical Database Structures, Integrity Constraints and Data Definition in the Hierarchical Model