دانلود Pluralsight SQL Server Tutorial Series دوره های آموزشی اس کیو ال سرور

Redgate SQL Prompt:
1. SQL Prompt Completion
2. SQL Prompt Snippets
3. SQL Prompt Refactoring

SQL Server - TSQL:
1. T-SQL and the CLR
2. T-SQL and the CLR II
3. T-SQL I
4. T-SQL II
5. T-SQL III

SQL Server Fundamentals:
1. Introduction to SQL Server
2. CTE's and Ranking
2. Using Group By and Having
3. CTE's and Ranking
4. Hierarchies
5. Managing Query Plans
6. Recursion, Pivoting, and Sampling
7. Security I
8. Security II

SQL Server Management Studio by Example:
1. Integrate SQL Prompt with Intellisense and Templates
2. Working with Queries in SQL Server Management Studio
3. SQL Server Management Studio Object Explorer

SQL Server Performance Indexing Basics:
1. Introduction
2. Fundamentals of Indexing
3. Practical Indexing Implementation Techniques
4. Index Maintenance
5. Introduction to Columnstore Index
6. Indexing Practical Performance Tips and Tricks
7. Checklist Index and Performance

SQL Server Questions and Answers:
1. Introduction
2. Retrieving IDENTITY value using @@IDENTITY
3. Concepts Related to Identity Values
4. Difference between WHERE and HAVING
5. Order in WHERE clause
6. Concepts Around Temporary Tables and Table Variables
7. Are stored procedures pre-compiled
8. UNIQUE INDEX and NULLs problem
9. DELETE VS TRUNCATE
10. Locks and Duration of Transactions
11. Nested Transaction and Rollback
12. Understanding DateTime Datatypes
13. Differences between VARCHAR and NVARCHAR datatypes
14. Precedence of DENY and GRANT security permissions
15. Identify Blocking Process
16. NULLS usage with Dynamic SQL
17. Appendix Tips and Tricks with Tools

Using XML and XQuery Effectively with SQL Server:
1. XML Intro - The XML Data Type
2. XML Schema Support
3. XQuery Introduction
4. XQuery Using XQuery with XML data type methods
5. XQuery Performance and XML Indexes
6. Hybrid Applications Using XML and Relational Together

Security and Encryption in SQL Server 2012 and 2014:
Security in SQL Server is often overlooked. Companies tend to concentrate on availability and performance, but a database system often stores virtually all of a company's valuable and confidential data. So what happens if this data is stolen? In this course, we will cover all areas you need to protect to effectively secure SQL Server. It means system and network protection, user authentication, permissions on the objects and data, and data encryption. We will also use some penetration testing frameworks to show you how attacks are performed against SQL Server through various types of exploits, including SQL injection. The course is focused on SQL Server 2012 and 2014, but most of the information applies to all versions from SQL Server 2005 onward.

Topics include:
- Introduction to Security With SQL Server
- Server and System Security
- Penetration Testing
- Authentication and Logins
- Roles and Permissions   
- Fighting SQL Injections
- Encryption

Practical Data Modeling With C# and SQL Server:   
- Origin Story! Birth of a Data Model   
- Clones! Replicants! The Importance of Normalization   
- Coding the Data Model   
- Erased From Existence! Maintaining Data Integrity Over Time   
- Everything's Connected: Removing Unnecessary Dependencies   
- Final Issue!

SQL Server: Optimizing Stored Procedure Performance:
When using stored procedures, their performance is dependent on creating the optimal plan for the execution environment and making sure that it remains cached. This comprehensive course will show you all of that and more, and is applicable to SQL Server developers and anyone responsible for ensuring performance of stored procedures, from SQL Server 2005 onward.

Topics include:
- Introduction
- Why Use Stored Procedures?
- Creation, Compilation, and Invalidation
- Other Concerns and Considerations

SQL Server: Common Query Tuning Problems and Solutions - Part 1:
Learn to recognize and diagnose numerous types of SQL Server query performance problems. This course is perfect for developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onward.

Topics include:
- Course Introduction
- Validating Assumptions   
- Troubleshooting Bad Assumptions
- Tuning Imprecision Problems

SQL Server: Common Query Tuning Problems and Solutions - Part 2:
This course teaches how to recognize and diagnose numerous types of SQL Server query performance problems.

Topics include:
- Course Introduction
- Troubleshooting Inefficiency
- Tuning OLTP vs. DSS Patterns
- Advanced Query Tuning Patterns

SQL Server: Installing and Configuring SQL Server 2016
Learn how to correctly install and configure SQL Server 2016, including configuration of Windows and storage for stability and performance, and post-installation updates, configuration, and database maintenance.

How do you configure Windows correctly for running SQL Server 2016? How do you choose a RAID level for the SQL Server storage? Which installation options should you choose for SQL Server, and how do you keep SQL Server up-to-date after installing it? This course, SQL Server: Installing and Configuring SQL Server 2016, answers all these questions and more. The course begins by explaining why it is so important to install SQL Server 2016 correctly and then explains how to configure Windows for stability and performance. It then describes and shows the SQL Server 2016 installation process, including which options to choose or not, along with common configuration mistakes to avoid. After that it explains how to keep your SQL Server 2016 instance up-to-date with Service Packs and Cumulative Updates, as well as post-installation configuration tasks. Finally it explains how to configure Database Mail and SQL Server Agent Alerts so that you are notified of critical errors when they occur. When you're finished with this course, you'll be better prepared to install SQL Server for the first time.

Table of Contents:
- Course Overview
- Introduction
- Pre-installation Tasks for the Operating System
- Pre-installation Tasks for SQL Server 2016
- Installing SQL Server 2016
- Post-installation Tasks for SQL Server 2016
- Automating Common Maintenance Tasks

SQL Server: Introduction to Query Store
One of the most highly anticipated new features in SQL Server 2016 is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and run-time statistics.

The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. This is the first time Microsoft has provided the ability to natively capture baseline data within SQL Server. In this course, SQL Server: Introduction to Query Store, you'll configure Query Store and understand how the settings affect the data stored. First, you'll review the different options for Query Store and will look at examples of what gets collected. Next, you'll dig through the included reports. Finally, you'll see how you can force SQL Server to use a specific plan for a query. By the end of this course, you'll be more confident with Query Store, as it will show you how to enable and configure Query Store.

Table of Contents:
- Course Overview
- Introduction
- Defining Query Store
- Implementing Query Store
- Forcing Plans with Query Store
- Practical Uses of Query Store