Cargando…

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Otros Autores: Deardurff, John (Orador)
Formato: Electrónico Video
Idioma:Inglés
Publicado: [Place of publication not identified] : Apress, 2018.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cgm a2200000 i 4500
001 OR_on1085012818
003 OCoLC
005 20231017213018.0
006 m o c
007 cr cna||||||||
007 vz czazuu
008 190208s2018 xx 049 o vleng d
040 |a UMI  |b eng  |e rda  |e pn  |c UMI  |d OCLCF  |d TOH  |d OCLCO  |d OCLCQ  |d OCLCO 
035 |a (OCoLC)1085012818 
037 |a CL0501000024  |b Safari Books Online 
050 4 |a QA76.9.C55 
049 |a UAMI 
100 1 |a Deardurff, John,  |e speaker. 
245 1 0 |a T-SQL querying :  |b writing a SELECT statement /  |c John Deardurff. 
246 3 |a Transact-structured query language querying 
264 1 |a [Place of publication not identified] :  |b Apress,  |c 2018. 
300 |a 1 online resource (1 streaming video file (48 min., 33 sec.)) 
336 |a two-dimensional moving image  |b tdi  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
337 |a video  |b v  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
511 0 |a Presenter, John Deardurff. 
500 |a Title from resource description page (Safari, viewed February 8, 2019). 
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 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a SQL server. 
630 0 7 |a SQL server.  |2 fast  |0 (OCoLC)fst01376937 
650 0 |a SQL (Computer program language) 
650 0 |a Client/server computing. 
650 6 |a SQL (Langage de programmation) 
650 6 |a Architecture client-serveur (Informatique) 
650 7 |a Client/server computing.  |2 fast  |0 (OCoLC)fst00864205 
650 7 |a SQL (Computer program language)  |2 fast  |0 (OCoLC)fst01102869 
655 4 |a Electronic videos. 
856 4 0 |u https://learning.oreilly.com/videos/~/9781484243336/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
994 |a 92  |b IZTAP