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

3.70 (146 reviews)

Udemy

platform

English

language

Databases

What you will 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

Why take this course?

Top 4 Reasons to take this course:

1) You can learn T-SQL, MDX, DAX and DMX from scratch as well as ask questions directly to a Published Author, Microsoft MVP, and a Senior Technology Architect with more than 14 years of experience who actively practices Business Intelligence, Data Mining and Analytics in real-world client projects internationally.

2) In a single course, without any prior query development experience - You can learn four query languages - T-SQL, MDX, DAX and DMX, in such detail that you can apply for a job of SQL Developer / SSAS Developer / Data Mining Developer. Also you get to compare the querying techniques in 4 different query languages side by side using examples from a single course, taught by a single instructor on the same sample data.

3) More than 1000+ queries are explained in the course on OLTP, OLAP and Data Mining Models.

4) Downloadable Course Content:

15+ curated reference guides from MSDN which provides exhaustive theory, syntax, examples and reference links for SQL Server, Data Mining, T-SQL, MDX, DAX, and DMX.
1000+ Ready-to-use T-SQL, MDX, DAX and DMX Queries
Links to 1 Sample OLTP Database, 1 Sample Data Warehouse, 1 OLAP Database with sample data and data mining models.

Course Description

SQL Server and SSAS Query Languages - T-SQL, MDX, DAX and DMX is a course in which a student having no experience in database query development would be trained step by step to a level where the student is confident to independently work in a high-performing database development project.

Course includes job-oriented practical hands-on queries with explanation and analysis, and theoretical coverage of key concepts. This is a fast track course to learn practical query development on 4 query languages using the latest version of SQL Server - 2016. No prior experience of working with any query language is required. Even installation of SQL Server, SSAS and Sample Data is covered in the course.

The course is structured in the following categories: Fundamentals, T-SQL, MDX, DAX and DMX. All the query languages have a common coverage that explains Selection, Joins, Grouping, Filtering, Sorting, Navigation, Calculations on the corresponding data models.

Screenshots

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

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

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

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

Reviews

Samantha

November 30, 2021

I would like the course to have subtitles. I can't understand the type of English being spoken here.

Damien

February 10, 2019

Even though, I work daily with Cubes and T-SQL, I though i'd pick up this course to see if there was anything new or a different/ faster method of working.. I'm sure the course is good, but I didn't even get past the 2nd video, the instructors English wasn't great and i struggled to pick up 1 in 5 words spoken.. it just wasn't worth my time rewinding the videos to try and determine if what he was saying was important or relevant..

Bielo

January 18, 2019

Congratulations is an excellent course with varied practical exercises and explained very clearly, also giving scope for self practice. You have my sincere recommendation. Thank you for imparting that knowledge.

Srini

December 3, 2018

I understood clearly for basics but not clear the video for some of the topics ,please let me know what was the problem here.

Nokuthula

November 28, 2018

Im really irritated because I can barely hear the audio, most of the videos are shaded for some reason like they were shot by a dirty camera. There is a lot of important information when you download the zip files that one cant even see or hear on the videos. It appears as if the instructor here didn't really care when he did this. Im so dissapointed I waisted my money coz I started watching long after the 30 days. Its horrible. And he doesn't even engage on questions asked. Whats the point?

Ahlyshawndra

July 12, 2018

This is really good information, well organized and easy to follow and understand. My only request would be to run some of the "final" queries more often.

Zubair

March 26, 2018

Most of the course refers you to the accompanying reference material to know anything useful... I could have just read a book instead of buying this course. The explanation of the original setup was very bad - plus my operating system could not use the SQL 2016 Evaluation package this course uses - which should have been highlighted before. My SQL 2014 does not work fully - hence cannot follow a lot of the examples on my own system.

Brad

March 15, 2018

I've been a SQL Server DBA for around 5yrs now and am transitioning into the OLAP world. This course has helped me towards this step.

Wesam

March 2, 2018

No clear explanation on where or how to install the Sql server or the required files. No responses from the instructor to the students' queries and questions

Suzette

January 31, 2018

The instructor has good, solid, simple queries that get right to the point rather than wasting time lecturing. Great format.

Kenneth

December 18, 2017

I would like to see more real-world scenarios where specific types of queries would be used for DAX, DMX and complex T-SQL. I would also like to see more complex MDX such as ranking functions. It would also be helpful to see examples of well written queries and poorly written queries for each language. This way students can see the correct way to write queries and what to avoid.

Aaron

November 28, 2017

This was a great course and tons of detail in to the four languages. I would reccomend this to anyone who's looking into seeing examples of SQL and DAX.

Dariusz

November 11, 2017

Good course. The title should contain somewhere world like "overview" or "introduction". I was able to listen to the trainer at 1.5x of speed for almost all parts. For sure you can sense that trainer has a great experience in the Microsoft SQL Server Analytical Services technologies. The course will give you a boost to learn more. It would be beneficial if you do by yourself all exercises delivered with this course. This is because video training contains only partial coverage of what example files contain. There are simply too many of them to discuss on video but they are quite simplified on the other hand as well. The best part for me was MDX queries. They were quite well explained with lots of examples. The course would be a little bit easier to digest if some more extensive theoretical introduction were delivered at starting point of each section. It would be nice to catch more ground with glossary of terms before moving further. Some important terms should have been additionally reminded or explained again while discussing MDX|DAX|SQL|DMX queries or traversing inside DW Cube folder structure.

Suresh

November 11, 2017

Instructor is incredibly verbose. Also, mentions "reference material" ad infinitum. I registered for the course to get important features of the matter covered in lectures. Well, is not that material did not get covered. It is that it takes a long time - because of repetitions and allusions to reference material - to cover topics that be covered very quickly. Maybe "reference material" is being alluded to so many times because, you feel that your presentation is lacking. Maybe you can rework your presentation after mentioning "reference material" just once at the beginning of the course. No disrespect was intended.

veselin

June 27, 2017

Course is very well design with a lot of useful examples and reference materials. I wish the presentation level is better.

Charts

Price

Rating

Enrollment distribution

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