Database Fundamentals

You will learn the fundamental concepts and technologies relating to database development and administration. Learn about relational databases, SQL, create/manipulate a database, stored procedures, administering a database: database security, & more.

Purchase Course

Learner Career Outcomes

6,284 students already enrolled

89%

Got a tangible career benefit from this course.
77%

Got a job, pay increase, or promotion.
68%

Started a new career after completing this specialization.

Enroll today to save money and grow more

This Introduction to Programming course will help you earn a certificate from a US-Canadian recognized college with a certificate and transcript.

Study now, Pay later

FAQ

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Will I receive a transcript from a college for completing this course?

Yes. Completion of a UPI course does earn you academic credit from colleges; therefore, colleges is able to provide you with a university transcript. Also, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
When will I have access to the lectures and assignments?

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you see the free preview option: The course may offer 'Some Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get an idea about the course.

Hear from our students about this course

My 15-year-old daughter just launched her first Android mobile application today, and she started with this course. I'm so proud, would recommend this course!

Matthew Robinson

Simply put, this course radically changed my 15-year-old daughter's life. I wanted her to learn some new skills besides her school work, and she had a keen interest in computer science. We had some courses that we might have been interested in but had had no idea where to start. Plus, among so many platforms to choose from, I had been looking for someplace to provide her with the best study material and authentic certification. Most importantly, a course that understands a student's problems to learn and grow. Well, we finally decided to go with UPI, and I'm going to tell you - I do not regret it a bit. A month or two later, she kept practicing and building projects - well, today, she launched her first Android mobile application video game! I'm lifetime worth of proud of her today and would like to thank all the teachers and UPI's course for giving her the best possible. I just enrolled my younger son as well this week!

Read Less

Totally worth it!

UPI Study

