Advanced SQL Queries

SQL Server 2014    |    Beginner
  • 13 videos | 1h 24m 17s
  • Earns a Badge
Rating 4.6 of 321 users Rating 4.6 of 321 users (321)
Master advanced queries. Queries in SQL allow you to manipulate databases like a pro. Discover advanced techniques including subqueries, correlated queries, difficult queries, and learn query tips for better efficiency.

WHAT YOU WILL LEARN

  • Describe a subquery and its use in sql
    Use query as a select column in sql
    Use correlated and noncorrelated queries in sql
    Use a query with a natural join
    Use in, not in commands in sql
    Use correlated query with exists and not exists operators
    Use having clause in sql with queries
  • Use queries with the update statement in sql
    Use queries with the insert statement in sql
    Use queries with the delete from statement in sql
    Use sql to create a more complex query
    Use sql more efficiently with operational tips
    Describe the multiple layers of tables and their management in various sql queries

IN THIS COURSE

  • 6m 28s
    After completing this video, you will be able to describe a subquery and its use in SQL. FREE ACCESS
  • 9m 16s
    Learn how to use a query as a SELECT column in SQL. FREE ACCESS
  • Locked
    3.  Correlated and Noncorrelated Queries
    7m 8s
    In this video, find out how to use correlated and noncorrelated queries in SQL. FREE ACCESS
  • Locked
    4.  Example of a Query With A Natural Join
    4m 35s
    Learn how to use a query with a natural join. FREE ACCESS
  • Locked
    5.  Using IN, NOT IN in SQL
    5m 21s
    In this video, find out how to use the IN and NOT IN commands in SQL. FREE ACCESS
  • Locked
    6.  Correlated Query with EXISTS and NOT EXISTS
    7m 28s
    Learn how to use correlated queries with the EXISTS and NOT EXISTS operators. FREE ACCESS
  • Locked
    7.  Using HAVING Clause with Queries
    5m 3s
    In this video, you will use the HAVING clause in SQL with queries. FREE ACCESS
  • Locked
    8.  Using Queries with the UPDATE Statement
    6m 10s
    Learn how to use subqueries with the UPDATE statement in SQL. FREE ACCESS
  • Locked
    9.  Using Queries with INSERT Statement
    4m 35s
    In this video, you will use queries with the INSERT statement in SQL. FREE ACCESS
  • Locked
    10.  Using Queries with DELETE FROM Statement
    4m 25s
    In this video, you will use queries with the DELETE statement in SQL. FREE ACCESS
  • Locked
    11.  Working with Difficult Queries
    9m 17s
    In this video, you will learn how to use SQL to create a more complex query. FREE ACCESS
  • Locked
    12.  Tips for Efficient Queries
    8m 10s
    In this video, find out how to use SQL more efficiently with operational tips. FREE ACCESS
  • Locked
    13.  Exercise: More Tables and Multi-Layer Architecture
    6m 21s
    Upon completion of this video, you will be able to describe the multiple layers of tables and how they are managed in various SQL queries. 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

Course CompTIA Data+: Query Optimization
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Book Database Performance at Scale: A Practical Guide
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Transactions
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)
Course SQL & Concurrency Concepts
Rating 4.6 of 245 users Rating 4.6 of 245 users (245)
Course Multiple SQL Tables
Rating 4.5 of 144 users Rating 4.5 of 144 users (144)