Get Started with T-SQL

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

Master the fundamentals of Transact-SQL and learn how to filter and analyze data in databases

1. Introduction Get Started with T-SQL

1. Welcome to the course!

2. About the author

3. More about the Course Content

4. Database, SQL, T-SQL - What does it all mean

2. Set up the environment

1. Download SQL Server

2. Downland SQL Server Management Studio

3. Import the AdventureWorks database

4. Quick Tips & Tricks

3. T-SQL Fundamentals

1. Write Your First SELECT Statement

2. Filtering Data with WHERE, OR and AND

3. Understanding LIKE

4. IN and NOT IN

5. Custom Columns & Aliases

6. Understanding NULL

7. Practise test T-SQL Fundamentals.html

4. Working with Data types and Functions

1. Numeric Values

2. Working with Strings

3. CHARINDEX

4. REPLACE

5. REPLICATE

6. UPPER and LOWER

7. SUBSTRING

8. Date Data Types

9. DATEPART, DATENAME

10. DATEADD

11. DATEDIFF

5. Aggregating Data

1. Understanding ORDER BY

2. Understanding GROUP BY

3. Summarize Data with SUM

4. Count Rows with COUNT

5. Understanding MIN and MAX

6. Calculating Averages with AVG

7. More Aggregate Functions

6. Introducing JOINS

1. Introducing JOINS

2. Working with INNER JOIN

3. Understand LEFT JOIN

4. Understand RIGHT JOIN

5. Understand FULL OUTER JOIN

6. Understand SELF JOIN

7. Next Steps

1. Congratulations!

179,000 تومان

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

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

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

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