Cargando…
Selecting data from multiple tables : using T-SQL for joins and unions in SQL server /
"Extend your SELECT statements to retrieve data simultaneously from multiple tables in a SQL Server database. This video covers these joins and shows how they are fundamental to getting maximum value from any relational database engine. It is impossible to write professional-level queries witho...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico Video |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Apress,
[2019]
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cgm a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1103671199 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o c | ||
| 007 | cr cna|||||||| | ||
| 007 | vz czazuu | ||
| 008 | 190605s2019 xx 045 o vleng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d OCLCF |d ALSTP |d OCLCO |d OCL |d OCLCQ |d OCLCO | ||
| 029 | 1 | |a AU@ |b 000068131507 | |
| 035 | |a (OCoLC)1103671199 | ||
| 037 | |a CL0501000051 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 | |
| 049 | |a UAMI | ||
| 100 | 1 | |a Deardurff, John, |e speaker. | |
| 245 | 1 | 0 | |a Selecting data from multiple tables : |b using T-SQL for joins and unions in SQL server / |c John Deardurff. |
| 264 | 1 | |a [Place of publication not identified] : |b Apress, |c [2019] | |
| 300 | |a 1 online resource (1 streaming video file (44 min., 38 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 title screen (viewed June 4, 2019). | ||
| 500 | |a Date of publication from resource description page. | ||
| 520 | |a "Extend your SELECT statements to retrieve data simultaneously from multiple tables in a SQL Server database. This video covers these joins and shows how they are fundamental to getting maximum value from any relational database engine. It is impossible to write professional-level queries without a solid grounding in joins. Selecting Data from Multiple Tables helps you to attain that level of expertise. You will start with an introduction to relationships and joins with a look at the differences between a parent and child table. You'll learn how to define rows in two tables to correspond to each other through a common value column, or through a set of such columns held in common in both tables. The examples show that such relationships can record and store a wide variety of master-detail data points such as, for example, the line items in a customer order. Segments in the video examine the major different join types, including inner joins, left and right outer joins, and full outer joins. You'll also work with self joins and cross joins. Finally, the video goes through various union operations that you can also use to combine rows from two or more tables, but in a manner different from a join. Union operations covered in this video include the basic union, and intersection and exception operations."--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 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a SQL (Computer program language) |2 fast |0 (OCoLC)fst01102869 | |
| 655 | 7 | |a Instructional films. |2 fast |0 (OCoLC)fst01726236 | |
| 655 | 7 | |a Instructional films. |2 lcgft | |
| 655 | 7 | |a Films de formation. |2 rvmgf | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/videos/~/9781484249055/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Alexander Street |b ALSP |n ASP4691334/marc | ||
| 994 | |a 92 |b IZTAP | ||