Masters in Digital Commerce with Conversational AI Chatbots

A 6 month program which delivers everything that is needed for you to start your career in developing applications as a business analyst with a background in digital commerce

  • Domain : CSE
Enroll Now View demo

GET COURSE COUNSELLING TODAY

Get a 1-on-1 demo to understand what is included in the course and how it can benefit you from an experienced sales consultant. The demo session will help you enroll in this course with a clear vision and confidence.

Request a Demo Session

KEY MODULES

This masters program is designed to help you get a very good understanding on how to develop applications to excel in your field as a business analyst where we also provide a good background on digital commerce with the usage of conversational chatbots. The program offers 8 courses which containts video content to help you understand the content. As you watch each  video, pay attention to the challenges and assignments that are provided as part of the course. These assignments will help you in applying the concepts that you would have learnt. At any point in time, if you have questions, do not hesitate to ask us. We hope you enjoy the course. The following courses are covered in this program:

  • The Complete Front End Development
  • Introduction to Java Programming
  • Data structures and Algorithms using JAVA
  • Everything about Databases
  • Business Analyst Fundamental for Beginners
  • NodeJS API Development for Beginners
  • Mongo Database Administration - The Complete Guide
  • Introduction to Yellow Messenger

1. The Complete Front-End Development-Syllabus

1 Basics of a Web Application

Information on the Web is stored in documents, using the HTML (HyperText Markup Language) language. Web clients interpret HTML and display the documents to a user. The protocol that governs the exchange of information between the Web server and Web client is named HTTP.


This week, we will give you a brief introduction to the topics of HTTP and how it works.

The topics in specific you will be learning are:

 

  • What are websites and how do they work? 
  • How does the Internet work? 
  • The browser and HTTP. 
  • How have web applications evolved- Web 1.0, 2.0, 3.0? 
  • HTTP session and session storage.
  • Fundamentals of web application design- The N-tier architecture.
  • Role of HTML, CSS, and JavaScript.
  • Set up the software development environment you will use throughout the remainder of the course.


2Structuring your webpage using HTML5

During the course of this week, you will be learning how to structure your webpage using HTML5. HTML5 is a programming language whose acronym stands for HyperText Markup Language. It allows the modification of the appearance of web pages. It is also used to structure and present content for the websites.


The topics taught in this week are:


  • Valid document structure, anatomy of HTML syntax
  • HTML5 semantic tags - Elements and attributes, Block and inline elements
  • Essential HTML5 tags - headings, paragraph, styles, comments, colours
  • HTML lists - unordered and ordered lists
  • Inserting images using HTML 
  • How to create hyperlinks using anchor tags
  • HTML tables
  • HTML forms and create a simple contact me form
  • HTML Div-Layout and separate content for CSS styling
  • Classes, ID
  • HTML iFrames
  • HTML Graphics
  • HTML Media
  • HTML APIs- Geolocation, Web Storage, Web Workers, Drag and Drop, SS Event
  • HTML best practices- HTML vs XHTML


3Styling your webpage using Cascading Style Sheets (CSS3)

During this week, you will learn how to style your webpage. Styling a web page is vital as it impacts how the audience perceives your brand, product, or service. The first impression that they have on your website can make either stay on your page or migrate them to a competitor’s. This is where Cascaded Style Sheets(CSS) come into play.


During this week, you will learn:


  • Basics of CSS3, CSS rules
  • Comments, Colors, background, border, margin, padding, height and width
  • CSS selectors and properties
  • Inline, internal, and external CSS
  • Font styling, web safe fonts - texts, icons, links
  • The 'Box model'
  • CSS sizing methods
  • CSS static, relative, and absolute positioning systems
  • CSS float and clear 
  • Pseudo classes and pseudo elements
  • Class vs. ID
  • Opacity, Navigation bars, Dropdowns
  • CSS rule conflict resolution. specificity, and implementing style hierarchy
  • Images and forms styling
  • Transitions, animations, pagination, 2D and 3D transforms
  • Responsive web design 
  • The grid system
  • Flexbox, media queries
  • CSS coding best practices

4 Make styling simpler using Bootstrap 4

As the number of devices that are available to the general populace increases, your website will receive traffic from various forms of devices. Each of these devices has different screen sizes, different UIs, and other differing features. So, it is vital that you ensure that your website looks best regardless of the device it is viewed from. During the classes this week, you will learn about Bootstrap4. Bootstrap is an open-source front-end framework for faster and easier web development. It includes HTML and CSS based design templates for typography, forms, buttons, tables, navigation, models, image carousels and many other, as well as optional JavaScript plugins.


This week’s content will have:


  • The mobile-first paradigm
  • Wireframes in the design phase
  • Twitter Bootstrap- Grid System
  • How to install the Bootstrap framework
  • Bootstrap containers to layout website easily
  • Other Bootstrap components- buttons, tables, images, jumbotron, alerts, progress bars, spinners, dropdowns, forms, panels, modal, tooltip, popover, scrollspy, utilities, media objects and filters
  • Bootstrap carousels
  • Bootstrap cards 
  • Bootstrap navigation bars
  • Bootstrap themes
  • Font awesome


5Principles of building a better UI

