SQL Server DBA Online Training

1
Mindmajix

• SQL Server DBA Online Training

2
Introduction to SQL DBA
SQL provide high quality database support which
exceed performance expectations. SQL Database
Administrator perform the task of monitoring of
database server. SQL DBA manages the hundreds of
SQL Server instances, SAN storage and security.
MindMajix provides technical and practical
training on SQL DBA where the trainee enhance
complete knowledge on database theory, database
design, RDMS, distributing computing
architectures, storage, recovery etc.
3
Course Curriculum
Module 1 - SQL Server Fundamentals T-SQL  Unit
1. SQL Server Introduction InstallationTopics- 
SQL Server Installation, Services
Authentication, SQL Server Components Firewall,
SSMS, Configuration Tools SMO, Protocols
Server Aliases, Linked Servers Types. Unit 2.
SQL Server 2012 Database DesignTopics- SQL
Database Creation, Files File Group Options,
Data File Recommendations, Log File
Recommendations, DB Offline Online Options,
Database Modifications. Unit 3. SQL Server
Tables DataTopics- Table Design and T-SQL Data
Types, INSERT SELECT Options, Aliasing,
Schemas,Tables File Group Usage, DELETE versus
TRUNCATE.
4
Unit 4. Data Validations and ConstraintsTopics- C
onstraints - Properties Objects, UNIQUE KEY and
NOT NULL, PRIMARY KEYS Usage, Composite Keys,
CHECK and DEFAULTS. Unit 5. Basic Queries and
JOIN QueriesTopics- EXISTS, APPLY, WHERE, ORDER
BY, GROUPING, HAVING, Sub Queries Nested
Queries, Bulk Operations Local Remote. Unit
6. Views and Row Data SecurityTopics- Views as
Virtual Objects, Views as Physical Objects,
SCHEMABINDING, ENCRYPTION, Issues with ALTER
TABLE, System Views Dynamic Management Views,
Views with Joins and Views. Unit 7. Indexes and
Query TuningTopics- Architecture of Table
Indexes, Clustered NonClustered Indexes,
SORT_IN_TEMPDB, ONLINE, FILLFACTOR and PAD_INDEX,
Execution Plans and Performance, Unique Indexes
and Uses, Working with Indexed Views. Unit 8.
Stored Procedures and BenefitsTopics- Stored
Procedures Use, Variables and Parameters,
SCHEMABINDING, ENCRYPTION, INPUT OUTPUT
Parameters, Dynamic SQL Queries, Procedure Cache
Recompilation.
5
Unit 9. User Defined Functions and
UsageTopics- Functions Use Types, Scalar
Table Valued Functions, SCHEMABINDING,
ENCRYPTION, System Functions and Events, Date,
Time, String and Metadata Functions. Unit 10.
Triggers and Cursors Memory LimitationsTopics- 
DML Triggers Performance, INSERTED and DELETED
tables, STATIC and DYNAMIC cursors, SCROLL
FORWARD_ONLY, LOCAL and GLOBAL cursors, KEYSET
Cursors and Usage, Embedding Cursors in
SPs. Unit 11. Transaction Conceptsin
RealtimeTopics- Transaction Types Use,
Blocking - DML Operations, Blocking - DDL
Operations, COMMIT ROLLBACK Options, SAVEPOINT
CHECKPOINT, Deciding Transaction Types,
Querying SQL_MODULES View.
6
Our SQL Server DBA Online Training  batches
starts every day. You can attend a DEMO for
free
7
We Provide Online Training On
TIBCO BW Tableau QlikView TIBCO Spotfire SAS
BI SAP Hybris Selenium Oracle DBA Oracle
SOA Oracle Financials IOS Development Android Data
Modeling- Erwin Performance Testing SFDC SAP
UI5 SAP Hana
8
We offers You
1. Interactive Learning at Learners convenience 2
. Industry Savvy Trainers 3.Real
Time" Practical scenarios 4. Learn Right from
Your Place 5. Customized Course Curriculum 6.
24/7 Server Access 7. Support after Training and
Certification Guidance 8. Resume Preparation and
Interview assistance 9. Recorded version of
sessions  
9
Thank you  Your feedback is highly important to
improve our course material. For Free Demo
Please Contact   INDIA 91-9246333245, US
1-2013780518, Email id info_at_mindmajix.com   htt
p//bit.ly/1wFgewd