Getting Started with MariaDB

Focused View

Pinal Dave

2:23:07

52 View

1. Course Overview

1. Course Overview.mp4

01:12

2. Getting Started

1. Version Check.mp4

00:15

2. Getting Started with MariaDB.mp4

09:34

3. Installing and Configuring MariaDB

1. Agenda.mp4

00:40

2. Installing MariaDB.mp4

04:07

3. Installing Integrated Development Environment.mp4

05:05

4. Getting Started with Sample Database.mp4

03:55

5. Summary.mp4

01:17

4. Retrieving and Modifying the Data in Single

01. Agenda.mp4

01:05

02. CRUD Operation.mp4

01:26

03. CRUD - Create - Syntax.mp4

05:09

04. CRUD - Retrieve - SELECT Syntax.mp4

01:50

05. CRUD - Update - INSERT Syntax.mp4

02:37

06. CRUD - Delete - Syntax.mp4

01:41

07. Demo - CRUD Operation - Create.mp4

07:05

08. Demo - CRUD Operation - Insert.mp4

06:08

09. Demo - CRUD Operation - Insert - Part 2.mp4

05:27

10. Demo - CRUD Operation - Update.mp4

04:22

11. Demo - CRUD Operation - Delete.mp4

05:24

12. Summary.mp4

01:35

5. Retrieving Data from Multiple Tables Using Joins

01. Agenda.mp4

01:01

02. SQL Join.mp4

01:48

03. Inner Join.mp4

02:35

04. Demo - Inner Join.mp4

02:39

05. Left Outer Join.mp4

02:31

06. Demo - Left Outer Join.mp4

02:26

07. Right Outer Join.mp4

02:15

08. Demo - Right Outer Join.mp4

02:55

09. Full Outer Join.mp4

02:58

10. Demo - Full Outer Join.mp4

03:25

11. Cross Join.mp4

02:27

12. Demo - Cross Join.mp4

02:25

13. Real World Scenario.mp4

01:28

14. Demo - Real World Scenario.mp4

06:57

15. Summary.mp4

01:19

6. Writing Efficient Code with Stored Routines

1. Agenda.mp4

01:02

2. Stored Routines.mp4

00:59

3. Advantages of Stored Routines.mp4

04:40

4. Stored Procedure.mp4

02:48

5. Demo - Stored Procedure.mp4

09:39

6. Stored Function.mp4

01:48

7. Demo - Stored Function.mp4

06:02

8. Difference and Similarity.mp4

01:42

9. Summary.mp4

01:15

7. Learning Resources and Next Step

1. Learning Resources.mp4

04:09

Description

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.

What You'll Learn?

MariaDB is great for its open-source innovation and enterprise-grade reliability, as well as its modern relational database. It has emerged as a smart alternative to legacy databases. In recent releases, MariaDB Server has become the leading open source database for enterprises closing the gaps with proprietary databases. In this course, Getting Started with MariaDB, you'll learn all the concepts which will help you to get started with MariaDB. First, you'll discover how to install and configure MariaDB. Next, you'll explore how to retrieve and modify the data. Then, you'll learn how to retrieve data using Joins. Finally, you'll figure out how to write efficient code and learn resources. By the end of this course, you'll have a solid foundation to get started developing applications with MariaDB.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Pinal Dave

Instructor's Courses

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.