A good User Interface (UI) is almost invisible to the user. It avoids unnecessary clutter and gets straight to the point. This is done by using a myriad of labels and visual aids. However, the most vital feature for a good UI are common UI elements. By integrating common elements in your UI, the users will feel more comfortable and will be able to get things done more quickly.


During the course of this week, you will learn:


  • Web Design - Colours, typography
  • Principles of a good User Interface (UI)
  • Principles of a good User Experience (UX)
  • Usability- Don’t make the user think
  • Naturalness
  • User Control
  • Predictability
  • Flexibility and efficiency
  • Consistency
  • Error prevention
  • Clarity
  • Visual hierarchy
  • Progressive disclosure
  • Accommodate all types of users
  • Fitts' law
  • Protect the user’s work
  • Design for interaction
  • Focus on one action
  • Grouping and breakup
  • Prioritise performance
  • Principles- DRY, KIS, less is more, Responsive Web Design (RWD).
  • Information architecture
  • User research and usability testing
  • Improving accessibility
  • Implementing these principles on our website.


6Starting an eCommerce website using HTML, CSS. and Bootstrap

The most common usage for a website is in E-commerce. In general, an eCommerce website is considered to be highly dynamic with a lot of elements. That is why the student is being introduced to this particular type of website. It will help them handle almost any type of website thereafter.


During this week we will teach you how to:


  • Interact with clients for creating their eCommerce website
  • Building the website front end from scratch with the help of wireframes
  • Code walkthrough


7Add behaviour to your website using JavaScript

This week we will be taking our website to the next level with interactivity and reaction to page events such as page load, button clicks, mouse movements, keyboard input etc. We’ll dynamically alter the contents and style of a webpage. A big advantage of having a website which is actively interacting with the user is more user engagement. This will give more leads and in turn more revenue.


The topics we will be covering in detail during this week are:


  • Variables, data types, operators in JavaScript 
  • Statements, syntax, comments, and events
  • Loops, control, and conditionals 
  • JS forms
  • Document Object Model (DOM)
  • Browser Object Model (BOM)
  • JS functions
  • Scope and closures 
  • Object-Oriented Programming (OOP) 
  • JS objects and prototypes- keyword
  • Cookies
  • Exception handling
  • Arrow functions
  • Promises
  • Template string, default parameters, spread and rest operators, destructuring, generators, set, map, weak set, weakmap 
  • HTML APIs
  • Separation of concerns, refactoring, debugging, and coding best practices


8 Learn to refactor JQuery in existing sites

In computer programming, refactoring is generally done to improve the design, structure, and/or implementation of the software. All these actions are done while preserving its functionality.

During this week we will learn about:

 

  • Installing and using the jQuery framework
  • jQuery syntax, selectors, events and functions
  • Manipulate text, styles and attributes with jQuery
  • Create animations and customizations with jQuery
  • Responding to user-initiated events with jQuery
  • Traversing - ancestors, descendants, siblings, filtering


9 Code your eCommerce website using JavaScript

We will learn how to code your eCommerce website with the help of JavaScript. The importance of JavaScript as a web technology can be determined from the fact that it is currently used by 94.5% of all websites. As a client-side programming language, JavaScript helps web developers to make web pages dynamic and interactive by implementing custom client-side scripts. The topics we will be discussing are 

  • Possibilities with JS 
  • Animating our website
  • Code walkthrough


10Serving and retrieving data using AJAX, JSON, and XML

We will be learning how to serve and retrieve data using 3 data types- AJAX, JSON and XML.


We will be covering:


  • Serving and retrieving data to a web site
  • Asynchronous loading - Set up and handle AJAX requests and responses. 
  • JSON
  • XML
  • Processing JSON data
  • JSON vs. XML

11 Your final eCommerce website

Now that we have covered the major parts of the course, we will now be moving on to the concluding week.


During this week, we will be 

  • Building final parts of the eCommerce site UI
  • Adding asynchronous calls to the website and Data transfer using JSON
  • Summary
  • What next?
  • Motivational tips


Projects Overview

Project 1

Highlights

Create the seller page as shown in the mockup
Create the return order page as shown in the mockup
Create the “my profile” page with the side navigation bar as shown in the mockup with an edit button.

Project 2

Highlights

The capstone project will help develop a professional-quality web portfolio. You will demonstrate the ability to design and implement a responsive site for a minimum of three platforms. 
Create an entire ecommerce site - “Swag of India” with given real world functionalities.

Coding Assignment:

Create the wishlist page with the side navigation bar just like you created the cart page using adding product id of wishlist item in local storage on click of the heart button on that product. Find that item from the JSON data and display the wishlist items shown.
On click of any product in my orders page, it should open the track order page as shown in the mockup. Display that product in this page, however it’s ok to have the same single dummy track for every product.
Create a checkout page with given mockup. Include required animations for the different divs of the form using jQuery similar to the FAQ page.
Create the “Edit profile” page, “My orders” page as shown in earlier module.
Connect all the pages you created for your site. Make sure to not have any broken links which should redirect to pages you have created.


2. Introduction to Java Programming-Syllabus

1 Basic constructs of Java Programming Language

