The Ultimate MySQL : Go from SQL Beginner to Advanced

Focused View

Jayanta Sarkar

5:54:45

7 View

1. Introduction

1. Introduction.mp4

02:48

2. what is MySQL.mp4

05:53

3. What does SQL stand for.html

2. MySQL Installation & Workbench Tutorial

1.1 01.zip

1. MySQL Installation & Workbench Tutorial.mp4

10:40

3. MySQL Table Tutorial

1.1 02.zip

1.2 code.zip

1. MySQL Create Table Tutorial.mp4

13:24

2.1 code.zip

2. MySQL Insert Tutorial.mp4

05:22

3.1 code.zip

3. MySQL INSERT Multiple Rows Tutorial.mp4

05:27

4. Which SQL statement is used to insert new data in a database.html

4. MySQL Constraints Tutorial

1.1 code.zip

1. MySQL Constraints Tutorial.mp4

13:14

2.1 code.zip

2.2 code2.zip

2.3 code3.zip

2. MySQL SELECT With WHERE Clause Tutorial.mp4

09:19

3. With SQL, how do you select a column named FirstName from a table named.html

4. Which SQL statement is used to extract data from a database.html

5. MySQL Operators

1.1 code.zip

1. MySQL AND, OR, NOT Operators.mp4

08:58

2.1 code.zip

2. MySQL In Operators.mp4

05:48

3. With SQL, how do you select all the columns from a table named Persons.html

4.1 code.zip

4. MySQL BETWEEN & NOT BETWEEN Operator Tutorial.mp4

06:34

5.1 code.zip

5. MySQL LIKE Operator & Wildcards.mp4

09:40

6. With SQL, how do you select all the records from a table named Persons where t.html

6. MySQL Regular Expression

1.1 code.zip

1. MySQL Regular Expression.mp4

12:02

7. MySQL ORDER BY & DISTINCT AND IS NULL

1.1 code.zip

1. MySQL ORDER BY & DISTINCT.mp4

08:04

2.1 code.zip

2. MySQL IS NULL & IS NOT NULL.mp4

03:12

8. LIMIT & OFFSET Tutorial

1. LIMIT & OFFSET Tutorial.mp4

06:07

9. MySQL Count Sum Min Max Avg Tutorial

1.1 code.zip

1. MySQL Count Sum Min Max Avg Tutorial.mp4

06:12

10. MySQL UPDATE

1. MySQL UPDATE.mp4

06:40

2. Which SQL statement is used to update data in a database.html

11. MySQL COMMIT & ROLLBACK

1. MySQL COMMIT & ROLLBACK.mp4

02:26

2. MySQL COMMIT & ROLLBACK PART II.mp4

05:58

3. With SQL, how do you select all the records from a table named Persons where t.html

12. MySQL DELETE

1. MySQL DELETE.mp4

04:30

2. Which SQL statement is used to delete data from a database.html

13. MySQL PRIMARY KEY & FOREIGN KEY AND JOINS

1.1 city table data.zip

1.2 city table.zip

1.3 personal table.zip

1. MySQL PRIMARY KEY & FOREIGN KEY.mp4

13:44

2.1 code.zip

2.2 personal table data.zip

2. MySQL INNER JOIN Tutorial.mp4

08:58

3.1 left join code.zip

3. MySQL LEFT JOIN.mp4

10:25

4. MySQL RIGHT JOIN.mp4

02:12

5. MySQL CROSS JOIN.mp4

03:48

6. MySQL JOIN Multiple Tables.mp4

08:11

14. MySQL GROUP BY & HAVING Clause Tutorial

1. MySQL GROUP BY & HAVING Clause Tutorial.mp4

09:35

2.1 SQL.txt

2. MySQL SubQuery with EXISTS & NOT EXISTS.mp4

09:02

15. MySQL UNION & UNION ALL

1.1 SQL.txt

1. MySQL UNION & UNION ALL.mp4

11:00

16. MySQL IF AND CASE Statement

1. MySQL IF Statement.mp4

05:18

2. MySQL CASE Statement.mp4

08:40

17. MySQL Arithmetic Functions

1. MySQL Arithmetic Functions Intro.mp4

03:24

2. MySQL Arithmetic Functions.mp4

11:11

18. MySQL String Functions

1.1 SQL.txt

1. MySQL String Functions part 1.mp4

10:20

2. MySQL String Functions part 2.mp4

11:35

3. MySQL String Functions part 3.mp4

06:46

19. MySQL Date Functions

1. MySQL Date Functions Part 1.mp4

07:13

2. MySQL Date Functions Part 2.mp4

07:48

3. MySQL Date Functions Part 3.mp4

12:54

20. MySQL Time Functions Tutorial

1. MySQL Time Functions Tutorial.mp4

05:09

2. MySQL Time Functions Tutorial Part2.mp4

07:56

21. MySQL ALTER Tutorial

1. MySQL ALTER Tutorial.mp4

03:37

2. MySQL ALTER Tutorial part 2.mp4

06:35

22. MySQL DROP & TRUNCATE Table Tutorial

1. MySQL DROP & TRUNCATE Table Tutorial.mp4

03:24

23. MySQL VIEW Tutorial

1.1 SQL.txt

1. MySQL VIEW Tutorial.mp4

07:08

2. MySQL VIEW EDIT Tutorial.mp4

03:17

3. MySQL VIEW EDIT Tutorial.mp4

03:17

Description

Master the Database Journey: From SQL Novice to MySQL Maestro in The Ultimate MySQL Course!

What You'll Learn?

Create your own database or interact with existing databases
Write complex SQL join queries across multiple tables
In-depth knowledge of database design will give students an edge over other applicants.
Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.

Who is this for?

Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today's most in-demand skills

Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.

Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL

What You Need to Know?

No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.

All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.

More details

Description
Unlock the power of relational databases with "The Ultimate MySQL: Go from SQL Beginner to Advanced." This comprehensive course is designed to guide you through the intricacies of MySQL, from the fundamentals of SQL to advanced database management.
Starting with the basics, you'll gain a solid understanding of SQL syntax, database design, and data manipulation. As you progress, you'll delve into the core principles of MySQL, mastering essential concepts like table relationships, indexing, and normalization. Hands-on exercises and real-world examples will reinforce your learning, ensuring you can confidently design and query databases.
The course goes beyond the basics, introducing you to advanced MySQL features and optimization techniques. Learn to optimize queries for performance, implement stored procedures and triggers, and explore transaction management. Dive into security best practices to safeguard your databases and gain insights into troubleshooting common issues.
By the end of the course, you'll not only be fluent in SQL but also possess the skills to architect and manage complex MySQL databases. Whether you're a beginner looking to build a strong foundation or an experienced professional aiming to enhance your database management skills, "The Ultimate MySQL" is your gateway to becoming a proficient and advanced SQL practitioner. Enroll now and elevate your database expertise to new heights.
Who this course is for:
Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today's most in-demand skills
Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Jayanta Sarkar

Instructor's Courses

Hi, I am Jayanta! I am a Python programmer and web developer. I have worked with companies both as an employee and self-employed. I have used Python language to develop both website and web applications.I will teach you how you can use Python, just like I do. The easiest way to learn something is to work on it. The more you exercise on this subject, the more you will learn. I take care to explain the programming concepts assuming my students do not have a computer science background. Indeed, you do not need a computer science degree to become a programmer.I graduated with a computer science technology from the University of North Bengal in India. Try out my courses, and you will be in for an exciting ride.

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.