Duration: 16 hours / 2 days
3 Lessons
Module 1
Module 2
Module 3
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
WEEK 2
WEEK 3
WEEK 4
WEEK 5
WEEK 6
WEEK 7
WEEK 8
WEEK 9
WEEK 10
WEEK 11
WEEK 12
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
WEEK 2
ACID (Atomicity, Consistency, Isolation, Durability)
WEEK 3
Joins and NoSQL
WEEK 4
Types of NoSQL Databases
WEEK 5
Document Store (MongoDB)
WEEK 6
Document Store (MongoDB)
WEEK 7
NoSQL – MongoDB
WEEK 8
MongoDB
WEEK 9
MongoDB
WEEK 10
Column Store (Cassandra)
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