Track
Software Development
Duration
30 hours
Skill Level
Advanced
Language
English
About this Course
Apply database concepts in real-world applications using normalization and schema design.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Transaction Support in SQL
- Introduction to Concurrency Control
- Two-Phase Locking Techniques for Concurrency Control
- Variations of Two-Phase Locking
- Dealing with Deadlock and Starvation
- Deadlock Detection
- Concurrency Control Based on Timestamp Ordering
- Multiversion Concurrency Control Techniques
- Granularity of Data Items and Multiple Granularity Locking
- Recovery Concepts
- NO - UNDO or REDO Recovery Based on Deferred Update
- Recovery Techniques Based on Immediate Update
- Shadow Paging
- Database Backup and Recovery from Catastrophic Failures
- Working of Key-Value Databases
- Features and Functions of Key-Value Databases
- Schema Design to Support Key Value
- Key - Value Database Vs Cache
- The Property Graph Model
- Why Data Relationships Matter
- Why Other NoSQL Databases don’t Fix the Problem Either
- Relational vs Graph Data Modelling Match-Up
- Example Data Model - Fraud Detection in Email Communications
- Database Query Language
- Difference Between Cloud and Database
- Cloud Database Deployment Models
- Key Benefits of Cloud Databases
- When to Use a Cloud Database
- Additional Considerations of Cloud Database
- Some Large Cloud Providers and Databases
- Advantages of Sharding
- Shared - Nothing Architecture
- Shared - Disk Architecture
- Sharding
- Sharded Cluster Components
- Considerations Before Sharding
- Sharded and Non-Sharded Collections and Connecting to a Sharded Cluster
- Introduction, Benefits of Business Intelligence Tools
- Best data analytics and BI tools
- Microsoft Power BI
- Tableau
- Qlik Sense
- Sisense
- Best BI tool for developing and deploying analytics apps
- Looker – data analytics and BI tool for start-ups and mid-sized businesses
- Oracle
- Domo BI
- SAS Analytics
- Relationship of RDBMS Terminology with MongoDB
- Sample Document
- Key Components of MongoDB Architecture
- MongoDB - Advantages
- Functionality of MongoDB
- MongoDB - CAP Approach
- MongoDB - Hierarchical Objects
- MongoDB - Environment
- MongoDB Processes and Configuration
- Install MongoDB on Windows
- Install MongoDB on Ubuntu
- MongoDB Statistics
- CRUD Operations in MongoDB
- Data Modelling
- Some Considerations While Designing Schema in MongoDB
- Create Database
- Drop Database
- Create Collection
- Data Types
- Insert Document
- Query Document
- Update Document
- Delete Document
- Design and Develop MongoDB Queries using CRUD operations
- Projection
- Limiting Records
- Sorting Records
- Aggregation - Examples
- Authentication Mechanisms in MongoDB
- Bulk Operations with Examples
- Indexing
- Replication
- Program to Implement Aggregation and Indexing in MongoDB
- Create Backup of Sharded Cluster
- SQL vs Mongo DB Entities
- Consistency of Data
- Query through API
- Exercise on Student Database Agenda
- MongoDB – Deployment
- Typical MongoDB Deployment, Read Preference and Write Concern_1
- Operation Performance and Partition
- Relationships
- Database References
- List of Drivers Supported by DBRefs
- MongoDB - Map Reduce
- Using MongoDB as a Service: mLab
- Execute the Query and Study its Execution Plan
- Careers in Database Technology
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Advanced Database Management and Application?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
Other MKCL Courses
-
Python
120 hours -
Mobile App Development
120 hours -
Advanced C# Programming Techniques
30 hours -
Advanced Concepts of C#
60 hours