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
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 2/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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%
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 3/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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
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 4/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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
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 5/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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
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 6/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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
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 7/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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
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 8/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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
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 9/9
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet,Hyderabad
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