100% Career Oriented Training & Placements
+91-9176033446

100% Job Assured Training & Placements

SQL/MongoDB Programming

Fees: Rs 18000
Duration: 45days/60hrs

Register

For details about the course

Call Us: +9176033446

What you'll learn

We have been offering 45days Course in SQL/MongoDB Programming from the scratch. Designed by industry experts,aim at providing industry-oriented education to students and hence making them job-ready.

  • Learn the ins and outs of SQL syntax
  • Run complex queries using MySQL logical operators and string functions
  • Write all the common SQL joins
  • Work with large datasets containing thousands of entries
  • Design and implement complex database schemas
  • Learn what document databases are and how data is organized with MongoDB
  • Learn how to perform CRUD operations with MongoDB
  • Write efficient and well-performing queries to fetch data in the format you need it
Show More

Course Content

    Introduction to Database and MySQL
    What is MySQL?
    What is PhpMyAdmin
    Datatypes in MySQL
    Keywords in MySQL
    Create Users
    Create Database and Table
    Create Table
    Drop Table
    Insert Statements
    Select Statements
    Clause - Where, Limit
    Operators - ISNULL, LIKE, ORDERBY
    Update Statements
    Delete Statements

    Understanding Databases, Collections & Documents
  • The Shell & MongoDB Drivers for Different Languages
  • Creating Databases & Collections
  • Understanding JSON Data
  • Comparing JSON & BSON
  • Create, Read, Update, Delete (CRUD) & MongoDB
  • Finding, Inserting, Deleting & Updating Elements
  • Understanding "insertMany()"
  • Diving Deeper Into Finding Data
  • "update" vs "updateMany()"
  • Understanding "find()" & the Cursor Object
  • Understanding Projection
  • Embedded Documents & Arrays - The Theory
  • Working with Embedded Documents
  • Working with Arrays
  • Accessing Structured Data

    Resetting Your Database
  • Why Do We Use Schemas?
  • Structuring Documents
  • Data Types - An Overview
  • Data Types in Action
  • Data Types & Limits
  • How to Derive your Data Structure - Requirements
  • Understanding Relations
  • One To One Relations - Embedded
  • One To One - Using References
  • One To Many - Embedded
  • One To Many - Using References
  • Many To Many - Embedded
  • Many To Many - Using References
  • Summarizing Relations
  • Using "lookUp()" for Merging Reference Relations

    Finding Available Options
    Setting "dbpath" & "logpath"
    Exploring the MongoDB Options
    MongoDB as a Background Service
    Using a Config File
    Shell Options & Help

    Creating Documents - An Overview
    Understanding "insert()" Methods
    Working with Ordered Inserts
    Understanding the "writeConcern"
    The "writeConcern" in Practice
    What is Atomicity?

    Methods, Filters & Operators
    Operators - An Overview
    Query Selectors & Projection Operators
    Understanding "findOne()" & "find()"
    Working with Comparison Operators
    Querying Embedded Fields & Arrays
    Understanding "$in" and "$nin"
    "$or" and "$nor"
    Understanding the "$and" Operator
    Using "$not"
    Diving Into Element Operators
    Working with "$type"
    Understanding Evaluation Operators - "$regex"
    Understanding Evaluation Operators - "$expr"

    Updating Fields with "updateOne()", "updateMany()" and "$set"
    Updating Multiple Fields with "$set"
    Incrementing & Decrementing Values
    Using "$min", "$max" and "$mul"
    Getting Rid of Fields
    Renaming Fields
    Understanding "upsert()"
    Time to Practice - Update Operations

      Understanding "deleteOne()" & "deleteMany()"
      Deleting All Entries in a Collection

      What Are Indexes & Why Do We Use Them?
      Adding a Single Field Index
      Indexes Behind the Scenes
      Understanding Index Restrictions
      Creating Compound Indexes
      Using Indexes for Sorting
      Understanding the Default Index
      Configuring Indexes
      Understanding Partial Filters
      Applying the Partial Index
      Understanding the Time-To-Live (TTL) Index
      Query Diagnosis & Query Planning
      Understanding Covered Queries
      How MongoDB Rejects a Plan
      Using Multi-Key Indexes
      Understanding Text Indexes
      Text Indexes & Sorting
      Creating Combined Text Indexes
      Using Text Indexes to Exclude Words
      Setting the Default Language & Using Weights
      Building Indexes

Learning Outcome

  • How to install and use MongoDB locally and in the cloud (MongoDB Atlas)
  • How to perform CRUD (Create, Read, Update, Delete) operations on MongoDB databases
  • How to filter for data efficiently
  • How to work with both the Mongo Shell and drivers (e.g. Node.js driver)
  • How to increase performance by using indexes (and how to use the right indexes!)
  • What replica sets and sharding are
  • How to plan, sketch, design, build, test, and optimize a Database
  • How to use the serverless platform (Stitch) offered by MongoDB

Mode of Training

  • Classroom Training
  • Instructor Led LIVE Virtual Classroom Training

Who Will Learn

  • Freshers/Job Seekers
  • IT Professionals
  • Both beginner and advanced MongoDB users who want to explore all the core features
  • Everyone who's interested in NoSQL databases
  • Data Analyst and Scientist

Review

5.0
Course Rating
63%
29%
6%
1%
1%