100% Placement
Expert Trainers
Practical Training
Live Projects
About Mongo DB
Microsoft SQL Server (MSSQL): Powering Reliable Data Management Solutions
Microsoft SQL Server (MSSQL) is a leading relational database management system developed by Microsoft. Renowned for its robustness and scalability, MSSQL offers an extensive suite of features catering to diverse data management needs. From its powerful SQL querying capabilities to advanced security measures and seamless integration with Microsoft’s ecosystem, MSSQL serves as a cornerstone for businesses, supporting critical applications and enabling efficient data storage, retrieval, and analysis. With versions ranging from the lightweight Express edition to enterprise-grade solutions, MSSQL remains a top choice for organizations seeking reliability, performance, and comprehensive database solutions.
- Tech Excellence Hub
- Expert-Led Learning Journeys
- Innovative Skills Development
- Cutting-Edge Lab Facilities
- Global Certification Hub
- Career-Ready Training Solutions
8070705599
Call Us For Admission
Best at feature
Why Choose Tironation
Introduction (1 hour)
• Introduction to NoSQL
• What Is NoSQL?
• Why NoSQL databases are required.
• Types of NoSQL Database
• NoSQL vs SQL Comparison
• ACID & BASE Property
• CAP Theorem
• Benefits of NoSQL databases
• Installation
• Start and Stop the mongodb process
Architecture (1.5 hour)
• Document, Collection, Databases
• JSON and BSON
• Storage Engines (WiredTiger and MMAP)
• Read Path
• Journaling
• Write Path
• Working Set • Capped Collection
• Oplog collection
• TTL Index
• GridFS
CRUD Operations (1 hour)
• Mongodb Data Types
• Inserting, Update, Deleting the documents
• Querying the documents
• Bulk insert operation
• Updating multiple document
• Limiting documents
• Filtering documents
Schema Design and Data modeling (1 hour)
• Dynamic Schema
• What is Data modeling?
• RDBMS and Mongodb Data modeling difference
• Embedding Document • Reference Document
Indexes (30 Mins)
• Index concepts in mongodb
• Types of indexes
• Indexes and its use cases
• Creating Indexes and Managing Indexes
• Index strategies
Database Administration (1.5 hour)
• Database status
• Troubleshooting issues
• Current Operations
• Rotating log files
• Users and Roles
• Copy and Clone database
• DB and Collection Stats
• Explain plan
• Profiling
• Changing configuration files
• Upgrading the database
Monitoring and Other Tools (30Mins)
• MMS Manager
• Ops Manager
• Mongo utility commands
• Mongo developer tools
• Mongodb Atlas
• Mongodb client drivers
Replication (1.5 Hour)
• Concept of replication
• ReplicaSet member roles
• Voting and Electing primary
• Role of Oplog in replication
• Read and Write Concern
• Arbiter,Hidden and Delayed replica node
• Priority settings
• Replicaset nodes health check
• Concept of resyncing the nodes
• Rollbacks during failover • Keyfile authentication
Scalability (1 hour)
• Concept of Scalability and Sharding
• Shardkey and Chunks
• Choosing shardkey
• Sharding components
• Types of Sharding
• Balanced data distribution
• Sharded and Non-sharded collection
• Sharded Replicaset • Tag aware sharding
Monitoring and Other Tools (30Mins)
• MMS Manager
• Ops Manager
• Mongo utility commands
• Mongo developer tools
• Mongodb Atlas
• Mongodb client drivers
Upgrading MongoDB to Latest Stable Version (30 mins)
• Upgrading MongoDB to Latest Stable Version
• Upgrade Process
• Post Upgrade Checks
MongoDB Performance Tuning (30 mins)
• Monitoring of Performance
• Logging database operations
• Capturing queries – Database Profiler
• Checking operating system parameters
• Explain plan-MongoDB provides an explain facility
• Measuring replication lag performance
Why Choose Tironation
Application Process
Why Tironation
Our Happy Students
Akshay Taralkar
Senior ManagerChoosing Tironation's IT course was the best investment in my career. The comprehensive curriculum, combined with hands-on labs and projects, allowed me to gain practical experience and develop the skills needed to excel in the fast-paced IT industry.
Pooja Kundekar
Senior ManagerI can recommend Tironation's IT course highly enough. The curriculum is up-to-date with industry trends, the instructors are passionate about what they teach, and the supportive learning environment fosters growth and innovation
Ashwini More
Senior Manager- TCSCourse stands out for its blend of theoretical knowledge and practical application. The instructors' expertise and the hands-on projects enhanced my technical skills and how to approach problems creatively and collaboratively."
Placement Companies
