Monthly Subscription Starting at AED 99 + VAT

Implement Polyglot Persistence Using SQL and NoSQL Databases
  • Level Professional
  • Duration 13 hours
  • Course by NIIT
  • Offered by

About

Have you ever wondered what happens to the registration details after you click on the submit button or to the order details once you press the confirm order button when you try to access any website? From where do you think, the details of the product catalogue are fetched to be displayed on the browser? All dynamic or interactive applications should be able to store the details provided by the user and retrieve them when requested. Most websites require a database. This course will take you through the process of creating, retrieving, updating, and deleting data using SQL and NoSQL databases. It also challenges you with hands-on practices that enable you to perform database operations using shell commands and GUI tools.

Modules

Context Setting

    • 1 Videos
Show info about module content

1 Videos

  • Context Setting

1.1 Explain ER Model and Data Normalization

    • 1 Videos
Show info about module content

1 Videos

  • Explain ER Model and Data Normalization

1.2 Demonstrate MySQL installation

    • 2 Videos
Show info about module content

2 Videos

  • Demonstrate MySQL installation
  • Watch and Repeat : Download and Install MySQL

1.3 Implement SQL commands to perform CRUD operations

    • 4 Videos
Show info about module content

4 Videos

  • Implement SQL commands to perform CRUD operations
  • Watch and Repeat : Create database and tables using DDL commands
  • Watch and Repeat : Manipulate data using DML commands
  • Watch and Repeat : Retrieve data using DQL commands

1.4 Build RESTful API using Node.js and MySQL database

    • 4 Videos
Show info about module content

4 Videos

  • Build RESTful API using Node.js and MySQL database
  • Watch and Repeat : Integrate MySQL with Node.js using Node.js driver for MySQL
  • Watch and Repeat : Build REST API Using Node.js and MySQL Part1
  • Watch and Repeat : Build REST API Using Node.js and MySQL Part2

Practice

    • 2 Videos
    • 1 Readings
    • 1 Programming
Show info about module content

1 Programming

  • Keep Note MySQL Queries

2 Videos

  • Practice Brief
  • Practice Debrief

1 Readings

  • Instructions to upload the Programming Assignment Solution

Challenge

    • 2 Videos
    • 1 Programming
Show info about module content

1 Programming

  • Keep Note – Integration with Node.js

2 Videos

  • Challenge Brief
  • Challenge Debrief

Summary

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Eliminate Data Redundancy Using Relational Data Model

1 Videos

  • Learning Consolidation

1 Readings

  • Eliminate Data Redundancy Using Relational Data Model

Context Setting

    • 1 Videos
Show info about module content

1 Videos

  • Context Setting

2.1 Model data using MongoDB

    • 1 Videos
Show info about module content

1 Videos

  • Model data using MongoDB

2.2 Demonstrate MongoDB installation

    • 2 Videos
Show info about module content

2 Videos

  • Demonstrate MongoDB installation
  • Watch and Repeat : Installing Mongo​

2.3 Make use of Mongo shell commands to perform CRUD operations

    • 4 Videos
Show info about module content

4 Videos

  • Make use of Mongo shell commands to perform CRUD operations
  • Watch and Repeat : CRUD With MongoDB Shell Commands​ Part1
  • Watch and Repeat : CRUD With MongoDB Shell Commands​ Part2
  • Watch and Repeat : CRUD With MongoDB Shell Commands​ Part3

2.4 Utilize the MongoDB Node driver to establish a connection with the Node.js application

    • 2 Videos
Show info about module content

2 Videos

  • Utilize the MongoDB Node driver to establish a connection with the Node.js application
  • Watch and Repeat : Integrate MongoDB With Node.js Using MongoDB Node Driver

2.5 Model application data to develop a schema-based solution using Mongoose

    • 2 Videos
Show info about module content

2 Videos

  • Model application data to develop a schema-based solution using Mongoose
  • Watch and Repeat : Integrating MongoDB With Node.js using Mongoose

2.6 Build RESTful API using Node.js and MongoDB

    • 5 Videos
Show info about module content

5 Videos

  • Build RESTful API using Node.js and MongoDB
  • Watch and Repeat : Building REST API Using Node.js and MongoDB Part1
  • Watch and Repeat : Building REST API Using Node.js and MongoDB Part2
  • Watch and Repeat : Building REST API Using Node.js and MongoDB Part3
  • Watch and Repeat : Building REST API Using Node.js and MongoDB Part4

Practice

    • 2 Videos
    • 1 Programming
Show info about module content

1 Programming

  • Web Ink

2 Videos

  • Practice Brief
  • Practice Debrief

Challenge

    • 2 Videos
    • 1 Programming
Show info about module content

1 Programming

  • Pin2Piano

2 Videos

  • Challenge Brief
  • Challenge Debrief

Summary

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Minimizing Impedance Mismatch Using NoSQL Database

1 Videos

  • Learning Consolidation

1 Readings

  • Minimizing Impedance Mismatch Using NoSQL Database

Auto Summary

Explore the world of dynamic applications with "Implement Polyglot Persistence Using SQL and NoSQL Databases." This engaging IT & Computer Science course by Coursera covers creating, retrieving, updating, and deleting data using both SQL and NoSQL databases. Perfect for professionals, it includes hands-on practices with shell commands and GUI tools. With a duration of 780 minutes, it offers Starter and Professional subscription options. Ideal for those looking to enhance their database management skills.

NIIT
Instructor

NIIT