T-SQL Fundamentals and Beyond: Unlock the Power of SQL

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

A Comprehensive Journey from T-SQL Novice to Data Maestro

1. Introduction

1. Introduction to the T-SQL and arguments of the course

2.1 SQL Server url installer.html

2.2 SSMS url installer.html

2. Walkthrough of SQL Server installation and configuration

2. Background to T-SQL querying and programming

1. Theoretical backgroud

2. Relational Model

3. Normalization

4. Types of Databases

5. SQL Server Architecture

6. Creating a Database in T-SQL Getting Started

7. Creating tables and defining data integreity

Files.zip

3. Single-Table Queries

1. Elements of the SELECT Statemen & FROM Clause

2. WHERE Clause

3. GROUP BY and HAVING Clauses

4. The SELECT Clause

5. The ORDER BY Clause

6. TOP & OFFSET-FETCH Limiting and Paging Your Query Results

7. Predicates and Operators Demystified

8. Mastering CASE Expressions and Handling NULLs

9. Single-Table Query Practice Zone.html

Files.zip

4. Joins

1. Cross Joins

2. Inner Joins

3. Advanced SQL Joins Composite, Non-Equi, and Multi-Join Queries

4. Outer Joins

5. Challenge Your Join Mastery Hands-On Join Exercises.html

Files.zip

5. Subqueries

1. Self-Contained Subqueries

2. Correlated Subqueries & EXISTS Predicate

3. Subquery Mastery Hands-On Exercises with Solutions.html

Files.zip

6. Table Expressions

1. Derived Tables

2. Common Table Expressions (CTE)

3. Views and Inline Functions

4. Table Expressions Mastery Hands-On Exercises with Solutions.html

Files.zip

7. Set Operators

1. Union, Intersect, and Except

2. Set Operators in T-SQL Hands-On Exercises with Solutions.html

Files.zip

8. Beyond the Fundamentals of Querying

1. Window Functions

2. Data Pivoting and Unpivoting

3. Window Functions and Pivoting Data Practical Exercises with Solutions.html

Files.zip

9. Data Modification

1.1 31 DATA MODIFICATION

1. Inserting, Deleting, and Updating Data

2. Data Modification in T-SQL Hands-On Exercises with Solutions.html

10. Transactions and Concurrency

1. Understanding Transactions

2. Locks & Blocking

3. Isolation levels

4. Deadlocks

5. T-SQL Concurrency Challenges Hands-On Exercises with Solutions.html

Files.zip

11. Programmable Objects

1. Variables, Batches, and Flow Elements

2. Dynamic SQL user-defined functions, stored procedures, and triggers

3. Error Handling

4. Jobs

Files.zip

12. Integrating Python and Machine Learning in T-SQL

1. Introduction to Python Integration

2. Machine Learning in SQL Server

Files.zip

139,000 تومان

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

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

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

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