skip to content
Covid-19 virus
COVID-19 Resources

Reliable information about the coronavirus (COVID-19) is available from the World Health Organization (current situation, international travel). Numerous and frequently-updated resource results are available from this WorldCat.org search. OCLC’s WebJunction has pulled together information and resources to assist library staff as they consider how to handle coronavirus issues in their communities.

Image provided by: CDC/ Alissa Eckert, MS; Dan Higgins, MAM
Selecting data from multiple tables : using T-SQL for joins and unions in SQL server Preview this item
ClosePreview this item
Checking...

Selecting data from multiple tables : using T-SQL for joins and unions in SQL server

Author: John Deardurff
Publisher: [Place of publication not identified] : Apress, [2019]
Edition/Format:   eVideo : Clipart/images/graphics : EnglishView all editions and formats
Summary:
"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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Instructional films
Material Type: Clipart/images/graphics, Internet resource, Videorecording
Document Type: Internet Resource, Computer File, Visual material
All Authors / Contributors: John Deardurff
OCLC Number: 1103671199
Notes: Title from title screen (viewed June 4, 2019).
Date of publication from resource description page.
Performer(s): Presenter, John Deardurff.
Description: 1 online resource (1 streaming video file (44 min., 38 sec.)) : digital, sound, color
Responsibility: John Deardurff.

Abstract:

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

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


\n\n

Primary Entity<\/h3>\n
<http:\/\/www.worldcat.org\/oclc\/1103671199<\/a>> # Selecting data from multiple tables : using T-SQL for joins and unions in SQL server<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Movie<\/a>, schema:VideoObject<\/a>, schema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nlibrary:oclcnum<\/a> \"1103671199<\/span>\" ;\u00A0\u00A0\u00A0\nrdfs:comment<\/a> \"Unknown \'gen\' value: cig<\/span>\" ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/10202577076#CreativeWork\/sql_server<\/a>> ; # SQL server.<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/10202577076#Topic\/sql_computer_program_language<\/a>> ; # SQL (Computer program language)<\/span>\n\u00A0\u00A0\u00A0\nschema:creator<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/10202577076#Person\/deardurff_john<\/a>> ; # John Deardurff<\/span>\n\u00A0\u00A0\u00A0\nschema:datePublished<\/a> \"2019<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/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.<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:exampleOfWork<\/a> <http:\/\/worldcat.org\/entity\/work\/id\/10202577076<\/a>> ;\u00A0\u00A0\u00A0\nschema:genre<\/a> \"Instructional films<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:inLanguage<\/a> \"en<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Selecting data from multiple tables : using T-SQL for joins and unions in SQL server<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:productID<\/a> \"1103671199<\/span>\" ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/www.aspresolver.com\/aspresolver.asp?MARC;4691334<\/a>> ;\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/proquest.safaribooksonline.com\/?fpi=9781484249055<\/a>> ;\u00A0\u00A0\u00A0\nwdrs:describedby<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/1103671199<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Related Entities<\/h3>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/10202577076#CreativeWork\/sql_server<\/a>> # SQL server.<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"SQL server.<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/10202577076#Person\/deardurff_john<\/a>> # John Deardurff<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Deardurff<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"John<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"John Deardurff<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/10202577076#Topic\/sql_computer_program_language<\/a>> # SQL (Computer program language)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"SQL (Computer program language)<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/title\/-\/oclc\/1103671199<\/a>>\u00A0\u00A0\u00A0\u00A0a \ngenont:InformationResource<\/a>, genont:ContentTypeGenericResource<\/a> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/www.worldcat.org\/oclc\/1103671199<\/a>> ; # Selecting data from multiple tables : using T-SQL for joins and unions in SQL server<\/span>\n\u00A0\u00A0\u00A0\nschema:dateModified<\/a> \"2020-07-13<\/span>\" ;\u00A0\u00A0\u00A0\nvoid:inDataset<\/a> <http:\/\/purl.oclc.org\/dataset\/WorldCat<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Content-negotiable representations<\/p>\n