Courses List


SQL Server and Azure SQL Databases

Mastering Query optimization in a SQL Database

By the culmination of this course, participants will possess the expertise to pinpoint query performance bottlenecks and identify the use of anti-patterns. More importantly, they will acquire the knowledge to avoid these common pitfalls in the future. The course's ultimate goal is to empower data professionals to extract every ounce of performance from their T-SQL queries, ensuring that their applications run with unparalleled efficiency. In essence, this course is a gateway to achieving excellence in T-SQL, providing all the necessary tools and knowledge to excel in the field of data management and query optimization.

Databricks

Practical Data Engineering in Databricks

This comprehensive course, is designed to equip you with the essential skills and knowledge to effectively utilize Databricks for data engineering tasks. The course is structured into eight modules, each focusing on key aspects of data engineering within the Databricks environment. This course is ideal for data engineers, data scientists, and anyone looking to enhance their data engineering skills using Databricks. By the end of this course, you will have a solid understanding of how to leverage Databricks for various data engineering tasks, from data ingestion and transformation to performance tuning and streaming data processing.

Power BI

Paginated Reports in Power BI

Learn to create, publish, and distribute Power BI paginated reports with our comprehensive course, "Paginated Reports in Power BI (XLA-210)." Ideal for Power BI report authors and Excel analysts, this course covers report layout design, data retrieval, parameter usage, data visualization, interactivity features, and report management. No specific prerequisites required, but familiarity with reporting tools is beneficial. Enhance your technical skills and master paginated reporting in Power BI.