Online Certificate Courses

Virtual Internship




MySQL Certification Course(Kannada)
Categories:
Micro Degree Courses(Kannada)
Best Seller
Description

ಬನ್ನಿ MySQLಅನ್ನು ಸುಲಭವಾಗಿ ಕನ್ನಡದಲ್ಲಿ ಕಲಿಯೋಣ 

Starting with the basics, we cover what is a database, different types of databases, what are tables etc.

Then we move on and create database and tables and add few data to our database.

Next up the most important CRUD operation in our sample table - Insert, Select, Update and Delete query.

Then, we move up to some some important functions in mysql, such as concat, reverse etc with a better understanding and in depth quering experience. Also, focus shifts to distinct, order by count, group by and aggregate function in Mysql.

Meanwhile, course dives into relationship in Mysql and how to relate two tables, what are the different kinds of joins to be implement to fetch related data and much more.

Finally, we take your through advanced topics such as unions and views.

About MicroDegree :
MicroDegree is teachning coding and job-ready skills in Kannada. Our vision is to empower local engineering talent from tier-2,3 region with foundational clarity in Kannada and connect them with right job opportunities at an affordable price

Learning outcome

  • You will be capable on handling relational database
  • You can work on handling real world dataset at workplace
  • You will be capable of designing databses and working as a Backend Engineer
  • You can enter into the world of Data Science and Analytics
Curriculum

Module 1 : Introduction to the course

Welcome to this course, What is Database?, Installing MySQL

Module 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,  Answering questions, Getting specific data, Updating the customers table, Deleting the customers table

Module 3 : Intermediate Section
Aggregate Functions , CONCAT(), REPLACE(), SUBSTRING(), CHAR_LENGTH(),  UPPER(),

Module 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

Module 5 : DATATYPES 
foreign key, largedataset, Data types Integer and String , DATE, DATETIME and JSON,  date time code,

Module 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

Module 7 : Advanced Concepts in RDBMS
Views, Indexes, Transactions

Module 8 : Assignment Section


Who Should Attend

  • No prior coding experience required
  • Anybody interested in learning coding
  • Any Degree, Engineering & IT Students
  • Early Professionals


Job prospect

  • Backend Developer
  • Data Analyst
  • Database Administrator
  • Business Analyst
  • Software Engineer


Certification

  • For Certification, you are given few tasks to modify code in the capstone project and submit the same.
  • Idea is to make sure, you completed the hands-on project and not just watched the video.
  • Complete Instructions are provided at the end of the Tutorials.


FAQ

1. Why is MicroDegree teaching Coding in Kannada?
As students lack conceptual clarity and programming foundations, they end up mugging programs. This results in mediocrity in learning technology stack further and mastering it. MicroDegree aims to create top engineering talent in Software Engineering by simplifying Programming. This is achieved by teaching in our native language - Kannada, with relevant concept clarity, analogies and some local flavour.

2.Will I be writing Code in Kannada?
No, coding would be done using standard IDE in simple English language. But the Course is taught in Kannada for better understanding of fundamentals, concept clarity and analogies.

Demo video link

https://youtu.be/uMcC5UEHf8g



Faculty Profiles
Frequently Asked Questions