MySQL Certification Course(Kannada)

Content Provider

MicroDegree

Course Level

Intermediate

Mode Of Delivery

Self-Paced

Duration

5 Hours

Certification By

Microdegree

Course Validity

Life-time Access

Course Fee

This is a paid course.

Enroll Now

~~999/-~~ 249/-

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

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

Key Features

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

Career Opportunities

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.

Who Should Attend

No prior coding experience required

Anybody interested in learning coding

Any Degree, Engineering & IT Students

Early Professionals

Frequently Asked Questions

Where can I find courses on the Platform?

After login to KRACKiN(www.krackin.com), you can find courses on the dashboard which are segregated as skill courses, career tracks and also Annual Membership.consisting of 75000 + courses. You can enrol to any of the courses available by selecting the ‘Buy Now’ button.