This is the very first topic of the course. In this part, you will be looking into the basics of the Java Programming language from the basic setup, using the Integrated development environment (IDE) and diving into creating programs using Java. In specific, you will be -

  • Setting up the environment for Java
  • Understanding the Java Ecosystem
  • Understanding the Eclipse IDE
  • Able to run your first Java program
  • Running and debugging Java Application
  • Learning about Data types and Operators
    • Conditional statements
    • Iterative statements
    • Other control statements
    • Functions and methods
  • Working with Arrays in Java
  • Working with Strings in Java

2Object Oriented Programming

This will be the second main topic of the course. Here, we will be giving emphasis on different concepts which are paramount to be a good Java Developer. The concepts taught here are very important as they will be the foundation of modern programming using Java. Here, you will be learning-

  • Encapsulation and Abstraction
  • Classes and Objects
  • Constructors
  • The "this" pointer
  • The Static and final keyword
  • Access Modifiers
  • Inheritance (is-a relationship)
  • Composition (has-a relationship)
  • Abstract classes and Interfaces
  • Method overloading and Overriding
  • Polymorphism

3Advanced Topics in Java

This is the final topic of the course. Here, we will be looking into more advanced topics which are essential to build more complex programs. You will be using the knowledge from the contents of the course in your final project. You will be learning-

  • Packages
  • Exception Handling
  • Multithreading
  • File Handling, I/O and networking


Projects Overview

Project 1

Highlights

The capstone project will help develop a professional-quality portfolio. Students will demonstrate the ability to design and implement a software.

The students are required to develop a scientific calculator which runs on an infinite loop. All the inputs are required to be stored. The calculator is to be developed based on the concepts taught in the course. This project will test a student's understanding of the basic concepts of JAVA programming.


3. Data Structures and Algorithms using JAVA-Syllabus

1Introduction

A data structure is a named location that can be used to store and organize data. An algorithm is a collection of steps to solve a particular problem. Learning data structures and algorithms allow us to write efficient and optimized computer programs. Data structures provide a means to manage large amounts of data efficiently for uses such as large databases and internet indexing services. Usually, efficient data structures are key to designing efficient algorithms.
In the first week of this course, you will learn:
  • Stack memory vs heap memory in Java
  • Physical vs logical data structure
  • Abstract data type and data structure
  • Complexity analysis
    • Asymptotic analysis, comparison of functions, recurrence relations
    • Time complexity
    • Space complexity
    • Master theorem
    • Amortized analysis
    • Iteration vs recursion
  • Recursion - Factorial, Fibonacci, finding nCr, tower of Hanoi problem.

2Arrays, Strings, and Lists

Arrays are used to store multiple values in a single variable, instead of declaring separate variables for each value. A string is a sequence of characters like - "hello". In this string the sequence of characters is 'h', 'e', 'l', 'l', and 'o'. Unlike other programming languages, strings in Java are not primitive types like int and char. Instead, all strings are objects of a predefined class named string. A LinkedList is a part of the collection framework present in Java utility package. This class is an implementation of the LinkedList data structure which is a linear data structure where the elements are not stored in contiguous locations and every element is a separate object with a data part and an address part.

 
In this session, we will learn about:
  • Arrays
    • Static arrays
    • Dynamic arrays
    • 2D arrays, row-major and column-major mapping, matrices
  • Strings
  • LinkedList
    • Singly LinkedList and its operations
    • Doubly LinkedList and its operations
    • Circular LinkedList and its operation

 

3Stacks and Queues

The stack is a linear data structure that is used to store the collection of objects. It is based on Last-In-First-Out (LIFO). Java collection framework provides many interfaces and classes to store the collection of objects. One of them is the stack class that provides different operations such as push, pop, search, etc. The queue is used to represent an ordered list of elements. It follows the FIFO or First In First Out procedure to insert and remove elements. The queue also supports methods of collection interface.

In this session, we will be discussing-
  • Stacks
    • Implementations- using arrays, using linked lists
    • Operation
    • Applications
  • Queues
    • Implementations- using arrays, using a LinkedList, using two stack
    • Circular queues
    • Priority queues


4Trees

 A tree is a non-linear data structure where data objects are organized in terms of hierarchical relationships. Java provides two in-built classes, TreeSet and TreeMap, in Java Collection Framework that cater to the needs of the programmer to describe data elements in the aforesaid form. There are many different types of tree structures available and we’ll be discussing them one by one

  • Trees.
    • Binary trees, their representations.
    • Pre-order, In-order, post-order traversals
    • Binary search trees
    • AVL trees

     

 

5 Heaps and Tries

Heap and Trie are a special case of trees. A Heap is a special tree-based data structure in which the tree is a complete binary tree. Trie is an efficient information retrieval data structure. Using Trie, search complexities can be brought to the optimal limit. In the session, we will try to solve the longest word in the dictionary problem using Tries.

 
Heaps
  • Min Heap
  • Max Heap
  • Find K largest (or smallest) elements in the array.

Tries

  • Longest Word in Dictionary Problem
 

 

 

6Graphs & Algorithms

A graph is a data structure that consists of-
1. A finite set of vertices also called as nodes and
2. A finite set of ordered pairs of the form (u, v) called as edges.
Algorithms in Java are static methods that can be used to perform various operations on collections. Since algorithms can be used on various collections, these are also known as generic algorithms. We will be discussing different types of algorithms like-
  • Graphs
    • Types of graphs
    • Breadth-first search, depth-first search
    • Topological sort
    • Shortest path problem
  • Algorithms
    • Dijkstra's algorithm
    • Bellman–Ford algorithm
      • Minimum spanning tree problem
    • Prim's algorithm
    • Kruskal's algorithm

 

