This course in designed for students who want to learn about stored procedures
  • Table of contents
  • 1 Download all software needed
  • 2 Installing Windows Server OS
  • 3 Shared folders
  • 3a Installing SQL 2014
  • 4 Installing Adventureworks database
  • 5 What is a Stored Procedures
  • 6 Modifying and deleting a sproc
  • 7 Using a single input parameter
  • 8 Multiple parameters
  • 9 Blocks multiple sql statements
  • 10 what is a variable
  • 11 Demo of Sproc using update.
  • 12 Demo of Sproc Insert, Print, IF Else and Set Nocount on
  • 13 Demo of IF Else
  • 14 Reading a nested if else statement
  • 15 While loop
  • 16 Cursors
  • 17 Transactions
  • 18 Error handling
  • 19 Table variables
  • 20 Derived tables
  • 21 Views
  • 22 Excel formula
  • 23 Intro to CTE
  • 24 Multiple CTEs
  • 25 Aggregate cte
  • 26 Insert delete Update CTE
  • 27 CTE and sproc
  • 28 Recursive CTE
  • 29 vlookup
  • 30 reviewing sprocs
  • 31 Stored Procedure permissions
  • 32 What is Power BI