SQL SERVER DBA – Radical Technologies Bangalore HSR Layout
Open Quick Enquiry
Please Contact Us
rad

SQL SERVER DBA

SQL Server DBA Training & Certification  in Bangalore

SQL Server DBA Training by 12+yrs exp Trainers from Industry.

SQL Server DBA Training Duration: 8 weekends

Course Syllabus

Introduction to Databases (3 hours)
• a) Databases – Relational and Others
• b) SQL Server vs. Other Relational Database Systems
• c) The Database as Part of the System Architecture
• d) The Role of the Database Administrator (DBA)
Introduction to Microsoft SQL Server (4 hours)
• a) SQL Server Versions and Editions
• b) SQL Server Services and Components
• c) SQL Server Client Tools
Overview of Microsoft SQL Server 2012(1 Hr)
• Database Engine
• T-SQL programming interface
• Business intelligence
• Summary
Installing Microsoft SQL Server 2012(2 Hrs)
• Editions of SQL Server 2012
• Choosing hardware for SQL Server
• Software prerequisites
• Before installation
• Installing SQL Server
• After installation
• Summary
Using SQL Server 2012 administration and development tools(1 Hr)
• Using SQL Server Books Online
• Using SQL Server Management Studio
• Using SQL Server Management Studio to create solutions and projects
• Using SQL Server Data Tools
• Summary

Designing databases
Designing SQL Server databases(2.5Hrs)
• Understanding SQL Server system databases
• Understanding the SQL Server database structure
• Adding files and filegroups
• Detaching and attaching SQL Server databases
• Understanding database recovery models
• Summary
Creating your first table(2.5Hrs)
• Developing a naming standard
• Understanding schemas
• Understanding SQL Server data types
• Understanding column properties
• Creating tables
• Altering tables
• Understanding computed columns
• Adding constraints to a table
• Understanding the FileTable
• Creating database diagrams
• Summary
Building and maintaining indexes (1 Hr)
• Index structure overview
• Adding index options
• Adding included columns
• Disabling and dropping indexes
• Summary

Advanced database design topics
Transactions and Locks (4 hours)
• a) Transactions Overview
• b) Lock Types
• c) Concurrency Issues
• d) Transaction Isolation Levels
• e) Locking Hints
• f) Deadlocks
• g) Nesting Transactions
Table compression (1 Hr)
• Understanding row compression
• Understanding page compression
• Summary
Table partitioning (2 Hrs)
• Creating a partition function
• Creating a partition scheme
• Partitioning tables and indexes
• Summary
Database snapshots(1 Hr)
• Understanding database snapshot prerequisites and limitations
• Creating and viewing database snapshots
• Dropping database snapshots
• Reverting to a database snapshot
• Summary
The SELECT statement(2Hrs)
• Writing a SELECT statement
• Sorting results
• Filtering data with the WHERE clause
• Creating aliases
• Using the JOIN operator to return data from multiple tables
• Limiting the data returned in your result set
• Using UNION to combine result sets
• Summary

Using Transact-SQL (T-SQL)
Advanced data retrieval topics(1 Hr)
• Paging data
• Writing expressions
• Using variables
• Summary
Modifying data(1 Hr)
• Inserting data into SQL Server tables
• Using sequence numbers
• Updating data in tables
• Deleting data from tables
• Merging data
• Summary
Built-in scalar functions(1 Hr)
• Using date and time functions
• Using conversion functions
• Using string functions
• Summary

Creating other database objects
Advanced T-SQL topics(1 Hr)
• Aggregating and grouping
• Using SQL Server temporary objects
• Handling T-SQL errors
• Summary
Views(1 Hr)
• What are views?
• Creating indexed views
• Summary
User-defined functions(1 Hr)
• Understanding user-defined scalar functions
• Understanding table-valued functions
• Limitations of functions
Stored procedures (1 Hr)

• Working with stored procedures

• Using the EXECUTE keyword
• Parameterizing stored procedures
• Dropping stored procedures
• Summary
Data manipulation triggers(1 Hr)
• Types of triggers
• Creating triggers
• Altering triggers
• Dropping triggers
• Enabling and disabling triggers
• Summary

Database maintenance
Backup and Recovery (6.5 hours)
• a) Backup Types
• b) Database Recovery Models
• c) Understanding the Recovery Process
• d) The Restore Operation
• e) Recovery Advisor
• f) Performing Online Restore Operations
• g) Recovering from Database Snapshot
• h) Recovering System Databases
• i) Planning a Backup Strategy
SQL Server Security (8 hours)
• a) SQL Server Security Overview
• b) Authentication Modes
• c) Principals and Securable
• d) Managing Permissions
• e) Understanding Ownership Chaining
• f) Controlling Execution Context
• g) SQL Server Auditing
• h) Security Best Practices
? Database management
SQL Server Profiler (1 Hr)
• Understanding SQL Server Profiler
• Summary
SQL Server security(1 Hr)
• Understanding principals
• Creating server logins
• Creating user-defined server roles
• Creating database users
• Creating built-in database roles
• Configuring contained databases
• Summary
SQL Server Agent(1 Hr)
• SQL Server Agent components
• Configuring jobs
• Summary
Database Mail(1 Hr)
• Database Mail components
• Configuring Database Mail
• Sending email using Database Mail
• Monitoring Database Mail
• Summary
Dynamic management objects(1 Hr)
• Retrieving SQL Server metadata from DMOs
• Querying server performance statistics
• Querying server information
• Querying performance information
• Querying indexing statistics
• Summary
Using a Standby Server (6hours)
• a) Introduction to High Availability
• b) Failover Clustering
• c) Log Shipping
• d) Database Mirroring
Implementing Replication (4 hours)
• a) Overview of Replication
• b) Implementing Snapshot Replication
• c) Implementing Transactional Replication
• d) Implementing Merge Replication
• e) Implementing Peer-to-Peer Replication
Transferring Data with SQL Server (4 hours)
• a) Overview of Data Transfer
• b) Using the Import and Export Wizard
• c) Performing Bulk Operations
• d) The Copy Database Wizard
• e) Introducing SQL Server Integration Services
• f) Source-To-Target Mapping
• g) Populating Dimension and Fact Tables
• h) Identifying Data Changes

 

Our Courses