7Sorting

Sorting generally means to put data in a certain order. The order can either be alphabetically sorted or numerically sorted. There are many types of sorting techniques available in Java. We will be discussing each of them in this session.
  • Sorting- 
    • Types of sorting techniques
    • Bubble sort
    • Insertion sort
    • Selection sort
    • Quick sort
    • Merge sort
    • Heap sort
    • Count sort
    • Bucket sort
    • Radix sort
    • Shell sort


8Searching and Hashing

Searching is probably one of the most common actions performed in a regular business application. This involves fetching data stored in data structures like arrays, list, and maps. More often than not, this search operation determines the responsiveness of the application for the end-user. Hashing is the process of converting a given key into another value. A hash function is used to generate the new value according to a mathematical algorithm. The result of a hash function is known as a hash value or simply, a hash.
 
Hashing is primarily used for authentication. Chaining is the practice of calling different methods in a single line instead of calling different methods with the same object reference separately. Under this procedure, we have to write the object reference once and then call the methods by separating them with a (dot.). Similar to chaining, open addressing is a method for handling collisions. In open addressing, all elements are stored in the hash table itself. So at any point, the size of the table must be greater than or equal to the total number of keys.
 
During this week we will be discussing about the following:
  • Searching
    • Linear search
    • Binary search
  • Hashing
    • Hash function
    • Collision handling
  • Chaining
  • Open addressing
    • Linear probing, primary clustering
    • Quadratic probing, secondary clustering
  • Double hashing

9 Greedy Algorithms

A greedy algorithm is a simple, intuitive algorithm that is used in optimization problems. The algorithm makes the optimal choice at each step as it attempts to find the overall optimal way to solve the entire problem. Greedy algorithms are quite successful in some problems, such as Huffman encoding which is used to compress data, or Dijkstra's algorithm, which is used to find the shortest path through a graph. Such algorithms are called greedy because while the optimal solution to each smaller instance will provide an immediate output, the algorithm doesn't consider the larger problem as a whole.
 
The topics discussed in this session will be-
  • The strategy of greedy algorithms
  • Elements of greedy algorithms
  • Advantages of greedy algorithms
  • Disadvantages of greedy algorithms
  • Applications of greedy algorithms
  • Knapsack problem
  • Job sequencing with deadlines
  • Huffman coding

10Divide and Conquer

The divide and conquer approach is pretty straightforward, the problem in hand is divided into smaller subproblems and then each problem is solved independently. As we keep dividing the subproblems into even smaller problems, we eventually reach a stage where no more division is possible. These "atomic" smallest possible problems are then solved. The solution of all "atomic" problem sets are finally merged in order to obtain the solution of an original problem.

 

In the session this week we will discuss:

  • The strategy of divide and conquer techniques
  • Advantages of divide and conquer techniques
  • Disadvantages of divide and conquer techniques
  • The master theorem of divide and conquer techniques
  • Applications of divide and conquer techniques
  • Find the median of two sorted arrays

 

11Backtracking

Backtracking is an algorithmic-technique for solving problems recursively by trying to build a solution incrementally, one piece at a time, removing those solutions that fail to satisfy the constraints of the problem at any point of time. We’ll discuss about two methods used to backtrack.
  • Backtracking- 
    • Brute force approach
    • N queens problem
  • After backtracking ,we will be studying how Java 8 collections framework is implemented. We will be covering the following,
    • Set
    • List
    • Queue
    • PriorityQueue
    • Map
    • HashSet
    • TreeSet
    • ArrayList
    • LinkedList
    • Vector
    • Dictionary
    • Stack

 

12Dynamic Programming

Dynamic Programming is also an algorithmic technique for solving the optimization of problems. It is done by breaking the problem down into simpler subproblems and utilizing the fact that the optimal solution to the overall problem depends upon the optimal solution to its subproblems.

During this session, we will be covering the following:

  • Dynamic programming- 
    • The strategy of dynamic programming
    • Properties of dynamic programming
    • Approaches of dynamic programming
    • 0/1 knapsack
    • Travelling salesman problem
    • Floyd Warshall
  • In the end, we will conclude and summarize the course by having a brief discussion on Greedy vs Divide & Conquer vs Dynamic Programming.

 


Projects Overview


4. Everything about Databases-Syllabus

1Introduction to Databases

A Database is a collection of interrelated data which helps in efficient retrieval, insertion and deletion of data from a database. We can also organize the data in the form of tables, views, schemas, reports etc. In this week we will having a small introduction to the topic, we will be looking at

  • Types of databases
  • Databases vs File system
  • Architecture
  • Schema
  • Models
  • Data Independence
  • DBMS languages
  • Set theory
  • Database in a web application architecture
  • ACID properties
  • Create a relational database application of your ecommerce application
    • Requirement analysis
    • Specification
    • Design
    • Implementation

 

2Entities and Relationships

