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