Fundamentals of Database Systems V7

BITTS International Career College > Certificate Courses > Fundamentals of Database Systems V7
Information Technology
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

Fundamentals of Database Systems V7 certification exam teaches you concepts of database management systems

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