Getting Started with MariaDB

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

This course will teach you how to learn MariaDB by installation and configuration from the scratch. You'll also learn how to write efficient queries to retrieve data from multiple tables.

1. Course Overview

1. Course Overview

2. Getting Started

1. Version Check

2. Getting Started with MariaDB

3. Installing and Configuring MariaDB

1. Agenda

2. Installing MariaDB

3. Installing Integrated Development Environment

4. Getting Started with Sample Database

5. Summary

4. Retrieving and Modifying the Data in Single

01. Agenda

02. CRUD Operation

03. CRUD - Create - Syntax

04. CRUD - Retrieve - SELECT Syntax

05. CRUD - Update - INSERT Syntax

06. CRUD - Delete - Syntax

07. Demo - CRUD Operation - Create

08. Demo - CRUD Operation - Insert

09. Demo - CRUD Operation - Insert - Part 2

10. Demo - CRUD Operation - Update

11. Demo - CRUD Operation - Delete

12. Summary

5. Retrieving Data from Multiple Tables Using Joins

01. Agenda

02. SQL Join

03. Inner Join

04. Demo - Inner Join

05. Left Outer Join

06. Demo - Left Outer Join

07. Right Outer Join

08. Demo - Right Outer Join

09. Full Outer Join

10. Demo - Full Outer Join

11. Cross Join

12. Demo - Cross Join

13. Real World Scenario

14. Demo - Real World Scenario

15. Summary

6. Writing Efficient Code with Stored Routines

1. Agenda

2. Stored Routines

3. Advantages of Stored Routines

4. Stored Procedure

5. Demo - Stored Procedure

6. Stored Function

7. Demo - Stored Function

8. Difference and Similarity

9. Summary

7. Learning Resources and Next Step

1. Learning Resources

235,000 تومان

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

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

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

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