Query

Advanced Database Query Systems [Repost]  eBooks & eLearning

Posted by tanas.olesya at Oct. 14, 2016
Advanced Database Query Systems [Repost]

Advanced Database Query Systems: Techniques, Applications and Technologies by Li Yan
English | 30 Oct. 2011 | ISBN: 160960475X | 411 Pages | PDF | 5 MB

Advanced Database Query Systems: Techniques, Applications and Technologies focuses on technologies and methodologies of database queries, XML and metadata queries, and…

Sachin Quickly Learns (SQL) - Structured Query Language  eBooks & eLearning

Posted by naag at Aug. 26, 2016
Sachin Quickly Learns (SQL) - Structured Query Language

Sachin Quickly Learns (SQL) - Structured Query Language
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1.5 Hours | Lec: 13 | 234 MB
Genre: eLearning | Language: English

Learn "Structured Query Language" on MS Access 2007, using Sachin Tendulkar's International Test Cricket Data.

Excel Power Pivot and Power Query For Dummies  eBooks & eLearning

Posted by AlenMiler at March 27, 2016
Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies by Michael Alexander
English | Apr 11, 2016 | ISBN: 111921064X | 304 Pages | AZW3/MOBI/EPUB/PDF (conv) | 42.83 MB

A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query?

Pluralsight - SQL Server Query Plan Analysis  

Posted by naag at Feb. 10, 2016
Pluralsight - SQL Server Query Plan Analysis

Pluralsight - SQL Server Query Plan Analysis
MP4 | Video: AVC 1024x768 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 14Min | 507 MB
Genre: eLearning | Language: English

Learn how to interpret and analyze SQL Server query plans, making performance problems easier to recognize and understand, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards

Environmental IT 101: Manipulation and Query Language  

Posted by AlenMiler at Jan. 29, 2016
Environmental IT 101: Manipulation and Query Language

Environmental IT 101: Manipulation and Query Language by Amir Hamzah Sharaai
English | Jan. 25, 2016 | ASIN: B01B2D88KW | 37 Pages | AZW3/EPUB/PDF (conv) | 2.65 MB

Manipulation and Query Language is about Structured Query Language (SQL) and Data Manipulation Language (DML) which terms used in database system, to manage the database.
T-SQL For Beginners: Learn to Query SQL Server Databases

T-SQL For Beginners: Learn to Query SQL Server Databases
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | 428 MB
Genre: eLearning | Language: English

Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server Databases
Pluralsight - SQL Server: Common Query Tuning Problems and Solutions - Part 2

Pluralsight - SQL Server: Common Query Tuning Problems and Solutions - Part 2
MP4 | AVC 549kbps | English | 1024x768 | 15fps | 2h 17mins | AAC stereo 128kbps | 558 MB
Genre: Video Training

There are a wide variety of common performance problems that you will encounter when query tuning. Part 2 of this two-part course begins by covering common problems arising from writing and using inefficient Transact-SQL code. You'll then learn about query performance problems and associated query tuning solutions for situations where the query and/or design is inappropriate for the workload type. Finally, the course will cover a variety of more advanced query tuning problem and solutions. The course is very demo-centric, with lots of practical tips and tricks you'll be able to apply in your environment. This course is perfect for developers, DBAs, and anyone responsible for query performance tuning in SQL Server, from SQL Server 2005 onward.
Pluralsight - SQL Server: Common Query Tuning Problems and Solutions - Part 1 [repost]

Pluralsight - SQL Server: Common Query Tuning Problems and Solutions - Part 1
MP4 | AVC 666kbps | English | 1024x768 | 15fps | 2h 31mins | AAC stereo 125kbps | 747 MB
Genre: Video Training

There are a wide variety of common performance problems that you will encounter when query tuning. Part 1 of this two-part course begins by showing how to validate query execution assumptions around statistics and cardinality in order to ensure you're troubleshooting the true root cause of a query performance issue. You'll then learn about common areas where bad assumptions can occur that negatively impact overall query performance, and about common problems and solutions related to being imprecise when querying a database. The course is very demo-centric, with lots of practical tips and tricks you'll be able to apply in your environment. This course is perfect for developers, DBAs, and anyone responsible for query performance tuning on SQL Server, from SQL Server 2005 onward.
Pluralsight - SQL Server: Troubleshooting Query Plan Quality Issues [repost]

Pluralsight - SQL Server: Troubleshooting Query Plan Quality Issues
WMW | WMV3 538kbps | English | 1024x768 | 15fps | 2h 20mins | WMA2 stereo 128kbps | 396 MB
Genre: Video Training

There are many problems that can lower the performance of your workload and one of the most common is an incorrect query plan. Often the poor query plan is chosen because the cardinality estimate is wrong - the estimate by the query processor of how many table rows will be involved in the query. This course shows you how to recognize when the query processor has an incorrect estimate, along with explaining and showing a multitude of possible causes, plus how to fix them. The course starts with explaining why query plan quality is important, and then shows how to easily spot cardinality estimate issues from examining query plans. The majority of the course shows all the possible causes of cardinality estimates being incorrect along with how to fix them, and more than 25 demos to walk you through practical examples of the concepts and problems in the lectures.
Data Management and Query Processing in Semantic Web Databases (repost)

Data Management and Query Processing in Semantic Web Databases
by Sven Groppe
English | 2011 | ISBN: 3642193560 | 279 pages | PDF | 4.88 MB