SQL Essentials with MariaDB: A Beginner's Guide

Focused View

247 Learning

3:05:28

499 View

1. Introduction to Databases and MariaDB

1. Introduction.html

2. Understanding Databases - Concepts and Necessities.html

3. Introduction to MariaDB - History and Features.html

4. Installing MariaDB and Setting Up Your Environment.mp4

07:21

5. Installing MariaDB Management Tool.mp4

08:02

6. Download Sample Database.mp4

07:14

7. Overview of database concepts.html

8. Overview of MariaDB Data Types.html

9. What is MariaDB.html

10. MariaDB VS MySQL.mp4

02:01

11. Overview of SQL.html

12. What are schemas.html

2. SQL Basics

1. Introduction to SQL Understanding Its Role and Syntax.html

2. Data Types and Tables in MariaDB.html

3. Basic CRUD Operations CREATE, READ (SELECT), UPDATE, DELETE.html

4. Understanding Primary Keys and Foreign Keys.html

3. Intermediate SQL Operations

1. Advanced SELECT Filtering, Sorting, and Functions.html

2. Joins and Unions Combining Data from Multiple Tables.html

3. Grouping Data and Aggregate Functions.html

4. Using Subqueries and Views.html

5. NULL Values.html

4. Database Design and Management

1. Normalization and Database Design Principles.html

2. Indexing for Performance.html

3. Introduction to Stored Procedures and Triggers.html

5. Real-World Applications and Best Practices

1. Designing a Simple Database Project.html

2. Security Best Practices in MariaDB.html

3. Performance Optimization Tips.html

6. MARIADB CRUD Operations

1. Introduction.mp4

01:57

2. CREATE CRUD Operation.mp4

11:06

3. Adding new data.mp4

08:22

4. READ CRUD Operation.mp4

08:29

5. UPDATE CRUD Operation.mp4

06:32

6. DELETE CRUD Operation.mp4

03:46

7. Truncating Tables.mp4

03:20

8. Dropping Tables.mp4

02:55

9. Removing Duplicates.mp4

04:36

10. Sorting Data.mp4

07:34

11. Using Aliases.html

7. Aggregate Functions

1. Introduction to aggregate functions.mp4

03:01

2. AVG Function.mp4

04:09

3. COUNT Function.mp4

06:20

4. MAX Function.mp4

03:04

5. MIN Function.mp4

02:59

6. SUM Function.mp4

03:09

7. GROUP BY Clause.mp4

05:44

8. HAVING Clause.mp4

05:06

8. TABLE JOINS

1. Introduction to table joins.mp4

04:12

2. INNER Join.mp4

09:43

3. CROSS Join.mp4

07:26

4. LEFT Join.mp4

07:04

5. RIGHT Join.mp4

09:16

9. Querying Data with SQL Operators

1. UNION Operator.mp4

07:27

2. EXCEPT Operator.mp4

06:42

3. INTERSECT Operator.mp4

03:43

4. COMPARISON Operator.mp4

06:39

5. AND OR Operators.mp4

06:29

Description

Navigate the World of Data: Learn SQL from Scrtach

What You'll Learn?

Understand Relational Database Concepts
Install and Configure MariaDB
Master Basic SQL Commands
Design Effective Database Schemas:
Execute Advanced Queries
Utilize Aggregate Functions
Implement Indexing for Performance
Manage Database Security
Use Joins Effectively
Create and Use Stored Procedures
Handle NULL Values

Who is this for?

Absolute beginners to SQL and MariaDB

Professionals looking to acquire database management skills

Anyone interested in understanding how databases work

What You Need to Know?

No prior experience with SQL or databases is required.

Basic understanding of computer operations and software installation.

More details

Description
ThisÂ beginner's course is designed to introduce you to the fundamentals of SQL using the MariaDB database system. Whether you're aspiring to become a database administrator, a web developer, or just looking to add database management skills to your repertoire, this course will provide you with a solid foundation in SQL through MariaDB, one of the most popular and robust database systems. By the end of this course, you'll be comfortable executing basic to intermediate SQL queries, managing databases, and understanding how databases can be utilized in real-world applications.
Embark on a journey into the world of databases with "SQL Essentials with MariaDB: A Beginner's Guide," a meticulously crafted course designed to introduce beginners to the foundational skills of database management using MariaDB, one of the most acclaimed open-source relational database management systems. This course aims to transform beginners into confident users of SQL, capable of designing, querying, and managing databases effectively.
Structured to cater to learners with little to no background in databases, this course starts with the basics, gradually advancing to more complex concepts and operations. Participants will explore the architecture of relational databases, understand the role of MariaDB in today's technology landscape, and learn the SQL language's core principles and syntax.

Who this course is for:
Absolute beginners to SQL and MariaDB
Professionals looking to acquire database management skills
Anyone interested in understanding how databases work

User Reviews

Rating

average 0

Total votes0

Focused display

Hello and welcome to 247 Learning.We create online courses that will help you acquire useful and productive technical skills that can be applied to real world jobs. We have over 18,000 students on Udemy that have signed up to our courses . We are continuously adding more courses to our course catalogues. We are looking forward to welcoming you to one or more of our courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.