DML & Multi-table Queries

SQL Server    |    Beginner
  • 10 videos | 1h 10m 3s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 23 users Rating 4.8 of 23 users (23)
A relational database stores data in tables that store data in rows or tuples and columns or attributes. Explore how to use DML statements to query data and manipulate result sets.

WHAT YOU WILL LEARN

  • Describe the purpose of sql, ddl, and dml statements in the context of sql server
    Use select statements to query tables and columns
    Use select statements with where, and, not, between to filter results
    Use the order by clause to order result sets returned from a select statement
    Use sql server aggregate functions, count, avg, min, max to return specific result sets
  • Use inner joins to retrieve data from multiple sql server tables
    Use outer joins to retrieve data from multiple sql server tables
    Use cross joins to retrieve data from multiple sql server tables
    Use the union statement to combine the results from multiple select statements executed on a sql server database
    Use intersect and except to compare and extract data from result sets returned from sql server data

IN THIS COURSE

  • 6m 35s
    Upon completion of this video, you will be able to describe the purpose of SQL, Data Definition Language (DDL), and Data Manipulation Language (DML) statements in the context of SQL Server. FREE ACCESS
  • 8m 22s
    To query tables and columns, use SELECT statements. FREE ACCESS
  • Locked
    3.  Filtering Results
    9m 1s
    During this video, you will learn how to use SELECT statements with WHERE, AND, NOT, and BETWEEN to filter results. FREE ACCESS
  • Locked
    4.  Ordering Result Sets
    4m 53s
    In this video, learn how to use the ORDER BY clause to order result sets returned from a SELECT statement. FREE ACCESS
  • Locked
    5.  Using Aggregate Functions
    6m 14s
    During this video, you will learn how to use SQL Server aggregate functions, including COUNT, AVG, MIN, and MAX, to return specific result sets. FREE ACCESS
  • Locked
    6.  Using Inner Joins
    7m 40s
    In this video, you will learn how to use INNER JOINS to retrieve data from multiple tables in SQL Server. FREE ACCESS
  • Locked
    7.  Using Outer Joins
    8m 3s
    In this video, learn how to use OUTER JOINS to retrieve data from multiple tables in SQL Server. FREE ACCESS
  • Locked
    8.  Using Cross Joins
    6m 54s
    In this video, find out how to use CROSS JOINS to retrieve data from multiple tables. FREE ACCESS
  • Locked
    9.  Combining Result Sets
    5m 53s
    In this video, you will use the UNION statement to combine the results from multiple SELECT statements executed on a SQL Server database. FREE ACCESS
  • Locked
    10.  Manipulating Result Sets
    6m 28s
    In this video, you will learn how to use INTERSECT and EXCEPT to compare and extract data from result sets returned from SQL Server. 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
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL 2016 Tables
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)
Course Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Course SQL Developer
Rating 4.5 of 583 users Rating 4.5 of 583 users (583)