T-SQL querying writing a SELECT statement

"This video provides you with the knowledge to write SELECT statements to retrieve data from a SQL Server database. The video begins with an explanation of fields and records, followed by the anatomy of a SELECT statement. It continues with how to use a WHERE clause to filter specific records i...

Full description

Bibliographic Details
Main Author: Deardurff, John
Format: eBook
Language:English
Published: [Place of publication not identified] Apress 2018
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 02517nmm a2200325 u 4500
001 EB001952480
003 EBX01000000000000001115382
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
050 4 |a QA76.9.C55 
100 1 |a Deardurff, John 
245 0 0 |a T-SQL querying  |b writing a SELECT statement  |c John Deardurff 
246 3 1 |a Transact-structured query language querying 
260 |a [Place of publication not identified]  |b Apress  |c 2018 
300 |a 1 streaming video file (48 min., 33 sec.) 
653 |a Architecture client-serveur (Informatique) 
653 |a SQL (Computer program language) / fast / (OCoLC)fst01102869 
653 |a SQL server / fast / (OCoLC)fst01376937 
653 |a Client/server computing / fast / (OCoLC)fst00864205 
653 |a SQL (Langage de programmation) 
653 |a SQL server / http://id.loc.gov/authorities/names/n90684343 
653 |a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502 
653 |a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Title from resource description page (Safari, viewed February 8, 2019) 
856 4 0 |u https://learning.oreilly.com/videos/~/9781484243336/?ar  |x Verlag  |3 Volltext 
082 0 |a 000 
520 |a "This video provides you with the knowledge to write SELECT statements to retrieve data from a SQL Server database. The video begins with an explanation of fields and records, followed by the anatomy of a SELECT statement. It continues with how to use a WHERE clause to filter specific records into the result set. Since a field can store various data types, the filter section shows how to work with those data types. Finally, there is coverage of how to sort and order a result set. Also covered is the four-part naming convention for tables in SQL Server. A proper understanding of table naming is important as queries become more involved and complex. Table and column aliases are covered as well, which are names that you can provide as substitutes for canonical names that are often long and cumbersome. Aliases provide a level of insulation in your queries from changes to names in the tables and columns that are being queried. While this video is about T-SQL and includes examples specific to SQL Server, the bulk of what you will learn is applicable to any vendor's implementation of the SQL language."--Resource description page