Duration: 16 hours / 2 days

3 Lessons

Module 1

• Database Fundamentals,
• Database objects in Oracle

Module 2

• DQL
• DML
• DDL
• DCL

Module 3

• Stored Procedures
• Functions and Triggers

View the Curriculum

Duration: 48 hours / 6 days

12 Lessons

The study of database design and management of a database is an essential component of the business IT world today.

Through this course the participant will gain a background in database design.

The participant will work with entity-relationship diagrams (ERD) to learn and implement the basic database design. Using Oracle SQL, the participants will apply the design principles to actually create and develop a working database.

This course is designed to help participants integrate theoretical material with practical knowledge to implement a database.

Participants will also use SQL commands to query single and multiple tables.

Single and group functions will also be used to enhance queries. Subqueries will be used to enhance data retrieval.

Data manipulation of data will also be covered to change the data in the database.

We will discuss the connection of an application program to the database to store and retrieve data.

WEEK 1

• Install SQL Developer 21
• Configure the database connection
• Activity 
  – Display connected user name
  – Display system date

WEEK 2

• Apply normalization principles to DB design
• Design tables
• Reading Chapter# 1
• Activity 
  – Design tables based on design criteria

WEEK 3

• Use the basic SELECT statement
• Queries with a single table
• Reading Chapter# 2
• Activity 
  – Create queries based on a given request

WEEK 4

• Create database tables with and without constraints
• Reading Chapter# 3 and 4
• Activity 
  – Create tables with or without constraints

WEEK 5

• Perform DML operations on data with TCL commands
• Reading Chapter# 5
• Activity
  – Perform DML operations against data in tables

WEEK 6

• Build queries with criteria to restrict rows
• Reading Chapter# 8
• Activity 
  – To create queries with conditions or restrictions

WEEK 7

• Build queries using more than one table
• Reading Chapter# 9
• Activity 
  – Access data from multiple tables
  – Display results of given lab queries

WEEK 8

• Build queries using single-row functions
• Reading Chapter# 10
• Activity 
  – To create queries using single-row functions
  – Create tables with single-row functions

WEEK 9

• Build queries using aggregate functions
• Reading Chapter# 11
• Activity 
  – To create queries using single-row functions and aggregate functions

WEEK 10

• Build queries using subqueries
• Reading Chapter# 12
• Activity 
  – Create queries with the use of subqueries

WEEK 11

• Build views
• Reading Chapter# 13
• Activity
  – Create views based on queries

WEEK 12

• Introduction to the Explain Plan
• Activity 
  – To show the explain plan for several queries

View the Curriculum

Duration: 40 hours / 8 days

10 Lessons

“Not only SQL” databases are heavily used in Big Data applications – particularly those that are web-related.

The benefits in scalability and performance make a NoSQL database a compelling choice.

In this course, participants will design and implement NoSQL databases using systems like MongoDB, Cassandra etc. Participants will also demonstrate the implementation of a NoSQL database in a large-scale storage and data processing model.

WEEK 1

Introduction to NoSQL Database Implementation

• Relational and NoSQL Databases
• Define Relational Databases
• Define NoSQL Databases
• Compare Relational with NoSQL Databases

WEEK 2

ACID (Atomicity, Consistency, Isolation, Durability)

• Define each term in ACID
• Describe examples where each property of ACID fails.

WEEK 3

Joins and NoSQL

• Define a Join as it relates to tables in a database.
• Describe ways in which a Join can be accomplished in a NoSQL database.

WEEK 4

Types of NoSQL Databases

• Define a Column Store
• Define a Document Store
• Define a Key-Value Store
• Define a Graph-type database

WEEK 5

Document Store (MongoDB)

• Describe some of the features of MongoDB.
• Discuss where the Document Store approach is most appropriate.

WEEK 6

Document Store (MongoDB)

• Describe some of the features of MongoDB.
• Discuss where the Document Store approach is most appropriate.

WEEK 7

NoSQL – MongoDB

• Create/Delete Documents
• Data Types

WEEK 8

MongoDB

• Query

WEEK 9

MongoDB

• Update Documents
• Aggregation

WEEK 10

Column Store (Cassandra)

• Describe some of the features of Cassandra
• Discuss where the Column Store approach is most appropriate
• Demonstrate the use of Cassandra

View the Curriculum 

Duration: 55 Hours

The objective of the MongoDB course is to equip participants with comprehensive
knowledge and practical skills necessary to proficiently work with MongoDB across its entire ecosystem.

Upon completing the MongoDB course, Participants will gain expertise in MongoDB’s architecture, CRUD operations, indexing, aggregation, data modeling, administration (including replication, sharding, monitoring, and backup), security measures, advanced topics such as integration with big data technologies and cloud deployment, as well as real-world application
through case studies and project work.

The course aims to prepare participants to effectively design, deploy, manage, and optimize MongoDB databases and applications in diverse operational environments.

Module 1: Introduction to MongoDB

Module 2: CRUD Operations

Module 3: Indexing and Aggregation

Module 4: Data Modeling

Module 5: Administration

Module 6: Security

Module 7: Advanced Topics

Module 8: Case Studies and Real-World Applications

View the Curriculum