Your cart is empty.
Keep shoppingMastering SQL Server Query Languages - T-SQL, MDX, DAX & DMX
1,596 students
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 bySiddharth Mehta
Last updated 3/2019
English
What you'll 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
Explore related topics
Course content
7 sections • 47 lectures • 6h 34m total length
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.
Description
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.
Who this course is for:
- 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