Advanced SQL Queries

SQL Server 2014
  • 13 Videos | 1h 28m 17s
  • Earns a Badge
Likes 209 Likes 209
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

  • Playable
    1. 
    Introduction to Subquery
    6m 28s
    UP NEXT
  • Playable
    2. 
    Using query as a SELECT Column
    9m 16s
  • Locked
    3. 
    Correlated and Noncorrelated Queries
    7m 8s
  • Locked
    4. 
    Example of a Query With A Natural Join
    4m 35s
  • Locked
    5. 
    Using IN, NOT IN in SQL
    5m 21s
  • Locked
    6. 
    Correlated Query with EXISTS and NOT EXISTS
    7m 28s
  • Locked
    7. 
    Using HAVING Clause with Queries
    5m 3s
  • Locked
    8. 
    Using Queries with the UPDATE Statement
    6m 10s
  • Locked
    9. 
    Using Queries with INSERT Statement
    4m 35s
  • Locked
    10. 
    Using Queries with DELETE FROM Statement
    4m 25s
  • Locked
    11. 
    Working with Difficult Queries
    9m 17s
  • Locked
    12. 
    Tips for Efficient Queries
    8m 10s
  • Locked
    13. 
    Exercise: More Tables and Multi-Layer Architecture
    6m 21s

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

Likes 226 Likes 226  
CHANNEL NoSQL
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 70 Likes 70  
COURSE SQL Developer
Likes 152 Likes 152