Managing MySQL Databases and Stored Procedures

سرفصل های دوره

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.

1. Course Overview

1. Course Overview

02. Working with MySQL Databases

01. Overview

02. Introduction to Relational Databases

03. Types of Relationships between Tables

04. Integrity Constraints

05. Data Types in MySQL

06. Integrity Constraints and Sequences

07. Create a Database Using MySQL

08. Create Tables Using MySQL

09. Insert Data Using MySQL

10. Creating and Using Temporary Tables in MySQL

11. Update and Delete Data Using MySQL

12. Summary

3. Introduction to MySQL Stored Procedures

1. Overview

2. Stored Procedures in MySQL

3. Create Stored Procedures in MySQL

4. Variables and Conditional Control Statements

5. Cursor, Loops, and Error Handlers

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

7. Stored Functions in MySQL

8. List and Delete Stored Procedures and Functions

9. Summary

4. Introduction to MySQL Triggers

1. Overview

2. Working with Triggers in MySQL

3. Managing Triggers in MySQL

5. Managing Events in MySQL

6. Summary

5. Working with MySQL Views

1. Overview

2. Introduction to MySQL Views

3. Updateable Views in MySQL

4. Prevent Bad Updates through Views

5. Managing Views in MySQL

6. Summary

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight