MySQL Course with 100+ Examples
Learn MySQL with 100+ live running queries and examples
Updated on Aug, 2023
Language - English
MySQL,Databases,Database Design & Development,Database Management,Database Programming
Lectures -42
Resources -27
Quizzes -15
Duration -2 hours
Course Description
Welcome to our MySQL Course!!!
In this Video Course, learn MySQL and its concept. MySQL is a relational database management system (RDBMS). RDBMS is the basis for SQL, and for all modern database systems such as MySQL, MS SQL Server, Microsoft Access, Oracle, etc. We have covered MySQL in this course. The course is for beginners and consists of more than 100+ live running queries, including creating new databases and tables.
The course begins with MySQL Introduction and Features. Then, we have shown how to set up and install it on both Windows. We proceed further with creating a new database and table, to perform various operations on it. With that, we have also covered live-running queries in every lesson.
Note: The flow would be step-by-step and the explanations would include a tutorial-like format, to make it easier for beginners to understand a new database and table and its concepts, with live running queries as examples. With that, we have also created some quizzes to polish your MySQL skills.
**Course Highlights**
40+ lessons
2h 20min video course with live running examples
100+ examples
15 Quizzes to polish your skills after learning from the lessons
While learning, you will get an opportunity to work on various hands-on exercises and understand the role of databases in a real-world application.
Hit the Enroll Button!
Goals
What will you learn in this course:
- Learn how to work with Databases from scratch
- Get a MySQL Crash Course (2022)
- Learn how to query SQL, since MySQL is SQL-based
- Maintaining the Database
- Writing optimal queries
Prerequisites
What are the prerequisites for this course?
Basic knowledge of Computer usage
Basic knowledge of a Database
Curriculum
Check out the detailed breakdown of what’s inside the course
MySQL Introduction
3 Lectures
-
Course Promo
00:33
00:33
-
Introduction & Features
03:48
03:48
-
MySQL vs MongoDB
03:25
03:25
MySQL Installation and Setup
1 Lectures
Create and Insert
3 Lectures
Select Records in MySQL
3 Lectures
Constraints in MySQL
6 Lectures
Alter a Table in MySQL
3 Lectures
Operators in MySQL
6 Lectures
CASE Statement in MySQL
1 Lectures
Comments in MySQL
1 Lectures
Built-in Functions in MySQL
5 Lectures
MySQL Statements
2 Lectures
Order Records in MySQL
1 Lectures
Limit Records in MySQL
1 Lectures
MySQL Alias
1 Lectures
MySQL Auto Increment
1 Lectures
MySQL Indexes
1 Lectures
MySQL Joins
1 Lectures
Drop Table and Database
2 Lectures
MySQL Quiz
1 Lectures
Instructor Details
Studyopedia
Never Stop LearningStudyopedia is an E-Learning website providing video courses, interview questions, and quizzes. Tutorials cover programming languages, databases, frameworks, etc. i.e. Python, Data Science, Machine Learning, Java, Android, C, C++, HTML5, Bootstrap, JavaScript, jQuery, PHP, CSS, WordPress, Drupal, Joomla, Magento, osCommerce, OpenCart, PrestaShop, etc.
We have taught millions of students and professionals through our video courses, website, and content, covering multiple programming languages and technologies.
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now