Sql Server DBA Training Syllabus:
SQL Server 2008 Overview
- Availability and Scalability Features
- Security Features
- Data Management Features
- Administration and Maintenance Features
- Development Features
- To enable SQLiMail
- Testing mail delivery
Installing and Configuring SQL Server 2008
- SQL Server 2008 Editions
- Installing Microsoft SQL Server
- System Requirements
- Preparing for a SQL 2008 Installation
- Installation Checklist
- Setup Features
- Using the System Consistency Checker
- Component Install
- Unattended Installation
- Upgrading from previous versions of SQL Server
- To verify the Installation
- Administrative Tools
SQL Server Management Studio and other tools
- Management Studio Windows
- Registered Servers
- Object Explorer
- Review Database Objects
- Modify Database Properties
- Create Database Scripts
- The Maintenance Plans Node
- Solution Explorer
- Query Editor
- Upgrading to SQL Server Computer Manager
- SQL Server 2008 Services node
- SQL Server 2008 Network Configuration node
- SQL Server 2008 Native Client Configuration node
- The SQLCMD Management Utility
- SQLCMD Syntax
- SQLCMD Variables
- Dedicated Administrative Connection
- SQL Server Management Studio SQLCMD Mode
- Using SQL Management Objects
- BCP in and out with Format files and Bulk Insert
- Import Export Wizard
Monitoring the Database Server
- Managing Metadata Views
- Metadata Storage
- System Views
- Information Schema
- Catalog Views
- Sys All
- Dynamic Management Views
- System Stored Procedures
Database and Index Maintenance
- Index Management
- New Index Features
- Creating Indexes
- Online Index Maintenance
- Parallel (multiple CPU) Index Operations
- Lock Options
- Included Columns in Indexes
- Partitioned Tables and Indexes
- Altering an Index
- Rebuilding an Index
- Reorganising an Index
- Disabling an Index
- Dropping an Index
- Index Fragmentation
- Using the Database Tuning Advisor
Securing SQL Server 2008
- Implementing Securables
- New Security Features
- Principals
- Securables
- Permissions
- Permission Types
- Managing Logins
- Managing Users
- Managing Schemas
- Schema Definition
- Using Schemas
- Managing Execution Context
- Managing Permissions
- Manage Server Permissions
- Manage Server-Scope Securable Permissions
- Manage Database Permissions
- Manage Database-Scope Securable Permissions
- Managing Certificates
- Native Data Encryption
- TDE
- Code and Module Signing
- SQL Server Auditing
SQL Server Backup & Recovery
- Disaster Recovery
- SQL 2008 Disaster Recovery Feature
- Enhanced Features
- Database Snapshots
- Creating a Snapshot
- Common Snapshot Applications
- Undeleting table rows
- Undoing a table update
- Recovering a dropped object
- Backup and Restore concept and types
- Backup and Restore options
- Media Integrity Changes
- Recovering the MASTER Database
- Create a mirrored backup
Database Availability
- SQL Server 2008 Data Availability
- Server Clustering concepts
- Failover of SQL Server Cluster
- Logshipping concept and setup
- Database Mirroring
- The Witness Server and Automatic Failover
- Configuring Database Mirroring
- Transaction Safety Level
- High Availability Operating Mode
- High Protection Operating Mode
- High Performance Operating Mode
- Monitoring Mirroring
- Database States for Database Mirroring
- Comparison between Logshipping and mirroring
Replicating Information
- Replication concept
- Distributor Administration
- Creating and Managing Publications and setting up of various types of replication
- Subscribing to a Publication
- Transforming Published Data
- Managing Replication Monitors
- Distributed query and transaction
- Distributed Transaction Coordinator Service
- Managing Linked Servers
SQL Server 2008 Integration Services (Optional)
- Creating the Database Objects
- Creating a Package Using Business Intelligence Studio
- Integration Services Project Template
- OLE DB Command object
- Column Mappings
- Adding a Data Viewer
Monitoring and Performance
- SQL Server Profiler
- Optimal Data Storage
- Windows Perfmon Monitors
- DMV’s
- Diagnostic Tools
- Query Analyzer
- Database Engine Tuning Advisor
- Index Optimisation
- Partitioned Indexes
- Lock optimsation
Struts 2: the modern web application framework
- Web applications: a quick study
- Frameworks for web applications
- The Struts 2 framework
Saying hello to Struts 2
- Declarative architecture
- A quick hello
- HelloWorld using annotations
Working with Struts 2 actions
- Introducing Struts 2 actions
- Packaging your actions
- Implementing actions
- Transferring data onto objects
- File uploading: a case study
Adding workflow with interceptors
- Why intercept requests
- Interceptors in action
- Surveying the built-in Struts 2 interceptors
- Declaring interceptors
- Building your own interceptor
Data transfer: OGNL and type conversion
- Data transfer and type conversion: common tasks of the web application domain
- OGNL and Struts 2
- Built-in type converters
- Customizing type conversion
Building a view: tags
- Getting started
- An overview of Struts tags
- Data tags
- Control tags
- Miscellaneous tags
- Using JSTL and other native tags
- A brief primer for the OGNL expression language
UI component tags
- Why we need UI component tags
- Tags, templates, and themes
- UI Component tag reference
Results in detail
- Life after the action
- Commonly used result types
- JSP alternatives
- Global results
Integrating with Spring and Hibernate/JPA
- Why use Spring with Struts 2
- Adding Spring to Struts 2
- Why use the Java Persistence API with Struts 2
Exploring the validation framework
- Getting familiar with the validation framework
- Wiring your actions for validation
- Writing a custom validator
- Validation framework advanced topics
Understanding internationalization
- The Struts 2 framework and Java i18n
- A Struts 2 i18n demo
- Struts 2 i18n: the details
- Overriding the framework’s default locale determination
Extending Struts 2 with plug-ins
- Plug-in overview
- Common plug-ins
- Internal component system
- Writing a breadcrumb plug-in
Best practices
- Setting up your environment
- Unit-testing your actions
- Maximizing reuse
- Advanced UI tag usage
Migration from Struts Classic
- Translating Struts Classic knowledge
- Converting by piecemeal
Advanced topics
- Advanced action usage
- Dynamic method invocation
- Using tokens to prevent duplicate form submits
- Displaying wait pages automatically
- A single action for CRUD operations
- Tiles and Struts 2
Conclusion