SQL Essentials with MariaDB: A Beginner’s Guide

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

Navigate the World of Data: Learn SQL from Scrtach

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

5. Installing MariaDB Management Tool

6. Download Sample Database

7. Overview of database concepts.html

8. Overview of MariaDB Data Types.html

9. What is MariaDB.html

10. MariaDB VS MySQL

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

2. CREATE CRUD Operation

3. Adding new data

4. READ CRUD Operation

5. UPDATE CRUD Operation

6. DELETE CRUD Operation

7. Truncating Tables

8. Dropping Tables

9. Removing Duplicates

10. Sorting Data

11. Using Aliases.html

7. Aggregate Functions

1. Introduction to aggregate functions

2. AVG Function

3. COUNT Function

4. MAX Function

5. MIN Function

6. SUM Function

7. GROUP BY Clause

8. HAVING Clause

8. TABLE JOINS

1. Introduction to table joins

2. INNER Join

3. CROSS Join

4. LEFT Join

5. RIGHT Join

9. Querying Data with SQL Operators

1. UNION Operator

2. EXCEPT Operator

3. INTERSECT Operator

4. COMPARISON Operator

5. AND OR Operators

189,000 تومان

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

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

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

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