An Entity–relationship model describes the structure of a database with the help of a diagram, which is known as Entity Relationship Diagram (ER Diagram). An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. An Entity may be an object with a physical existence – a person, car, house, or employee. Or, it may be an object with a conceptual existence like– a company or job. These entities can have attributes that define its properties. By defining the entities, their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases. ER diagrams are used to sketch out the design of a database. In this week we will be looking at-

  • Entities, Relationships and Attributes
  • ER Model and Relational Model
    • Advantages and Disadvantages
  • Attributes of relationships
    • Simple vs Composite Attributes
    • Single valued vs Multi-valued Attributes
    • Stored vs Derived Attributes
    • Complex Attributes
  • Degree of a relationship and Cardinality Ratio
  • Total vs Partial Participation
  • Intention vs Extension
  • Recursive Relationship
  • How Relational Model is derived from Discrete Math

3Creating Database Tables

Once we have data, it is vital that it gets categorised into a database table. This allows for easy retrieval, editing, insertion and deletion of new or old data. This week, we will be looking at how to create a database table. In specific we will be looking at

  • Converting ER diagram to Tables in RDBMS
  • Super Key vs Key vs Candidate Key vs Primary Key
  • Integrity rules
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Constraints violated by Insertion, Deletion, Updation and Selection
  • Steps taken by DBMS in case of constraint violation
  • Authorization in relational databases
  • Generalisation and Specialisation
  • Aggregation

4Database Design

Database design is the procedure of organizing data according to a database model. The designer will determine what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.

  • Functional dependencies
  • Relational Decomposition
  • Multivalued Dependency
  • Join Dependency
  • Inclusion Dependence
  • Normal forms-
    • 1st Normal Form
    • 2nd Normal Form
    • 3rd Normal Form
    • Boyce Codd Normal Form
  • Codd’s rules
  • Data-modeling with Unified Modeling Language (UML)

5SQL

Structured Query Language or SQL is a standard Database language used to create, maintain and retrieve the data from relational databases like MySQL, Oracle, SQL Server, PostGre. As the name suggests, it is used when we have structured data. All databases that are not relational and therefore do not use SQL, are called NoSQL databases. we’ll be looking into NoSQL later in the course. In this week, we will be looking into-

  • Declarative programming
  • Studying SQL using MySQL and PhpMyAdmin.
  • Characteristics of SQL
  • Advantages of SQL
  • SQl Data Types
  • SQL Commands
  • SQL Operators
  • SQL Table queriesSQL SELECT Statement
  • SQL INSERT Statement
  • SQL UPDATE Statement
  • SQL DELETE Statement
  • SQL Clauses
  • SQL Aggregate Functions
  • SQL Set Operations
  • Dealing with NULL values

6 SQL

This week is a continuation of the previous one. Here, we continue to look into more topics related to the Structured Query Language.

  • SQL JOINs
    • Cartesian product
    • Natural Joins
    • Inner joins
    • Outer Joins
  • SQL Views
  • SQL Sub Queries
  • SQL Compound Queries
  • Query Processing
    • Materialization, Pipelining
    • Estimating Query Cost
    • Query optimizations

7Designing your ecommerce Database

  • Design your ecommerce database till BCNF
  • Identify keys
  • Document your design using UML Diagrams
  • Generate Complex queries for the functionalities of your ecommerce website

8Scaling the Database

  • Storage system
    • File structure
    • B Trees and B+ trees
    • Ordered vs Unordered File Organization
  • Database Hashing
  • Database indexing
  • Database Keys and Indexes
    • SQL Index
  • Database Partitioning
  • Database Sharding
  • Map Reduce
  • RAID
  • Data warehouse processing

9PL/SQL

  • When to use Procedural Language?
  • Functions
  • Stored Procedures
  • Triggers
    • Notify customers as soon as the product is back in stock
  • Common table expressions
  • Recursion
  • Cursors

10NOSQL Databases

  • Introduction to NoSQL
  • Advantages and Disadvantages
  • MongoDB
    • Comparison with SQL
    • Relational vs document oriented
    • Your first MongoDB database
    • Querying in MongoDB- CRUD
    • Creating and Retrieving products for ecommerce website
    • Sorting and Paginating in ecommerce website
    • Embedding vs Referencing in documents
    • Data modeling in NoSQL
    • Aggregation Pipelines
    • Map Reduce
    • Scalability and Indexing in key value database
  • Graph databases

11Transactions for concurrency control and failure recovery

  • Transactions
  • Concurrency Control
    • Need for Concurrent Execution of Transactions
    • Inconsistency Problem due to Concurrent Execution
    • Lost Update Problem
    • Dirty Read Problem
    • Unrepeatable Read Problem
    • Phantom Read Problem
  • Handling Deadlocks
  • Data Backup
  • Data Recovery
  • Data Replication
  • Security

12In Memory Database

  • Why use "In Memory" Database
  • Redis vs MongoDB
  • The Pub-Sub model
  • Install and use Redis
  • Redis commands
  • Backup
  • Pipelining
  • Partitioning
  • Security


Projects Overview

Project 1

Highlights

1. For the given functionality, submit the PL/SQL code
2. Using MongoDB, design your entire ecommerce Database. Mention why you used embedded vs referenced documents. Generate Complex aggregate queries for the given functionalities of your ecommerce website
3. Submit a 2-page report on why and how you would use Redis for fast caching in your large-scale ecommerce website.
4. Submit a report on how you would optimise given queries.

