Clusters are at the heart of most tasks in Databricks, and configuring them precisely is crucial to ensuring optimum performance while also managing costs. This course covers how cluster policies can be used to help meet these goals.

In this course, you'll learn the critical skills to install, administer, support, and troubleshoot SQL Server Availability Groups. You will cover a variety of environments including Windows, Linux, and Always On, with or without a domain.

The course will teach an administrator how to use the features of SQL Server Reporting Services (SSRS) to manage a service and portal for deployment of reports through security, caching, and scheduled jobs.

This course will teach you how to use Regular Expressions in SQL Server to both identify data issues, and clean them up to ensure your data is fit for purpose. This is a critical part of ensuring your data is fit for the purpose intended.

This Free Online Course Includes: 20-30 Hours of Learning CPD Accreditation Final Assessment

This Free Online Course Includes: 10-15 Hours of Learning CPD Accreditation Final Assessment

This Free Online Course Includes: 1.5-3 Hours of Learning CPD Accreditation Final Assessment

Master advanced SQL Server functions for data manipulation and performance tuning. Learn through real-world scenarios to optimize database efficiency and solve common data problems.

Discover the secrets to mastering hierarchical data management in SQL Server. This course will teach you effective strategies and techniques for efficiently querying, navigating, and optimizing complex hierarchical data.

This course teaches how to work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.

SQL Server’s data engine traditionally stores relational data but it can also be used to store data in non-relational schemas. You’ll learn about one example -- Entity, Attribute, Value (EAV).

This course details recent additions to the standard SQL language and includes topics such as Analytic Functions and Extensions to GROUP BY, to name a few.