Mastering SQL Server Query Languages – T-SQL, MDX, DAX & DMX

Query SQL Server, OLAP Cubes, Data Mining Models, Tabular Cubes & OLTP Database with 4 query languages & 1000+ queries

Created by: Siddharth Mehta
Enterprise Cloud Architect, Published Author, Cloud Geek

What Will I Learn?

• Download curated reference material spanning thousands of pages
• Download 1000+ ready-to-use queries developed in the course
• Learn how to query SQL Server databases, SSAS databases, and Data Mining models using T-SQL, MDX & DAX, and DMX respectively.
• Install SQL Server 2016 Database Engine, SQL Server Analysis Services in Multi-dimensional and Tabular mode, and SQL Server Management Studio
• Learn fundamentals of SQL Server, SQL Server Analysis Services and Data Mining

Requirements

• No prior working knowledge of SQL Server, SSAS, Data Mining, T-SQL, MDX, DAX or DMX is required.
• A Windows machine (Win 7 or higher) preferably with 4 GB RAM or higher
• SQL Server 2016 or higher Installable setup (even trial version will do). Installation is covered in the course.
• Added Advantage: Conceptual knowledge of SQL Server, SSAS and Data Mining will help to learn the query languages faster. Fundamentals are covered in the course.

Target audience

• This course is for students seeking to learn transactional and analytical query languages should
• This course is for professionals seeking to learn SQL Server database query development
• This course is for anyone seeking a SQL / Analytical / Data Mining Developer job / role