Suggestions used-
1. Logical ending for each session- PPT script
2. DBMS divide into two – first 9 modules basic and last 3 modules advanced
3. Examples and assignments to be evolved from scratch to final project
4. Mongodb and redis only as per consumer perspective.


5. Business Analyst Fundamentals for Beginners-Syllabus

1Business Analyst

  • Introduction & Importance of Business Analysis
  • What Business Analysts do? 
  • Why are BAs important?  
  • Foundation of Business Analyst
  • Key Skills for Business Analyst

2Project Management

  • Project Management
  • What does it mean? 
  • Project management methodologies including traditional Waterfall and Agile frameworks
  • Learn how to gather requirements from stakeholders and documentary sources
  • Project Documents- (BRD, FSD, Project Plan) etc.
  • Project Plan - Various Tools 
  • Project Plan with JIRA

3Flow Charts

  • Flow charts concepts
  • Draw.io – Tool for Flowcharts
  • Self-explanatory flow charts

4Cloud Computing

  • Evolution & Benefits 
  • Service Model – IaaS, PaaS, SaaS 
  • Deployment Model – Public, Private, Hybrid Cloud
  • Virtualization Concept 
  • Data Centers : Then & Now

5Design & Architecture

  • Shared Security Model & Security Aspects 
  • Cloud Deployments – Single Tenant v Multitenant Model 
  • Monolithic – SOA- Microservices  Architecture 
  • Cloud Computing Resources & its types
  • Compute & Choices 
  • Network Nausea  
  • Storage Stunts 
  • Database Dumbbells 

6Cloud Applications & Integrations

  • Cloud Applications – Solution specific
  • Integrations – Together we work better
  • API – Core for Integrations 
  • REST & SOAP 
  • POSTMAN
  • Basic Introduction of API's integration with Node.js

7NLP, Data Analysis & Bots

  • NLP - Introduction 
  • Intents, Entities, Properties
  • Data Analysis Concepts (FP, FN, TP,TN)
  • Top 10 integrations and its use cases. (Zendesk, Salesforce, Salesforce live chat, Freshchat, Freshdesk, Shopify, Magnato ) 


Projects Overview

Project 1

Highlights

Problem Statement:

Frisco Systems, a worldwide leader in technology that powers the Internet, had made a series of strategic semiconductor acquisitions that were running on disparate ERP platforms. Frisco Systems forecasted this semiconductor business to become one of their fastest-growing divisions with expectations to grow beyond a billion dollars by the end of 2022. It was essential to consolidate these acquisitions on to one platform to enable the forecasted growth and scale. 

Merging the acquisition needs business also to be merged and work as a single entity. A Big team with complete Hierarchy is involved in this project. Your role is a Business Analyst. 

Now there are multiple tasks for which various people will be accountable or responsible. You are required to plan the tasks with an RACI Matrix

Project 2

Highlights

Problem Statement:

Skill-game is a Mobile gaming company and they want to launch a new game similar to Scrabble. Now, as a Business analyst, you need to demonstrate the process of starting with a Product Concept and working up the chain to determine business problems and a business objective. You need to ask Questions with business executives and come-up with the Product Concept. 

Project 3

Highlights

Problem Statement:

Migration projects are quite common nowadays and will be in the future too. This is considered to be the biggest change which any IT company needs to achieve without losing the current functionality. 

Many IT projects are focused on migrating existing functionality to a Cloud system. The goal of the project may be to move to a new platform, build a new system from the ground up with the exact same functionality, or to move a piece of functionality from one system to another. Justifications for such projects include moving off an unsupported technology, gaining performance improvements or integrating with other enterprise systems.

Consider any project which has an Application Server, Database, User Interface etc.

The requirements gathering effort for migration projects is notably different than for a new system being built from scratch or for adding new functionality to an existing system. At a high level, the distinctions are in scope definition, understanding original business needs, working with end users, discovering the end-to-end functionality and IT involvement.

Scope discussions should take into account whether to include the following: 

  • Migration of all functionality
  • Phasing pieces of functionality over a rollout timeframe 
  • Adding or changing functionality 
  • Updating user interfaces

What all information gathering you will be doing as a business analyst. What do you need to know technically for these kinds of projects?  List out what all questions come to your mind while working as a Business Analyst. 

 


6. NodeJS API Development for Beginners-Syllabus

1Introduction and Installation of Node.js

  • What is Node.js?
  • Environment Setup – Windows & macOs
  • Creating First App
  • REPL
  • Runtime Environment

2Core Concepts – Node.js

  • What is Web and how it works
  • Node server
  • Node.js – Lifecycle and Even Loop
  • Requests & Response
  • Routing
  • I/O Model
  • Module
  • Require
  • Method exporting using module.export

3Development workflow, Debugging and Error Handling

  • IDE – in detail
  • NPM
  • Installing third party packages
  • Nodemon
  • Error handling
  • Debugger

4Express.js

  • Installation
  • Configuration
  • Adding Middleware
  • How middleware works
  • Handling Routes

