Multiple SQL Tables
SQL Server 2014
12 Videos | 1h 23m 16s - Earns a Badge
Work with multiple tables. Mastering the fundamentals of SQL creates a foundation. Explore multi-table database architecture and design, connecting several tables, using inner/outer joins, and equijoins and non-equijoins.
WHAT YOU WILL LEARN
-
define multiple tables and describe their use in SQL
use SQL for the process of connecting tables
use FOREIGN KEY with CREATE in SQL architecture
describe relationships between tables and the different patterns
use composite keys and their relative values
describe the functional dependencies and their use -
use functional dependencies in a example
use inner joins in SQL
use equijoins and non-equijoins and describe their differences in SQL architecture
use Outer Joins in SQL
use multiple joins and multiple conditions in SQL
use the UNION operator and describe how it combines results
IN THIS COURSE
-
1.Introduction to Multi-table Architecture5m 30sUP NEXT
-
2.Connecting Tables Together9m 2s
-
3.Creating Tables with a FOREIGN KEY7m 15s
-
4.Patterns of Data in SQL8m 12s
-
5.SQL Composite Keys Using Multiple Values7m 57s
-
6.Functional Dependencies5m 17s
-
7.Use Case Example Using Functional Dependencies5m 31s
-
8.Inner Joins – An Introduction5m 21s
-
9.Equijoins and Non-equijoins7m 8s
-
10.Outer Joins8m 19s
-
11.Multiple Conditions Using Multiple Joins5m 51s
-
12.UNION Operator and Combining Results4m 54s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
