New Page 1
The January 2008 instance of this class is discounted 50% because it's our first run of this class and we may not have the timing/sequence fine tuned! We still expect our students to derive great value and to return home with the skills needed to get work done.
Module 1 - Life as a DBA
- Production vs development roles
- Guardian of the data
- Working with development teams
- Working with off the shelf applications
- Should we buy 3rd party tools?
- Managing the workload
- Customer service
- Risk mitigation
- Discussion: Current experiences of students
Module 2 - Licensing, Versions, & Sizing Hardware
- Figuring out which version to buy
- Licensing model makes a difference in cost
- Provisioning drive space (SAN, SCSI, other) and configuration
- Virtualization
- Memory and memory models
- 32bit vs 64 bit, and how many processors to buy
Module 3 - Installing & Maintaining SQL Server
- Installing SQL 2005 client tools only
- Creating a service account
- Installing SQL 2005 as default instance
- Installing a second instance of SQL 2005
- Applying a Service Pack
- Configuring Surface Area
- Hands-On Lab: Installing & Configuring
Module 4 - Introduction to Management Studio
- Connecting to a server
- Tour of the tools
- Writing and saving queries
- Using supplied templates
- Hands-On Lab: SSMS
Module 5 - Creating & Managing Databases
- Creating a Database - How to do it and where should it go?
- Attach/Detach
- Database options
- Filegroups
- Hands-On Lab: Databases
Module 6 - Security
- Windows vs SQL logins
- Creating logins
- Server roles
- Creating users and mapping users to logins
- Database roles
- Application and User Defined Roles
- Ownership chaining
- Linked Servers
- Hands-On Lab: Security
Module 7 - Backup & Restore
- Recovery Models
- Full, transaction, differential
- Striped, mirrored, and copy only backups
- Filegroup backup
- Restoring a full backup
- Restoring master
- Point in time restore
- Hands-On Lab: Backup & Restore, all variations!
Module 8 - SQL Agent
- What is SQL Agent?
- Configuring operators
- Database mail
- Creating and managing jobs
Module 9 - Maintenance Plans
- Why you need a maintenance plan
- Creating a plan using the wizard
- When to go beyond the wizard
- Hands-On Lab: Maintenance Plans
Module 10 - Database Design
- Basic relational design and how it relates to performance
- Defaults and check constraints
- Stored procedures
- Views
- Functions
- Synonyms
- Change control and versioning
- Hands-On Lab: Design & Deployment
Module 11 - Indexing
- Overview of indexing principles
- Clustered vs non clustered
- Primary keys
- Full text indexing
- How to identify missing indexes
- Hands-On Lab: Indexing
Module 12 - Basic Performance Tuning
- Intro to Profiler & Perfmon
- Reading simple query plans
- Basic query hints
- Tuning Wizard
- Benchmarking
- Hands-On Lab: Using the Tuning Wizard
- Hands-On Lab: Tuning a simple query
Module 13 - Importing & Exporting Data
- Using the Import/Export Wizard
- BCP
- Bulk Insert
- Quick look at SSIS
- Hands-On Lab: Import/Export
Module 14 - Other Tools
- SQLCmd
- SQLDiag
- Hands-On Lab: Tools
Module 15 - Replication
- Overview of replication
- Replication topologies
- Implementing snapshot replication
- Implementing transactional replication
- Implementing merge replication
- Implementing peer to peer replication
- Hands-On Lab: Replication Workshop
Module 16 - Database Snapshots
- Principles of snapshots and sparse files
- Creating a database snapshot
- Limitations
- Reverting to a snapshot
- Snapshots for testing
- Hands-On Lab: Snapshots
Module 17 - Log Shipping
- Overview of log shipping
- Implementing log shipping
- Hands-On Lab: Log shipping
Module 18 - Clustering
- Clustering scenarios and principles
- Installing SQL Server on a cluster
- Cluster resources
- Failing over a cluster
Module 19 - Common DBA Tasks
- Troubleshoot blocking
- Restore database to development server
- Repair dropped table
- Troubleshoot deadlocking
- Fix/move logins
- Out of date statistics