SQL Server 2005-2008-DBA

Document Sample
SQL Server 2005-2008-DBA Powered By Docstoc
					                                                        1


                                            www.H2KInfosys.com

                                  >>Dream, Strive and Achieve Victory>>

Page | 1
                             SQL Server 2005/2008 DBA SSIS and SSRS Training

                                                    Contact

                            Training@h2kinfosys.com or h2kinfosys@gmail.com

                                                 770-777-1269



           Training Overview and Topics to be covered:


             DAY 1 (2 Hrs)

             * SQL Server 2005 and 2008 Overview and Installation

             * SQL Server 2008 Overview and Installation

                # Overview of SQL Server

                # Installation Requirements (Hardware and Software)

                # Installation Walkthrough (Step-by-Step)

                # Overvoew of SQL Server Management Studio (SSMS)



             * Applying SQL Patches.(Pre-requisites, installation steps, demo).



             DAY 2 (2 Hrs)

             * Creating and Managing Database

               # Creating Databases

               # Database

                                       Dream, Strive and Achieve Victory

                   www.H2KInfosys.com        email: h2kinfosys@gmail.com     contact: 770-777-1269
                                                       2


             # File Groups

             # Database Options

             # Managing database
Page | 2
           * Creating and Managing Tables and Implementing Data Integrity

            # Creating Tables

            # Defining Table Location

            # Modifying Tables

            # Dropping Tables

            # Data Types

            # Defining Constraints

            # Partitioned Table

            # Data Compression (New Feature in SQL Server 2008



           DAY 3(2 Hrs)

           * Data Manipulation and Data Correlation

             # Select/Update/Delete

             # Sub Queries

             # Joins

             # Union/UnionAll/Intersect

           * SQL Server Built-in Functions

               # Mathematical Functions

               # String Functions

               # Date Functions

               # Convert Functions

                                        Dream, Strive and Achieve Victory

                 www.H2KInfosys.com          email: h2kinfosys@gmail.com    contact: 770-777-1269
                                                      3


              # Aggregate Functions

           * Creating and Managing Views

              # Create View
Page | 3
              # Alter View

              # Drop View

              # Check and Encryption Options



           DAY 4 (2 Hrs)

           * Introduction to T-SQL Programming

              # Variable Declaration

              # Temp Table Concepts

              # Variable Table Concepts

              # Loops

           * Creating and Modifying Procedures and Cursors

               # Creating Procedures

               # Parameter Types

               # Modifying Procedures

               # Using Temp Tables, Variabke Tabkes and cursirs in Procedures

               # How to use Dynamic SQL Statements in Procedures.

               # Error Handling

           * Creating and Modifying user defined Functions

              # Creating/Modifying Scalar functions

              # Creating/Modifying table functions

           * Creating and Modifying Triggers

                                       Dream, Strive and Achieve Victory

                www.H2KInfosys.com          email: h2kinfosys@gmail.com    contact: 770-777-1269
                                                         4


              # Table Triggers

              # DDL Triggers


Page | 4
           DAY 5 (2 Hrs)

           * Working with Distributed Data

              # Creating Linked Servers

              # How to use DML Statements against to the remote servers

              # How to use remote Procedure execution in SQL Servers

           * SQL Server Security

               # Authentication Methods

               # Server level Security

               # Database Level Security

               # Object Permissions



           DAY 6 (2 Hrs)

           * Creating and Managing Indexes

               # Clustered Index

               # Non Clustered Index

               # Unique index

               # Composite Indexes

               # Fill Factor /Pad Index

               # Use of DTA (Database Tuning Advisor)



           DAY 7 (2 Hrs)

                                          Dream, Strive and Achieve Victory

                 www.H2KInfosys.com            email: h2kinfosys@gmail.com    contact: 770-777-1269
                                                      5


           * Backup/Recovery

              # Recovery Models

              # Backup Types
