|
General Course
Information
Instructor:
Zakir Hossain, CS Graduate (OSU), OCP, OCA, MCDBA,
MCITP-DBA, Security+, Oracle RAC-Admin, Oracle
Backup/Recovery-Admin, Oracle Performance/Monitoring-Admin, Oracle
App Server-Admin, System Admin (Windows/RedHat), SCJP (Sun
Certified Java Programmer), ITIL V3, PMP
CEO,
Data Group
Manager – Enterprise Architecture & Database, DOD
Office Hours:
Will be given in class
Phone: 703-986-9944/703-203-2325
E-mail: info@DataGroupUSA.com
Web Site: www.DataGroupUSA.com/training
Location: 6118 Franconia
Rd, Suite-217-A, Alexandria, VA 22310
Duration: 3-5 Months, 16 + 16 Classes + (Lecture + Lab + Lab)
+
Learning Method:
Instructor Led Classroom/Instructor Led Online.
We will show you exactly what SQL Server 2008/2005 and 2000 is and
we will walk you through the
different scenarios throughout the course.
Prerequisites:
ü
Your sincerity and a firm goal to be
a DBA
ü
Your dedication is must
ü
Basic Computer Knowledge
- Helpful, but not required
ü
Knowledge of Windows XP/7, Windows
Server 2003/2008 -
Helpful, but not required
ü
Knowledge of Microsoft Office
- Helpful, but not required
Textbook:
1. SQL Server 2008 Administration
with Example by Zakir Hossain
2. SQL Server DBA/Developer - Interview Guide by
Zakir Hossain
SQL Server Database Software:
SQL Server 2008 provides a robust platform that enables
organizations to run their most demanding, mission-critical
applications. It is essential that database administrators know
how to manage this complex platform correctly. This hands-on
course provides you with the skills you need to install SQL
Server, create and modify storage structures, manage security,
back up/recover and everything that you need to be a DBA (Database
Administrator), Database Engineer, Data Modeler or Data Architect.
SQL Server 2008 offers a progressive and powerful way to manage
your organization's information. A robust and scalable enterprise
solution, SQL Server 2008 extends the features of SQL Server 2005
and improves application development time and cost management.
This hands-on course provides a solid foundation on which to build
essential SQL Server development and administrative skills,
including creating databases, generating Transact-SQL statements,
implementing security and replicating data over multiple servers.
Overview of
Database and Database Career:
Introduction
and Welcome Notes
Guidelines for Microsoft SQL DBA & Developer
Excellence
Career Opportunity for
Microsoft SQL Server DBA & Developer
History and Comparative Study of Relational Database
Technology & SQL Server
Overview of IT
and SQL Server Database:
IT Environment:
Development, Test, Production & DBA/Developer Role
Different types of servers and their functions
including SQL Server Database Server
History of SQL
Fundamental architecture of Computer Systems
Fundamental architecture of different Software, OS,
and Database Software
Installing SQL Server
2008/2005/2000:
What more to configure after
installation of SQL Server
SQL Server 2008 Editions
SQL Server 2008 Requirements
Downloading SQL Software
Installing SQL Server 2008, 2005, & 2000
SQL Server Installation Center Overview
Launching SQL Server 2008
Creating Database
System Databases
SQL Server Management Studio Overview
Query Interface Overview
Installation Verification & Remote Database Access
Configuration
Configuring SQL Server 2008, 2005, and 2000
SQL Server Native/Essential Tools:
To fully make use of all of the features of SQL Server you need to
know how to use the many tools it has to offer.
Management Studio, Enterprise Manager -
Overview
Query Analyzer - Overview
Graphical Query Designer
Import and Export Wizard
SQL Server Reporting Services – SSRS
Business Intelligence Development Studio – BIDS
SQL Server Analysis Services – SSAS
SQL Server Configuration Manager - Overview
SQL Server Reporting Services Configuration Manager -
Overview
SQL Server Profile, Index and Database Tuning Advisor
SQL Server 2008 Upgrade Advisor
Policy-based
Management
Creating Database:
Planning process needed to create your database to meet your
specific business need.
Database Planning and
Examining disk structures
Creating Databases Overview
Recommendations
Creating and Managing Tables and
Views:
Analyzing
various datatypes
Creating a New Table
Defining column attributes
Indexing
tables with Management Studio
Adding,
deleting or changing columns
Database Views
Creating a New View
Creating Database Diagrams
Managing
database Space/Storage:
Permitting automatic database growth
Allocating file size and growth parameters
Adding database files to expand databases
Choosing files and directories
Creating data
files and transaction log file
Defining file groups
Specifying database options
DISK/Storage
Management:
SAN
RAID
Introduction
to Sample Databases:
Installing AdventureWorks2008
Database
Introduction to AdventureWorks2008 Database
Database Mail:
We will show you how to use SQL Server Database Mail and
Microsoft’s “built-in” SMTP server to send email notifications to
operators, from SQL Server 2008.
Simple Mail Transfer Protocol (SMTP)
Server
Database Mail Profiles and Accounts
Configuring Database Mail
Database Mail SMTP Authentication
Implementing Backup
and Disaster Recovery (DR):
Having a disaster recovery plan is a necessity in today’s
computing world. We will show you the different disaster recovery
models you can implement to make sure you are protected against
data corruption, hardware failures, and anything else that would
destroy data.
SQL Server Recovery Models:
Full Recovery Model
Bulk Logged Recovery Model
Simple Recovery Model
Choosing a
Recovery Model
Backup Options and
Types:
Local and Network Backup
Backup Types:
Cold Backup:
Detach and Attach
Database
Offline Backup
Instance Offline
Backup
Hot Backup:
Full
Database Backups
Full File Backups
Partial Backups:
Differential Backup and Transaction Log Backup
Recovery
Requirements
Recovering a Database
Testing recovery scenarios
Recovering a Database to Point-In-Time
Transaction
log architecture
Reclaiming transaction log space
Best Practices
Automating Administrative Tasks:
We will show you how to use the SQL Server Agent to automate
administrative tasks, saving you time and allowing you to move on
to more important work.
SQL Server Agent
Configuring SQL Server Agent
Creating and Running Jobs
Database Maintenance Plan
Automating backups by scheduling jobs
Checking database integrity and defragmenting data
Notifying operators via e-mail
Job Scheduling Options - Database Server and Windows
Scheduling
Multistep jobs:
Creating alerts and operators
Associating alerts with jobs
Performing Data Management Tasks:
You will learn several data management skills focused on "rounding
out" your SQL Server 2008 administration knowledge. A primary
focus will be understanding and managing indexes.
Importing and Exporting
Creating and
Maintaining Indexes
Clustered vs. Nonclustered Indexes
Full-Text Indexing
Enforcing uniqueness with primary
key and other constraints
Check
constraints to validate conditions
Building
relationships with foreign keys
Creating and
Maintaining Constraints
Database Upgrade &
Migration:
Upgrading Database:
Upgrade SQL Server 2000/2005/2008/2008 R2
Migrating Database:
Migrate MS Access Database to SQL Server
Migrate MySQL Database to SQL Server
Migrate Oracle Database to SQL Server
Patching/Applying SP (Security Patch), HOT FIX:
Apply Windows SP
Apply SQL Server SP
SQL Server Business
Intelligence Components:
Transforming
Data with SSIS (SQL Server Integration Services):
Exporting Data from
Files/other Sources to SQL Server Database
Importing Data from Files to
SQL Server Database/Tables
Interacting with Microsoft Office
Pulling data from/To SQL Server into
Excel
Migrating an Access database to SQL
Server
Moving and Denormalizing Data into a Data Warehouse
Creating DTS/SSIS Package
Saving DTS/SSIS Package
Deploying DTS/SSIS Package
Managing DTS/SSIS Package
Upgrading DTS to SSIS
Information Delivery
with SQL Server Reporting Services:
Server/Services Architecture
Report Development Tools - Report
Developer & BIDS
Developing and Deploying Reports using
Report Developer & BIDS
Designing reports with BIDS - Report
Wizard
Designing reports with BIDS - Report
Wizard - Custom Report
Deploying reports to a Report Server for
centralized access
Report Server & Reports Management
High Availability
Solutions:
Learn the benefits of the various high availability options and
why you would use each one. Plus, we will show you how to keep
your database always available by having multiple servers ready to
go, so you're not depending on just one server.
SQL Server Failover Clustering
Database Mirroring
Database LogShipping
Database Replication
Comparisons
Security -
Configuring & Managing Server/Database Security:
As a DBA, one
of your most important responsibilities will be securing company
data resources against unauthorized access and modification. We
will tackle SQL Server Security from physical security to
permissions and schemas; and everything in between.
Contrasting Windows and SQL Server authentication
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
Handling Mismapped Login
Server-Level Role vs. Database-Level Role
Making logins members of server and Database roles
Object Level Permissions
Granting
or revoking permissions
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
Information_Schema and Sys
Enforcing password policy
Best Practices
Distributed
Database, Distributed Query and Database Link:
Introduction to Distributed Database
Distributed Database and Database Link
Creating Database Link
Writing Distributed Queries
Database
Configuration:
Determine System and
Server Information
Configuring Authentication
Database Auditing
Configuring Memory, CPU, Connections, Remote
Connection, Users
Configuring File Streaming
Configuring Database Backup Time-Out and Retention
Monitoring and
Performance Tuning:
We will show you the many tools you can use to monitor your SQL
Server performance to anticipate problems before they occur.
Monitoring Tools & Techniques:
SQL Profiler/SQL Trace (T-SQL)
Windows System Monitor
Activity Monitor
Transact-SQL
Windows Logs
Counter
Dynamic Management Views
Monitoring Tools Comparison
Lock, Block, and Deadlock
What to Monitor and How to Monitor
SQL Server Common Commands:
As a database administrator you will find the DBCC ‘family’ of
commands and the myriad of applications for the sp_configure
system stored procedure to be invaluable. These two commands touch
every aspect of the DBA role and provide you with access to every
configuration option available within SQL Server 2008.
Database Console Commands (DBCC)
Running DBCC CHECKTABLE and DBCC CHECKDB Commands
Setting Server Configuration Options
sp_configure clr enable Command
sp_configure c2 audit mode Command
sp_configure fill factor Command
Data Compression:
Learn how you can slow the effect of the data storage explosion by
compressing SQL Server data while still maintaining performance
requirements.
Row Compression
Page Compression
Data Partitions
Table Compression via T-SQL
Compressing Backups
Third Party
Tools:
Administration Tools:
Idera
RedGate
Data Modeling
Tools:
Toad Data Modeler
ERWin
Visio
|
Testimonial