Sql Use

Oracle SQL Developer : Tips and Tricks  eBooks & eLearning

Posted by naag at Nov. 23, 2016
Oracle SQL Developer : Tips and Tricks

Oracle SQL Developer : Tips and Tricks
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hours | Lec: 21 | 262 MB
Genre: eLearning | Language: English

Learn how to use Oracle SQL Developer and take advantage of its most useful features. Use it smartly.

T-SQL Window Functions [repost]  eBooks & eLearning

Posted by FenixN at Aug. 27, 2016
T-SQL Window Functions [repost]

T-SQL Window Functions
HDRips | MP4/AVC, ~330 kb/s | 1024x768 | Duration: 02:03:00 | English: AAC, 99 kb/s (2 ch) | 360 MB
Genre: Development / Programming

Learn to use the versatile T-SQL functions called "window functions" to solve complex queries.

PowerShell and SQL Server  eBooks & eLearning

Posted by naag at Aug. 27, 2016
PowerShell and SQL Server

PowerShell and SQL Server
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours 48M | 605 MB
Genre: eLearning | Language: English

Learn how to use PowerShell with SQL Server to perform common DBA and Developer tasks.

SQL Server: Replacing Profiler with Extended Events  eBooks & eLearning

Posted by naag at July 3, 2016
SQL Server: Replacing Profiler with Extended Events

SQL Server: Replacing Profiler with Extended Events
June 2016 | MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | 510 MB
Genre: eLearning | Language: English

Use your knowledge of Profiler and Trace to help learn how to effectively use their replacement: Extended Events. If you use Trace or Profiler in SQL Server, in any capacity, this course is relevant to you.

SQL Server: Understanding and Using DBCC Commands  eBooks & eLearning

Posted by naag at March 31, 2016
SQL Server: Understanding and Using DBCC Commands

SQL Server: Understanding and Using DBCC Commands
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2h 16m | 447 MB
Genre: eLearning | Language: English

This course will teach you which DBCC commands to use to enhance your production environment in SQL Server. You'll see demos of how to use DBCC commands, along with replacement Dynamic Management Objects, as well as scenarios for when to use them.
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: Transact-SQL Common Table Expressions

Pluralsight - SQL Server: Transact-SQL Common Table Expressions
MP4 | Video: 1024x768 | 122 kbps | 44 KHz | Duration: 1 Hours | 355 MB
Genre: eLearning | Language: English

Learn how to create and use common table expressions (CTEs) correctly, for developers and DBAs from SQL Server 2005 onward

Introduction To Transact-SQL  eBooks & eLearning

Posted by ParRus at Sept. 13, 2015
Introduction To Transact-SQL

Introduction To Transact-SQL
WEBRip | English | MP4 | 960 x 540 | AVC ~328 kbps | 29.970 fps
AAC | 160 Kbps | 48.0 KHz | 2 channels | 4h 46mn | 923.9 MB
Genre: Video Tutorial / Development, Programming

Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database. Jeff Jones, an IT professional with over forty years of experience shows you how to use the tools available in Transact-SQL to discover the database definition, access tables, submit queries, and view the results.
Pluralsight - SQL Server Optimizing Stored Procedure Performance

Pluralsight - SQL Server Optimizing Stored Procedure Performance
MP4 | AVC 743kbps | English | 1024x768 | 30fps | 7h 11mins | AAC stereo 126kbps | 1.79 GB
Genre: Video Training

If you want to use SQL Server databases effectively, you will end up using stored procedures. Their aim is that you have optimized and compiled code that resides in a cache to improve workload performance for subsequent executions. However, you might find that it does not always work out that way. The performance of a stored procedure is heavily dependent on how the plan is chosen and cached. If the plan is not optimal for subsequent executions it could cause performance to suffer greatly. In the end, you might suffer from what is known as parameter-sniffing-problems where the optimal plan for a procedure varies based on the parameters supplied. This comprehensive course will teach you how stored procedure plan caching works and how to get SQL Server to produce the optimal plan for your stored procedure performance in a variety of circumstances. The course is applicable to SQL Server developers and anyone who is responsible for writing stored procedures that must repeatedly perform well.
Microsoft SQL Server 2005 Programming For Dummies by Andrew Watt [Repost]

Microsoft SQL Server 2005 Programming For Dummies by Andrew Watt
English | Apr 2, 2007 | ISBN: 0471774227 | 435 Pages | PDF | 5 MB

SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more.