I was a first-year student in college with a computer science major. I had no idea how to code or cope up with my classes before I took this course. Totally worth it! To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood. I would highly recommend taking this course if you want to be introduced to [programming and start building cool projects!

Read Less

Took this course, made a few projects, got an offer from Microsoft today! Yayyy!!

Brooke Grey

I recently graduated from the University of Philadelphia with a major in Finance. However, I have always wanted to do something in computer science but had no coding experience. I took this class two months ago, in May 2021, and completed the course. I did projects to enhance my skills and used UPI's "Connect with Professionals" program to see if I could now make a career into it! I recently applied to a few jobs and got my offer letter as a junior software developer in Microsoft today! I want to thank UPI, professors, and others for helping me learn and grow. I would definitely recommend this course for beginners :)

Read Less

Course curriculum

1. Introduction
1. Data Defined
2. Analog vs. Digital Data
3. Types of Data
4. Databases
5. Data vs. Information
6. Lesson Summary
7. Data Terms & Definitions
8. Learning Outcomes
9. Quiz 1.1
1. What is a Database?
2. What is Structured Query Language (SQL)?
3. Evolution of a Database
4. Database Management and Types of Database Management
5. Relational Databases
6. Object-Oriented Databases
7. SQL Databases
8. Network Databases
9. Graph Databases
10. Diagrams: How Different Databases Connect
11. What Are Databases Used For?
12. Differences Between Databases and Spreadsheets
13. Database Software
14. Using Database Software to Improve Business Performance
15. Database Challenges
16. Lesson Summary
17. Quiz 1.2
1. What are Data?
2. Database Structure
3. Data vs. Information
4. Lesson Summary
5. Learning Outcome
6. Quiz 1.3
1. Database Background
2. Data Basics
3. Database Management
4. Relationships Between Tables
5. Lesson Summary
6. Quiz 1.4
1. What Is a Record?
2. Records in the Database
3. Example of a Database Record
4. Fields
5. Data Types
6. Lesson Summary
7. Quiz 1.5
1. Overview of Database Fields
2. Example
3. Database Field Types
4. Example
5. Lesson Summary
6. Quiz 1.6
1. Purpose of Database Management Systems
2. Functions of a DBMS
3. Pros and Cons of DBMS
4. Multi-User Databases
5. Lesson Summary
6. Learning Outcomes
7. Quiz 1.7
1. DBMS Models
2. Flat File
3. Hierarchical DBMS
4. Network DBMS
5. Relational DBMS
6. Object-Oriented DBMS
7. Lesson Summary
8. Learning Outcomes
9. Quiz 1.8
1. What Is DBMS All About?
2. Advantages of DBMS
3. Lesson Summary
4. Quiz 1.9
1. Introduction
1. Entities
2. Entity Attributes
3. Entity or Attribute?
4. Relationships
5. Lesson Summary
6. Quiz 2.1
1. The Need for Databases
2. Relational Databases
3. Functional Dependency
4. Lesson Summary
5. Quiz 2.2
1. The ER Diagram
2. Entities and Tables
3. Keys
4. Cardinality
5. Lesson Summary
6. Quiz 2.3
1. Database Relationships
2. Rules for Relational Databases
3. Primary and Foreign Keys
4. Cardinality of Relationships
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.4
1. What Is a Relational Database?
2. Relational Database Uses
3. Relational Database Functions
4. Lesson Summary
5. Quiz 2.5
1. We Need Information
2. What Is a Database?
3. What is SQL?
4. What Is the History of SQL?
5. Lesson Summary
6. Quiz 3.1
1. Manipulating a Database
2. Structured Query Language
3. SQL Statements
4. SQL Syntax
5. SQL Operators
6. Boolean Logic
7. Lesson Summary
8. Learning Outcomes
9. Quiz 3.2
1. Database Query
2. Example of a Query
3. Using Semicolons
4. Other Operations
5. Microsoft Access Example
6. Lesson Summary
7. Quiz 3.3
1. Structured Query Language
2. How to Build a Query
3. Example: Two Tables
4. Lesson Summary
5. Quiz 3.4
1. Query Concepts
2. What is Syntax?
3. What is a Relational Database?
4. What is Structural Query Language (SQL)?
5. SQL Clauses
6. SQL Statements
7. SQL Syntax Notes
8. SQL Commands and Syntax
9. Lesson Summary
10. Quiz 3.5
1. Subqueries
2. WHERE
3. FROM
4. SELECT
5. MySQL: Subquery Update
6. Lesson Summary
7. Quiz 3.6
1. A Common Join
2. Example
3. SELECT
4. FROM
5. INNER JOIN
6. ON
7. Results of the Query
8. Lesson Summary
9. Quiz 3.7
1. Introduction
2. Full Outer Join Syntax
3. Lesson Summary
4. Quiz 3.8
1. What is SQL?
2. Grouping Without an Order
3. Grouping With an Order
4. Lesson Summary
5. Quiz 3.9
1. Creating Simplicity
2. What is SQL?
3. What is a SQL Script?
4. Creating a SQL Script
5. Running a SQL Script
6. Lesson Summary
7. Quiz 3.10
1. Dealing with the Information Glut
2. What is SQL?
3. What is a SQL Query?
4. What is a SQL Script?
5. Lesson Summary
6. Quiz 3.11
1. Reducing Repetition
2. SQL Script
3. Script Uses
4. Sample Scripts
5. Lesson Summary
6. Quiz 3.12
1. Introduction
1. Naming Data Types in SQL
2. CHAR
3. VARCHAR
4. Lesson Summary
5. Quiz 4.1
1. Different Types of Numbers
2. INT
3. SMALLINT
4. Others
5. Lesson Summary
6. Quiz 4.2
1. Data Types for Numbers
2. NUMERIC and DECIMAL
3. How Are They Different from Other Data Types?
4. Explaining the Syntax
5. Lesson Summary
6. Quiz 4.3
1. SQL Data Types
2. The Real & Float Data Types
3. The Double Data Type
4. Lesson Summary
5. Quiz 4.4
1. What is BOOLEAN?
2. Yes or No?
3. The Use of Boolean Logic
4. Example
5. Lesson Summary
6. Quiz 4.5
1. Knowing When in SQL
2. Why Use a Specific Data Type?
3. The TIME Data Type
4. The DATE Data Type
5. The TIMESTAMP Data Type
6. Lesson Summary
7. Quiz 4.6
1. What's a BLOB?
2. MySQL
3. Oracle
4. SQL Server
5. Lesson Summary
6. Qui 4.7
1. Introduction
1. Information is Not Enough
2. What Is SQL?
3. What Is T-SQL?
4. Differences Between SQL and T-SQL
5. Lesson Summary
6. Quiz 5.1
1. What Is PL/SQL?
2. The PL/SQL Environment
3. Syntax of PL/SQL
4. Declaration:
5. Commands:
6. Null Statement
7. Handling Exceptions or Errors:
8. PL/SQL Delimiters:
9. PL/SQL Statements:
10. PL/SQL Comments:
11. Lesson Summary
12. Quiz 5.2
1. Dynamic SQL
2. Dynamic SQL In Action
3. SQL Injection
4. Lesson Summary
5. Quiz 5.3
1. Introduction
1. The Need for Simplification
2. What is a Data Model?
3. What is Abstraction?
4. What is an Abstract Data Model?
5. What is the Purpose of Using an Abstract Data Model?
6. Lesson Summary
7. Quiz 6.1
1. Parents, Children, and Objects
2. Object Diagrams
3. Building a Diagram
4. The Importance of Object Diagrams
5. Lesson Summary
6. Quiz 6.2
1. Class Diagram Definition
2. Class Diagram Example
3. Symbols and Notation
4. Class Diagram Importance
5. Lesson Summary
6. Quiz 6.3
1. What Is a Database Schema?
2. Schema Theory
3. A Simple Database
4. A Better Database
5. A Useful Database
6. Lesson Summary
7. Quiz 6.4
1. Database Schemas
2. Designing a Schema
3. Map it Out
4. Lesson Summary
5. Quiz 6.5
1. Introduction
1. Using SQL's Primary Keys
2. How Are They Used?
3. Example in Use
4. Lesson Summary
5. Quiz 7.1
1. What is a Foreign Key?
2. Primary vs. Foreign Keys
3. Linking Tables
4. Example of a Foreign Key
5. Lesson Summary
6. Learning Outcomes
7. Quiz 7.2
1. SQL Databases & Relationships
2. Relationship Types & Representation
3. SQL Relationships Examples
4. Lesson Summary
5. Quiz 7.3
1. The Database Table
2. Design and Conventions
3. Field
4. Unique Identifier
5. Database Language
6. Lesson Summary
7. Quiz 7.4
1. What Is a Database?
2. Relational Database Design Steps
3. Lesson Summary
4. Quiz 7.5
1. Database Management System Design
2. Why Do We Go to This Length?
3. What Is Normalization?
4. The Normal Forms
5. Types of Normal Forms
6. Quiz 7.6
7. Lesson Summary
1. The Prevalence of Databases
2. What is SQL?
3. What is Normalization?
4. Example
5. What are the Rules for Normalization?
6. Lesson Summary
7. Quiz 7.7
1. First Normal Form
2. General Rules
3. Examples of 1NF
4. Lesson Summary
5. Quiz 7.8
1. Normalization
2. Transitive Dependence
3. 3NF: Examples
4. Practical Concerns
5. Lesson Summary
6. Quiz 7.9
1. Introduction
1. Constraining Data
2. Where Does the Constraint Go?
3. Types of Constraints
4. Lesson Summary
5. Quiz 8.1
1. DBMS & SQL
2. Basic SQL Commands
3. SELECT SQL Statements
4. JOIN SQL Statements
5. UPDATE, INSERT, and DELETE Statements
6. Lesson Summary
7. Quiz 8.2
1. Creating a Database
2. Create Database command options in Transact SQL
3. Create Database command options in MySQL
4. Create Database options summary
5. Deleting a Database
6. Drop Database command in Transact SQL
7. Drop Database command in MySQL
8. Lesson Summary
9. Quiz 8.3
1. Data Manipulation Language
2. SELECT
3. INSERT
4. UPDATE
5. DELETE
6. Lesson Summary
7. Quiz 8.4
1. How Do We Add Information to the Table?
2. Insert Multiple Records
3. SQL INSERT Examples
4. Insert Single Record
5. Inserting Without All Columns
6. Lesson Summary
7. Quiz 8.5
1. What is SQL?
2. Lesson Summary
3. Quiz 8.6
1. SQL?
2. Lesson Summary
3. Quiz 8.7
1. DROP Columns & Rows
2. Remove a Column
3. Some Examples
4. Delete a Row of Data
5. Lesson Summary
6. Quiz 8.8
1. Cleaning House
2. What is SQL?
3. What is a Database?
4. What is an Index?
5. What do the DROP Index and DROP Database Commands do in SQL?
6. Lesson Summary
7. Quiz 8.9
1. Oracle databases and database objects
2. Prerequisites
3. Topics covered in this lesson
4. Test Data to be used for this lesson
5. Exercises
6. Question 1
7. Question 2
8. Question 3
9. Indexes
10. Other CONSTRAINTS
11. Question 5
12. Question 6
13. Lesson Summary
1. Introduction
1. Database Administration
2. Administrator Responsibilities
3. Case Study
4. Importance of DBA
5. Lesson Summary
6. Quiz 9.1
1. Database Concurrency, Locking and Transactions Concurrency
2. Transactions and locks
3. Side effects of database concurrency
4. Lesson Summary
5. Quiz 9.2
1. Definition of Persistence
2. Types of Persistence
3. Object Persistence in Databases
4. Persistent Data: Importance
5. Persistent Databases: Examples
6. Lesson Summary
7. Quiz 9.3
1. Data Integrity
2. Two-Phased Locking Protocol
3. Lesson Summary
4. Quiz 9.4
1. Database Transactions
2. Transaction Properties
3. Atomicity
4. Consistency
5. Isolation
6. Durability
7. Lesson Summary
8. Quiz 9.5
1. The Use of Information
2. What is SQL?
3. What is a Cursor?
4. What is a Cursor Used for?
5. What Does SQL Cursor Syntax Look Like?
6. Lesson Summary
7. Quiz 9.6
1. What Is Database Security Management?
2. Threats to Database Security
3. Forms
4. Lesson Summary
5. Quiz 9.7
1. Roles and Responsibilities of a Database Administrator
2. Documentation of Databases
3. Helpful Tools to Assist in Documentation
4. Lesson Summary
5. Quiz 9.8
1. Databases in Organizations
2. Distributed Databases
3. Lesson Summary
4. Learning Outcomes
5. Quiz 9.9
1. Introduction
1. What Is a Database Application?
2. How Databases Work
3. How Databases Work
4. Advantages Over Spreadsheets
5. Lesson Summary
6. Quiz 10.1
1. Database Programs
2. Types of Database Programs
3. Single File / Flat File Database Programs
4. Relational Database Management System (RDMS)
5. Lesson Summary
6. Quiz 10.2
1. Microsoft SQL Server: What is it?
2. History
3. SQL Server Products
4. Microsoft SQL Server in Action
5. Features
6. Transact-SQL (T-SQL)
7. Lesson Summary
8. Quiz 10.3
1. Overview of the Oracle Database
2. Oracle Products
3. Accessing the Oracle Database
4. Structured Query Language (SQL)
5. PL/SQL
6. Conclusion
7. Quiz 10.4
1. MySQL Introduction
2. History of MySQL
3. MySQL Advantages and Usage in Web Projects
4. Lesson Summary
5. Quiz 10.5
1. Overview of Microsoft Access
2. Comparing Access with Other Databases
3. History of Access
4. Jet Database Engine
5. SQL Server
6. Lesson Summary
7. Quiz 10.6
1. The Technology Behind the Scenes
2. What is a Database?
3. What is a Database Reporting Tool?
4. What are Some Examples of Database Reporting Tools?
5. Lesson Summary
6. Quiz 10.7
1. What Is Markup Language?
2. Markup Languages Over the Years
3. Browser Battles
4. Lesson Summary
5. Learning Outcomes
6. Quiz 10.8
1. Introduction to XML
2. What can an XML file do?
3. What is an XML Schema?
4. Example of XML Schema
5. Lesson Summary
6. Quiz 10.9
1. The Importance of Information
2. What is a Web Application?
3. Web Application Categories
4. Effects of These Applications on Business Information Systems
5. Lesson Summary
6. Quiz 10.10
1. Website Design Defined
2. Planning Your Website
3. Building Your Website's Foundation
4. Decorating Your Website
5. Finalizing Your Website
6. Lesson Summary
7. Lesson Objectives
8. Quiz 10.11
1. Displaying Web Pages on the Internet
2. Using MySQL to Store and Display Web Data
3. Extensible Markup Language (XML) for Storing Websites' Data
4. How is XML Used to Markup Data?
5. Example
6. Reading XML and Displaying it in Webpages using PHP
7. Lesson Summary
8. Quiz 10.12
1. Introduction
1. What Is Business Intelligence?
2. Steps for Starting a New BI System
3. Business Analytics
4. Lesson Summary
5. Quiz 11.1
1. The History of Keeping Information
2. Definition
3. Uses
4. Lesson Summary
5. Quiz 11.2
1. The Lure of Big Data
2. What Is Big Data?
3. Analyzing Big Data
4. Big Data Example
5. Lesson Summary
6. Quiz 11.3
1. The Four Vs of Big Data
2. Volume
3. Velocity
4. Variety
5. Veracity
6. Lesson Summary
7. Quiz 11.4
1. The Ever-Increasing Presence of Data
2. What is Big Data?
3. What Are Its Advantages?
4. What Are Its Challenges?
5. Lesson Summary
6. Quiz 11.5
1. Different Applications
2. Healthcare
3. Education
4. Business
5. Lesson Summary
6. Quiz 11.6
1. Data Warehouses
2. Distributed DBMS
3. Data Mining
4. Lesson Summary
5. Learning Outcomes
6. Quiz 11.7
1. Definition of Data Mart
2. Implementing a Data Mart
3. Data Mart Benefits
4. Lesson Summary
5. Quiz 11.8
1. What is a Data Warehouse?
2. What is Quality Data?
3. What Makes Good Quality Data?
4. When is Poor Quality Data Likely to Be Injected?
5. Quality Data: The Bottom Line
6. Lesson Summary
7. Quiz 11.9
1. The Ever-Growing Thirst for Knowledge
2. What is Big Data?
3. What is a Data Warehouse?
4. What Are the Differences Between Big Data and Data Warehouses?
5. Lesson Summary
6. Quiz 11.10
1. Research and Data
2. Methods of Data Collection
3. The Process of Data Analysis
4. Lesson Summary
5. Learning Outcomes
6. Quiz 11.11
1. An Introduction to Data Analytics (DA)
2. Tools Used for Data Analytics
3. Lesson Summary
4. Quiz 11.12
1. Introduction
1. Spreadsheet Software
2. Database Software
3. Lesson Summary
4. Learning Outcomes
5. Quiz 12.1
1. What Is a Flat File Database?
2. Flat File Database Examples
3. Flat File Database Drawbacks
4. Lesson Summary
5. Quiz 12.2
1. Different Databases
2. Flat File Database
3. Uses of Flat File Databases
4. Relational Databases
5. Uses of a Relational Database
6. Lesson Summary
7. Quiz 12.3
1. What is a Hierarchical Database?
2. Hierarchical Databases: Uses
3. How a Hierarchal Database Works
4. Lesson Summary
5. Quiz 12.4
1. Data Is Everywhere!
2. What Is a Database?
3. Hierarchical Database
4. Relational Database
5. Why One Over the Other?
6. Lesson Summary
7. Quiz 12.5
1. Subject Databases Defined
2. Bibliographic Databases
3. Subject Databases vs. Internet
4. Creation of Subject Databases
5. Lesson Summary
6. Quiz 12.6
1. What is a Database Object?
2. Visualizing Database Objects
3. Examples of Database Objects
4. Lesson Summary
5. Quiz 12.7
1. Object-Oriented Databases
2. Fundamental Features
3. Advantages
4. Challenges & Solutions
5. Some Applications
6. Lesson Summary
7. Quiz 12.8
1. An Alternative to SQL
2. Why NoSQL?
3. Types of NoSQL
4. Lesson Summary
5. Quiz 12.9
1. FINAL EXAM
1. About this Assignment
2. Database Normalization
3. Miniature Database
4. Formatting & Sources
5. Grading Rubric
6. Before You Submit
7. How to Submit Your Assignment

About this course

$79.00
667 lessons
0 hours of video content

89%

77%

68%

Ch 1 - Introduction to Database Fundamentals

Ch 1.1 - What are Data? - Types, Sources & Definition

Ch 1.2 - What are Databases? - Examples & Types

Ch 1.3 - Database Concepts and Structures: The Elements That Make Up a Database

Ch 1.4 - Database Terminology

Ch 1.5 - Database Record: Definition & Explanation

Ch 1.6 - Database Fields: Definition & Types

Ch 1.7 - What is a Database Management System? - Purpose and Function

Ch 1.8 - Models of Database Management Systems (DBMS)

Ch 1.9 - Advantages of Database Management Systems (DBMS)

Ch 2 - Relational Database Model

Ch 2.1 - What is an Entity in a Database?

Ch 2.2 - What is an Attribute in a Database?

Quiz 2.3 - What is the Entity-Relationship Model? - Diagram & Examples

Ch 2.4 - What is a Relational Database? - Elements, Design & Advantages

Ch 2.5 - Relational Database: Model & Example

Ch 3.1 - History of SQL

Ch 3.2 - Structured Query Language: Manipulating Databases Using SQL

Ch 3.3 - Database Query: Definition & Tools

Ch 3.4 - What Is Query in SQL?

Ch 3.5 - Basic SQL Query Syntax

Ch 3.6 - SQL Subqueries: Example & Definition

Ch 3.7 - SQL: Inner Joins

Ch 3.8 - SQL: Full Outer Joins

Ch 3.9 - SQL: GROUP BY Clause

Ch 3.10 - How to Create & Run a SQL Script

Ch 3.11 - SQL Scripts vs. Queries

Ch 3.12 - SQL Scripts: Uses & Examples

Ch 4 - Data Types in SQL

Ch 4.1 - SQL Data Types: CHAR & VARCHAR

Ch 4.2 - SQL Data Types: INT & SMALLINT

Ch 4.3 - SQL Data Types: DECIMAL & NUMERIC

Ch 4.4 - SQL Data Types: REAL, FLOAT & DOUBLE

Ch 4.5 - SQL Data Types: BOOLEAN

Ch 4.6 - SQL Data Types: DATE, TIME & TIMESTAMP

Ch 4.7 - SQL Data Types: BINARY LARGE OBJECT

Ch 5 - Variations of SQL

Ch 5.1 - What is T-SQL?

Ch 5.2 - What is PL/SQL?

Ch 5.3 - What is Dynamic SQL?

Ch 6 - Relational Data Modeling

Ch 6.1 - Abstract Data Models

Ch 6.2 - What is a UML Object Diagram? - Definition & Example

Ch 6.3 - What is a UML Class Diagram? - Definition, Symbols & Examples

Ch 6.4 - What is a Database Schema? - Example & Definition

Ch 6.5 - How to Design a Database Schema

Ch 7 - Relational Database Design

Ch 7.1 - What is a Primary Key in SQL?

Ch 7.2 - What is a Foreign Key in SQL?

Ch 7.3 - Relationships in SQL: Examples & Explanation

Ch 7.4 - Database Table: Design & Conventions

Ch 7.5 - Designing a Relational Database: Tutorial & Overview

Ch 7.6 - What is Normal Form in DBMS? - Types & Examples

Ch 7.7 - SQL Normalization: Example & Rules

Ch 7.8 - First Normal Form in DBMS with Examples

Ch 7.9 - Third Normal Form in DBMS with Examples

Ch 8 - Creating, Modifying & Deleting Databases

Ch 8.1 - SQL: Constraints

Ch 8.2 - Basic SQL Commands in Database Management Systems (DBMS)

Ch 8.3 - SQL: CREATE DATABASE & DROP DATABASE Statements

Ch 8.4 - Data Manipulation Language (DML) Commands

Ch 8.5 - SQL: INSERT Statement

Ch 8.6 - SQL: UPDATE Statement

Ch 8.7 - SQL: DELETE Statement

Ch 8.8 - SQL DROP Columns & Rows: Tutorial

Ch 8.9 - SQL DROP Index & DROP Database: Tutorial

Ch 8.10 - Practical Application for Database Programming: Database Creation in Oracle Database Express

Ch 9 - Database Administration & Security

Ch 9.1 - Database Administrator: Responsibilities & Activities

Ch 9.2 - Database Concurrency & Locking

Ch 9.3 - Persistence in Databases: Definition, Examples & Importance

Ch 9.4 - Two-Phased Locking, Releasing Locks & Deadlocks in Databases

Ch 9.5 - ACID Properties in Data Base Management Systems (DBMS)

Ch 9.6 - What is a Cursor in SQL? - Example & Syntax

Ch 9.7 - Database Security Management

Ch 9.8 - Configuration & Documentation for Database Administrators: Overview & Examples

Ch 9.9 - What is a Distributed Database? - Architecture, Principles & Advantages