Udemy - SQL Essentials with MariaDB - A Beginner's Guide

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size1.1 GB
  • Uploaded Byfreecoursewb
  • Downloads28
  • Last checkedMar. 03rd '24
  • Date uploadedMar. 02nd '24
  • Seeders 11
  • Leechers17
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : E531F27D4A3F4E353D9E60A96F22DBAE6A3F28C7

SQL Essentials with MariaDB: A Beginner's Guide

https://DevCourseWeb.com

Published 2/2024
Created by 247 Learning
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 56 Lectures ( 3h 53m ) | Size: 1.14 GB

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

Requirements:
No prior experience with SQL or databases is required.
Basic understanding of computer operations and software installation.

Files:

[ DevCourseWeb.com ] Udemy - SQL Essentials with MariaDB - A Beginner's Guide
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction to Databases and MariaDB
    • 1. Introduction.html (3.1 KB)
    • 10. MariaDB VS MySQL.mp4 (7.3 MB)
    • 11. Overview of SQL.html (4.1 KB)
    • 12. What are schemas.html (3.7 KB)
    • 2. Understanding Databases - Concepts and Necessities.html (4.1 KB)
    • 3. Introduction to MariaDB - History and Features.html (4.1 KB)
    • 4. Installing MariaDB and Setting Up Your Environment.mp4 (35.5 MB)
    • 5. Installing MariaDB Management Tool.mp4 (37.3 MB)
    • 6. Download Sample Database.mp4 (46.8 MB)
    • 7. Overview of database concepts.html (4.1 KB)
    • 8. Overview of MariaDB Data Types.html (5.0 KB)
    • 9. What is MariaDB.html (3.7 KB)
    2. SQL Basics
    • 1. Introduction to SQL Understanding Its Role and Syntax.html (3.7 KB)
    • 2. Data Types and Tables in MariaDB.html (3.8 KB)
    • 3. Basic CRUD Operations CREATE, READ (SELECT), UPDATE, DELETE.html (2.6 KB)
    • 4. Understanding Primary Keys and Foreign Keys.html (3.4 KB)
    3. Intermediate SQL Operations
    • 1. Advanced SELECT Filtering, Sorting, and Functions.html (3.9 KB)
    • 2. Joins and Unions Combining Data from Multiple Tables.html (3.5 KB)
    • 3. Grouping Data and Aggregate Functions.html (3.8 KB)
    • 4. Using Subqueries and Views.html (3.7 KB)
    • 5. NULL Values.html (3.5 KB)
    4. Database Design and Management
    • 1. Normalization and Database Design Principles.html (3.9 KB)
    • 2. Indexing for Performance.html (3.4 KB)
    • 3. Introduction to Stored Procedures and Triggers.html (3.7 KB)
    5. Real-World Applications and Best Practices
    • 1. Designing a Simple Database Project.html (4.0 KB)
    • 2. Security Best Practices in MariaDB.html (4.4 KB)
    • 3. Performance Optimization Tips.html (4.4 KB)
    6. MARIADB CRUD Operations
    • 1. Introduction.mp4 (4.0 MB)
    • 10. Sorting Data.mp4 (45.2 MB)
    • 11. Using Aliases.html (3.5 KB)
    • 2. CREATE CRUD Operation.mp4 (74.0 MB)
    • 3. Adding new data.mp4 (56.3 MB)
    • 4. READ CRUD Operation.mp4 (54.3 MB)
    • 5. UPDATE CRUD Operation.mp4 (37.5 MB)
    • 6. DELETE CRUD Operation.mp4 (18.2 MB)
    • 7. Truncating Tables.mp4 (17.9 MB)
    • 8. Dropping Tables.mp4 (20.4 MB)
    • 9. Removing Duplicates.mp4 (28.2 MB)
    7. Aggregate Functions
    • 1. Introduction to aggregate functions.mp4 (12.0 MB)
    • 2. AVG Function.mp4 (29.0 MB)
    • 3. COUNT Function.mp4 (50.2 MB)
    • 4. MAX Function.mp4 (22.4 MB)
    • 5. MIN Function.mp4 (21.9 MB)
    • 6. SUM Function.mp4 (20.3 MB)
    • 7. GROUP BY Clause.mp4 (43.8 MB)
    • 8. HAVING Clause.mp4 (36.8 MB)
    8. TABLE JOINS
    • 1. Introduction to table joins.mp4 (15.8 MB)
    • 2. INNER Join.mp4 (66.8 MB)
    • 3. CROSS Join.mp4 (43.5 MB)
    • 4. LEFT Join.mp4 (46.8 MB)
    • 5. RIGHT Join.mp4 (66.8 MB)
    9. Querying Data with SQL Operators
    • 1. UNION Operator.mp4 (40.6 MB)
    • 2. EXCEPT Operator.mp4 (48.2 MB)
    • 3. INTERSECT Operator.mp4 (20.6 MB)
    • 4. COMPARISON Operator.mp4 (58.8 MB)
    • 5. AND OR Operators.mp4 (44.3 MB)
    • Bonus Resources.txt (0.4 KB)

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce