About this Course
This course will advance your T-SQL programming and problem-solving skills. You'll learn how to build more advanced SQL queries and work with reporting data. You’ll also create dashboard reports, automate tasks and apply advanced techniques and tools to real-world problems. As a final project, you’ll use development best practices to complete a SQL development project using advanced SQL server features and techniques.
What You'll Learn
- How to use SQL Server to work with reporting data structures
- How to perform data processing and migrations using Integration Services
- How to create tabular databases using Analysis Services
- Techniques for developing an administrative dashboard using Reporting Services
- How to automate administrative tasks using PowerShell and secure relational data using permissions and encryption
Get Hands-On Experience
- Create automation tasks using multiple technologies
- Design, transform and manage various data formats and structures
- Develop data-driven reports for database management
- Design strategies for data quality and management