SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. As a database server, the primary function of the SQL Server is to store and retrieve data used by other applications.
In this course, students will learn to perform advanced queries, data pivoting, advanced stored procedures, and business intelligence techniques in SQL Server Management Studio.
Learn to administer SQL Server effectively.
Who Is This Course For?
intermediate users and coders
What Will You Learn?
How to write queries for business intellience purposes.
How to work with dates and times for query purposes.
How to create reporting categories using Cartesian products.
How to use aggregate functions to summarize data in a meaningful way.
How to perform cross-tabulations and data pivoting.
How to create complex subqueries to using efficiently nested query logic.
Prerequisite
SQL Server 201 / Intermediate
Mentor(s)
Cynthia V. Marcello
Data Diva
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.