Developing with MySQL

Focused View

Agaba Philip

2:15:09

6 View

1. Course Overview

1. Course Overview.mp4

00:52

2. Developing with MySQL

1. Introduction.mp4

03:03

2. Installing MySQL on Windows, Mac, and Linux.mp4

03:21

3. Creating the Databases.mp4

02:26

3. Views

1. Creating Views.mp4

02:55

2. Altering and Dropping Views.mp4

02:03

3. Updateable Views.mp4

05:07

4. Stored Procedures

1. Stored Procedures.mp4

05:59

2. Procedure Parameters.mp4

03:44

3. Parameter Validation.mp4

02:43

4. Variables.mp4

01:27

5. Triggers and Events

1. Triggers and Events.mp4

02:53

2. Viewing Triggers.mp4

00:27

3. Events.mp4

01:50

4. Viewing, Dropping, and Altering Events.mp4

01:42

6. Transactions and Concurrency

1. Transactions and Concurrency.mp4

02:56

2. Creating Transactions.mp4

02:55

3. Concurrency and Locking.mp4

03:24

4. Problems with Concurrency.mp4

06:14

5. Isolation Level Read Uncommitted.mp4

01:45

6. Isolation Level Read Committed.mp4

01:47

7. Isolation Level Repeatable Read.mp4

02:50

8. Isolation Level Serializable.mp4

01:08

9. Deadlocks.mp4

01:22

10. Summary.mp4

02:00

7. Data Types

1. Data Types Strings.mp4

01:29

2. Data Types Integers.mp4

00:56

3. Data Types Rationals.mp4

00:59

4. Data Types Boolean.mp4

00:52

5. Data Types Date and Time.mp4

00:56

8. Database Design

1. Database Design.mp4

01:14

2. Data Modelling.mp4

01:52

3. Conceptual Models.mp4

02:30

4. Relationships - One-to-one.mp4

02:50

5. Relationships - One-to-many.mp4

01:04

6. Relationships - Many-to-many.mp4

01:29

7. Logical Models.mp4

02:12

8. Physical Models.mp4

03:04

9. Primary Keys.mp4

02:19

10. Foreign Keys.mp4

02:13

11. Foreign Key Constraints.mp4

02:21

12. 1NF First Normal Form.mp4

05:14

13. 2NF Second Normal Form.mp4

01:40

14. 3NF Third Normal Form.mp4

01:40

15. Forward Engineering a Model.mp4

01:41

9. Indexing for High Performance

1. Indexing for High Performance.mp4

02:16

2. Creating Indexes.mp4

02:54

3. Viewing Indexes.mp4

02:03

4. Prefix Columns.mp4

03:10

5. Composite Indexes.mp4

02:00

6. Composite Indexes Order of Columns.mp4

01:29

7. When Indexes Are Ignored.mp4

01:22

8. Covering Indexes.mp4

01:14

9. Maintaining Indexes.mp4

01:30

10. Data Security

1. Data Security.mp4

02:08

2. Dropping Users, Changing Passwords.mp4

02:15

3. Granting Privileges to Users.mp4

02:08

4. Granting Privileges to Apps.mp4

05:12

Description

MySQL is the most popular open source DBMS for the enterprise. It also powers more than 30% of the web. In this course, you’ll learn to develop enterprise-level MySQL-backed applications from a data centric point of view.

What You'll Learn?

If you’re tired of having to piece together disconnected tutorials and wish to master MySQL the easy way, this is the course you need. In this course, Developing with MySQL, through a series of bite-sized, easy-to-follow clips that cover both theory and practice, you'll become an expert MySQL developer. First, you'll work with Views, Stored Procedures, Triggers, and Events. Next, you’ll explore Transactions, Concurrency, Data Types, and Database Design. Finally, you'll delve into indexing for high performance and security. By the end of this course, you’ll be able to manage even the most ambitious MySQL projects with confidence and ease.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Agaba Philip

Instructor's Courses

I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pastime.

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.