test

 

 

 

 

 

 

 

 

Data Analytics course Key Benefits

 

Program Highlights

ExcelR DevOPs training

Top-Notch Faculty

Trainers at ExcelR are passionate about training, and carry 12+ years of industry experience.

ExcelR DevOPs training

Exhaustive Course Curriculum

Our industry-relevant course curriculum is tailored to provide practical exposure with the theory.

ExcelR Data Analyst training

Real-life Projects

Learners will work on real-life Projects from various domains to get application knowledge.

 

ExcelR DevOPs training

Job Readiness

Intensive interview preparation from Day 1 to prepare candidates for interviews with our network of 2000+ hiring partners

 

Skills Covered

Data Analysis concepts

Database concepts

 

Functions Charts & Slicers

Data Visualization

 

 

Tools Covered

Excel

Tableau

Power BI

MySQL

Python

Jupyter Notebook

RStudio

Pandas

NumPy

Matplotlib

Seaborn

Scikit Learn

Hadoop

Spark

Pytorch

Keras

TensorFlow

NLTK

OpenCV

Gbard

BERT

Hugging face

ChatGPT

Lang chain

DALL-E 2

 

Projects

  • This Project involves collecting, processing, and visualizing online sales data to derive insights about customer behaviour, sales trends, product performance, and market dynamics, enhancing strategic decision-making. (Beginner)
  • This project involves gathering, analysing, and visualizing financial data to uncover insights into customer behaviours, transaction patterns, credit risk, and operational efficiency. This will aid in improving customer service, risk management, and strategic financial planning. (Beginner)
  • Your project centres on predicting future gold prices using advanced forecasting techniques. It entails collecting historical gold price data and applying statistical models and machine learning algorithms to identify trends and factors influencing price fluctuations. The goal is to develop accurate predictions that assist investors and financial analysts in making informed decisions. (Intermediate)
  • This project is focused on developing a book recommendation system. It involves utilizing user data, book metadata, and reading patterns to create a personalized algorithm. This system will analyse readers' preferences and past interactions to suggest books that match their interests, enhancing user engagement and reading experience. (Intermediate)
  • It involves analysing financial data from businesses using machine learning techniques to identify early warning signs of financial distress. By predicting potential bankruptcy risks, the model helps companies implement timely interventions, improving financial stability and decision-making processes. (Advanced)
  • A beginner level GAN (Generative Adversarial Network) project, for the fashion industry, involves creating a model that can generate new, realistic clothing designs. In this project, the GAN consists of two parts: a Generator, which produces images of clothing items, and a Discriminator, which evaluates whether these images are real or generated. The training process involves feeding the network with a dataset of various clothing images, allowing the Generator to learn and create novel designs while the Discriminator improves its ability to distinguish between real and synthetic images. (Advanced)

 

Case Studies

  • How a retail company boosted sales using Excel, Power BI, Tableau, and MySQL. Learn how they analysed customer data, tracked inventory, and visualized trends to make data-driven decisions. Discover the impact of these tools on revenue, inventory management, and customer satisfaction, all through this real-world case study.
  • Dive into the world of healthcare analytics as we examine a hospital's journey to improve patient care. See how Excel, Power BI, Tableau, and MySQL were used to analyse patient data, track medical outcomes, and enhance resource allocation. Witness the positive transformations in patient care and operational efficiency in this illuminating case study.
  • Discover how a retail giant leveraged data science techniques, including regression analysis, to accurately forecast sales and optimize inventory management. Explore the implementation of predictive models using historical sales data and its transformative impact on demand forecasting, reducing waste, and increasing profitability in this compelling case study.

 

Learning Path

DA Learning Path - ExcelR

 

Why ExcelR

ExcelR DevOPs training

Industry-Based Course Curriculum

ExcelR DevOPs training

Hands-on with 100+ Assignments

ExcelR DevOPs training

Job Readiness Program with our 2000+ partner companies

 

ExcelR DevOPs training

Support through WhatsApp, Calls, & Emails

ExcelR DevOPs training

Lifetime eLearning Access

 

Course Description

https://excelrcom.b-cdn.net/assets/admin/ckfinder/userfiles/images/2023_UPLOADS/PowerBi/Skill_4.png

Course Curriculum

  • What is Fullstack
  • What are the Requirements to build End to End Web Application?
  • What are the Challenges in modern web development?

