Master SQL: From Beginner to Expert

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

Your Ultimate Path to SQL Expertise: Real-World Projects and Techniques in MSSQL

1 - Introduction

1 - Course Introduction

2 - Section 1 Introduction to SQL.html

2 - Untitled-video-Made-with-Clipchamp-1

3 - Setting Up the Environment

4 - Understanding Databases

2 - Basic SQL Concepts

5 - Create Manual DB Table

6 - 1Introduction to SQL Syntax

6 - Data-examples.xlsx

7 - 2Working more SELECT Statements

8 - Insert Command

9 - More into Insert

10 - Update Command

11 - Delete Command

3 - Functions

12 - String functions

12 - String-functions.txt

13 - Date Functions

14 - Aggregate functions

14 - aggregation-function.txt

15 - Mathematicla functions

15 - mathematioal-functions.txt

16 - Conditional Functions

4 - Intermediate SQL

17 - 1Joins and Relationships

17 - joins.txt

18 - Joins Practise Task

18 - Solutions.docx

18 - task-joins.txt

19 - 2Subqueries

19 - subquerries.txt

20 - Rank function

21 - View

22 - Error Handling

22 - error-handling.txt

5 - Advanced SQL Concepts

23 - Window functions

23 - windows-functions.txt

24 - Unions

24 - Unions.txt

25 - 2Advanced Subqueries

25 - Subquerries.txt

26 - Temporary tables

26 - Temporary-tables.txt

27 - CTE.txt

27 - Common Table Expression CTE

28 - Functions UserDefined Functions

28 - User-defined-functions.txt

29 - TableValued Functions TVFs

29 - Table-valued-functions.txt

30 - Stored Procedure

30 - Stored-procedure.txt

6 - SQL Performance Optimization

31 - Normalization and Denormalization

32 - Creating and Managing Indexes

32 - Creating-and-Managing-Indexes.txt

33 - Query Optimization Techniques

33 - querry-optimization-consepts.txt

7 - RealWorld Projects and Applications

34 - 1Project 1 Building a Simple Ecommerce Database.html

35 - 2Project 2 Data Analysis with SQL.html

8 - Expressing Gratitude and Offering Support

36 - Expressing Gratitude and Offering Support.html

189,000 تومان

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

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

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

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