Durasi : 3 hari
Description:
The SQL Server administration training provides you with the knowledge and skills you need to administer SQL Server database servers effectively.
This training is for database administrators and developers, who want to administer SQL Server successfully.
All students will:
- Install and configure Microsoft SQL Server
- Understand the concept of Microsoft SQL Server
- Implement and maintain indexes
- Take database snapshots
- Secure SQL Server
- Back up and recover data
Prerequisites:
- User know basic of database
- User know basic T-SQL
Course Topic
Session 1: Getting Started
- What is SQL Server
- Install the SQL Server
- Connect to the SQL Server
- SQL Server Sample Database
- Load Sample Database
Session 2: Basic
- System databases and their purposes
Session 3: Managing Logins, Users, Permissions and Roles
- Create Login
- Create User
- Grant permissions
- Revoke permissions
- Alter Login
- Alter User
- Drop Login
- Drop User
- CREATE ROLE
- ALTER ROLE
- DROP ROLE
Session 4: Blocking & Deadlock
- Blocking
- Deadlock
Session 5:Table Partitioning
- Create a partitioned table
- Partitioning an existing table
Session 6: Database snapshots & contained databases
- Database Snapshot
- Contained Databases
Session 7: Import / Export Data
- Bulk Copy Data (BCP)
- BULK INSERT
Session 8: Managing Indexes
- Clustered indexes
- Create nonclustered indexes
- Rename indexes
- Disable indexes
- Enable indexes
- Unique indexes
- Drop indexes
- Indexes with included columns
- Filtered indexes
- Indexes on computed columns
Session 9: Managing Triggers
- Creating a trigger in SQL Server
- Creating an INSTEAD OF trigger
- Creating a DDL trigger
- Disabling triggers
- Enabling triggers
- Viewing the definition of a trigger
- Listing all triggers in SQL Server
- Removing triggers
Session 10: Encryption
- Environment set up
- Create a database master key for column level SQL Server encryption
- Create a self-signed certificate for Column level SQL Server encryption
- Configure a symmetric key for column level SQL Server encryption
- Data encryption
- Decrypt column level SQL Server encryption data
- Permissions required for decrypting data
Session 11: Backup & Restore
- Recovery model
- Backup types
- Full backup
- Differential Backup
- Transaction Log Backup