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
Rust Programming Masterclass from Beginner to Expert
Welcome to our Rust programming language course! In the world of programming languages, there are often …
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, …
video
CSS Bootcamp: Master CSS (Including CSS Grid/Flexbox)
Work through real-world projects and learn how to create modern, responsive websites using CSS Grid and …
video
Elasticsearch 8 and the Elastic Stack: In-Depth and Hands-On
Learn all the latest techniques to search, analyze, and visualize big data with Elasticsearch, Kibana, Logstash, …