Multiple SQL Tables

SQL Server 2014    |    Beginner
  • 12 videos | 1h 20m 16s
  • Earns a Badge
Likes 122 Likes 122
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

  • 5m 30s
    In this video, you will define multiple tables and describe their use in SQL. FREE ACCESS
  • 9m 2s
    In this video, you will use SQL to connect tables. FREE ACCESS
  • Locked
    3.  Creating Tables with a FOREIGN KEY
    7m 15s
    During this video, you will learn how to use FOREIGN KEY with CREATE in SQL. FREE ACCESS
  • Locked
    4.  Patterns of Data in SQL
    8m 12s
    Upon completion of this video, you will be able to describe relationships between tables and the different patterns. FREE ACCESS
  • Locked
    5.  SQL Composite Keys Using Multiple Values
    7m 57s
    In this video, you will use composite keys and their corresponding values. FREE ACCESS
  • Locked
    6.  Functional Dependencies
    5m 17s
    Upon completion of this video, you will be able to describe functional dependencies and their use. FREE ACCESS
  • Locked
    7.  Use Case Example Using Functional Dependencies
    5m 31s
    In this video, you will use functional dependencies in an example. FREE ACCESS
  • Locked
    8.  Inner Joins – An Introduction
    5m 21s
    In this video, you will learn how to use inner joins in SQL. FREE ACCESS
  • Locked
    9.  Equijoins and Non-equijoins
    7m 8s
    During this video, you will learn how to use equijoins and non-equijoins and describe their differences in SQL architecture. FREE ACCESS
  • Locked
    10.  Outer Joins
    8m 19s
    In this video, you will learn how to use Outer Joins in SQL. FREE ACCESS
  • Locked
    11.  Multiple Conditions Using Multiple Joins
    5m 51s
    In this video, you will use multiple joins and multiple conditions in SQL. FREE ACCESS
  • Locked
    12.  UNION Operator and Combining Results
    4m 54s
    In this video, you will use the UNION operator and describe how it combines results. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance, Sixth Edition
Course MySQL: Understanding & Implementing Joins
Likes 57 Likes 57  
Course SQL 2016 Tables
Likes 405 Likes 405  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Transactions
Likes 51 Likes 51  
Course Database Design
Likes 109 Likes 109  
Course SQL Tables
Likes 190 Likes 190