Demo Videos

Course Highlights

    • 15+ Hours of Course Content
    • Covers Python, MySQL, Data Analytics
    • Real-world Capstone Project
    • Quizzes & Mini-projects
    • No Prior Coding Knowledge
    • Instant Doubt Clarification
    • Telegram Developer Community
    • Certification of Completion
    • Become an Alumni of MicroDegree
    • Unlimited access*
  • Who Should Attend

    • Anybody interested in learning Data Science and Coding
    • Any Degree, Engineering & IT Students
    • Early Professionals
  • Job Opportunities

    • Data Analyst
    • Business Analyst
    • Data Engineer
    • Python Developer
    • Product Manager

Completion Certificate by MicroDegree

On completion of course become a proud alumni of MicroDegree. MicroDegree is chosen among top innovative startups by Government of Karnataka's flagship Elevate Call-2 program

Course curriculum

  • 1

    Basics

    • 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

  • 2

    Foundations

    • 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

  • 3

    Python for Data Analytics

    • 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

    • Referral Program

  • 4

    Intermediate

    • 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

    • Student Feedback - Intermediate Section

  • 5

    Advanced

    • 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

  • 6

    Capstone Project

    • 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

    • What did you feel about the entire Course

Expert Instructor

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.

 Rakesh Kothari

Co-founder & CTO

Rakesh has 12+ years of industry experience building enterprise applications at scale. He has worked across banking and insurance domains with top companies. 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 believes it is the best to start with as a newbie into the programming world and enter into the world of Data.

 Manikanta A Nayar

Co-founder & COO

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.

Learner Review

  • Akshata Kothari

    Thank you so much for this course. The concepts explained by the trainer was really good and clear. As it was in kannada it helped me in understanding the concept better.

  • karthik k

    You are giving examples for every concept which makes us learn faster. Excellent. Keep going

  • Chethana Amin

    It's really a good thought to start a course in kannada. It helps lot of people.

  • Divya G

    Explaining in Kannada is understanding in good manner

  • Deepashree N

    Awesome thing... u guys made python very very easy which can be learnt in our mother tongue.... thank you...

  • Monica Govindappa

    Learning in Kannada is helping out to grasp things quickly over all making it to learn in an interesting way.

Refer & Earn

Friends ಗೆ Refer ಮಾಡಿರಿ ಹಾಗೂ ಪಡೆಯಿರಿ Cash upto ₹15,000