Master SQL and Databases in 30 Days: A Complete Guide

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

Learn SQL and Database Management from Scratch: Master Queries, Data Analysis, and Optimization in Just 30 Days

1 - DAY 01 Introduction to SQL

1 -Understanding SQL and its Importance

2 -Setting Up Your Local SQL Environment and Running Your First Database

3 - Resources.html

3 - SQL Code Running Your First Database.html

2 - DAY 02 Understanding Databases and Tables

1 -Database Structure and Table Relationships

2 -Hands-on Project Creating Databases and Tables in SQL

3 -Hands-on Project Verifying Structure and Relationships

4 - SQL CODE Database Structure and Table Relationships.html

3 - DAY 03 Using the SELECT Statement

1 -Purpose and Syntax of SELECT

2 -Hands-on Project Querying Data from Tables in SQL

3 -Hands-on Project Use SELECT with Aggregate Functions

4 - SQL CODE Querying Data from Tables in SQL.html

4 - DAY 04 WHERE Clause and Logical Operators

1 -Filtering Data with WHERE Clause

2 -Hands-on Project Applying Logical Operators in SQL Queries

3 - SQL CODE Applying Logical Operators in SQL Queries.html

5 - DAY 05 Sorting Data with ORDER BY

1 -Sorting Data Using ORDER BY

2 -Hands-on Project Writing Queries with ORDER BY

6 - DAY 06 Using LIMIT & OFFSET

1 -Understanding LIMIT & OFFSET

2 -Hands-on Project Limiting Query Results

7 - DAY 07 Using Aggregate Functions

1 -Overview of Aggregate Functions

2 -Hands-on Project Applying Aggregate Functions to Data

8 - DAY 8 GROUP BY Clause

1 -Grouping Data with GROUP BY

2 -Hands-on Project Applying Aggregate Functions to Groups

9 - DAY 9 HAVING Clause

1 -Filtering Groups with HAVING

2 -Hands-on Project Applying Filters to Grouped Data

10 - DAY 10 JOINs

1 -Hands-on Project Joining Multiple Tables

11 - DAY 11 Subqueries

1 -Understanding Subqueries

2 -Hands-on Project Writing Subqueries in SQL

12 - DAY 12 Working with CASE Statements

1 -Understanding CASE Statements

2 -Hands-on Project Writing Conditional SQL Queries

13 - DAY 13 Self-Joins

1 -Understanding Self-Joins

2 -Hands-on Project Writing Queries with Self-Joins

14 - DAY 14 UNION & UNION ALL

1 -Combining Result Sets with UNION

2 -Hands-on Project Merging Results from Multiple Queries

15 - DAY 15 Understanding Indexes

1 -Introduction to Indexing in Databases

2 -Hands-on Project Creating and Managing Indexes

139,000 تومان

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

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

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

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