Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Fundamentals of Database Systems

Use the Fundamentals of Database Systems course and lab to learn database concepts and methodologies. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, and training. The database training 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.
NameBuy
Fundamentals of Database Systems
Test Prep
55+ Pre Assessment Questions | 50+ Post Assessment Questions |
Features

Why choose TOPTALENT?

Outline

Lessons 1:
Preface

Lessons 2:
Databases and Database Users

  • Introduction
  • An Example
  • Characteristics of the Database Approach
  • Actors on the Scene
  • Workers behind the Scene
  • Advantages of Using the DBMS Approach
  • A Brief History of Database Applications
  • When Not to Use a DBMS
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography

Lessons 3:
Database System Concepts and Architecture

  • Data Models, Schemas, and Instances
  • Three-Schema Architecture and Data Independence
  • Database Languages and Interfaces
  • The Database System Environment
  • Centralized and Client/Server Architectures for DBMSs
  • Classification of Database Management Systems
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography

Lessons 4:
Data Modeling Using the Entity–Relationship (ER) Model

  • Using High-Level Conceptual Data Models for Database Design
  • A Sample Database Application
  • Entity Types, Entity Sets, Attributes, and Keys
  • Relationship Types, Relationship Sets, Roles, and Structural Constraints
  • Weak Entity Types
  • Refining the ER Design for the COMPANY Database
  • ER Diagrams, Naming Conventions, and Design Issues
  • Example of Other Notation: UML Class Diagrams
  • Relationship Types of Degree Higher than Two
  • Another Example: A UNIVERSITY Database
  • Summary
  • Review Questions
  • Exercises
  • Laboratory Exercises
  • Selected Bibliography

Lessons 5:
The Enhanced Entity–Relationship (EER) Model

  • Subclasses, Superclasses, and Inheritance
  • Specialization and Generalization
  • Constraints and Characteristics of Specialization and Generalization Hierarchies
  • Modeling of UNION Types Using Categories
  • A Sample UNIVERSITY EER Schema, Design Choices, and Formal Definitions
  • Example of Other Notation: Representing Specialization and Generalization in UML Class Diagrams
  • Data Abstraction, Knowledge Representation, and Ontology Concepts
  • Summary
  • Review Questions
  • Exercises
  • Laboratory Exercises
  • Selected Bibliography

Lessons 6:
The Relational Data Model and Relational Database Constraints

  • Relational Model Concepts
  • Relational Model Constraints and Relational Database Schemas
  • Update Operations, Transactions, and Dealing with Constraint Violations
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography

Lessons 7:
SQL Data Definition and Data Types

  • SQL Data Definition and Data Types
  • Specifying Constraints in SQL
  • Basic Retrieval Queries in SQL
  • INSERT, DELETE, and UPDATE Statements in SQL
  • Additional Features of SQL
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography

Lessons 8:
More SQL: Complex Queries, Triggers, Views, and Schema Modification

  • More Complex SQL Retrieval Queries
  • Specifying Constraints as Assertions and Actions as Triggers
  • Views (Virtual Tables) in SQL
  • Schema Change Statements in SQL
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography

Lessons 9:
The Relational Algebra and Relational Calculus

  • Unary Relational Operations: SELECT and PROJECT
  • Relational Algebra Operations from Set Theory
  • Binary Relational Operations: JOIN and DIVISION
  • Additional Relational Operations
  • Examples of Queries in Relational Algebra
  • The Tuple Relational Calculus
  • The Domain Relational Calculus
  • Summary
  • Review Questions
  • Exercises
  • Laboratory Exercises
  • Selected Bibliography

Lessons 10:
Relational Database Design by ER- and EER-to-Relational Mapping

  • Relational Database Design Using ER-to-Relational Mapping
  • Mapping EER Model Constructs to Relations
  • Summary
  • Review Questions
  • Exercises
  • Laboratory Exercises
  • Selected Bibliography

Lessons 11:
Introduction to SQL Programming Techniques

  • Overview of Database Programming Techniques and Issues
  • Embedded SQL, Dynamic SQL, and SQL J
  • Database Programming with Function Calls and Class Libraries: SQL/CLI and JDBC
  • Database Stored Procedures and SQL/PSM
  • Comparing the Three Approaches
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography

<h3 tabinde
© 2024 TOPTALENT LEARNING.