SQL Designing, Optimizing, and Maintaining a Database 70-450 Training Course

Section A: Designing Database SolutionsSection B: Storage ConsiderationsSection C: Understanding TempdbSection D: Designing SQL Server InstancesSection E: Other Instance Configuration OptionsSection F: Understanding Physical DatabasesSection G: Creating Databases with Transact-SQLSection A: FILESTREAM and Full-Text IndexesSection B: SQL Server Upgrade PlanningSection C: Understanding Database ConsolidationSection D: Business FactorsSection E: SQL Server Instance AuthenticationSection F: Windows Service AccountsSection G: Key ManagementSection H: Enterprise Key ManagementSection I: Securing EndpointsSection A: Database PermissionsSection B: Schemas and Application RolesSection C: Ownership ChainingSection D: CLR and Service BrokerSection E: Policy-Based ManagementSection F: Gathering Security InformationSection G: Extended EventsSection H: Event NotificationSection I: Encryption StrategySection A: Clustering and Log ShippingSection B: Design Database MirroringSection C: High Availability with ReplicationSection D: Replication PlanningSection E: Selecting a High-Availability SolutionSection A: Planning Database RecoverySection B: Full Backups and RestoresSection C: Transaction Log Backups and RestoresSection D: Differential Backups and RestoresSection E: Recovery Test PlansSection F: OS Level Monitoring SolutionsSection A: Data CollectionSection B: Index Tuning and DMVsSection C: The Performance StudioSection D: Dedicated Administrator ConnectionsSection E: Page-Level Data CompresssionSection F: Heap and Index MaintenanceSection A: Table PartitionsSection B: Implementing Resource GovernorSection C: Understanding Resource GovernorSection D: Resource Governor MonitoringSection E: Management and CompressionSection F: Management Automation StrategySection G: Administering SSISSection H: Linked ServersSection I: Data Distribution via Replication

Learning@Home is an international learning provider and is committed to excellence in training delivery. We aim to make the option of further education accessible to everyone, allowing you to truly take control over your learning by focusing on those who are unable to attend classroom or taught sessions. We currently offer over 600 distance learning courses accredited by a number of established Awarding Bodies including Active IQ, AQA, CISCO, Edexcel, ICB, Microsoft, NCFE, and Sage.