Mode Of Delivery
ಬನ್ನಿ 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
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