آموزش امنیت در اس کیو ال سرور

Introduction to SQL Server: 1. What is a Relational Database 2. SQL Server Data Manipulation Language 3. Using Select 4. Using Insert, Update, and Delete 5. Data Definition Language 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