Microsoft Office Essential Skills Exchange Online

Master machine learning and artificial intelligence skills with this advanced data science and artificial intelligence course from iHub IIT Roorkee. Learn from IIT faculty and industry experts with 1:1 mentorship in this intensive online bootcamp. Top 2 performers from each batch may get a fellowship worth Rs. 80,000, plus the opportunity to showcase their startup ideas and secure incubation support of upto Rs. 50 Lakhs for their startup from iHUB DivyaSampark, IIT Roorkee.
4,8




About Program
Become an expert in Data Science, Machine Learning and Artificial Intelligence with iHUB DivyaSampark, IIT Roorkee & Intellipaat! Build a strong foundation in data science by learning in-demand skills, solving real-world challenges, and working on real-world projects. A flexible learning environment and 24/7 support makes this course perfect for beginners and professionals alike. Join now and accelerate your career to new heights in the cutting-edge fields of data science, machine learning, and artificial intelligence!
40 Hrs of Sessions
32 Hrs of Labs
Real-time Use cases
24/7 Lifetime Support
Certification Based Curriculum
Flexible Schedules
One-on-one doubt clearing
Career path guidance
Job Support
-
Individuals with a bachelor’s degree and a strong interest in learning AI and data science
-
IT professionals looking to make a career transition as data scientists and artificial intelligence engineers
-
Software Developer, Project managers, Non-Technical Professionals & Entry-level professionals looking to build their careers in artificial intelligence and data science
-
Undergraduate freshers with an interest in Data Science & AI
What roles can a person trained in data science and artificial intelligence play?
What roles can a person trained in data science and artificial intelligence play?
Data Wrangling
NLP
AI Models
Machine Learning
Data Science
MLOps
Python
Data Analysis
Azure Data Factory
SQL
AI/ML
Data visualization
Algorithms
GIT
PySpark SQL
Tools Covered
Meet Your Mentors
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Designation
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Designation
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
99.9% Customer Satisfaction based on 550+ reviews of 2,250 Faculty Courses, and 2,820 Happy Students trust us.
Interested in this Program? Secure your spot now!
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
SQL Basics –Â
- Fundamentals of Structured Query Language
- SQL Tables, Joins, VariablesÂ
Advanced SQL – Â
- SQL Functions, Subqueries, Rules, Views
- Nested Queries, string functions, pattern matching
- Mathematical functions, Date-time functions, etc.Â
Deep Dive into User Defined Functions
- Types of UDFs, Inline table value, multi-statement table.Â
- Stored procedures, rank function, SQL ROLLUP, etc.
SQL Optimization and Performance
- Record grouping, searching, sorting, etc.Â
- Clustered indexes, common table expressions.
Hands-on exercise:Â
Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).
Career Transition
Who can apply for the course?
- Individuals who have pursued B.E., B.Tech, B.Sc., B.Com, M.E., M.Tech, M.Sc., and MCA
- College students in the last year of their graduation or post-graduation
- Any working professional up to 28 years old
- Software Developers, Testers, and QA Engineers
- System Analysts and Administrators Professionals
- Freshers and Graduates who want to make a career in Software Testing

What roles does Software Testing Course Provide?
Software Test Engineer
Software test Engineers are responsible for creating and implementing test procedures to ensure that software programmes work as expected.
QA Analyst
Create test plans for new software releases and services. Create, write, and run test scripts to verify the functionality of application and database requirements.
Database Tester
Database Testers run tests to ensure that the exact data values retrieved or fetched from the database by the desktop-based application or web-based application are correct.
Manual Test Engineer
Manual Test Engineers perform testing activities such as planning, and test design that occur prior to coding. They also work on proactive defect tracking, which means that defects are discovered at an early stage.
Software Test Engineer
Develop detailed, comprehensive, and well-structured test plans and test cases, as well as estimating, prioritizing, planning and coordinating testing activities. They are also responsible for designing, developing, and executing software scripts.
Performance Test Engineer
Performance Test Engineer creates and maintains performance test plans, injects load using JMeter load testing software, and analyse metrics from application and system logs.
Courtney Henry
Designation