Capturing Logic with Stored Procedures in MariaDB

Focused View

Pinal Dave

1:08:49

35 View

1. Course Overview

1. Course Overview.mp4

01:19

2. Getting Started with Stored Procedures

1. Version Check.mp4

00:15

2. Introduction.mp4

00:51

3. Stored Procedures.mp4

01:09

4. Advantages of Stored Procedures.mp4

05:04

5. Syntax - Create Stored Procedure.mp4

01:09

6. Demo - Create First Stored Procedure.mp4

09:38

7. Demo - Replace Stored Procedure.mp4

02:37

8. Summary.mp4

00:44

3. Applying Parameters in Stored Procedures

1. Introduction.mp4

01:10

2. Parameters in Stored Procedures.mp4

03:40

3. Demo - Stored Procedures with Parameters - IN.mp4

05:02

4. Demo - Stored Procedures with Parameters - OUT.mp4

05:21

5. Demo - Stored Procedures with Parameters.mp4

03:17

6. Summary.mp4

00:55

4. Returning Information from Stored Procedures

1. Introduction.mp4

00:53

2. Nested Stored Procedures.mp4

02:08

3. Demo - Nested Stored Procedures.mp4

04:38

4. Demo - Nested Stored Procedures with Parameters.mp4

11:52

5. Summary.mp4

00:57

5. Summary

1. Summary.mp4

01:40

2. Demo - Information Schema.mp4

03:19

3. Three Important Resources.mp4

01:11

Description

In this course, you’ll get started with Maria DB stored procedures, look into complex business logic inside stored procedures, and learn how to efficiently shape data per business requirements.

What You'll Learn?

Stored Procedures are very powerful for retrieving or updating data from tables, which is one of the most important routines for DBAs and developers when dealing with set-based operations.

In this course, Capturing Logic with Stored Procedures in MariaDB, you’ll gain the ability to work with complex business logic inside stored procedures.

First, you’ll learn how to create stored procedures.

Next, you’ll discover how to use various different parameters in stored procedures.

Finally, you’ll explore how to work with multiple stored procedures together and return various different information from the stored procedures.

When you’re finished with this course, you’ll have the skills and knowledge of stored procedures needed to work with complex business logic.

Software required: MariaDB

More details

User Reviews

Rating

average 0

Total votes0

Focused display

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.