Database Trainer (Advanced SQL & MongoDB)

4 - 8 years

0 Lacs

Posted:1 week ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

As a Database Trainer specializing in Advanced SQL and MongoDB, your role will involve teaching key areas to participants in a classroom training setting. Your responsibilities will include: - Conducting a deep dive into SQL Joins with real-world performance use cases - Teaching Subqueries and Common Table Expressions (CTEs) - Explaining Aggregations, ROLLUP, CUBE, and conditional grouping - Covering Indexing strategies such as B-tree, bitmap, limitations, and maintenance - Providing insights on Query optimization and cardinality estimation - Analyzing Execution plans (specifically for MySQL/MariaDB) - Demonstrating Stored procedures, triggers, events, and functions - Guiding participants on Error handling and real-time project problem-solving - Assisting in Complex query building and analytics-focused SQL - Teaching about Transactions and connection pooling For MongoDB, your responsibilities will include: - Explaining Schema design: embedded vs referenced - Teaching Aggregation pipeline operations: $match, $group, $project, $unwind, etc. - Discussing Index structures, cardinality, and EXPLAIN - Providing guidance on Performance tuning and stream pipeline - Demonstrating Integration with Node.js/Python - Covering Transactions, security practices, and connection pooling Additional details about the company or any other information were not specified in the job description. As a Freelance Database Trainer, you will be required to deliver training on Advanced SQL and MongoDB to 20 participants each. The training will be conducted in person at Gurugram, with a duration of 4 hours per day split equally between Advanced SQL and MongoDB. The contract length for this position is 2 days.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You