Intermediate SQL Server
In this course, students will use SQL Server Management Studio and explore the use of stored procedures to manage repetitive data tasks, use aggregate functions to summarize data, cross tabulations for describing data patterns, and triggers to control table-level insert, delete and update actions based on criteria.
Create DB objects: tables, views, indexes, sequences, synonyms, stored procedures, user-defined functions, triggers.
Who Is This Course For?
You might have some experience with coding already, so it is time to learn relational database fundamentals now.
If you don't have a coding experience, then SQL Server 101 is a pre-requisite.
What Will You Learn?
How to use triggers to respond to table-level actions based on criteria.
How to use cross-tabulations to summarize data in a descriptive manner.
How to create aggregate functions to summarize data in a meaningful way.
How to create a stored procedure to execute common tasks.
Prerequisite
SQL Server 101
Duration
15 hours
Cost
$799.00
Course Schedule:
This course is not currently scheduled. Please sign up if you want to get this course soon.