Join 3000+ Learners.

Learn coding and job-ready skills from industry experts in Kannada. MicroDegree is chosen among top innovative startups by Govt. of Karnataka's flagship Elevate-Call2 program

Snow
Forest

Join 3000+ Learners

Learn coding and job-ready skills from industry experts in Kannada. MicroDegree is chosen among top innovative startups by Govt. of Karnataka's flagship Elevate-Call2 program

Snow
Forest

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

Programming Languages and Tools Covered

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.

Industry Projects

  • In this course, we will be working on real world datasets which you will find in most of your day to-day work. With these datasets, you will be equipped to work with real-world databases with ease and confidence.

Course curriculum

  • 1

    Introduction to the course

    • Welcome Message

    • Course Preview

    • Welcome to this course

    • What is Database?

    • Join Developer Community

    • Installing MySQL

  • 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

  • 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

    Certification

    • Certification Instructions

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

Learner Review

Sumedh Mallya

JavaScript (Beginners)

All the courses are superb.. Especially Javascript course.. The tutor also teaches very good.. They respond to the queries quickly and are more supportive e.. They are sharing knowledge not behind money.. Because they teach as well as provide certificate for free I Javascript course.. Keep it up Microegree

Pushparaj Battemaru

Python

Java script course is really good course,I learnt lot about Java script from beginner level to intermediate level .This couse was really helped me a lot to learn new language in web development .The instructor was really good and his explaination style,voice (audio)and video clarity were crystal clear❤️.easily we can understand. In this course I learnt not only basics, it includes better parctical examples/around 3- 4 projects. And I will recommend you to take this course and it will help you to become a good developer. 🤝thank you microdegree for this great course🤝

Akshata Kothari

Python

Explanation and the course content was good and very helpful. Thank you.

Frequently Asked Questions

  • Who should Sign up?

    Anybody willing to learn Programming in a simple way could sign up. Students starting from the High School, Pre-University, Diploma, Engineering, Graduates, Freshers, Early Professional and even Experienced Professionals. Our Courses are designed keeping in mind to give clarity on programming foundations to move up to expert level irrespective of educational backgrounds.

  • Will I get a Certificate?

    Yes, you will get an e-Certificate of Completion once you successfully finish all the modules within your course. We track individual progress reports which includes micro lessons, quizzes, assignments etc.

  • Will I have to complete or submit any projects to get the Certification?

    No, you don't have to complete or submit any major projects to get an e-Certificate. Although, Courses include minor quizzes, assignments and take away projects for which 'Source Codes' would be shared by MicroDegree.

  • What is the duration to complete Courses?

    While you will have a life-time access to complete the courses, we recommend you to complete the courses by a month's time for better learning outcomes.

  • How can I get my Doubts clarified?

    You would be using our ' Discord Community' for instant doubt clarifications and also weekly 'Mentorship' is done through free webinars on respective courses by our expert educators.