Multiple SQL Tables

SQL Server 2014    |    Beginner
  • 12 videos | 1h 20m 16s
  • Earns a Badge
Rating 4.5 of 144 users Rating 4.5 of 144 users (144)
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 Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book Job Ready SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Table Design: Functions & Strings
Rating 4.5 of 116 users Rating 4.5 of 116 users (116)
Course Datasets in R: Selecting, Filtering, Ordering, & Grouping Data
Rating 4.6 of 7 users Rating 4.6 of 7 users (7)
Course SQL Concepts & Queries
Rating 4.6 of 2013 users Rating 4.6 of 2013 users (2013)