microsoft

Foundation in Data Science

Explore the world of data science by mastering Excel, T-SQL, MongoDB, and Python. Learn inferential statistics, data mining, and machine learning with R and WEKA, and complete a hands-on capstone project to solidify your data science skills.

Learning Outcome

Work with spreadsheets and analyze data using MS Excel
Learn fundamental concepts of Transact SQL(TSQL) commands
Understand MongoDB concepts, features, architecture and data model, and learn to install, configure, and monitor open-source NoSQL databases
Understand the basics of statistical analysis, descriptive statistics, predictive analytics, probability, and Bayes theorem
Master data exploration, predictive & descriptive analytics techniques using R
Develop applications using Python language
Use WEKA to perform data mining tasks
Develop a Capstone project using WEKA and implement data mining tasks

Course Breakdown

Data Analysis with MS Excel
16
Data Handling using T-SQL
16
Managing Large DataSets with MongoDB
32
Inferential Statistical Analysis
16
Data Science using R Programming
36
Application Based Programming in Python
36
Data Mining with WEKA
24
Capstone Project for Data Mining
24

Technologies

Office 365
Microsoft SQL Server 2019
MongoDB 6.x
R Studio 2.x or higher
Python 3.6.x
WEKA (Opensource AI and data mining tool)
WEKA

Certificate and Career Path

Related Courses

Ethical Hacking

Cybersecurity Operations Fundamentals

Network Administration

Why join Aptech

Join a diverse community of learners from around the world, expanding your network and perspectives.