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