HTML - Front End

  • Overview of Web And web application
  • Overview of Mobile and mobile applications
  • Web VS Mobile
  • Web Designer vs HTML Developer
  • Elements and Attributes
  • Tags
  • Introduction
  • Types
  • Single Tags / Empty Tags / Void Tag / Self Enclosing Tag
  • Paired Tags
  • Semantic Tags
  • Non Semantic Tags
  • Elements
  • Introduction
  • Types
  • Inline elements
  • Block Level
  • Inline-Block
  • Attributes
  • Introduction
  • Types
  • Predefined Attributes
  • Global Attributes
  • Style
  • Id
  • Class
  • Element Specific Attributes
  • src
  • alt
  • type
  • Custom / User Defined Attributes
  • Text tags
    • Headings
    • to

       
    • Paragraph
    • Lists
    • Ordered List
    • Unordered List
    • Definition ListTables
    • article
    • aside
  • Graphic Tags
    • Image Tag
    • Figure tag
  • Links
    • Anchor
    • Internal linking(Within Project)
    • External Linking(from our project to external pages)
    • (#)Hash Based navigation(With-in page)
  • Multimedia Tags
    • Audio
    • Video
  • Layout
    • Div
    • Section
    • Header
    • Main
    • Nav
    • Footer
  • What is forms and why should we create a forms?
  • Form tags and form attributes
    • Form
    • Form attributes
    • Method
    • Action
    • enc-type
    • Autocomplete
    • Novalidate
  • Form Elements & form element attributes
  • Types
    • Input types
    • text
    • password
    • file
    • hidden
    • radio
    • checkbox
    • submit (Action Items)
    • reset (Action Items)
    • Textarea
    • Dropdown Box
    • select
    • option
    • Attributes of form elements
    • type
    • name
    • placeholder
    • value
  • HTML5 Features with Examples
  • New structural elements
    ,
    ,
    ,
  • New from control calendar, date,time,email,url,search
  • Javascript enhancement
  • New HTML5 APIs
  • HTML Geolocation, HTML Drag And Drop, Web storage
  • New function for embedding audio(
  • Client-side data storage
  • Interactive documents
  • HTML5 validations Attributes

CSS- Front End

  • What is CSS
  • Why Use CSS?
  • How is CSS Used?
  • Creating and Linking a CSS StyleSheet
  • How To Test A Stylesheet
  • Selectors:
    • What is a selector?
    • The Universal /Global Selector
    • The Tag /Element Selector
    • The ID Selector
    • The Class Selector
    • The Attribute Selector
    • The Relationship Selector
    • Pseudo Selector
    • Group Selector
    • Specificity & When To Use Selectors
    • What are Properties?
    • The CSS General Rule
  • Types of Colors
  • Coloring Text
  • Background colors
  • Images/URLs in CSS
  • Other background Properties
  • Opacity / Transparency
  • Gradients
  • Fonts & Text Manipulation:
  • Introduction to types of units
  • Text Manipulation
  • Font Size,Bolding & Style
  • Font Families
  • Including external fonts W/Google Fonts
  • Using External Fonts
  • Introduction
  • The Box Model
  • Padding
  • Border
  • Margin
  • Changing Content Size
  • CSS Borders
  • Margin & Padding
  • Float & Display Types
  • Introduction
  • Flexbox Components
  • Creating a Flex Container
  • Flex Direction & Wrap
  • Content Alignment
  • Flex Item Order
  • Shrink, Grow & Basis
  • The 'Flex' Property
  • Item Alignment
  • Grid vs Flexbox
  • Introduction
  • Differences
  • Creating a Grid
  • Template Columns & Rows
  • Justify & Align Grid
  • Row & Column Gaps
  • Column & Row Lines
  • Grid Area
  • The Transitions Property
  • Transform property
  • Creating Animations w/Keyframes
  • Adding an Animation
  • Animation Properties
  • Media Queries in css
    • Introductions
    • properties

Project 1 - Individual project on HTML & CSS

Bootstrap - Front End

  • What is Bootstrap
  • History of Bootstrap
  • Versions of Bootstrap
  • Popularity of Bootstrap
  • Bootstrap Documentation
  • Installing Bootstrap Locally
  • Install or adding Bootstrap via Cdn link
  • Adding Javascript cdn link
  • BreakPoints
    • Extra small
    • Small
    • Medium
    • Large
    • Extra large
    • Extra extra large
  • Containers
    • container- fluid
    • container
  • Columns
    • column
    • row
  • Gutter
    • Horizontal gutter
    • Vertical gutter
    • Row column gutter
    • No gutter
  • Margins
  • Padding
  • Components in Bootstrap
  • Background
  • Colors
  • Display
    • none
    • inline
    • inline-block
    • block
    • grid
    • flex
    • inline-flex
  • Float
    • float-start
    • float-end
  • Position
    • position-static
    • position-relative
    • position-absolute
    • position-fixed
    • position-sticky
  • Direction
    • flex-column
    • flex-column-reverse
    • flex-row
    • flex-row-reverse
  • justify-content
    • justify-content-start
    • justify-content-end
    • justify-content-center
    • justify-content-between
    • justify-content-around
    • justify-content-evenly
  • align-items
    • align-items-start
    • align-items-end
    • align-items-center
    • align-items-baseline
    • align-items-stretch
  • flex-fill
  • flex grow & shrink
  • Grid options
  • Extra small (xs)
  • Small (sm)
  • Medium (md)
  • Large (lg)
  • Extra large (xl)
  • Extra extra large (xxl)
  • Containers and rows
  • Columns
  • Responsive Breakpoints

Presentation Session-1 / Practical Case Study Analysis by students

Project 2 - Individual Project on HTML, CSS & Bootstrap

Javascript- Front End

  • What is Javascript? Use of javascript?
  • Trend of Javascript?
  • Types of Implementing Javascript?
    • Inline
    • Internal
    • External
  • What are the Datatypes? Example for each one of them?
  • Variables & Constants?
  • What is Hoisting?
  • Alert, Prompt and Confirm Modals
  • Operators
    • What is Operators ?
    • Types of Operators
    • Examples for each one of them
  • Decision Making
    • What is decision making ?
    • Different types?
    • Examples for each one of them
  • Loops
    • What is loops?
    • Usage?
    • Types of loops?
    • Entry controlled vs exit controlled loops
    • Examples for each one of them
  • What are the types of data storage?
  • Data Structures in JavaScript?
  • Strings & Methods
  • Mutable and Immutable Strings/Objects
  • Arrays & Methods
  • Objects & Methods
  • Array of Objects?
  • Object configuration and properties
  • Writable and Enumerable Objects
  • Object Clone
  • What is DOM & Dom Manipulation Methods?
  • Types of DOM Manipulation Methods?
    • Dom Selectors
    • getelementById()
    • getElementsByTagName()
    • getElementsByClassName()
    • querySelector()
    • querySelectorAll()
  • Adding Css using Javascript
    • document.getElementById('idvalue').style.property = 'value';
    • Classlist
    • addClass
    • removeClass
    • InnerHTML
    • Document.write() vs innerHTML
  • Attaching Event
  • addEventListener()
  • Detaching Event
  • removeEventListener()
  • Manipulating Elements
  • createElement()
  • appendChild()
  • removeChild()
  • replaceChild()
  • Adding Css using Javascript
    • document.getElementById('idvalue').style.property = 'value';
    • Classlist
    • addClass
    • removeClass
    • InnerHTML
    • Document.write() vs innerHTML
    • Manipulating Attributes
    • setAttribute()
    • removeAttribute()
  • What are Functions in JavaScript?
  • When and where to use Functions?
  • 6 Ways of declaring Functions
  • Arrow Functions Advantages and Disadvantages
  • Immediate Invoke Function
  • Declare Function as Class/Expression
  • setTimeout and setInterval
  • Generator Functions
  • Reusable Functions
  • Function Advantages and Disadvantages
  • What is forms and validations?
  • Events and Event handling
    • Types of events
    • Keyboard events
    • keyup
    • keydown
    • keypress (deprecated)
    • Mouse events
    • click
    • dblclick
    • hover
    • mouseover
    • mousemove
    • mouseleave
    • contextmenu
    • Form
    • events
    • submit
    • blur
    • focus
    • reset
    • change
    • Page events
    • load
    • scroll
    • resize
  • What is event Bubbling And Capturing?
  • Event loop
  • Event Lifecycle
  • Types of form validations
  • field validations
  • form validation
  • Regular expressions
  • form validation using regex
  • form validation without regex
  • What are the types of errors in JS?
    • syntax errors
    • type errors
    • assignment errors
    • reference errors
    • others
  • How to handle the errors?
  • What is exception handling?
    • try block
    • catch block
    • finally block
    • throw block
    • custom error messages
  • Object oriented Principles
    • Data abstraction
    • Data Encapsulation
    • ES5
    • Object Literal
    • Object Constructor
    • Es6+
    • Classical
    • Polymorphism
    • Operators Overloading
    • Function Overloading
    • Inheritance
    • Types of inheritance
    • Is Supported Types
  • Example
    • Es5 - Prototypal Inheritance
    • Es6+ - Classical Inheritance
  • Getter and Setter
  • Spread and Rest Operators
  • Ajax Call in JavaScript
  • Closures
  • Race Condition
  • Strict Mode
  • Module Export and import
  • Block Scoping
  • Template literals
  • Call Backs, Async Await and Promises
  • Call, Apply and Bind
  • JSON Structure
  • JSON Parse and Stringify
  • ES5 vs ES6
  • HTML5 Canvas
  • HTML5 Web API's
  • HTML5 Geo Tags, Drag and Drop
  • Web Storage - Local vs Session
  • Overview of PWA
  • Web Service Workers
  • Browser Tools - Chrome, Firefox and Edge

Presentation Session-2 / Practical Case Study Analysis by students

GIT

  • Fast introduction to GIT commands,Simple Rebase Example,Setup for rebasing conflict,Abort a Rebase,Rebase Conflict Resolution,Pull with Rebase (GitHub)

Project 3 - Group Project using HTML ,CSS ,BOOTSTRAP,JAVASCRIPT

Core Java- Back End

  • Introduction To Java
  • Java History
  • Why Java
  • JVM
  • Class, Objects, Data Types
  • Variables
  • Type Casting
  • Object Oriented Programming Concepts
  • Abstraction
  • Encapsulation
  • Polymorphism
  • Inheritance
  • Java Coding Standards
  • Package - Creating package, naming package
  • Java Keywords
  • Module resolution declaration merging
  • Access Specifiers - Public, Private, Protected, Default
  • Static Concept - Block, Variable, Method, Class
  • Scanner Class
  • Control Statement - If, If…else, Nested if…else and Switch Case
  • Flow Statement- for, while, do..while
  • Constructor- Default, Parameterized
  • Inheritance
  • Extends, super and this keyword
  • Serialization
  • Transient
  • Exception Handling
  • Exception Handling- try, catch, throw, throws, finally
  • Method Overloading, Method Overriding
  • Interface
  • Abstract Class
  • Garbage Collection
  • Marker Interface
  • String Concept
  • String Basics
  • String Methods
  • String Buffer
  • String Builder
  • Custom Immutable Class
  • Framework
  • Basics
  • Iterator Interface
  • Methods of Collection Interface
  • List(Arraylist,Linkedlist and Vector)
  • Set(Hash Set,Tree Set)
  • Map(Hash Map, Tree Map, Hashtable)
  • Collection Framework Advanced Concepts
  • Comparable Interface
  • Comparator Interface
  • Collections class
  • Differentiate Comparable and Comparator
  • Java Enum
  • Date Concept
  • File Handling Concept
  • File Handling Basics
  • Create Folder
  • Create File- .txt. .pdf, .xlsx, .docs, etc
  • Write File
  • Read File
  • Delete File
  • Thread
  • Concept,Lifecycle
  • Extends Thread
  • Implement Runnable Interface
  • Thread Priorities
  • Thread Methods
  • Thread Synchronization
  • Synchronization
  • Object Locking
  • Inter Thread Communication

Practical Case Study Analysis by students

  • JDK 1.8.0 New Features with Hands-on
  • Lambda Expression
  • Functional Interface
  • Default Method in Interface
  • Static Method in Interface
  • Method References
  • Date Time API
  • Stream API
  • Collectors
  • For each Loop
  • String Joiner Class
  • Parallel Sort
  • Optional Class
  • J2EE
  • JDBC
  • JDBC Introduction
  • JDBC Architecture
  • Database Overview
  • JDBC Basics
  • Mysql
  • Create Database
  • Create Table

Practical Case Study Analysis by students

  • Insert, Update, Delete
  • Truncate
  • SQL Join
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Aggregate Function
  • MIN
  • AVG
  • SUM
  • COUNT
  • SQL HAVING Clause
  • GROUP BY
  • ORDER BY
  • SQL Aliases
  • SQL LIKE Operator
  • SQL In
  • SQL Between
  • SQL Null Values
  • SQL TOP
  • SQL LIMIT
  • SQL Stored Procedures
  • Java Application Using JDBC Connectivity
  • Handling SQL Exceptions
  • DriverManager
  • ResultSet
  • Connection
  • Statement
  • Prepared Statement
  • Callable Statement
  • DB Connectivity Steps
  • Store Image in SQL
  • Read Image in SQL
  • SQL Queries using SQLYog

Practical Case Study Analysis by students

  • JDBC CRUD Application
  • Servlet
  • Servlet Basics
  • Need of Server Side Programming
  • Servlet Life
  • Cycle 1 Init()
  • Service()
  • doGet()
  • doPost()
  • Destroy()
  • Servlet Hello World Application
  • Web.xml Structure
  • Servlet Directives- include(), forward(), sendRedirictive()
  • HttpServletRequest, HttpServletResponse in Servlet
  • Servlet and JDBC Integration
  • Servlet, HTML5, MySQL, Tomcat using Real Time Login Application
  • JSP
  • JSP Basics
  • Creating dynamic Web content with JSP
  • Scriptlet
  • Declaration
  • Servlet, JSP, MySQL, Tomcat Login Application
  • Servlet, JSP, MySQL, Tomcat CRUD Application

Presentation Session-3 / Practical Case Study Analysis by students

Project 4 - Group Project using Frontend(HTML,CSS,JS,Bootstrap) and Backend(Core Java, Advanced Java, JDBC,SERVLETS and MYSQL)

  • FRAMEWORK
  • Hibernate
  • Hibernate Introduction
  • Hibernate Basics
  • Hibernate Architecture
  • Hibernate Session
  • Hibernate SessionFactory
  • Hibernate Configuration
  • Hibernate Configuration Offline
  • Hibernate with HBM
  • Hibernate with Annotation
  • Hibernate Validator
  • Hibernate CRUD
  • Hibernate Association Mapping
  • One to One Mapping
  • One to Many Mapping
  • Many to One Mapping
  • Many to Many Mapping
  • Hibernate Aggregation
  • Hibernate Named Queries
  • Hibernate Native SQL
  • HQL-Hibernate Query Language
  • Hibernate HQL- Criteria Query Language
  • Hibernate Application with Mysql DB-CRUD
  • Diff. save(), saveOrUpdate(), update(), persist() and merge()
  • Diff. get() and load()
  • Hibernate vs. JPA
  • Hibernate Application with Mysql DB, JSP-User Interface-CRUD
  • Spring Framework
  • Singleton
  • Prototype
  • Request
  • Session
  • Global-Session
  • Auto wiring
  • Spring Annotations
  • Spring MVC
  • Spring MVC Basics
  • Spring MVC Hello World Application
  • Spring MVC Restful Web Services Basics
  • Spring MVC without Maven
  • Spring MVC with Maven
  • Maven basics
  • Spring MVC Application Deployment
  • Spring MVC Application Deployment Log files
  • Spring MVC WAR File Creation Steps
  • Spring, Hibernate, Mysql, Maven- CRUD Operation
  • Java, Spring, Spring Security, Algorithm, Hibernate, Maven, Mysql Integration Application
  • Spring Security
  • Spring Security Basics
  • Spring Security Features
  • Spring Security Authentication
  • Spring Security Encryption
  • Password Encryption by using Spring Security
  • Spring Security Login Form
  • Spring Security Authentication
  • Spring Security Maven Dependency
  • Spring Security CRUD- Signup and Login Application
  • Spring Boot
  • Spring Boot Introduction
  • Spring Boot Basics
  • Why Spring Boot
  • Spring Boot Features
  • Main Goal of Spring Boot
  • Creating Project- Spring Initializer
  • Spring Boot Hello World Application
  • Spring Boot Devtool Dependency-Spring Boot - How to Reload Changes Without Restarting the Server
  • Spring Boot Actuator
  • Spring Boot Build Systems
  • Spring Boot Code Structure
  • Spring Boot Runners
  • Spring Boot Tomcat Port Number
  • Spring Boot with RESTFul Service
  • Spring Boot with Logger
  • Deploy Spring Boot Applications on External Tomcat Server
  • Spring Boot - Common Application Properties (application.properties)
  • Spring Boot, Hibernate with RESTFul Web Service
  • Spring Boot, Spring Data with RESTFul Web Service
  • Spring Boot, Hibernate CRUD Application
  • Spring Boot, Spring Data JPA CRUD Application
  • Spring Boot, Spring- JDBCTemplate CRUD
  • Spring Boot, Hibernate, MySQL, Project Lombok CRUD Application
  • Spring Boot with XML Payload using Postman API
  • Spring Boot with JSON Payload using Postman API
  • Spring Boot CORS Support
  • Java QR Code Generator Basics
  • Spring Boot QR Code Generator Hands on Session
  • Spring Boot QR Code Reader Hands on Session

Practical Case Study Analysis by students

  • Spring Data - JPA
  • Spring Data JPA Basics
  • Spring Data JPA Introduction
  • Spring Data JPA Architecture
  • Spring Data JPA application.properties file
  • JPA Repository
  • CRUD Repository
  • Spring Boot, Spring Data JPA CRUD using Postman API
  • Spring Boot, Spring Data JPA, Project Lombok CRUD using Postman API Hands on Session
  • JUnit- Mockito Framework
  • Spring - JDBCTemplate
  • Spring - JDBCTemplate Introduction
  • RowMapper
  • Builder
  • Spring Boot, JDBCTemplate using Postman API Hands on Session
  • WEB SERVICES
  • SOAP Web Service
  • RESTful Web Service
  • Design Pattern
  • Singleton Design Pattern
  • Builder Design Pattern
  • Factory Pattern
  • Abstract Factory Pattern
  • Prototype Pattern
  • Facade Pattern
  • Adapter Pattern
  • Filter Pattern
  • Composite Pattern
  • Decorator Pattern
  • Proxy Pattern
  • Iterator Pattern
  • Bridge Pattern
  • Flyweight Pattern
  • MVC Pattern
  • MICROSERVICES
  • Microservices Introduction
  • Microservices Architecture
  • Microservices Project Structure
  • Microservices Frameworks
  • Spring Boot with Microservices Basics
  • Spring Boot with Microservices Coding Standards
  • Spring Boot with Microservices Builder Design Pattern
  • Spring Boot with Microservices QR Code Generator
  • Spring Boot, Hibernate, Maven, MySQL CRUD Application- POSTMAN API
  • Spring Boot, Spring Data-JPA, Maven, MySQL CRUD Application- POSTMAN API
  • Spring Boot, Spring Data- JDBCTemplate, Maven, MySQL CRUD Application
  • Spring Boot, ORM, Microservices with Project Lombok
  • Spring Boot, CORS, Spring Data[JDBCTemplate], Microservices CRUD with Project Lombok Using React JS

Presentation Session-4 / Practical Case Study Analysis by students

React

  • What is React?
  • React Project Setup/React Boilerplate
  • Variables and Datatypes
  • Node, Module, Package, Node Package Manager(NPM)
  • Create React App
  • Virtual DOM?
  • Loops, Operator and Conditions?
  • Array and String Methods
  • What is JSX Element
  • Commenting a JSX element
  • Rendering a JSX Element
  • Style and className in JSX
  • Injecting data to a JSX Element
  • Big picture of components
  • JavaScript function vs Class
  • Creating React Component
  • Class Component
  • Functional Component
  • How to create Reusable Components

Practical Case Study Analysis by students

  • Props in Functional Component
  • What is props?
  • Props object
  • Destructuring props
  • propTypes
  • defaultProps
  • How to share data between components using Props
  • What is State in React
  • How to set state in Functional Component
  • How to set state in Class Component
  • How to reset the State in class/functional
  • What is React Router ?
  • BrowserRouter
  • Route
  • Switch
  • NavLink
  • Nested Routing
  • Redirect
  • Prompt
  • Form input fields
  • Form Data Binding
  • Form Validations
  • Styling Forms

Practical Case Study Analysis by students

  • UI Components
  • Installing and integrate Material UI
  • Theme, color, fonts and background
  • UI Lists, Tables and accordion
  • Async Request in React - Axios/Fetch
  • How to do HTTP/API request?
  • GET, POST, PUT and Delete using Axios and Fetch
  • Functional component Lifecycle hooks
  • Class component Lifecycle hooks
  • Refs and useContext
  • ES6 vs ES5 React code
  • React Events
  • What are keys in React
  • Higher order Components
  • Style Properties in React Component

Practical Case Study Analysis by students

React Angular Frontend Advance

  • NgrX state management in Angular
  • Redux and Flux in React
  • ngRx vs Redux vs Flux
  • Sample State implementation in Redux
  • Karma/Jasmine/Jest
  • How to create sample test case
  • How to write and execute unit test case
  • How to ignore or run particular test case
  • Chrome Development Tools
  • IDE - VsCode Debugging
  • Console Log
  • Debug Extensions for React
  • How to build React Project
  • What is Webpack and its alternatives?
  • Build optimization techniques

Presentation Session-5 / Practical Case Study Analysis by students

Value Added Courses

  • What is UX?
  • The five main principles of UX design
  • What do UX designers do?
  • Benefits of UX design (and UX designers!)
  • What's next? Key takeaways
  • What is CSS?
  • What problem does CSS solve?
  • What are CSS preprocessors?
  • CSS preprocessor features
  • Pros and cons of using a CSS preprocessor
  • Popular CSS preprocessors
  • Final thoughts
  • Grid
  • Container
  • Breakpoints
  • Use Media Query
  • What is MongoDB?
  • Key Features of MongoDB
  • What are Node and Express?
  • What is REST API?
  • Key Benefits of REST API
  • Node Express MongoDB System Architecture
  • Steps to Build a REST API using Node Express MongoDB
  • Step 1: Connecting to MongoDB Atlas
  • Step 2: Adding REST API CRUD Routes
  • Step 3: Setting Up the Front-End
  • Step 4: Testing the Application
  • Conclusion
  • Maven - Overview
  • Maven - POM
  • Maven - Build Lifecycle
  • Maven - Creating Project
  • Maven - Build & Test Project
  • Maven - External Dependencies
  • Maven - Build Automation
  • Maven - Manage Dependencies
  • Maven - Deployment Automation
  • Maven - Web Application
  • Maven - Eclipse IDE
  • Benefits of DevSecOps Tools:
  • Types of DevSecOps Tools:
  • DevSecOps Security Tools:
  • DevSecOps Pipeline Tools:
  • DevSecOps Automation Tools:
  • DevSecOps Testing Tools:
  • DevSecOps Monitoring Tools:
  • DevSecOps CI/CD Tools:
  • Other Vital DevSecOps Tools:
  • Implement DevSecOps Techniques Using the Right Tools:
  • Tips to Leverage Your DevSecOps Tools:
  • Conclusion
  • Write code and deploy automatically, AWS takes care of the infrastructure:
    • Integrate with CD, build and deploy automatically. Never worry about configuration of the underlying services Use vanilla JavaScript, or any JS Go, Ruby, PHP, and Python An easy and quick way to deploy
  • Build and deploy using containers:
    • Build and deploy a website using cloud native technologies such as Docker and Kubernetes Fully managed infrastructure with lightweight and global scalability options available Easiest and fastest way to deploy a web application with containers
  • Build and deploy on a virtual machine:
    • Highest level of control of the complete technology stack Full support of the underlying operating system plus custom configurations Easiest conversion from on-premise virtual machines to cloud
  • Introduction to ChatGPT and AI
  • AI and Machine Learning Concepts
  • Chat GPT Functionalities and Applications
  • Chat GPT Prompt Engineering
  • Variables,Data Types, Loops, Operators and Conditions
  • Built In Functions and Lambda Functions
  • List,Set and Tuples
  • String and Dictionaries
  • File Handling
  • OOPS in Python
  • Modules and Packages
  • Generators and Iterators
  • Decorators
  • Context Managers
  • Virtual Environments

Data Science

Firstname Lastname Email
John Doe john@example.com
Mary Moe mary@example.com
July Dooley july@example.com

Modules

 

 

ExcelR Solutions – USA

ExcelR Solutions,
Regency Square,6200 Savoy Drive,
Suite 1202, Houston,Tx 77036 USA,
Phone:  +1 844-392-3571
Fax:+1-281-971-3067
Phone:   +1-281-971-3065,

ExcelR Solutions – UK ExcelR Solutions,

20 Kendrick Court,
Kendrick Road,
Reading RG1 5DS, UK.

ExcelR Solutions – Malaysia

ExcelR Solutions,
1 Sentral, Level 16, 
Jalan Stesen, Sentral 5,
KL Sentral Kuala Lumpur 50470
Malaysia.
Phone:   +6(03)-2718 5616

 

ExcelR Solutions – Bangalore

ExcelR Solutions,
#49, 1st Floor, 27th Main,
1st Cross, Behind Tata Motors,
BTM 1st stage,
Bengaluru, Karnataka 560068
Phone:  +91 9632156744

 ExcelR Solutions – Hyderabad 

ExcelR Solutions,
2-56/2/19, 3rd floor,
Vijaya towers, near Meridian school,
Ayyappa Society Rd, Madhapur,
Hyderabad, Telangana 500081
Phone:   080080 09706

ExcelR Solutions – Pune

ExcelR Solutions,
102, 1st floor, Phase II,
Prachi Residency, Opp Lane to Kapil Malhar,
Baner Road, Baner,
Pune, Maharastra 411046
Phone:  +91 98809 13504

 

ExcelR Solutions – Mumbai

ExcelR Solutions,
New Bridge Business Centre,
B1/04-05, Ground Floor B Wing, Boomerang,
Chandivali Road,Ganesh Nagar,
Chandivali Powai, Andheri East
Mumbai, Maharashtra 400072

Phone:  +91 9632156744

 

 

TRUE POSITIVE :- When PREDICTED POSITIVE but in ACTUAL also happens that way
TRUE NEGATIVE:- When PREDICTED NEGATIVE but in ACTUAL also happens that way
FALSE POSITIVE:- When PREDICTED POSITIVE but in ACTUAL happens absolutely OPPOSITE
FALSE NEGATIVE:- When PREDICTED POSITIVE but in ACTUAL happens absolutely OPPOSITE

Career Transformations

PMP Course Benefits
PMP Course Benefits

Our Expert Panel

 

Contact Our Team of Experts

Testimonials

FAQs

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence

 

(PMP)® Certification Training locations in Bangalore : Ammrutha halli [560092], Maruthi Seva Nagar [560033], Kuvempu Layout [560077], Bellandur [560103], Jayanagar III Block [560011], Anandnagar [560024], Nandinilayout [560096], B SK II Stage [560070], Indiranagar [560038], Yelahanka [560063], Chickpet [560053], Domlur [560071], Bansashankari III Stage [560085], Vimanapura [560017], Nagarbhavi [560072], Basaveshwaranagar [560079], Bommanahalli [560068], Mico Layout [560076], Electronic City [560100], Taverekere [560029], Nehru Nagar [560020], Agram[560007], Halsuru Pete [560002], Basavanagudi [560004], R.M.V. Extension II [560094], Jayanagar [560041], Carmelaram [560035], New Thippasandra [560075], Kanakanagar [560032], Nayandahalli [560039], Fraser Town [560005], Jalahalli East [560014], Kacharakanahalli [560084], Malleswaram West [560055], Bannerghatta [560083], Srirampuram [560021], Rajarajeshwarinagar [560098], Sivan Chetty Gardens [560042], Dommasandra [562125], Whitefield [560066], Vidyaranyapura [560097], Bolare [560082], Mathikere [560054], Doddanekkundi [560037], Hampinnagar [560104], C.V.Raman Nagar [560093], Chikkabanavara [560090], Attur [560064], Kumbalagodu [560074], Bhattarahalli [560049], Chikkalasandra [560061], Sharada Nagar [560065], Jalahalli West [560015], H.K.P Road [560051], Jp Nagar III Phase [560078], Sadashiva nagar [560080], Krishnarajapuram R S [560016], Mahalakshipuram Layout [560086], Guddadahalli [560026], Chudenapura [560060], Vidhana Soudha [560001], Shanthinagar [560027], Rajaji Nagar [560010], Chandapura [560099], Ramakrishna Hegde Nagar [560045], Shalabh Bhatnagar [560012], Peenya [560058], Ashoknagar [560050], Jalahalli Nacen [560013], Banawadi [560043], Malleswaram [560003], Doddakallasandra [560062], K.G Road [560009], Muthusandra [560087], Marathahalli [560056], JC Nagar [560006], Chamrajpet [560018], HSR Layout [560102], Devanagundi [560067], Yeswanthpura [560022], Mahadevapura [560048],Hulsur Bazaar [560008],Magadi Road [560023], Adugodi [560030], Bagalgunte [560073], Devasandra [560036], Rv Niketan [560059], Narasimharaja Colony [560019], Koramangala VI Bk [560095], Agara [560034], Vijayanagar East [560040], Benson Town [560046], Viveknagar S.O [560047], Dasarahalli [560057], Bapagrama [560091], Richmond Town [560025].

Call Us whatsapp