Multiple SQL Tables

SQL Server 2014    |    Beginner
  • 12 Videos | 1h 23m 16s
  • Earns a Badge
Likes 70 Likes 70
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

  • Playable
    1. 
    Introduction to Multi-table Architecture
    5m 30s
    UP NEXT
  • Playable
    2. 
    Connecting Tables Together
    9m 2s
  • Locked
    3. 
    Creating Tables with a FOREIGN KEY
    7m 15s
  • Locked
    4. 
    Patterns of Data in SQL
    8m 12s
  • Locked
    5. 
    SQL Composite Keys Using Multiple Values
    7m 57s
  • Locked
    6. 
    Functional Dependencies
    5m 17s
  • Locked
    7. 
    Use Case Example Using Functional Dependencies
    5m 31s
  • Locked
    8. 
    Inner Joins – An Introduction
    5m 21s
  • Locked
    9. 
    Equijoins and Non-equijoins
    7m 8s
  • Locked
    10. 
    Outer Joins
    8m 19s
  • Locked
    11. 
    Multiple Conditions Using Multiple Joins
    5m 51s
  • Locked
    12. 
    UNION Operator and Combining Results
    4m 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.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE T-SQL Queries
Likes 173 Likes 173  
Likes 166 Likes 166