When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 2 modules in this course
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.
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.
Explain ER Model and Data Normalization•14 minutes
Demonstrate MySQL installation•1 minute
Watch and Repeat : Download and Install MySQL•6 minutes
Implement SQL commands to perform CRUD operations•10 minutes
Watch and Repeat : Create database and tables using DDL commands•6 minutes
Watch and Repeat : Manipulate data using DML commands•8 minutes
Watch and Repeat : Retrieve data using DQL commands•8 minutes
Build RESTful API using Node.js and MySQL database•5 minutes
Watch and Repeat : Integrate MySQL with Node.js using Node.js driver for MySQL•3 minutes
Watch and Repeat : Build REST API Using Node.js and MySQL Part1•10 minutes
Watch and Repeat : Build REST API Using Node.js and MySQL Part2•5 minutes
Practice Brief•5 minutes
Practice Debrief•3 minutes
Challenge Brief•3 minutes
Challenge Debrief•3 minutes
Learning Consolidation•1 minute
2 readings•Total 20 minutes
Instructions to upload the Programming Assignment Solution•10 minutes
Eliminate Data Redundancy Using Relational Data Model•10 minutes
1 assignment•Total 30 minutes
Eliminate Data Redundancy Using Relational Data Model•30 minutes
2 programming assignments•Total 240 minutes
Keep Note MySQL Queries•75 minutes
Keep Note – Integration with Node.js•165 minutes
Minimizing Impedance Mismatch Using NoSQL Database
Module 2•6 hours to complete
Module details
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.
Established in 1981, NIIT offers Managed Training Services to market-leading companies in 30 countries worldwide. NIIT’s comprehensive suite of Managed Training Services includes bespoke curriculum design and content development, learning administration, learning delivery, strategic sourcing, learning technology, and advisory services.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.