SQL Server DBA Training in Chennai

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