|
|
|
|
- Overview of Microsoft SQL Server 2008
- Database Engine
- Business Intelligence
- Installing and Configuring SQL Server 2008
- Upgrading to SQL Server 2008
- Installing SQL Server 2008
- Editions of SQL Server 2008
- Service Accounts
- Collation Sequences
- Authentication Modes
- Infrastructure Requirements
- SQL Server Instances
- Using the Tools in SQL Server 2008
- SQL Server Documentation
- Business Intelligence Tools
- Management Tools in SQL Server 2008
- Performance Management Tools
- Designing Tables
- Naming Objects
- Schemas
- Data Types
- Column Properties
- Constraints
- Database Diagrams
- Creating Tables
- Computed Columns
- Sparse Columns
- Creating Databases
- SQL Server System Databases
- SQL Server Database Structure
- Creating a Database
- Moving Databases
- Database Snapshots
- Creating a Database Snapshot
- Reverting Data Using a Database Snapshot
- Indexes
- Index Structure
- Clustered Indexes
- Online Index Creation
- Nonclustered Indexes
- Included Columns
- Filtered Indexes
- Index Management and Maintenance
- XML Indexes
- Spatial Indexes
- Partitioning
- Partition Functions
- Partition Schemes
- Partitioning Tables and Indexes
- Managing Partitions
- Service Broker
- Service Broker Architecture
- Message Types and Contracts
- Queues and Services
- Conversations
- Sending and Receiving Messages
- Queue Activation
- Prioritization
- Full-Text Indexing
- Querying Full-Text Data
- Full-Text Catalogs
- Full-Text Indexes
- Security
- Configuring the Attack Surface
- Data Encryption
- Principals, Securables, and Permissions
- Endpoints
- CLR Security
- Policy-Based Management
- Overview of Policy-Based Management
- Policy Categories
- Facets
- Policy Targets
- Policies
- Conditions
- Policy Compliance
- Data Recovery
- Database Backups
- Recovery Models
- Database Restores
- SQL Server Agent
- Creating Jobs
- Creating Maintenance Plans
- Creating Alerts
- Dynamic Management Views
- Overview of DMVs
- Retrieving Object Metadata
- Database Diagnostics
- High Availability
- Failover Clustering
- Replication
- Database Mirroring
- Log Shipping
Conclusion
College Students from Gujarat (Ahmedabad, Vadodara, Rajkot, Jamnagar, Mehsana, Surat, Valsad, Bhavnagar, Patan) Amreli, Gandhinagar Gujarat, Udaipur, Jaipur, Jodhpur, Rajasthan, Madhya Pradesh (M.P) BCA, MCA, BE IT, BE Tech, BSC IT can also join.
|
|
|