5REST APIs

  • What is, Why REST APIs?
  • Accessing Data
  • HTTP Methods
  • Core Principles
  • Create REST API
  • Postman
  • Route setup
  • Requests & Responses
  • API planning
  • CORS Errors

6Understanding DataBase

  • MongoDB 
  • MongoDB Installing and Connecting
  • Schemas, models and documents
  • MySQL
  • NoSQL vs MySQL

7API Security – Part 1

  • User Model
  • User Registration
  • Lodash
  • Hashing
  • Authentication
  • JSON Web Tokens

8API Security – Part 2

  • Authorization
  • Route Protection
  • Current user identification
  • Log out user
  • Role Based – Authorization
  • Testing Authorization

9Asynchronous JavaScript – Part 1

  • Synchronous vs Asynchronous
  • Callback
  • Callback hell
  • Promises

10Asynchronous JavaScript – Part 2

  • Replace Callback with Promises
  • Promises consuming
  • Parallel Promises

11Asynchronous JavaScript – Part 3

  • Async and Await
  • Recap – Asynchronous JavaScript

12CRUD operations using MongoDB

  • Create
  • Read
  • Update
  • Delete
  • Mongoose

13Handling and Logging errors

  • Error middleware
  • Rejected promises
  • Uncaught exception
  • Unhandled Promise Rejections
  • Logging

14NPM & Build Tool

  • What is Build Tool
  • NPM usage
  • Versioning in package.json
  • Build processes in Node.js

15Version control System - GIT

  • Introduction
  • Setup and configuration
  • Locally working with GIT
  • Remote
  • Conclusion

16Elastic Search

  • Introduction
  • Elastic Stack Overview
  • Understanding Elastic Stack
  • Architecture Overview

17Cloud Functions

  • Introduction
  • Events and Triggers
  • FAAS 
  • Benefits of FAAS  (Cloud Platform: Firebase )


Projects Overview

Project 1

Highlights

Api creation – User Registration, Login and Logout Access Control,

User Authentication with JWT (JSON Web Tokens).

Project 2

Highlights

The capstone project will help develop a professional-quality portfolio. Students will demonstrate the ability to design and implement backend services using Node.js, Express.js, GIT and MongoDB.


7. MongoDB Database Administration:The complete guide-Syllabus

1Introduction to MongoDB

In this Module, you will learn about MongoDB basics,documents, collections,MongoDB shell etc.

You will also learn about some of the fundamentals required to start with MongoDB Administration.

  • Introduction to Course Structure
  • Prerequisite software installation & setups
  • NoSQL Introduction
  • Basics of MongoDB
  • MongoDB Installation 
  • Documents & Collections

2MongoDB CRUD and Querying

In this Module, you will learn about CRUD operations in MongoDB and querying techniques for MongoDB

  • Introduction to MongoDB Shell
  • Customizing your prompt
  • Running scripts in Shell
  • Inserting Documents
  • Removing Documents
  • Updating Documents
  • Introduction to find
  • Cursors
  • Query conditions and criteria
  • Limits , skips & sorts

3MongoDB Indexes ,special collections & GridFS

In this module,you will learn about MongoDB indexes its various types.It will also cover some special types of collections and GridFS utility in MongoDB

  • MongoDB Indexes
  • Types of Indexes
  • Index Administration
  • Capped Collections
  • GridFS

4Introduction to Aggregation framework and Transactions

 In this module, you will learn about aggregation framework in MongoDB and also get an introduction to transactions.

  • Pipeline and stages in Aggregation
  • Expressions & $project
  • Introduction to grouping
  • ACID properties and introduction to Transactions
  • Schema design for MongoDB
  • Data optimization

5MongoDB Replication Setup & Components

In this module, you will learn about MongoDB replication, how to setup replication and components of replica set.

  • Introduction to replication
  • Setting up a replica set
  • Modifying replica set
  • Priority,hidden members,election arbiters etc
  • Replication Syncing & heartbeats
  • Rollbacks

6Mongo DB Replication Internals and Administration

 In this module, you will learn how to connect to a replicated environment and monitor your replication cluster and basic administration of replica set.

  • Client – replica set scenario
  • Write concerns & read concerns
  • Sending reads to secondaries
  • Modifying member state
  • Monitoring Replication
  • Oplog resisizing
  • Replication Lag monitoring

7Mongo DB Sharding Introduction and Configuration

 In this module, you will learn about MongoDB sharding basics and learn how to configure a sharded environment.

  • What is Sharding
  • When to Shard
  • Config, mongos and shard nodes
  • The Balancer
  • Change Streams

8Mongo DB Sharding Administration

In this module, you will learn how to effectively choose a shard key for your sharded cluster and sharding administration concepts.

  • Shard key strategies
  • Controlling data distribution in shards
  • Sharding commands
  • Modifying sharded clusters
  • Moving chunks
  • Jumbo chunks

9Mongo DB Security

In this module, you will learn about the various security mechanisms in MongoDB

  • Authentication Vs Authorization
  • Authentication Mechanisms
  • Localhost Exception
  • Scram Sha -1 security
  • X509 
  • LDAP Security
  • Kerberos Security
  • Inter Cluster security using keyfile
  • RBAC methods for Authorization

10MongoDB Durability and Backups

