Course curriculum

  • 1

    Introduction to Database Development

    • Presentation

    • Module
  • 2

    Designing and Implementing Tables

    • Presentation

    • Module

    • Lab 02
  • 3

    Advanced Table Designs

    • Presentation

    • Module

    • Lab 03
  • 4

    Ensuring Data Integrity Through Constraints

    • Presentation

    • Module

    • Lab 04
  • 5

    Indexes

    • Presentation

    • Module

    • Lab 05
  • 6

    Optimizing Indexes

    • Presentation

    • Module

    • Lab 06
  • 7

    Columnstore Indexes

    • Presentation

    • Module

    • Lab 07
  • 8

    Designing and Implementing Views

    • Presentation

    • Module

    • Lab 08
  • 9

    Designing and Implementing Stored Procedures

    • Presentation

    • Module

    • Lab 09
  • 10

    User Defined Functions

    • Presentation

    • Module

    • Lab 10
  • 11

    Data Manipulation Triggers

    • Presentation

    • Module

    • Lab 11
  • 12

    Using In Memory Tables

    • Presentation

    • Module

    • Lab 12
  • 13

    Implementing Managed Code in SQL Server

    • Presentation

    • Module

    • Lab 13
  • 14

    Storing and Querying XML Data in SQL Server

    • Presentation

    • Module

    • Lab 14
  • 15

    Storing and Querying Spatial Data in SQL Server

    • Presentation

    • Module

    • Lab 15
  • 16

    Storing and Querying BLOBs and Documents

    • Presentation

    • Module

    • Lab 16
  • 17

    SQL Server Concurrency

    • Presentation

    • Module

    • Lab 17