Page | 5
              # Full Database backup

              # Differential Backup

              # Transactional Log Backup

              # Restore Databases

              # Restore transaction Logs

              # Point of Recovery

              # Backup Compression (New Feature in SQL Server 2008)

              # Running important DBCC and DMVs for analyze database performance.

              # Assignments.



           DAY 8 (2 Hrs)

           * Database Mail

           * SQL Server Scheduling and Notification

              # Managing jobs using Maintenance Plans.

              # Managing Alerts

           * Monitoring and Troubleshooting SQL Server Performance



           DAY 9 (2 Hrs)

            * SQL Server Clustering (High Availability Solutions) Concept



           DAY 10 (2 Hrs)

                                       Dream, Strive and Achieve Victory

                 www.H2KInfosys.com         email: h2kinfosys@gmail.com     contact: 770-777-1269
                                                         6


              * Discussing the Performance Tuning Typical Guideline Steps.

              * Use of DTA (Database Tuning Advisor), SQL Profiler, System Monitor Tool and PAL
           Tool.

Page | 6

            DAY 11 (2 Hrs)

             * Database Mirroring

               # Setting Up all kinds of Mirroring.

              # Performance Issues to be discussed.



            DAY 12 (2 Hrs)

             * Replication - All Types (Snapshot, Transactional, Merge, Peer-to-Peer Replication) -
           Concepts, demo.

             # Acquiantanes of replication troubleshooting commands.



            DAY 13 (2 Hrs)

             * Migration or Upgrade to SQL Server 2008 (Steps, process to perform, running
           Upgrade Advisor)



            DAY 14 (2 Hrs)

             * Log shipping

               # Setting UP Logshipping with different modes of databases.

              # Common check-list areas.



            DAY 15 (2 Hrs)

             * Resource Governor (New Feature in SQL Server 2008)


                                         Dream, Strive and Achieve Victory

                   www.H2KInfosys.com          email: h2kinfosys@gmail.com   contact: 770-777-1269
                                                           7


             * Activity Monitor.

             * SQL Server Integration Services (SSIS) and running DTS.

                # Introduction to SSIS
Page | 7
                # Tasks, Data Flows, Control Flows, Expression and Variables, Containers, Advanced
           Tasks.

                # Error Handling and Logging in SSIS.

                # Migrating DTS packages into SSIS.

                # Report handling and Logging in SSIS.

                # Enterprise package deployment.



            DAY 16 (2 Hrs)



             * SQL Server Reporting Services (SSRS).

                # Installing SSRS and setup.

               # Creating Reports - Reporting services Report designer.

               # Report development Life Cycle.

               # Deploying reports

               # Configuring the reports.

               # Grouping, sorting, parameters, expressions, functions, expressions, custom Codes/

               # Reporting Services Roles, report security.

               # USe of Report Builder, report deployment.

               # USe Of BIDs.

               # Report Scheduling.



           DAY 17 (2 Hrs)
                                            Dream, Strive and Achieve Victory

                   www.H2KInfosys.com            email: h2kinfosys@gmail.com    contact: 770-777-1269
                                                         8


            * Database Design Concepts and Design Tool (ERWin Tool), BPWin: Process Modelling
           and functional design.

                   # Normalion

Page | 8           # De-Normalization

             * SQL Best Practices analyzer (BPA) Report for SQL 2000, 2005 and 2008.



            DAY 18 (2 Hrs)



            * SQL Best Practices analyzer (BPA) Report for SQL 2000, 2005 and 2008.

            * Running SQL Performance Dashboard Reports - For SQL 2005, 2008.



              DAY 19 (2 Hrs)

                   * SQL Server Interview Questions

                   * SQL Server FAQs

                   * SQL DBA - Certifications (MCDBA, MCITP, preparation process).

                   * Additional SQL related tools - RedGate, LiteSpeed, Quest Software products,
           Toad.




            DAY 20 (2 Hrs)

                    * Queries/Doubts.

                            WORK TOGETHER TOWARDS SUCCESSFUL CAREER




                                         Dream, Strive and Achieve Victory

                     www.H2KInfosys.com        email: h2kinfosys@gmail.com    contact: 770-777-1269
                                                             9


            This is just the overview of the content and the topics to be discussed. Detailed discussion on
           each topic will be discussed through PDF, Power Point presentation and through live Demo.



Page | 9               “Nothing is a waste of time if you use the experience wisely”


           Check the below links for Advantages and FAQ’s:

           http://www.h2kinfosys.com/trainingadvantages.pdf

           http://www.h2kinfosys.com/index.php/faqs




                                           Dream, Strive and Achieve Victory

                    www.H2KInfosys.com           email: h2kinfosys@gmail.com       contact: 770-777-1269

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:11/14/2011
language:English
pages:9