Pearson - Database Systems: A Practical Approach to Design, Implementation, and Management

pearson-dbsys
Pearson - Database Systems: A Practical Approach to Design,...
ISBN : 978-1-61691-461-5

Lessons

uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. Learners can do Flashcards, Exercises, Quizzes and Labs related to each chapter. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Flashcards

Each lesson comes with Flashcards. There is no limit to the number of times learners can attempt these. Flashcards help master the key concepts.

Flashcards
536+
Lessons
34+

Table of Content

Here's What you will Learn

Lesson 1: Introduction to Databases

  • Introduction
  • Traditional File-Based Systems
  • Database Approach
  • Roles in the Database Environment
  • History of Database Management Systems
  • Advantages and Disadvantages of DBMSs
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 2: Database Environment

  • The Three-Level ANSI-SPARC Architecture
  • Database Languages
  • Data Models and Conceptual Modeling
  • Functions of a DBMS
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 3: Database Architectures and the Web

  • Multi-user DBMS Architectures
  • Web Services and Service-Oriented Architectures
  • Distributed DBMSs
  • Data Warehousing
  • Cloud Computing
  • Components of a DBMS
  • Oracle Architecture
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 4: The Relational Model

  • Brief History of the Relational Model
  • Terminology
  • Integrity Constraints
  • Views
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 5: Relational Algebra and Relational Calculus

  • The Relational Algebra
  • The Relational Calculus
  • Other Languages
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 6: SQL: Data Manipulation

  • Introduction to SQL
  • Writing SQL Commands
  • Data Manipulation
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 7: SQL: Data Definition

  • The ISO SQL Data Types
  • Integrity Enhancement Feature
  • Data Definition
  • Views
  • Transactions
  • Discretionary Access Control
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 8: Advanced SQL

  • The SQL Programming Language
  • Subprograms, Stored Procedures, Functions, and Packages
  • Triggers
  • Recursion
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 9: Object-Relational DBMSs

  • Advanced Database Applications
  • Weaknesses of RDBMSs
  • Storing Objects in a Relational Database
  • Introduction to Object-Relational Database Systems
  • SQL:2011
  • Object-Oriented Extensions in Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 10: Database System Development Lifecycle

  • The Information Systems Lifecycle
  • The Database System Development Lifecycle
  • Database Planning
  • System Definition
  • Requirements Collection and Analysis
  • Database Design
  • DBMS Selection
  • Application Design
  • Prototyping
  • Implementation
  • Data Conversion and Loading
  • Testing
  • Operational Maintenance
  • CASE Tools
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 11: Database Analysis and the DreamHome Case Study

  • When Are Fact-Finding Techniques Used?
  • What Facts Are Collected?
  • Fact-Finding Techniques
  • Using Fact-Finding Techniques: A Worked Example
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 12: Entity-Relationship Modeling

  • Entity Types
  • Relationship Types
  • Attributes
  • Strong and Weak Entity Types
  • Attributes on Relationships
  • Structural Constraints
  • Problems with ER Models
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 13: Enhanced Entity-Relationship Modeling

  • Specialization/Generalization
  • Aggregation
  • Composition
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 14: Normalization

  • The Purpose of Normalization
  • How Normalization Supports Database Design
  • Data Redundancy and Update Anomalies
  • Functional Dependencies
  • The Process of Normalization
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • General Definitions of 2NF and 3NF
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 15: Advanced Normalization

  • More on Functional Dependencies
  • Boyce-Codd Normal Form (BCNF)
  • Review of Normalization Up to BCNF
  • Fourth Normal Form (4NF)
  • Fifth Normal Form (5NF)
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 16: Methodology-Conceptual Database Design

  • Introduction to the Database Design Methodology
  • Overview of the Database Design Methodology
  • Conceptual Database Design Methodology
  • Chapter Summary

