uCertify

Database Administration

(UOP-DBM370.AB1)
Lessons
Lab
TestPrep
130 Reviews
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction to Databases and Relational Data Model

  • 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
  • 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
  • Relational Model Concepts
  • Relational Model Constraints and Relational Database Schemas
  • Update Operations, Transactions, and Dealing with Constraint Violations
2

Relational Database Design, Programming Techniques, and Object Database Concepts

  • Relational Database Design Using ER-to-Relational Mapping
  • Mapping EER Model Constructs to Relations
  • Laboratory Exercises
  • 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
  • Overview of Object Database Concepts
  • Object Database Extensions to SQL
  • The ODMG Object Model and the Object Definition Language ODL
  • Object Database Conceptual Design
  • The Object Query Language OQL
  • Overview of the C++ Language Binding in the ODMG Standard
3

File Structures, Hashing, Indexing and Query Processing

  • Introduction
  • Secondary Storage Devices
  • Buffering of Blocks
  • Placing File Records on Disk
  • Operations on Files
  • Files of Unordered Records (Heap Files)
  • Files of Ordered Records (Sorted Files)
  • Hashing Techniques
  • Other Primary File Organizations
  • Parallelizing Disk Access Using RAID Technology
  • Modern Storage Architectures
  • Types of Single-Level Ordered Indexes
  • Multilevel Indexes
  • Dynamic Multilevel Indexes Using B-Trees and B+-Trees
  • Indexes on Multiple Keys
  • Other Types of Indexes
  • Some General Issues Concerning Indexing
  • Physical Database Design in Relational Databases
  • Translating SQL Queries into Relational Algebra and Other Operators
  • Algorithms for External Sorting
  • Algorithms for SELECT Operation
  • Implementing the JOIN Operation
  • Algorithms for PROJECT and Set Operations
  • Implementing Aggregate Operations and Different Types of JOINs
  • Combining Operations Using Pipelining
  • Parallel Algorithms for Query Processing
4

Distributed Database Concepts

  • Distributed Database Concepts
  • Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design
  • Overview of Concurrency Control and Recovery in Distributed Databases
  • Overview of Transaction Management in Distributed Databases
  • Query Processing and Optimization in Distributed Databases
  • Types of Distributed Database Systems
  • Distributed Database Architectures
  • Distributed Catalog Management
5

Database Security

  • Introduction to Database Security Issues
  • Discretionary Access Control Based on Granting and Revoking Privileges
  • Mandatory Access Control and Role-Based Access Control for Multilevel Security
  • SQL Injection
  • Introduction to Statistical Database Security
  • Introduction to Flow Control
  • Encryption and Public Key Infrastructures
  • Privacy Issues and Preservation
  • Challenges to Maintaining Database Security
  • Oracle Label-Based Security

1

Introduction to Databases and Relational Data Model

  • Understanding categories of end users
  • Understanding constraints
  • Performing the DELETE operation
  • Performing the UPDATE operation
  • Performing the INSERT operation
2

Relational Database Design, Programming Techniques, and Object Database Concepts

  • Discussing databases and relational data model
  • Identifying examples of manipulation functions
  • Discussing the characteristics of the database approach
3

File Structures, Hashing, Indexing and Query Processing

  • Understanding storage device types
  • Discussing relational database design, object, and SQL
  • Identifying the components of disk device
  • Understanding the buffer replacement strategies
  • Understanding program variables
  • Describing the hashing techniques
  • Creating a function-based index
  • Using a function-based index
  • Performing the SELECT operation
  • Identifying the steps of processing a high-level query
  • Counting the number of department from the table
  • Using NOT IN operator
  • Using INTERSECT operator
  • Performing the CROSS JOIN operation
  • Performing the RIGHT JOIN operation
  • Performing the LEFT JOIN operation
  • Performing the INNER JOIN operation
4

Database Security

  • Discussing database security
  • Discussing the distributed database concepts
  • Creating a view

Related Courses

All Courses