MySQL– For Beginner
Learn to create Database Driven Web Applications using MySQL. Also Get a Deeper knowledge of relational databases & Manage the MySQL applications more efficiently
Ratings
4.7
Content Duration
5 hours+
Taught By
Industry expert
Students enrolled
5200+
Teaching Language
ಕನ್ನಡ
Course Type
Pre recorded
Who is this course for
What The Job Opportunities Available
With this skill you can get into roles like:
Data Analyst
Business Analyst
Financial Analyst
Product Manager
Database Administrator
Course content
- Welcome Message
- Course Preview
- Welcome to this course
- What is Database?
- Join Developer Community
- Installing MySQL
- Alternative MySQL Installation
- Xampp-2
- 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
- Referral Program
- Aggregate Functions
- CONCAT()
- REPLACE()
- SUBSTRING()
- CHAR_LENGTH()
- UPPER()
- 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
- foreign key
- large dataset
- Data types Integer and String
- DATE, DATETIME and JSON
- date time code
- Types of JOINS
- INNER JOIN
- Relationships in MYSQL
- join 3 tables
- LEFT JOIN
- Right Join
- OUTER JOINS & UNIONS
- Views
- Indexes
- Assignment Info
- Certification Instructions
- Referral Program
Completion Certificate by MicroDegree
What Our students say
Step by step explanation is good... I liked it very much as it is easy to remember. Best part is which made entire concepts easily understandable. 🔥💯
Lokesh
Good that we are learning in our mother tongue. we can learn each and every concept without any difficulty. Mani sir explained well Sir gave real life example which helped me lot, now I am confident apply for the new job. Learn from expert trainers from top companies
Praveen
This is fantastic course for the beginners. I am from Non IT Background swalpanu confusing anislila, trainer Mani sari sakkathag helkottru. Neat and Clean Training
Nagaraj
Nam mathru bashe kannadadali irodrinda thumba sulubhavagi artha agide. Trainer ge mathu entire Microdegree team ge thumane thanks, heege kannadigarige use ago antha course madtha iri nammavru it field li belibeku ❤️ ಜೈ ಕನ್ನಡ
Nethra
Concepts are fully covered with neat explanation . A very good simplified curated course for Beginners. Plus point is learning this skill in ಕನ್ನಡ, Englishalli kaliyodkintha thumabne fast aagi kalthi, thanks microdegree 😀
Sujatha
Learn from expert trainers from top companies
Learn from our Expert Instructor
.png)
Manikanta A Nayar
Co-founder & COO | MicroDegree
Manikanta is an Engineering graduate from PA College of Engineering and has 3+ years of industry experience building scalable enterprise applications. He has expertise across MySQL, JavaScript and MERN stack. Manikanta was a Regional Co-ordinator at Free Software Movement Karnataka (FSMK) Mangalore, and has conducted more than a dozen technical workshops and seminars. He believes learning technology in Kannada gives better clarity in concepts and foundations thereby enhances the employability rate of local engineering talent.
Frequently asked questions
This MySQL course has been thoughtfully designed to provide you with a wide range of skills.
1 MySQL Basics
2 Advanced SQL queries
3 Datatypes
4 JOINS
5 Indexes
6 Advanced Concepts in RDBMS
This is a 5+ hour pre recorded video course which you can access from anywhere, anytime and learn at your own pace without disturbing your busy schedule.
Yes, You will get a certificate from Microdegree post course completion.
Yes definitely, this course takes you on a learning journey from absolute basics to all the way up to advanced features. So anyone can learn this course even if you do not have any prior coding experience.
After making the payment, your account will automatically create in our learning portal. You will get the login credentials of the learning portal via mail instantly just after your enrollment to the course.
Kindly email us at hello@microdegree.work & our support team will get back to you as soon as possible.
We are supported by
