Multiple SQL Tables
SQL Server 2014
| Beginner
- 12 Videos | 1h 20m 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 SQLuse SQL for the process of connecting tablesuse FOREIGN KEY with CREATE in SQL architecturedescribe relationships between tables and the different patternsuse composite keys and their relative valuesdescribe the functional dependencies and their use
-
use functional dependencies in a exampleuse inner joins in SQLuse equijoins and non-equijoins and describe their differences in SQL architectureuse Outer Joins in SQLuse multiple joins and multiple conditions in SQLuse 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.