در حال حاضر محصولی در سبد خرید شما وجود ندارد.

پنل کاربری

رمز خود را فراموش کرده اید؟ اگر اولین بار است از سایت جدید استفاده میکنید باید پسورد خود را ریست نمایید.
دسته بندی
دسته بندی

Querying Microsoft SQL Server 2022

24,900 تومان
بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
خرید دانلودی فوری

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

ویدئو معرفی این محصول

Want to learn more about how to query data from SQL Server tables? In this course, instructor Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language and the updated features of SQL Server 2022.

Learn the fundamental structure of a successful query, from ideation to execution. Find out how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a data set, ensuring that it’s properly formatted and applicable to a wide variety of needs and perspectives. Along the way, Adam gives you tips and pointers on how to get the most out of your queries. Upon completing this course, you'll be equipped with the commands and keywords you need to know to analyze your data more effectively.


01 - Introduction
  • 01 - Turn data into information with queries
  • 02 - What you should know
  • 03 - Download the sample database

  • 02 - 1. Introduction to T-SQL Queries
  • 01 - What is Transact SQL
  • 02 - The SQL querying environment
  • 03 - Return records with SELECT and FROM
  • 04 - Filter records with WHERE
  • 05 - Sort records with ORDER BY
  • 06 - Column aliases
  • 07 - Create values with constants and math
  • 08 - Challenge Write a SELECT query
  • 09 - Solution Write a SELECT query

  • 03 - 2. Additional Filter Techniques
  • 01 - Limit results with TOP
  • 02 - Remove duplicates with DISTINCT
  • 03 - Comparison operators
  • 04 - Understand NULL values
  • 05 - Match text with LIKE and wildcards
  • 06 - Challenge Retrieve matching text strings
  • 07 - Solution Retrieve matching text strings

  • 04 - 3. Retrieve Records from Multiple Tables
  • 01 - Table joins and relationships
  • 02 - Inner joins
  • 03 - Left, right, and full outer joins
  • 04 - Cross joins
  • 05 - Challenge Return data from multiple tables
  • 06 - Solution Return data from multiple tables

  • 05 - 4. Group Records
  • 01 - Understand record grouping
  • 02 - Use GROUP BY and COUNT
  • 03 - Aggregate functions
  • 04 - Explore data with SUM
  • 05 - Filter groups with HAVING
  • 06 - Challenge Obtain order summaries
  • 07 - Solution Obtain order summaries

  • 06 - 5. Manipulate Data with Functions
  • 01 - Use functions in T-SQL
  • 02 - String functions
  • 03 - Text concatenation
  • 04 - Round with mathematical functions
  • 05 - Find the GREATEST or LEAST value
  • 06 - Work with date functions
  • 07 - FORMAT date and times
  • 08 - Group dates into buckets
  • 09 - Return random records with NEWID
  • 10 - Create a series of values
  • 11 - The IIF logical function
  • 12 - Write a CASE statement
  • 13 - Challenge Use functions in a SQL query
  • 14 - Solution Use functions in a SQL query

  • 07 - 6. Writing SQL Scripts
  • 01 - Change database context with USE
  • 02 - Add comments to a script
  • 03 - When to use square brackets

  • 08 - 7. SQL Subqueries
  • 01 - What is a subquery
  • 02 - Use a subquery in a HAVING clause
  • 03 - Correlated subqueries
  • 04 - PIVOT the result set
  • 05 - Challenge Write a query with a subquery
  • 06 - Solution Write a query with a subquery

  • 09 - 8. Work with Variables
  • 01 - Create and use variables in a query
  • 02 - Create a counter for a looping statement
  • 03 - Challenge Use variables in a query
  • 04 - Solution Use variables in a query

  • 10 - 9. Result Set Operators
  • 01 - Combine results with UNION
  • 02 - Return distinct rows with EXCEPT
  • 03 - Return common rows with INTERSECT

  • 11 - Conclusion
  • 01 - Next steps