Introduction & Features

SQL vs NoSQL

Installing MySQL on Windows

Create a Database

Create a Table

Insert Records

SELECT Statement

SELECT DISTINCT Statement

WHERE Clause 

Not Null Constraint

Primary Key Constraint

Foreign Key Constraint

Unique Constraint

Default Constraint

Check Constraint

Alter table & add a new column

Drop a column

Modify a column

AND Operator

OR Operator

NOT Operator

IN operator

LIKE Operator

BETWEEN Operator

CASE Statement

Comments

sum() function

avg() function

count() function

max() function

min() function

UPDATE Statement

DELETE Statement

ORDER BY Statement

LIMIT Clause

Alias

Auto Increment

Indexes

Create, Drop & Show Indexes

INNER, LEFT and RIGHT Joins

DROP Table Command

DROP DATABASE Command

Untitled item

Learn MySQL with live running queries and examples

Amit started his own venture Studyopedia in 2018, to create, publish and sell programming courses to top E-Learning companies/websites, on today's trending technologies, including Python, Data Science, Machine Learning, etc. Has left a job offer from Accenture to follow his dream of being an entrepreneur. He is also having extensive experience in creating courses (Video + Text) for engineers and working IT professionals.

Amit Diwan

This comprehensive course is perfect for beginners who want to master the fundamentals of a relational database management system (RDBMS). MySQL forms the foundation for SQL and modern database systems like MS SQL Server, Microsoft Access, and Oracle. Throughout this course, you'll dive deep into MySQL, exploring its features, installation process, and practical applications.

The course is thoughtfully structured to guide you through the essentials of MySQL, starting with an introduction to its key features. You'll learn how to set up and install MySQL, creating a solid foundation for your learning journey. From there, you'll progress to creating new databases and tables, performing various operations, and executing live-running queries. With plethora of examples and hands-on exercises, you'll gain practical experience and confidence in working with SQL.

To reinforce your understanding and test your newly acquired skills, the course includes quizzes designed to challenge and solidify your knowledge. By the end of this course, you'll have a strong grasp of MySQL and its role in real-world applications. Whether you're a complete beginner or looking to expand your database management skills, this course provides a step-by-step, tutorial-like approach that makes learning MySQL accessible and enjoyable.

Certificate Details

MySQL for Beginners

Course Goals

Amit Diwan