Fundamentals of Database Systems V7

Availability: Continuous

Length: 39 Hours

Department: Information Technology
Semester: Continuous
Duration: 39 Hours

Department: Information Technology
Semester: Continuous
Method: Online
Duration: 39 Hours

Gain skills to work with database fundamentals with the Fundamentals of Database Systems V7 course and lab. Lab simulates real-world, hardware, software and command line interface environments and can be mapped to any text-book, course, and training. The course covers fundamental concepts necessary for designing, using, and implementing database systems and applications; database modeling and design; languages and models provided by database management systems; and database system implementation techniques. The lab is versatile and provides hands-on learning with real-world scenarios.

  • Preface

  • Databases and Database Users

  • Database System Concepts and Architecture

  • Data Modeling Using the Entity–Relationship (ER) Model

  • The Enhanced Entity–Relationship (EER) Model

  • The Relational Data Model and Relational Database Constraints

  • SQL Data Definition and Data Types

  • More SQL: Complex Queries, Triggers, Views, and Schema Modification

  • The Relational Algebra and Relational Calculus

  • Relational Database Design by ER- and EER-to-Relational Mapping

  • Introduction to SQL Programming Techniques

  • Web Database Programming Using PHP

  • Object and Object-Relational Databases

  • XML: Extensible Markup Language

  • Basics of Functional Dependencies and Normalization for Relational Databases

  • Relational Database Design Algorithms and Further Dependencies

  • Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures

  • Indexing Structures for Files and Physical Database Design

  • Strategies for Query Processing

  • Query Optimization

  • Introduction to Transaction Processing Concepts and Theory

  • Concurrency Control Techniques

  • Database Recovery Techniques

  • Distributed Database Concepts

  • NOSQL Databases and Big Data Storage Systems

  • Big Data Technologies Based on MapReduce and Hadoop

  • Enhanced Data Models: Introduction to Active, Temporal, Spatial, Multimedia, and Deductive Databases

  • Introduction to Information Retrieval and Web Search

  • Data Mining Concepts

  • Overview of Data Warehousing and OLAP

  • Database Security

  • Appendix A: Alternative Diagrammatic Notations for ER Models

  • Appendix B: Parameters of Disks

  • Appendix C: Overview of the QBE Language

  • High School Diploma or Equivalent

  • Age must be 18 years or above

  • English Proficiency

  • Database Developer

  • Database Administrator