sql server dba by real time experts@dba school hyderabad

8/7/2019 SQL Server DBA By Real Time Experts@DBA School Hyderabad

http://slidepdf.com/reader/full/sql-server-dba-by-real-time-expertsdba-school-hyderabad 1/9

DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad

Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

DBA School providing real time and practical knowledge and you willlearn more than what you are expecting now.

SQLSERVER 2005/2008 DBA CourseContents

• Fundamentals for SQL Server 2008

• What is SQL Server and why?

• Relational database models

• Client/server Architecture

• Introducing SQL Server 2008

• A brief history of SQL Server

• Whats’ new in SQL Server 2008

• SQL Server editions

• Basics of database design

• Normalization

• Denormalization

• Introducing SQL Server Management Studio

• System databases

• User databases and Creating a Database

• Objects in a database




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Tables and File groups

• Creating tables

• Data types

• Constraints

• Creating Indexes and Types of Indexes

• Database diagrams and Building relationships

• T-SQL Basics

• What is T-Sql?

• Syntax conventions

• Identifiers

• Operators

• Wild cards

• Variables

• Functions

• DDL, DML, DCL and TCL

• Using Sqlcmd

• SELECT

• The SELECT clause

• The FROM clause

• The WHERE clause

• The ORDER BY clause

• Using GROUP BY and HAVING

• TOP N and TOP N%




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• OVER

• Full-Text Search

• UNION queries

• JOINS

• INNER JOIN

• OUTER JOIN

• CROSS JOIN

• SELF JOIN

• VIEWS

• Simple Views

• Complex Views

• Indexed Views

• Action queries

• INSERT

• UPDATE

• DELETE

• TRUNCATE

• DROP

• SELECT INTO

• INSERT INTO

• Stored Procedures and Functions

• System SPs and User SP’s

• System Functions and User Functions




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Structured Error handling

• Triggers

• Creating DML Triggers

• Altering DML Triggers

• Using the Inserted and Deleted Tables

• Checking Updated Columns

• Recursive and Nested Triggers

• Creating DDL Triggers

• Sub queries and Distributed Transactions

• Cursors

• Transactions, Locking and Execution plans

• COMMIT & ROLLBACK

• What is Locking?

• Monitoring Locks

• Tuning Locking

• Deadlocks

• XML and SQL Server

• .NET inside SQL Server

• Creating CLR User-Defined Functions

• Creating CLR Stored Procedures

• Using the Sql Namespace

• Creating CLR Triggers

• Creating CLR User-Defined Types




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Choosing When To Use CLR Objects

Course contents for SQL Server 2008 Administration:

• Fundamentals for SQL Server 2008

• What is SQL Server and why?

• RDBMS and beyond Relational database models

• Client/server Architecture

• Introducing SQL Server 2008

• A brief history of SQL Server

• Whats’ new in SQL Server 2008

• In depth discussion on SQL Server editions and Pricing.

• SQL Server Architecture

• Components of SQL Server

• Page and Extents

• Data Files and Log Files

• Protocols, Aliases and Port Numbers

• Physical architecture

• Memory architecture - AWE

• Installing SQL Server 2008

• Pre-requisites for Installation

• SQL Server Installation Center

• Feature selection

• Default and named Instances

• Authentication and authorization




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Database Engine and data directories

• Collation Settings and Case sensitivity

• SQL Server Services

• Installation overview

• Upgrading to SQL Server 2008

• In-Place Upgrade

• Migrating to SQL Server 2008

• Side-By-Side Migration

• Configuring SQL Server 2008

• SQL Server 2008 Tools

• Configuration Tools

• Performance Tools

• System, User and Example databases

• Disaster Recovery

• Setting up the backup strategy

• Recovery models and Recovery states

• Backup Techniques

• Using third party tools

• Managing Security

• Security Architecture

• Users, Logins and Permissions

• Fixed Server Roles

• Recovering SA password




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Transferring data

• Import and Export

• Bulk copy

• Detach and attach of DBs

• Moving System and User databases

• Automating Administrative Tasks

• About SQL Server Agent

• Creating Jobs, alerts

• Index Re-building

• Update Statistics jobs

• Database server health check

• Creating Maintenance plans

• Monitoring SQL Server

• Choosing appropriate monitoring tools

• Error Log file and Agent log Viewer

• Activity Monitor

• Performance Monitor

• Microsoft Base Line Security Analyzer

• SQL DB Mail

• Configuring profiles and accounts

• Configuring Database Mail




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Creating operators

• Sending Notifications

• Common Commands in…

• DBCC

• Performance tuning

• Advanced Server configuration

• Implementing Replication

• Transaction Log Architecture

• Snapshot Replication

• Transactional Replication

• Merge Replication

• Replication Agents

• Resource Governer

• Maintaining High availability

• Log Shipping

• Pre-requisites

• Deploying Log shipping

• Freequently raised errors

• Database Mirroring

• Pre-requisites

• Operating modes in mirroring

• Deploying Mirroring

• DB Snapshots




Ph: +91 9966293445 / +91 8142368899 / +91 9394156256 / 040-30629104

• Clustering Architecture

• Types of clustering

• Installing SQL 2008 Cluster

• Troubleshooting and Performance Tuning

o Indexing

o Scan and seek

o Fragmentation

o Transactions and Isolation levels

o IO counters, Memory Counters and disk counters

• Locking Technology

• Roles and Responsibilities of SQL Server DBA in Real time.

• MS-SQL Server Business Intelligence

• Brief Introduction about SSIS, SSAS and SSRS

isit: www.hyddbatraining.com

Phone: +91 9966293445 / +91 8142368899 /+91 9394156256 / 040-30629104

Contact Us

DBA School

# 501, Mahindra Residency,

Near Aditya Trade Center,

Ameerpet,

Hyderabad

http://www.hyddbatraining.com/

http://www.hyddbatraining.com/

sql server dba by real time experts@dba school hyderabad

Documents