Implement Polyglot Persistence Using SQL and NoSQL Databases

Overview

Class Central Tips

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.

Syllabus

Eliminate Data Redundancy Using Relational Data Model

Over the last 3 decades, RDBMS has been a stable database for large global corporations and small business. Most employers mandate SQL skills as a necessary check in their recruitment process. As a software engineer, you will be required and be able to work with MySQL database to create, store, query and analyze data from RDBMS. In this learning sprint, you will learn how to model data using the ER diagram. You will implement MySQL shell commands to perform CRUD operations. The hands-on exercises, in this learning sprint will also enable you to build RESTful APIs using Node.js and MySQL database.

Minimizing Impedance Mismatch Using NoSQL Database

For a customer facing system of engagement, it is crucial to have a database that can handle unstructured and unpredictable data. NoSQL document database like MongoDB fulfills this criteria. As a back-end programmer, you will be required to resolve the mismatch between the storage and application systems and accordingly model data to make processing efficient. In this learning sprint, you will identify steps to model data for MongoDB database. You will learn to setup MongoDB in local machines and perform CRUD operations using the shell commands. In addition, the hands-on exercises will help you gain experience with various techniques used to integrate MongoDB with Node.js RESTful APIs.