Video description
- Query and retrieve data from a SQL Server database
- Understand the basic structure of a SELECT statement
- Filter query results to only those records that interest you
- Sort query results in ascending or descending order
- Execute queries that answer Top N type business questions
- Properly reference tables in your queries by using all four parts of a table name
- Improve readability and maintainability through using alias names
Table of contents
- Introduction 00:02:30
- Fields and Records 00:03:12
- The Anatomy of a SELECT statement 00:06:54
- The Four-Part Name of a Table 00:04:28
- Concatenation and Aliases 00:06:22
- Filter Records by a Numeric Field 00:04:53
- Filter Records by a Character Field 00:04:52
- Filter Records by a Date Field 00:05:17
- Filter Records with a NULL value 00:03:25
- Sorting Records in a SELECT statement 00:03:07
- Sorting Records by Top Values 00:03:33
Product information
- Title: T-SQL Querying: Writing a SELECT Statement
- Author(s):
- Release date: December 2018
- Publisher(s): Apress
- ISBN: 9781484243336
You might also like
video
Advanced Applied SQL for Business Intelligence and Analytics
Extend your knowledge of SQL, databases, and BI by mastering complex topics such as materialized views, …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
video
Introduction to SQL Server 2016 Integration Services (SSIS): Getting Started with Extract, Transform, and Load (ETL) Using SSIS
10+ Hours of Video Instruction Get up and running in designing, and implementing ETL solutions using …