001 Welcome |
002 What you should know before watching this course |
003 Setting up for the course |
004 Planning a database server infrastructure |
005 Considerations for database server consolidation |
006 Managing server resources in a consolidated database infrastructure |
007 Designing OLTP databases |
008 Using first normal form |
009 Using second normal form |
010 Using third normal form |
011 Designing data warehouses |
012 Understanding files and filegroups |
013 Using multiple files |
014 Planning for partitioning |
015 Planning compression |
016 Restoring filegroups separately |
017 Enabling FileStream access |
018 Using FileStream data |
019 Understanding indexes |
020 Using indexes |
021 Working with query plans |
022 Working with columnstore indexes |
023 Indexing tips |
024 Introduction to policy-based management |
025 Implementing policy-based management |
026 Extending policy-based management to repair problems |
027 Using policy-based management to prevent problems |
028 Introduction to server health monitoring |
029 Populating the data warehouse |
030 Exploring health data |
031 Introduction to Windows PowerShell |
032 Using Windows PowerShell to run SQL commands |
033 Performing an SQL backup with PowerShell |
034 Goodbye |
آموزشی