Advanced Databases and SQL Querying

Visit Tutorial Page ( Report)
This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept. If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.
  • Introduction
    • Introduction

      Welcome this course! We revisit some concepts from the previous course (Introduction to Databases and Querying) and walk you through the agenda for this course

  • SQL Views
    • SQL Views - An Introduction

      A brief walkthrough of the concept of SQL views.

    • SQL Views - Deep Dive into Querying
  • SQL Triggers
    • SQL Triggers - An Introduction
    • SQL Triggers - Deep dive into Querying
  • SQL Computed Columns
    • SQL Computed Columns - An Introduction
    • SQL Computed Columns - Deep dive into Querying
  • SQL Stored Procedures
    • SQL Stored Procedures - An Introduction
    • SQL Stored Procedures - Deep dive into Querying
  • SQL User Defined Functions (UDF)
    • SQL User Defined Functions - An Introduction
    • SQL User Defined Functions - Deep dive into Querying
  • SQL Transactions and Error Handling
    • SQL Transactions and Error Handling - An Introduction
    • SQL Transactions and Error Handling - An Introduction (Continued)
    • SQL Transactions and Error Handling - Deep Dive into Querying
  • SQL grouping functions and Ranking functions
    • SQL Grouping Sets and Common Table Expressions
    • SQL Ranking Functions - An Introduction
    • SQL Ranking Functions - Deep Dive into Querying
  • SQL XML data-types
    • SQL XML Datatype - An Introduction
    • SQL XML Datatype - Deep Dive into Querying
  • SQL Partitions
    • SQL Partitions - An Introduction
    • SQL Partitions - Deep Dive into Querying
  • SQL Dynamic Queries
    • SQL Dynamic Queries and Pivots - An Introduction
    • SQL Dynamic Queries and Pivots - Deep dive into QUerying
  • SQL Filestream and Free-Text Search
    • SQL Filestream
    • SQL Free-Text Search
  • SQL Geography and Geometry datatype
    • Geometry and Geography Data Types
  • Conclusion and Next steps
    • Conclusion and Next Steps
Write Your Review

Reviews