MySQL Fundamentals

Focused View

Pinal Dave

2:38:20

84 View

1. Introduction

1. Version Check.mp4

00:15

2. Introduction.mp4

02:12

2. Installations and GUI Tools

1. Introduction.mp4

00:58

2. Downloads.mp4

00:45

3. Demo - Installation.mp4

01:28

4. Demo - Installation Part 2.mp4

04:02

5. MySQL Workbench.mp4

00:29

6. Demo - MySQL Workbench.mp4

03:29

7. MySQL Command Line Editor.mp4

00:37

8. Demo - MySQL Command Line Editor.mp4

01:33

9. Summary in Sixty Seconds.mp4

00:24

3. Fundamentals of RDBMS and Database Designs

1. Introduction.mp4

00:54

2. ClientServer System.mp4

01:40

3. Web Application Server.mp4

02:11

4. History of Relational Database Model.mp4

01:05

5. Relational Database Model Concepts.mp4

02:40

6. Relational Database Model Keys.mp4

04:35

7. Column Definition.mp4

02:29

8. Summary in Sixty Seconds.mp4

00:32

04. Introduction MYSQL Workbench

01. Introduction.mp4

00:55

02. MySQL Workbench Features.mp4

01:40

03. Starting MySQL Workbench.mp4

01:39

04. Demo - Opening a New Connection.mp4

02:16

05. Demo - Manage Connections.mp4

02:35

06. Demo - Selecting Data.mp4

00:52

07. Demo - Updating Data.mp4

04:40

08. Demo - Open and Execute SQL File.mp4

01:55

09. Demo - Inserting Data.mp4

01:17

10. Demo - Deleting Data.mp4

00:46

11. Demo - View and Edit Column Definition.mp4

03:22

12. Demo - Creating Snippet.mp4

01:37

13. Demo - Output Window.mp4

00:52

14. Demo - Data Modeling.mp4

01:42

15. Demo - Server Administration.mp4

02:56

16. Demo - Workbench Central.mp4

01:58

17. Summary in Sixty Seconds.mp4

00:41

05. Data Retrieval Techniques

01. Introduction.mp4

01:02

02. Basics of SELECT statement.mp4

01:42

03. Setup for demo.mp4

00:47

04. Beginning SELECT statement.mp4

02:20

05. Demo - Select without FROM clause.mp4

02:20

06. Demo - Retrieve all the data from table.mp4

01:51

07. Demo - Order data based on a column.mp4

01:51

08. Demo - Retrieve selected columns from table.mp4

01:32

09. Demo - Retrieve selected columns and rows.mp4

02:41

10. Demo - Bringing it together.mp4

03:10

11. Demo - Retrieve empty resultset.mp4

00:49

12. Working with Arithmetic Expressions.mp4

01:42

13. Demo - Arithmetic Expressions.mp4

03:13

14. Select statement and other functions.mp4

00:38

15. Demo - Select statement and other functions.mp4

02:35

16. Demo - Select statement and string functions.mp4

03:37

17. Demo - Select statement and date functions.mp4

04:12

18. Demo - Select statement and distinct rows.mp4

01:44

19. Introducing WHERE clause.mp4

00:54

20. Select statement and Comparision Operators.mp4

00:59

21. Demo - Comparision Operators.mp4

04:55

22. Select statement and Logical Operators.mp4

01:09

23. Demo - Logical Operators.mp4

06:40

24. Select statement and WHERE clause.mp4

01:45

25. Demo - Using Between in WHERE clause.mp4

05:18

26. Demo - Using Like in WHERE clause.mp4

04:43

27. Select statement and ORDER BY clause.mp4

00:52

28. Demo - Select statement and.mp4

03:23

29. Retrieving limited rows.mp4

01:00

30. Demo - Retrieving limited rows.mp4

02:03

31. Summary in Sixty Seconds.mp4

00:44

6. Data Modification Techniques

1. Introduction.mp4

00:48

2. Insert Statement.mp4

00:43

3. Demo - Insert Statement.mp4

09:05

4. Update Statement.mp4

00:46

5. Demo - Update Statement.mp4

05:00

6. Delete Statement.mp4

00:34

7. Demo - Delete Statement.mp4

03:12

8. Summary in Sixty Seconds.mp4

00:29

7. Summary and Resources

1. Final Words.mp4

01:31

Description

Fundamentals of MySQL, an essential part of the LAMP stack.

What You'll Learn?

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write basic data retrieval and data modification queries.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.