CBT Nuggets – Microsoft SQL Server 2012 Querying (70-461)

CBT Nuggets – Microsoft SQL Server 2012: Querying (70-461)
English | Size: 3.17 GB
Category: Tutorial


This Microsoft training course with Garth Schulte will teach you how to write queries using SQL Server 2012. Learn to create and alter tables with T-SQL, implement subqueries, manage transactions, and more, as you prepare for Microsoft’s 70-461 exam, one of three exams that must be passed to receive your MCSA: SQL Server 2012/2014 certification. [Read more…]

PluralSight – Querying Data Using Map reduce in MongoDB

PluralSight – Querying Data Using Map reduce in MongoDB Bookware-KNiSO
English | Size: 143.35 MB
Category: Tutorial


Working with large volumes of document data for analytics requires the power and flexibility of MongoDB s Map-reduce feature. In this course, Querying Data Using Map-reduce in MongoDB, you ll gain the ability to get yourself fully equipped to confidently apply the Map-reduce pattern to any data set no matter how large it could be. First, you ll discover the requirement for Map-reduce among other aggregation capabilities of MongoDB. Next, you ll explore how to create a custom JavaScript map function and a reduce function that are needed to perform map and reduce operations. Finally, you ll learn how to use these custom functions to perform a Map-reduce operation on a MongoDB data set to aggregate results across documents. When you re finished with this course, you ll have the skills and knowledge of working with the Map-reduce function in MongoDB that will help you leverage the power of MongoDB s aggregation feature for data crunching requirements in your next project [Read more…]

PluralSight – Querying And Shaping Data In Power BI Using M

PluralSight – Querying And Shaping Data In Power BI Using M-REBAR
English | Size: 278.60 MB
Category: Tutorial


We all have to deal with dirty data. By using the M language, we can clean and prep our data for use in Power BI. M turns manual data cleanup into an automated process. [Read more…]

PluralSight – Querying Geospatial Data from MongoDB

PluralSight – Querying Geospatial Data from MongoDB-BOOKWARE-KNiSO
English | Size: 114.82 MB
Category: Tutorial


Release Notes: Analyzing spatial data doesn’t have to be a difficult task. In this course Querying Geospatial Data from MongoDB, you ll learn to execute geospatial queries in MongoDB. First, you ll explore the concepts needed to understand the geospatial features of MongoDB. Next, you ll discover how to store geospatial data in GeoJSON format. Finally, you ll learn how to find places within a certain area and close to a point. When you re finished with this course, you ll have the skills and knowledge of MongoDB and geospatial data needed to execute geospatial queries efficiently [Read more…]

PluralSight – Querying JSON XML and Temporal Data with T SQL

PluralSight – Querying JSON XML and Temporal Data with T SQL
English | Size: 419.82 MB
Category: CBTs

The most common scenario with SQL Server is querying structured data. But many do not know that it also allows storing and querying semi-structured data using XML and JSON; as well as obtaining values from any point in time with temporal tables. [Read more…]

PluralSight – Querying JSON XML and Temporal Data with T SQL

PluralSight – Querying JSON XML and Temporal Data with T SQL-BOOKWARE-KNiSO
English | Size: 419.82 MB
Category: Tutorial

The most common scenario with SQL Server is querying structured data. But many do not know that it also allows storing and querying semi-structured data using XML and JSON; as well as obtaining values from any point in time with temporal tables. [Read more…]