-
Administrative Tools
-
Lecture 1.1Upgrading to SQL Server Management Studio
-
Lecture 1.2Management Studio Windows
-
Lecture 1.3Registered Servers
-
Lecture 1.4Object Explorer
-
Lecture 1.5Review Database Objects
-
Lecture 1.6Modify Database Properties
-
Lecture 1.7Create Database Scripts
-
Lecture 1.8The Maintenance Plans Node
-
Lecture 1.9Solution Explorer
-
Lecture 1.10Query Editor
-
Lecture 1.11Template Explorer
-
Lecture 1.12Dynamic Help
-
Lecture 1.13Upgrading to SQL Server Computer Manager
-
Lecture 1.14SQL Server 2005 Services node
-
Lecture 1.15SQL Server 2005 Network Configuration node
-
Lecture 1.16SQL Server 2005 Native Client Configuration node
-
Lecture 1.17The SQLCMD Management Utility
-
Lecture 1.18SQLCMD Syntax
-
Lecture 1.19SQLCMD Variables
-
Lecture 1.20Dedicated Administrative Connection
-
Lecture 1.21SQL Server Management Studio SQLCMD Mode
-
Lecture 1.22Using SQL Management Objects
-
Lecture 1.23SMO Object Model
-
-
Monitoring the Database Server
-
Database and Index Maintenance
-
Lecture 3.1Index Management
-
Lecture 3.2New Index Features
-
Lecture 3.3Creating Indexes
-
Lecture 3.4Online Index Maintenance
-
Lecture 3.5Parallel (multiple CPU) Index Operations
-
Lecture 3.6Lock Options
-
Lecture 3.7Included Columns in Indexes
-
Lecture 3.8Partitioned Tables and Indexes
-
Lecture 3.9XML Index Support
-
Lecture 3.10Altering an Index
-
Lecture 3.11Rebuilding an Index
-
Lecture 3.12Reorganizing an Index
-
Lecture 3.13Disabling an Index
-
Lecture 3.14Dropping an Index
-
Lecture 3.15Index Fragmentation
-
Lecture 3.16Using the Database Tuning Advisor
-
-
Securing SQL Server 2005---
-
Lecture 4.1Implementing Securable
-
Lecture 4.2New Security Features
-
Lecture 4.3Principals
-
Lecture 4.4Securable
-
Lecture 4.5Permissions
-
Lecture 4.6Permission Types
-
Lecture 4.7Managing Logins
-
Lecture 4.8Managing Users
-
Lecture 4.9Managing Schemas
-
Lecture 4.10Schema Definition
-
Lecture 4.11Using Schemas
-
Lecture 4.12Managing Execution Context
-
Lecture 4.13Managing Permissions
-
Lecture 4.14Manage Server Permissions
-
Lecture 4.15Manage Server-Scope Securable Permissions
-
Lecture 4.16Manage Database Permissions
-
Lecture 4.17Manage Database-Scope Securable
-
Lecture 4.18Permissions
-
Lecture 4.19Managing Certificates
-
Lecture 4.20Native Data Encryption
-
Lecture 4.21Code and Module Signing
-
-
SQL Server Disaster Recovery---
-
Lecture 5.1Disaster Recovery
-
Lecture 5.2SQL 2005 Disaster Recovery Feature
-
Lecture 5.3Enhanced Features
-
Lecture 5.4Database Snapshots
-
Lecture 5.5Creating a Snapshot
-
Lecture 5.6Common Snapshot Applications
-
Lecture 5.7Undeleting table rows
-
Lecture 5.8Undoing a table update
-
Lecture 5.9Recovering a dropped object
-
Lecture 5.10Backup and Restore
-
Lecture 5.11Backup Changes
-
Lecture 5.12Media Integrity Changes
-
Lecture 5.13Recovering the MASTER Database
-
Lecture 5.14Create a mirrored backup
-
Lecture 5.15Restore from the backup mirror
-
Lecture 5.16Create a snapshot
-
Lecture 5.17Restore the snapshot data
-
Lecture 5.18Automate the creation of daily snapshots
-
-
Database Availability-------------
-
Lecture 6.1SQL 2005 Data Availability
-
Lecture 6.2Database Mirroring
-
Lecture 6.3The Witness Server and Automatic Failover
-
Lecture 6.4Configuring Database Mirroring
-
Lecture 6.5Transaction Safety Level
-
Lecture 6.6Operating Modes
-
Lecture 6.7High Availability Operating Mode
-
Lecture 6.8High Protection Operating Mode
-
Lecture 6.9High Performance Operating Mode
-
Lecture 6.10Mirroring Security
-
Lecture 6.11Monitoring Mirroring
-
Lecture 6.12Database States for Database Mirroring
-
Lecture 6.13Prepare the Servers
-
Lecture 6.14Configure Mirroring
-
Lecture 6.15Verify Principal and Mirror Access
-
Lecture 6.16Terminating the Mirror Session
-
-
Integration Services-----------
-
Monitoring and Performance
-
Lecture 8.1SQL Server Profiler
-
Lecture 8.2Optimal Data Storage
-
Lecture 8.3Diagnostic Tools
-
Lecture 8.4Query Analyzer
-
Lecture 8.5Database Engine Tuning Advisor
-
Lecture 8.6Index Optimization
-
Lecture 8.7Federated Database Servers
-
Lecture 8.8Partitioned Indexes
-
Lecture 8.9Lock optimization
-
Lecture 8.10Best Practices for Native XML Web Services
-
Related Courses
Oracle DBA
Oracle Database Architecture: An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of…
Sap Hana
SAP HANA ADMINISTRATOR COURSE SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. In SAP HANA, HANA stands for High-Performance Analytic Appliance. SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud.…
Leave feedback about this