MySQL Course for Beginners

Focused View

Studyopedia Trainings

1:58:11

6 View

1. MySQL Introduction

1. Introduction & Features.mp4

03:48

2. SQL vs NoSQL.mp4

03:25

2. MySQL Installation and Setup

1. Install MySQL on Windows.mp4

09:07

3. Create and Insert

1. Create a Database.mp4

01:55

2. Create a Table.mp4

03:54

3. Insert Records.mp4

06:23

4. Select Records in MySQL

1. SELECT Statement in MySQL.mp4

03:28

2. SELECT DISTINCT Statement in MySQL.mp4

02:06

3. WHERE Clause in MySQL.mp4

03:13

5. Constraints in MySQL

1. Not Null Constraint.mp4

03:58

2. Primary Key Constraint.mp4

03:16

3.1 foreign key.txt

3. Foreign Key Constraint.mp4

02:51

4. Unique Constraint.mp4

01:44

5. Default Constraint.mp4

03:01

6. Check Constraint.mp4

03:46

6. Alter a Table in MySQL

1. Alter table and add a new column.mp4

01:39

2. Alter table and drop a column.mp4

01:53

3. Alter table and modify a column.mp4

03:18

7. Operator in MySQL

1. AND Operator.mp4

02:38

2. OR Operator.mp4

03:16

3. NOT Operator.mp4

02:38

4. IN Operator.mp4

02:47

5.1 Like Operator.txt

5. LIKE Operator.mp4

06:24

6. BETWEEN Operator.mp4

02:51

8. Comments in MySQL

1. Add a comment in MySQL.mp4

02:57

9. Built-in Functions

1. MySQL sum() function.mp4

02:08

2. MySQL avg() function.mp4

01:36

3. MySQL count() function.mp4

02:47

10. MySQL Statements

1. UPDATE Statement.mp4

03:23

2. DELETE Statement.mp4

02:58

11. Order Records in MySQL

1. ORDER BY Statement.mp4

02:42

12. Limit records in MySQL

1. How to select limited records with the LIMIT Clause.mp4

01:55

13. MySQL Indexes

1. Create, Drop and Show indexes.mp4

04:05

14. MySQL Joins

1.1 Joins.txt

1. INNER, LEFT and RIGHT Joins.mp4

06:56

15. Drop Table and Database

1. DROP TABLE Command.mp4

01:53

2. DROP DATABASE Command.mp4

01:32

3. MySQL Quiz.html

Description

Learn MySQL in 2024 with live running queries and examples

What You'll Learn?

Learn how to work with Databases from scratch
Get a MySQL Crash Course (2024)
Learn how to query SQL, since MySQL is SQL-based
Maintaining the Database
Writing optimal queries

Who is this for?

Database Beginners

Web Developers

Application Developers

Programmers

What You Need to Know?

Basic knowledge of Computer usage

More details

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 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. The course is for working with MySQL on Windows.

Course Highlights
36 lessons
2h video 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.
Who this course is for:
Database Beginners
Web Developers
Application Developers
Programmers

User Reviews

Rating

average 0

Total votes0

Focused display

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

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.