Managing MySQL Databases and Stored Procedures

Focused View

Chris Behrens

1:49:41

8 View

1. Course Overview

1. Course Overview.mp4

01:54

02. Working with MySQL Databases

01. Overview.mp4

00:59

02. Introduction to Relational Databases.mp4

03:09

03. Types of Relationships between Tables.mp4

02:38

04. Integrity Constraints.mp4

02:30

05. Data Types in MySQL.mp4

06:22

06. Integrity Constraints and Sequences.mp4

02:55

07. Create a Database Using MySQL.mp4

04:04

08. Create Tables Using MySQL.mp4

06:17

09. Insert Data Using MySQL.mp4

05:39

10. Creating and Using Temporary Tables in MySQL.mp4

03:18

11. Update and Delete Data Using MySQL.mp4

05:53

12. Summary.mp4

01:36

3. Introduction to MySQL Stored Procedures

1. Overview.mp4

00:57

2. Stored Procedures in MySQL.mp4

03:40

3. Create Stored Procedures in MySQL.mp4

05:15

4. Variables and Conditional Control Statements.mp4

04:23

5. Cursor, Loops, and Error Handlers.mp4

05:45

6. Stored Procedures Using Cursors, Loops, and Error Handlers.mp4

03:55

7. Stored Functions in MySQL.mp4

05:03

8. List and Delete Stored Procedures and Functions.mp4

01:22

9. Summary.mp4

01:34

4. Introduction to MySQL Triggers

1. Overview.mp4

01:03

2. Working with Triggers in MySQL.mp4

06:16

3. Managing Triggers in MySQL.mp4

01:08

5. Managing Events in MySQL.mp4

01:32

6. Summary.mp4

01:13

5. Working with MySQL Views

1. Overview.mp4

00:43

2. Introduction to MySQL Views.mp4

06:35

3. Updateable Views in MySQL.mp4

03:03

4. Prevent Bad Updates through Views.mp4

05:49

5. Managing Views in MySQL.mp4

01:26

6. Summary.mp4

01:45

Description

MySQL is one of the most widely used open-source relational database management systems. This course will enable you to kick-start your journey with MySQL and introduce you to various MySQL functionalities to store, retrieve, and manipulate data.

What You'll Learn?

Data is the new fuel of the modern world and almost every aspect of our modern life is influenced by data-driven systems. Therefore, we need efficient database management systems to store, retrieve, and manipulate data. In this course, Managing MySQL Databases and Stored Procedures, you are going to learn how to create databases to store, retrieve, and manipulate data using MySQL.

First, you'll explore the basics of the relational data model and learn how you can design a relational database for an application that requires the storage of data. Next, you'll get hands-on experience with various MySQL functionalities to store, retrieve, and manipulate data. Then, you'll discover the MySQL stored procedures that can be used to write complex logic to manipulate data stored in a database. Finally, you'll learn how to use views in MySQL to ensure data encapsulation and security.

By the end of this course, you’ll have an in-depth knowledge of MySQL statements and stored procedures and you’ll also be capable of designing and managing a relational database using MySQL.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Chris Behrens

Instructor's Courses

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.