Data Analytics Course – No prior Coding knowledge required
Learn how to collect, clean, and analyse data, as well as use data visualisation tools to communicate your findings
Ratings
4.8
Content Duration
15 hours+
Taught By
Industry expert
Students enrolled
3878+
Teaching Language
ಕನ್ನಡ
Course Type
Pre recorded
Who is this course for
Anybody who is interested in learning Data Science
What are the Job Opportunities Available
With this skill you can get into roles like:
Data Analyst
Business Analyst
Data Engineer
Python Developer
Product Manager
Course content
- Welcome Message
- Course Preview
- What is Data Analytics
- Applications Of Data Analytics
- Steps in Data Science
- Career Roles in Data Science Field
- Tools For Data Science
- Join Developer Community
- MySQL - What is Database?
- MySQL - Course Preview
- MySQL - Welcome to this course
- MySQL - Installation
- MySQL - Alternative Mysql Installation
- Xampp-2
- MySQL - Creating a database
- MySQL - Creating first table
- MySQL - Insert Value to table
- MySQL - Select statement
- MySQL - Logical AND & OR
- MySQL - BETWEEN and NOT Operator
- MySQL - Primary Key, Default and Null
- MySQL - Customers table
- MySQL - Testing the customer table
- MySQL - Answering questions
- MySQL - Getting specific data
- MySQL - Updating the customers table
- MySQL - Deleting the customers table
- MySQL - Aggregate Functions
- MySQL - CONCAT()
- MySQL - REPLACE()
- MySQL - SUBSTRING()
- MySQL - CHAR_LENGTH()
- MySQL - UPPER()
- MySQL - Look into Distinct
- MySQL - ORDER BY
- MySQL - LIMIT
- MySQL - Pattern Matching
- MySQL - COUNT()
- How do you feel about the course till Now ?
- MySQL - GROUP BY
- MySQL - MIN MAX and SUBQUERIES
- MySQL - GROUP BY with MAX and MIN
- MySQL - SUM and AVG
- MySQL - having
- MySQL - foreign key
- MySQL - largedataset
- MySQL - Data types Integer and String
- MySQL - DATE, DATETIME and JSON
- MySQL - date time code
- MySQL - let's Join
- MySQL - Types of JOINS
- MySQL - INNER JOIN
- MySQL - Relationships in MYSQL
- MySQL - join 3 tables
- MySQL - LEFT JOIN
- MySQL - Right Join
- MySQL - OUTER JOINS & UNIONS
- MySQL - Views
- MySQL - Indexes
- MySQL - Assignment Info
- Join Developer Community
- Student Feedback - Basics And Foundation
- Certification Instructions
- Referral Program
- Python - Course Preview
- Python - What is Python
- Python - Who should Learn Python?
- Python - Why Python
- Python - How to learn Python
- Python - Basics Of Programming
- Python - Installation & Setup
- Python - My First Python Program
- Python - Instruction Execution in Python
- Python - Variables
- Python - Taking User Input
- Python - Build Calculator Exercise
- Python - Strings from Beginning
- Python - String Manipulation
- Python - Working With Numbers
- Python - Intro to DataStructures
- Python - Lists in Python
- Python - List Methods
- Python - Number List Manipulation
- Python - Tuples
- Python - If Else Statements
- Python - Logical Operators
- Python - Comparison Operators
- Python - Build a Converter App
- Python - Loops Intro
- Python - While Loop
- Python - Guessing Game Project
- Python - For Loops In Python
- Python - 2D Lists & Nested Loops
- Python - Dictionaries
- Python - Functions Intro
- Python - Parameters in Functions
- Python - Return Statements in Functions
- Python - Word Counter Exercise
- Python - Intermediate Project - Student Management System
- Python - Handling Errors
- Python - Generic Exceptions & Finally
- Python - Modules
- Python - Packages in Python
- Python - File IO
- Python - Object Oriented Programming (OOPs)
- Python - Classes and Objects
- Python - PyPI And Pip
- Python - Coding Standards
- Python - Price Tracker App - Intro
- Python - Web Scraping Using Beautiful Soup
- Python - Parsing Data
- Python - Dynamic Multiple Inputs
- Python - Price Check Logic
- Python - Write Output File
- Python - Project Wrap Up
- Student Feedback - Python for Data Analytics
- Certification Instructions
- Why Pandas?
- Reading Data and Iterate through each Row
- Description of data and sorting
- Working with Column
- Saving Data
- Filtering Data, Reset Index, Regex Filtering and Conditional Changes
- Aggregate Statistics using Groupby
- Working with huge data
- The Basics of Numpy
- Accessing Specific Elements
- Initializing Different Arrays
- Basic Mathematics, Statistics and Linear Algebra
- Reorganizing Arrays & copy variable
- Load data, Advanced Indexing and Boolean Masking
- Quiz
- Data Visualization - What is MatPlotLib?
- Data Visualization - Line Graphs and ShortHand Notations
- Data Visualization - Bar Graphs in MatPlotLib
- Data Cleaning - Introduction, Data & Null Values
- Data Cleaning - Removing Column and Rows
- Data Cleaning - Normalizing Data
- Capstone Project Part-1
- Capstone Project Part-2
- Capstone Project Part-3
- Capstone Project Part-4
- Capstone Project Part-5
- Capstone Project Part-6
- Referral Program
- Instructions
Completion Certificate by MicroDegree
Listen to what our Students have to say 😀
Wonderful Experience. The video lessons are in a very structured manner, even for a NoN- IT Background person its very easy learn and understand concepts. Adrallu Kannadalli helikottirodu super... 😊
Abijith
The Knowledge of the trainer is fantastic. They teach complex topics using simple examples. Easy to understand. Thanks a lot Microdegree 😊👍
Shravya
ಕನ್ನಡದಲ್ಲಿ ಕಲಸೋದ್ರಿಂದ ತುಂಬ ಸುಲಭ ಆಯಿತು. Big thanks to Microdegree. The trainers are very experienced and helped us easily understand concepts. Overall good experienced and very interesting teaching.
Manjunath
I liked most of the teaching. Indexes was the good one . It is very unique way to teach in regional languge . totaly feels good learned something new from this
Shafiq
I felt like I made I have made the best decision. The training here is really really good, I got placed recently and all thanks to Microdegree for the wonderful training.
ಜೈ ಕನ್ನಡ ❤️
Kavitha
Learn from our Expert Instructor
Rakesh Kothari
Co-founder & CTO | MicroDegree
Rakesh has 12+ years of industry experience building enterprise applications at scale. He has worked across banking and insurance domains with top companies like TCS and Bank of America. He is an Engineering graduate from BMS College of Engineering, Bangalore and has expertise across technologies like Python, Java, Android, JavaScript and MERN Stack. Rakesh recommends Python as the go-to programming language for beginners. He feels it is the best to start with as a newbie into the programming world and has simple easy to understand english - like statements.
.png)
Manikanta A Nayar
Co-founder & COO | MicroDegree
Manikanta is an Engineering graduate from PA College of Engineering and has 3+ years of industry experience building scalable enterprise applications. He has expertise across MySQL, JavaScript and MERN stack. Manikanta was a Regional Co-ordinator at Free Software Movement Karnataka (FSMK) Mangalore, and has conducted more than a dozen technical workshops and seminars. He believes learning technology in Kannada gives better clarity in concepts and foundations thereby enhances the employability rate of local engineering talent.
Greeshma Mathad
Data Science Geek
An Electronics and Communication Engineer from B.V. Bhoomaraddi College of Engineering, she's a Data enthusiast with 4+ years of experience in the software industry. Worked as a Software Engineer at Accenture and has also been instructor for Java & Python programming for kids at Byjus.
Learn from expert trainers from top companies
Frequently asked questions
This Data Analytics course has been thoughtfully designed to provide you with a wide range of skills.
1. Data Analysis
2. Data Visualization
3. Data Cleansing
4. Data Collection
5. Spreadsheet
6. SQL
7. Data Aggregation
8. Data Calculation
9. Python
10. NumPy
11. Sample Size determination
12. Decision Making
13. Problem Solving
14. Questioning
This is a 15+ hour pre recorded video course which you can access from anywhere, anytime and learn at your own pace without disturbing your busy schedule.
Yes, You will get a certificate from Microdegree post course completion.
Yes definitely, this course takes you on a learning journey from absolute basics to all the way up to advanced features. So anyone can learn this course even if you do not have any prior coding experience.
After making the payment, your account will automatically create in our learning portal. You will get the login credentials of the learning portal via mail instantly just after your enrollment to the course.
Kindly email us at hello@microdegree.work & our support team will get back to you as soon as possible.
We are supported by