In this module, you will learn about durability mechanism supported by MongoDB and the backup models supported along with application administration

  • Current Operations
  • Mongotop & mongostat
  • Journaling in MongoDB
  • Backup Methods
  • Mongodump & mongoexports
  • Backup & restore clusters

11Mongo DB Production Ready

 In this module, you will learn how to manage a production environment of MongoDB and things to consider for the same.

  • File based configurations for production clusters
  • Data encryption
  • Logging
  • Monitoring memory , space and performance
  • Designing production systems

12MongoDB Atlas & Tools

 In this module, you will learn how to create a cluster in MongoDB Atlas platform and how to use MongoDB compass and MongoDB Ops Manager

  • Creating account in MongoDB Atlas and creating cluster
  • Installing ops manager
  • Ops Manager Features
  • MongoDB Compass Usage


Projects Overview

Project 1

Highlights

  • Create a MongoDB 5 node replica set running on different ports
  • Configure 3 data nodes, 1 arbiter and 1 hidden node with slave delay
  • Insert 100 documents into a collection in primary
  • Query the secondary node to only fetch 10 documents as per the filter condition provided in the project
  • Change the arbiter node to secondary node
  • You must use the following:
    • MongoDB Community edition
    • Oracle VM Virtual Box
    • Linux VM

Project 2

Highlights

  • As a MongoDB Administrator you have to build a sharded cluster in your local VM with all production ready checkboxes checked
  • Enable scarm sha 1 security for the cluster and create roles , privileges and users for the cluster
  • Enable inter cluster authentication for all the nodes of the cluster using keyfile
  • Enable backup job for the cluster using cronjob
  • Setup MongoDB ops manager and monitor the cluster using ops manager
  • You must use the following:
    • MongoDB community edition
    • Oracle VM Virtual Box
    • Linux VM
    • MongoDB Ops Manager

8. Introduction to Yellow Messenger-Syllabus

1The Platform & its Key Features

  • Basic Concepts 
    • Intents, Journeys, Entities, Utterances
    • Testing the Model
  • Journey builder  
    • Prompts, Messages, Actions, Logic • Training the bot

2Bot Flow

  • Define the flow of the bot 
    • On successful interpretation of the User input ○
    • On Failure of interpretation of user input 
  • On Success 
    • Based on User Input
      • Journeys are triggered.
      • FAQ are Triggered 
  • On Failure 
    • Suggestion Step is Triggered
    • If unable to suggest
      • Fallback step is triggered 
    • Document Search Step Triggered 
      • Provided relevant Document uploaded

3Prompts, Validation, and Response

  • Prompts are used to accept user input 

    • It could be in the form of Text, Quick Replies, Carousel and Question 

    • Values entered by the user can be stored in a pre-defined variable

  • Predefined Prompts for: 
    • Name, Email, Phone and Location
    • Built in Validation 

4Entities

  • Entities are a mechanism for identifying and extracting useful data from utterances.
  • NER (Named Entity Recognition) is the task of NLP that studies how to extract entities from texts.
    • Ex : “Show white convertible cars”
      • Entity : White(entityType : color)
      • convertible (entityType : carType).
  • Classification Entities
    • List
    • Regex

5Access Control and Chat Widget

  • Access Control
    • Access Control is the security dashboard of the platform for managing permissions for Users and Groups.
  • Granting Access Control
    • Access Controls:
      • Admin
      • Developer
      • Database Viewer
      • Approver
      • Inbox(Admin)
      • Inbox(agent)
      • Insight
      • Engagement(admin)
      • Engagement(user)
      • Tester
  • Bot Direct Link
    • Test your Bot using the Bot Direct Link
  • Chat Widget
    • Chat widget helps in configuring Appearances and Settings of a bot


WHO IS THIS COURSE FOR ?


  • Students in their 4th year aspiring for a business analyst role
  • Employed individuals looking for a career as a business analyst

Technologies covered

Node.JS, Javascript, MongoDB

These frameworks/technologies are crucial for creating applications that will help you in your journey as a business analyst.

Java

The fundamentals of JAVA programming are covered in detail in this program

SQL

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system


Certification

  • Top 5% of the class will get a merit certificate
  • Course completion certificates will be provided to all students
  • Build a professional portfolio
  • Automatically link your technical projects
  • E-verified profile that can be shared on LinkedIn

Flexible Course Fees

Choose the plan that’s right for you

Basic

9 Months Access

$199.05

Per month for 10 months

  • Access Duration : 9 Months
  • Mode of Delivery : Online
  • Project Portfolio : Available
  • Certification : Available
  • Individual Video Support : 8/Month
  • Group Video Support : 8/Month
  • Email Support : Available
  • Forum Support : Available
  • Telephone Support : Available
Premium

Lifetime Access

$331.75

Per month for 10 months

  • Master's Assistance : Lifetime
  • Access Duration : Lifetime
  • Mode of Delivery : Online
  • Project Portfolio : Available
  • Certification : Available
  • Individual Video Support : 24x7
  • Group Video Support : 24x7
  • Email Support : Available
  • Forum Support : Available
  • Telephone Support : Available
  • Dedicated Support Engineer : Available

The Skill-Lync Advantage

See all

Testimonials

Companies hire from us

See all

SKILL LYNC WORKS TO GET YOU A JOB

See all