Lesson 17: Methodology-Logical Database Design for the Relational Model

  • Logical Database Design Methodology for the Relational Model
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 18: Methodology-Physical Database Design for Relational Databases

  • Comparison of Logical and Physical Database Design
  • Overview of the Physical Database Design Methodology
  • The Physical Database Design Methodology for Relational Databases
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 19: Methodology-Monitoring and Tuning the Operational System

  • Denormalizing and Introducing Controlled Redundancy
  • Monitoring the System to Improve Performance
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 20: Security and Administration

  • Database Security
  • Countermeasures-Computer-Based Controls
  • Security in Microsoft Office Access DBMS
  • Security in Oracle DBMS
  • DBMSs and Web Security
  • Data Administration and Database Administration
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 21: Professional, Legal, and Ethical Issues in Data Management

  • Defining Legal and Ethical Issues in IT
  • Legislation and Its Impact on the IT Function
  • Establishing a Culture of Legal and Ethical Data Stewardship
  • Intellectual Property
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 22: Transaction Management

  • Transaction Support
  • Concurrency Control
  • Database Recovery
  • Advanced Transaction Models
  • Concurrency Control and Recovery in Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 23: Query Processing

  • Overview of Query Processing
  • Query Decomposition
  • Heuristical Approach to Query Optimization
  • Cost Estimation for the Relational Algebra Operations
  • Enumeration of Alternative Execution Strategies
  • Query Processing and Optimization
  • Query Optimization in Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 24: Distributed DBMSs-Concepts and Design

  • Introduction
  • Overview of Networking
  • Functions and Architectures of a DDBMS
  • Distributed Relational Database Design
  • Transparencies in a DDBMS
  • Date's Twelve Rules for a DDBMS
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 25: Distributed DBMSs-Advanced Concepts

  • Distributed Transaction Management
  • Distributed Concurrency Control
  • Distributed Deadlock Management
  • Distributed Database Recovery
  • The X/Open Distributed Transaction Processing Model
  • Distributed Query Optimization
  • Distribution in Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 26: Replication and Mobile Databases

  • Introduction to Data Replication
  • Replication Architecture
  • Replication Schemes
  • Introduction to Mobile Databases
  • Oracle Replication
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 27: Object-Oriented DBMSs-Concepts and Design

  • Next-Generation Database Systems
  • Introduction to OODBMSs
  • Persistence in OODBMSs
  • Issues in OODBMSs
  • Advantages and Disadvantages of OODBMSs
  • Comparison of ORDBMS and OODBMS
  • Object-Oriented Database Design
  • Object-Oriented Analysis and Design with UML
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 28: Object-Oriented DBMSs-Standards and Systems

  • Object Management Group
  • Object Data Standard ODMG 3.0, 1999
  • ObjectStore
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 29: Web Technology and DBMSs

  • Introduction to the Internet and the Web
  • The Web
  • Scripting Languages
  • Common Gateway Interface (CGI)
  • HTTP Cookies
  • Extending the Web Server
  • Java
  • Microsoft's Web Platform
  • Oracle Internet Platform
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 30: Semistructured Data and XML

  • Semistructured Data
  • Introduction to XML
  • XML-Related Technologies
  • XML Schema
  • XML Query Languages
  • XML and Databases
  • XML in Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 31: Data Warehousing Concepts

  • Introduction to Data Warehousing
  • Data Warehouse Architecture
  • Data Warehousing Tools and Technologies
  • Data Mart
  • Data Warehousing and Temporal Databases
  • Data Warehousing Using Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 32: Data Warehousing Design

  • Designing a Data Warehouse Database
  • Data Warehouse Development Methodologies
  • Kimball's Business Dimensional Lifecycle
  • Dimensionality Modeling
  • The Dimensional Modeling Stage of Kimball's Business Dimensional Lifecycle
  • Data Warehouse Development Issues
  • Data Warehousing Design Using Oracle
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 33: OLAP

  • 33.1. Online Analytical Processing
  • OLAP Applications
  • Multidimensional Data Model
  • OLAP Tools
  • OLAP Extensions to the SQL Standard
  • Oracle OLAP
  • Chapter Summary
  • Review Questions
  • Exercises

Lesson 34: Data Mining

  • Data Mining
  • Data Mining Techniques
  • The Data Mining Process
  • Data Mining Tools
  • Data Mining and Data Warehousing
  • Oracle Data Mining (ODM)
  • Chapter Summary
  • Review Questions
  • Exercises

Copyright © 2002-2017 uCertify / All Rights Reserved.