Demo Videos

Course Highlights

    • 5 Hours of Course Content
    • Quizzes and Assignments
    • Working on Real World Datasets
    • 1 Year Course Access
    • 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 coding and wants to a Data Engineer.
    • Any Degree, Engineering & IT Students
    • Early Professionals
  • Job Opportunities

    • Data Scientist
    • Backend Engineer
    • Stepping stone towards becoming a Data Scientist, Backend Engineer

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

    Introduction to the course

    • Welcome Message

    • Course Preview

    • Welcome to this course

    • What is Database?

    • Join Developer Community

    • Installing MySQL

    • Alternative Mysql Installation

    • Xampp-2

  • 2

    MySQL Basics

    • Creating a database

    • Creating first table

    • Insert Value to table

    • Select statement

    • logical AND and OR

    • BETWEEN and NOT Operator

    • Primary Key, Default and Null

    • Customers table

    • Testing the customer table

    • Answering questions

    • How do you feel about the course till Now ?

    • Getting specific data

    • Updating the customers table

    • Deleting the customers table

    • Referral Program

  • 3

    Intermediate Section

    • Aggregate Functions

    • CONCAT()

    • REPLACE()

    • SUBSTRING()

    • CHAR_LENGTH()

    • UPPER()

    • Student Feedback - Basics And Intermediate

    • Keep Updated!

  • 4

    Advanced SQL queries

    • Look into Distinct

    • ORDER BY

    • LIMIT

    • Pattern Matching

    • COUNT()

    • GROUP BY

    • MIN MAX and SUBQUERIES

    • GROUP BY with MAX and MIN

    • SUM and AVG

    • having

    • Student Feedback - Advance Section

  • 5

    DATATYPES

    • foreign key

    • largedataset

    • Data types Integer and String

    • DATE, DATETIME and JSON

    • date time code

  • 6

    Intro to JOINS

    • let's Join

    • Types of JOINS

    • INNER JOIN

    • Relationships in MYSQL

    • join 3 tables

    • LEFT JOIN

    • Right Join

    • OUTER JOINS & UNIONS

  • 7

    Advanced Concepts in RDBMS

    • Views

    • Indexes

  • 8

    Assignment

    • Assignment Info

  • 9

    Certification

    • Certification Instructions

    • Referral Program

Expert Instructor

 Manikanta A Nayar

Co-Founder

Manikanta has 3+ years of industrial experience in building scalable Javascript Full Stack Web Application. He is passionate about sharing the knowledge to his peers in an efficient way. He has expertise over Javascript, React, Nodejs, MongoDB and Mysql. He was a Regional Co-ordinator at Free Software Movement Karnataka (FSMK) Mangalore, and has conducted more than a dozen technical workshops and seminars.

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