SQL, SSAS & Data Mining Query Languages - T-SQL MDX DAX DMX
4.4 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
349 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL, SSAS & Data Mining Query Languages - T-SQL MDX DAX DMX to your Wishlist.

Add to Wishlist

SQL, SSAS & Data Mining 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
Bestselling
4.4 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
349 students enrolled
Created by Siddharth Mehta
Last updated 4/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 6 Articles
  • 44 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
View Curriculum
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 is the 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
47 Lectures
06:34:43
+
Introduction
2 Lectures 12:39

Introduction with Instructor

Preview 02:16

Walk-through of Course objectives and Course requirements 

Preview 10:23
+
Fundamentals, Tools Setup and Reference Guides
6 Lectures 48:57

Learn how to install and configure SQL Server 2016 and SQL Server Analysis Services 2016

SQL Server Installation
09:25

Install sample OLTP database, OLAP databases and Data Mining Models

Installing Sample Databases
05:09

Learn basics of SQL Server and download all the SQL Server and T-SQL related reference guides created from Microsoft Docs

SQL Server Basics and Reference Guides
09:53

Learn basics of SQL Server Analysis Services and download all the MDX and DAX related reference guides created from Microsoft Docs

SSAS Basics and MDX + DAX Reference Guides
12:18

Learn basics of Data Mining and download all the DMX related reference guides created from Microsoft Docs

Data Mining Basics and Reference Guide
11:34

Comparison of SSAS Multidimensional vs SSAS Tabular
00:38
+
Basic T-SQL
14 Lectures 02:47:39

Learn how to select data using T-SQL SELECT Statement

Select Statement - Part 1
14:33

Learn how to select data using T-SQL SELECT Statement

Select Statement - Part 2
09:44

Learn how to select data using T-SQL SELECT Statement

Select Statement - Part 3
11:44

Learn how to select data using T-SQL SELECT Statement

Select Statement - Part 4
12:57

Learn how to join data from different tables in T-SQL

Joins
19:38

Learn how to group data in T-SQL

Grouping
15:11

Learn using variables and looping constructs in T-SQL

Variables & Loops
07:26

Learn Error Handling and Dynamic SQL using T-SQL

Error Handling and Dynamic SQL
12:01

Learn how to filter data and use advance looping techniques in T-SQL

Subquery, Pivoting, Ranking, and CTE
18:50

Learn how to use system and user-defined functions in T-SQL

System Functions and User Defined Functions
11:36

Learn how to develop stored procedures using T-SQL

Stored Procedures
11:30

Learn how to develop tables and views using T-SQL

Tables and Views
12:20

Learn how to manipulate data in T-SQL using Insert, Update and Delete commands

Insert / Update / Delete
07:19

Glossary of SQL Server and T-SQL Terms

Glossary of SQL Server and T-SQL Terms
02:50
+
Data Analysis Expressions
7 Lectures 34:58

Learn the Fundamentals of DAX Expression Language

Fundamentals of DAX Expression Language
07:01

Learn how to select data from multi-dimensional models using DAX

Selecting Data
07:19

Learn how to filter data from multi-dimensional models using DAX

Filtering Data
02:48

Learn how to group data from multi-dimensional models using DAX

Grouping Data
05:12

Learn how to select data from dimensions and facts using DAX

Joining Data
03:41

Learn how to use complex functions on tabular data models using DAX

Complex Functions
08:03

Glossary of DAX Terms

Glossary of DAX Terms
00:54
+
Multi-Dimensional Expressions
12 Lectures 01:36:56

Learn how to select data from multi-dimensional models using MDX

Selecting Data
10:37

Learn how to work with dimensions, attributes and members in multi-dimensional models using MDX

Dimensions, Attributes and Members
15:20

Learn how to navigate data from multi-dimensional models using MDX

Navigating Data
13:50

Learn how to sort data from multi-dimensional models using MDX

Sorting Data
05:41

Learn how to filter data from multi-dimensional models using MDX

Filtering Data
10:58

Learn how to develop complex calculations in multi-dimensional models using MDX

Calculations
10:04

Learn how to work with date and time in multi-dimensional models using MDX

Date & Time
05:13

Learn how to develop aggregations in multi-dimensional models using MDX

Aggregations
07:22

Learn how to develop sets in multi-dimensional models using MDX

Sets
06:04

Learn how to develop subcubes in multi-dimensional models using MDX

Subcubes
05:36

Learn how to work with KPIs in multi-dimensional models using MDX

Key Performance Indicators
04:27

Glossary of MDX Terms

Glossary of MDX Terms
01:44
+
Data Mining Extensions
4 Lectures 29:07

Learn how to select cases and contents from data mining models using DMX

Case and Content Queries
10:57

Learn how to select prediction output from data mining models using DMX

Prediction Queries
09:57

Learn how to query clusters related data from data mining models using DMX

Cluster Queries
07:24

Glossary of DMX Terms

Glossary of DMX Terms
00:49
+
Summary
2 Lectures 04:52

Course Wrap-up and Next Steps

Summary and Next Steps
03:51

Discount coupons of my other courses

Bonus Lecture - Discounts
01:01
About the Instructor
Siddharth Mehta
4.1 Average rating
455 Reviews
5,266 Students
7 Courses
Published Author, Microsoft MVP Alumni, Sr. Tech Arch

My name is Siddharth Mehta. I work in the role of a Senior Technology Architect with a multinational IT firm. I have career experience of more than 14 years in the IT industry working with multinational IT companies and Fortune 500 clients. 

Industry Experience

-|- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains

-|- I usually work as a lead architect for a portfolio of applications in web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other categories.

-|- In my present role, I remain responsible for Arch Design, Tech Stack selection, Infra design, 3rd party products evaluation and procurement, and Performance engineering. My primary specialty is Microsoft SQL Server and Microsoft Business Intelligence. I usually work with MS BI integration with cross technologies like Elasticsearch / Lucene, MongoDB, Sharepoint 2013 and 2010, jQuery based framework like Highcharts and GoJS, jQueryMobile, Bootstrap, iOS xCode framework, and many others.

Authoring Achievements

-|- I have authored more than 200 articles and tutorials collectively for online publications like mssqltips, sqlserverperformance, sqlservercental, techrepublic and others.

-|- I have authored / co-authored as well as reviewed books for print-media publication houses like Manning publication, Packt publication.

-|- I have also authored a whitepaper for MSDN Library titled: Bulk report generation using SSIS and SSRS 2008 R2.

Certifications

-|- TOGAF 9 Part I & II certified architect
-|- CITA-F certified architect
-|- HCAHD (Hortonworks Hadoop certified)
-|- MCSD.Net, and MCTS in SQL Server maintenance as well as Developing BI apps using SQL Server
-|- Certified Sr. Technology Architect as well as Digital Architect

Academics

Master of Science with major in Computer Applications and Information Technology