SQL Development with MS SQL Server Beginner to Master

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

Learn SQL (Structured Query Language) with MS SQL Server and T-SQL from Mac, Linux or Windows!

1. Introduction

1. Introduction

2. Install List.html

3. Install

4. MacOSLinux SQL Server Install - Notes.html

5. MacOSLinux SQL Server Install

6. Hotkeys and Macros.html

2. SQL Basics Part 1

1. Basics Part 1 Theory

2. Windows Connect to the Database

3. CREATE DATABASE

4. CREATE SCHEMA

5. Scalar Variables notes.html

6. Scalar Variables

7. CREATE TABLE

8. DEFAULT & NULL

9. INSERT

10. SELECT

11. UPDATE

12. ALTER TABLE

13. Custom Types

3. SQL Basics Part 2

1. Basics Part 2 Theory

2. Windows File Location

3. Mac Backup Restore

4. Windows Backup Restore

5. TOP

6. WHERE

7. DELETE

8. UPDATE

9. INTO

10. TRUNCATE

4. SQL Basics Part 3

1. Basics Part 3 Theory

2. ORDER BY

3. DISTINCT

4. GROUP BY

5. AS (Aliases)

6. HAVING

7. Basics Quiz.html

5. SQL Intermediate Part 1

1. Intermediate Part 1 Theory

2. ISNULL & COALESCE

3. NULLIF

4. CAST

5. Convert Code.html

6. CONVERT

7. GETDATE

8. DATEADD

9. DATEDIFF

10. CASE

11. STRING AGG

12. FOR XML PATH & STUFF

6. SQL Intermediate Part 2

1. Intermediate Part 2 Theory

2. INNER JOIN

3. LEFT JOIN

4. RIGHT JOIN

5. FULL JOIN

6. OUTER APPLY

7. CROSS APPLY

8. UNION

9. EXCEPT

10. Intermediate Quiz.html

7. Indexes

1. Indexes Theory

2. Go To Definition

3. CLUSTERED INDEX

4. NONCLUSTERED INDEX

5. UNIQUE

6. PRIMARY KEY

7. COMPOSITE KEY

8. Window Functions

1. Window Function Theory

2. ROW NUMBER

3. RANK

4. DENSE RANK

5. NTILE

6. LAG

7. LEAD

8. FIRST VALUE

9. LAST VALUE

9. SQL Advanced

1. Advanced Theory

2. Stored Procedures - CREATE

3. Stored Procedures - Parameters Part 1

4. Stored Procedures - Parameters Part 2

5. OFFSET

6. Nested Queries

7. Temporary Tables - Creation

8. Temporary Tables - Management

9. IF & ELSE

10. TRANSACTION

10. Congratulations!

1. Congratulations!

235,000 تومان

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

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

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

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