Demo Videos

Course Highlights

  • 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
Enrol Now

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.

Placement success stories

Sudeep Dsouza


Associate Software developer
Mindstack Technologies

Samanth Kumar


Associate Software developer
Mindstack Technologies

Kavya S N


Associate Software developer
Mindstack Technologies

Manjunath


Junior Software developer
Cliq Labs

Deeraj R


Junior Software developer
Cliq Labs

Ashwath


Software Trainee
7Edge Technologies

Placement success stories

Sudeep Dsouza


Associate Software developer
Mindstack Technologies

Samanth Kumar


Associate Software developer
Mindstack Technologies

Kavya S N


Associate Software developer
Mindstack Technologies

Manjunath


Junior Software developer
Cliq Labs

Deeraj R


Junior Software developer
Cliq Labs

Ashwath


Software Trainee
7Edge Technologies

Karnataka Startup Champions

ನವಭಾರತದ ಶಿಲ್ಪಿಗಳು

We believe in learning technology in our local language by emphasizing on relevant analogies, examples and thereby making fundamentals strong with deep concept clarity. Our motto is to make emerging technology affordable for students & early professionals across regions irrespective of their educational backgrounds.

Refer & Earn

Refer to get 10% Referral Bonus paid directly to your Bank Account

Refer Now