DML & Multi-table Queries

SQL Server 2014
  • 10 Videos | 1h 14m 33s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
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

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

Likes 166 Likes 166  
Likes 57 Likes 57  
Likes 29 Likes 29