Fundamentals of Database Systems V7

BITTS International Career College > Certificate > Fundamentals of Database Systems V7
BITTS logo
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.

students at BITTS

A gateway into any profession and one of most important positions in an Organization

Quick Application Form

Entry requirements

  • High School Diploma or Equivalent
  • Age must be 18 years or above
  • English Proficiency

Course structure and modules

  • 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

Career opportunities

  • Database Developer
  • Database Administrator