Combining and Filtering Data with T-SQL 2019

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

Following along with the exercise files, this course takes you from setting up the environment through writing more advanced queries using T-SQL functions, expressions, and logic.

1. Course Overview

1. Course Overview

2. Setting up the SQL Server Environment

1. Version Check

2. Introduction

3. Setting up the SQL Server Environment

4. Creating SQL Server Databases

5. Using SQL Server Management Studio

6. Summary and Resources

3. Shaping Data in a Query

1. Introduction

2. The SELECT Query Syntax

3. Concatenating Values in T-SQL

4. Casting and Converting Data Types

5. Formatting Strings

6. Working with Characters

7. Formatting Dates and Numbers

8. Review and Resources

4. Querying Data from Multiple Tables Using JOINS

1. Introduction

2. Understanding Primary and Foreign Keys

3. Using the Inner Join

4. Left and Right Joins

5. Full OUTER Joins

6. Self Join

7. Review and Resources

5. Filtering and Controlling Flow

1. Introduction

2. Expressions and Comparison Operators

3. Applying T-SQL Logical Operators

4. Controlling Flow with T-SQL Logic

5. Review and Resources

6. Limiting the Results with T-SQL Functions

1. Introduction

2. Offset and Fetch

3. TOP Functions

4. Using Variables to Limit Results

5. Review and Resources

7. Aggregating Data in a Query

1. Introduction

2. Using COUNT in T-SQL

3. Using SUM in T-SQL

4. Using AVG in T-SQL

5. Using MIN and MAX in T-SQL

6. Review and Resources

8. Using T-SQL Set Operators

1. Introduction

2. Difference between Joins and Set Operators

3. Union All

4. Union

5. Intersect

6. Except

7. Review and Resources

9. Simplifying with Intermediate Tables and Common Table Expressions

1. Introduction

2. Using Common Table Expressions in T-SQL

3. Using Temporary Tables in T-SQL

4. Using Cursors in T-SQL

5. Review and Resources

10. Summary

1. Summary

139,000 تومان

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

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

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

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