Scribd
Upload
59 views9 pages

SQL Server 2008 New Syllabus

The document provides information about DBA School, a training organization located in Hyderabad, India. It details the courses offered, including training for SQL Server 2008 administration, implementation, and business intelligence components. Contact information is given to learn more about the programs.

Uploaded by

Anonymous xMYE0TiNBc
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
59 views9 pages

SQL Server 2008 New Syllabus

The document provides information about DBA School, a training organization located in Hyderabad, India. It details the courses offered, including training for SQL Server 2008 administration, implementation, and business intelligence components. Contact information is given to learn more about the programs.

Uploaded by

Anonymous xMYE0TiNBc
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 9

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91

8142368899 visit: www.hyddbatraining.com

DBA SCHOOL PROVIDING EXCELLENT TRAINING FOR SQL SERVER DBA

SQL SERVER 2008 ADMINISTRATION Course contents Of SQL Server DBA 2008

MS-SQL SERVER 2008 Implementation (SQL, T-SQL) Administration Business Intelligence (SSIS, SSAS and SSRS) Microsoft SQL Server 2008 Training

Introducing SQL Server 2008


What's New in SQL Server? SQL Server Editions

Designing Tables

Data Types Creating Tables Constraints Database Diagrams

Basics of Database Design


Normalization Denormalization Introducing SQL Server Management Studio

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

Creating a Database Adding Tables Creating Indexes and Constraints Building Relations

SELECT queries

The SELECT Clause The FROM Clause The WHERE Clause The ORDER BY Clause Using GROUP BY and HAVING UNION Queries

Indexes

Index Clustered Indexes Nonclustered Indexes Filtered Indexes

Views

What is View? syntax of View

T-SQL Basics

What is T-SQL? Syntax Conventions Executing SQL Statements Creating Data Types Operators

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

Variables Functions

Stored Procedures, and Functions


Using Stored Procedures Using Functions

Advanced Transact-SQL

Transactions Cursors Triggers Creating DML Triggers Altering DML Triggers Using the Inserted and Deleted Tables Checking Updated Columns Creating DDL Triggers

Locking and Execution Plans


What is locking? Monitoring Locks Tuning Locking Deadlocks

Microsoft SQL Server 2008 Administration Training Introduction to SQL Server 2008

What is SQL Server 2008? SQL Server 2008 Solutions A Brief History of SQL Server

Installing SQL Server 2008

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

SQL Server 2008 Editions SQL Server 2008 Requirements Basics of SQL Server Security Installing SQL Server 2008 SQL Server Installation Center Overview New SQL Server Stand-Alone Installation Launching SQL Server 2008

An Introduction to Tools

SQL Server Business Intelligence Development Studio Overview Analysis Services and Configuration Tools Overview Documentation and Tutorial Overview Integration Services and Performance Tools Overview System Databases SQL Server Management Studio Overview Query Interface Overview

Creating databases

Database Planning Creating Databases Overview Creating General Page Creating Options Page Creating Filegroups Page Creating a New Table Database Diagrams Creating Database Diagrams

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

Database Views Creating a New View Creating a Synonym

Configuring Security

SQL Server Security Landscape Physical Security Managing User Access Logins and Users Creating a User Account in AD Creating SQL Login and SQL User Account Testing SQL User Account Setting SQL User Permissions Server-Level Role vs. Database-Level Role Schemas Overview Creating Schemas Testing Schemas Protecting Your Data Auditing SQL Server Remote Access File Security and SQL Server Data Encryption SQL Server SA Login and Certificate-Based SQL Server Login Public Database Role Implementing Disaster Recovery SQL Server Recovery Models Full Recovery Model Bulk Logged Recovery Model

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

Simple Recovery Model Backup Types Full Database Backups Restoring a Database Full File Backups Partial Backups Recovery Requirements

Performance

SQL Profiler/SQL Trace (T-SQL) Windows System Monitor Activity Monitor Transact-SQL Windows Logs Default Trace Dynamic Management Views Monitoring Tools Comparison

Automating Administrative Tasks


SQL Server Agent Configuring SQL Server Agent Key Fixed Database Roles Creating and Running Jobs Security Guidelines

High Availability

SQL Server Failover Clustering SQL Server Database Mirroring

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

SQL Server Log Shipping SQL Server Replication Comparisons

Replication

What is SQL Replication? SQL Server Replication Concepts Types of Replication Creating Publication Creating Push Subscription

Resource Governor

Troubleshooting SQL Server Managing Resource Utilization Resource Governor Resource Pools Creating a Resource Pool Workload Groups Creating a Workload Group Classification Creating a Classifier Function

Performing Data Management Tasks


Importing and Exporting Permissions for Importing and Exporting Maintaining Indexes

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

Clustered vs. Non-clustered Indexes Filtering Indexes Full-Text Indexing

Data Compression

Data Partitions Compressing Backups

Common Commands

Database Console Commands (DBCC) Running DBCC CHECKTABLE and DBCC CHECKDB Commands Setting Server Configuration Options sp_configure clr enable Command

Database Mail

Simple Mail Transfer Protocol (SMTP) Server Database Mail Profiles and Accounts Configuring Database Mail Database Mail SMTP Authentication

MS-SQL SERVER Business Intelligence 1. SQL SERVER Integration Services 2. SQL SERVER Analysis Services 3. SQL SERVER Reporting Services

Courses Available at DBA SCHOOL: 1. Oracle 10g DBA 2. Oracle 11g DBA 3. Oracle APPS DBA

DBA SCHOOL, #501, Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad Ph: +91 9966293445 / +91 8142368899 visit: www.hyddbatraining.com

4. PeopleSoft DBA 5. PeopleSoft Technical 6. PeopleSoft Functional (HRMS and FSCM) 7. Oracle RAC 8. SQL Server DBA

Visit: www.hyddbatraining.com REPLY BELOW Email: satyaseelam@gmail.com / dbaschool1@gmail.com Mobile: +91-9966293445 / +91-8142368899 Contact Us DBA School Mahindra Residency Flat #501 Near Aditya Trade Center Ameerpet Hyderabad -500038

You might also like