SQL Server DBA
CloudLabs
Projects
Assignment
24x7 Support
Lifetime Access
.
Course Overview
SQL Server 2012 is Microsoft’s latest cloud-ready information platform. Organizations can use SQL Server 2012 to efficiently protect, unlock, and scale the power of their data across the desktop, mobile device, datacenter, and either a private or public cloud.
At the end of the training, participants will be able to:
Pre-requisite
Attendees should be comfortable with Windows server architecture. Some experience of programming and/or XML would be useful but not mandatory.
Duarion
5 days
Course Outline
- Availability and Scalability Features
- Security Features
- Data Management Features
- Administration and Maintenance Features
- Development Features
- To enable SQLiMail
- Testing mail delivery
- SQL Server 2008 Editions
- Installing Microsoft SQL Server
- System Requirements
- Preparing for a SQL 2008 Installation
- Installation Checklist
- Setup Features
- Using the System Consistency Checker
- Component Install
- Unattended Installation
- Installation Sequence
- Installation Maintenance
- Retaining SQL 2000 / 2005
- To verify the Installation
- Administrative Tools
- Upgrading to SQL Server Management Studio
- Management Studio Windows
- Registered Servers
- Object Explorer
- Review Database Objects
- Modify Database Properties
- Create Database Scripts
- The Maintenance Plans Node
- Solution Explorer
- Query Editor
- Template Explorer
- Dynamic Help
- Upgrading to SQL Server Computer Manager
- SQL Server 2008 Services node
- SQL Server 2008 Network Configuration node
- SQL Server 2008 Native Client Configuration node
- The SQLCMD Management Utility
- SQLCMD Syntax
- SQLCMD Variables
- Dedicated Administrative Connection
- SQL Server Management Studio SQLCMD Mode
- Using SQL Management Objects
- SMO Object Model
- Managing Metadata Views
- Metadata Storage
- System Views
- Information Schema
- Catalog Views
- Sys All
- Dynamic Management Views
- System Stored Procedures
- Index Management
- New Index Features
- Creating Indexes
- Online Index Maintenance
- Parallel (multiple CPU) Index Operations
- Lock Options
- Included Columns in Indexes
- Partitioned Tables and Indexes
- XML Index Support
- Altering an Index
- Rebuilding an Index
- Reorganising an Index
- Disabling an Index
- Dropping an Index
- Index Fragmentation
- Using the Database Tuning Advisor
- Implementing Securables
- New Security Features
- Principals
- Securables
- Permissions
- Permission Types
- Managing Logins
- Managing Users
- Managing Schemas
- Schema Definition
- Using Schemas
- Managing Execution Context
- Managing Permissions
- Manage Server Permissions
- Manage Server-Scope Securable Permissions
- Manage Database Permissions
- Manage Database-Scope Securable Permissions
- Managing Certificates
- Native Data Encryption
- Code and Module Signing
- Disaster Recovery
- SQL 2008 Disaster Recovery Feature
- Enhanced Features
- Database Snapshots
- Creating a Snapshot
- Common Snapshot Applications
- Undeleting table rows
- Undoing a table update
- Recovering a dropped object
- Backup and Restore
- Backup Changes
- Restore Changes
- Media Integrity Changes
- Recovering the MASTER Database
- Create a mirrored backup
- Restore from the backup mirror
- Create a snapshot
- Restore the snapshot data
- Automate the creation of daily snapshots
- SQL Server 2008 Data Availability
- Database Mirroring
- The Witness Server and Automatic Failover
- Configuring Database Mirroring
- Transaction Safety Level
- Operating Modes
- High Availability Operating Mode
- High Protection Operating Mode
- High Performance Operating Mode
- Mirroring Security
- Monitoring Mirroring
- Database States for Database Mirroring
- Prepare the Servers
- Configure Mirroring
- Verify Principal and Mirror Access
- Execute the Mirror Failover
- Verify Mirror and Witness Status
- Terminating the Mirror Session
- Replication Enhancements
- Stand-alone Replication Monitor
- Support for Oracle Publishing
- HTTP Synchronisation for Merge Replication
- Subscriber Initialisation
- Replicating DDL Statements
- Modified User Interface
- Replication Management Objects
- To Configure Publishing and Distribution
- Configuring Peer-to-Peer Replication
- Create a Publication
- Create a Subscription with RMO
- Creating the Database Objects
- Creating a Package Using Business Intelligence Studio
- Integration Services Project Template
- OLE DB Command object
- Column Mappings
- Adding a Data Viewer
- Optimal Data Storage
- Diagnostic Tools
- Query Analyzer
- Database Engine Tuning Advisor
- Index Optimisation
- Federated Database Servers
- Partitioned Indexes
- Lock optimsation
- Best Practices for Native XML Web Services
Reviews
"The corporate training provided by Greater Insights was truly exceptional. The trainers were highly knowledgeable and engaging, making the sessions both informative and enjoyable. I gained valuable insights and practical skills that I immediately applied in my work. I highly recommend Greater Insights for their professionalism and expertise."
Rahul NiraniaSamsung
"As a participant of the corporate training program organized by Greater Insights, I was thoroughly impressed with the level of customization they offered. They took the time to understand our specific needs and tailored the training accordingly. The trainers were fantastic, and the interactive sessions fostered an environment of active learning. I am grateful for the valuable knowledge and skills I acquired."
Bhawna TiwariSamsung
"I cannot express enough gratitude to Greater Insights for the outstanding corporate training they provided. The trainers were not only experts in their respective fields but also incredible communicators. They created a dynamic and collaborative learning environment, which allowed us to learn from one another. The training surpassed my expectations, and I would eagerly participate in any future programs they offer."
Ashutosh SinghSamsung
"Attending the corporate training sessions organized by Greater Insights was a game-changer for me. The trainers were not only experienced professionals but also inspiring mentors. They equipped me with practical tools and strategies that have significantly enhanced my productivity and efficiency at work. I wholeheartedly recommend Greater Insights to anyone looking to excel in their professional endeavors."
Somashekar MuniyappaInfogain
"The corporate training program offered by Greater Insights was an enlightening experience. The trainers had a deep understanding of the subject matter and were able to break down complex concepts into easily digestible information. The interactive activities and case studies made the training engaging and relevant to our day-to-day work challenges. This training has undoubtedly boosted my confidence and competence."
Amresh DiwanInfogain
"I had the privilege of participating in a corporate training program organized by Greater Insights, and I must say it was a transformative experience. The trainers' expertise and passion for their subjects were evident in every session. The training materials provided were comprehensive and well-structured, enabling us to grasp the content effectively. I am grateful for the valuable skills I acquired, which have greatly contributed to my professional growth."
Namratha BabuTorry Harris
"The corporate training sessions conducted by Greater Insights were simply outstanding. The trainers went above and beyond to ensure that we understood the concepts thoroughly. The interactive nature of the sessions encouraged active participation and enhanced our learning experience. I am truly grateful for the practical strategies and techniques I learned, which have had a positive impact on my work performance."
Rahul BhashyamTorry Harris
"Participating in the corporate training program organized by Greater Insights was an enlightening experience. The trainers were not only knowledgeable but also skilled at delivering the content in an engaging manner. The training materials were well-designed, and the real-life examples provided valuable insights. I am confident that the knowledge and skills I gained will significantly contribute to my professional growth."
Deepti JainTorry Harris
"I can confidently say that the corporate training provided by Greater Insights was top-notch. The trainers were highly experienced and had a knack for simplifying complex concepts. The training sessions were interactive and encouraged open discussions, which fostered a collaborative learning environment. The practical skills I acquired during the training have proven to be invaluable in my day-to-day work."
HARSHAL TRIVEDIL&T TS
"Greater Insights exceeded my expectations with their corporate training program. The trainers were not only experts in their fields but also exceptional communicators. They effortlessly connected with the participants and ensured everyone's active involvement. The training content was comprehensive and provided a solid foundation for professional growth. I am grateful for the opportunity to learn from such seasoned professionals."
Namrata PillayL&T TS
"The corporate training facilitated by Greater Insights was exceptional in every aspect. The trainers were engaging and created a positive and inclusive learning environment. The training materials were well-structured and easy to follow, making the learning process enjoyable. The practical exercises and case studies allowed me to apply the knowledge immediately, resulting in improved job performance. I highly recommend Greater Insights for their commitment to excellence."
Sandhya M SanuHoneywell
"I recently attended a corporate training program organized by Greater Insights, and I am incredibly impressed. The trainers were not only knowledgeable but also highly skilled at delivering the content in a relatable manner. The training sessions were interactive and encouraged open dialogue, which made the learning experience engaging and dynamic. The practical skills I gained have already made a significant impact on my professional growth."
Neha SahayHoneywell
"I had the privilege of participating in a corporate training program conducted by Greater Insights, and it was truly transformative. The trainers were passionate and dedicated professionals who took the time to address our individual needs. The training sessions were interactive and encouraged active participation, allowing us to learn from one another's experiences. I am grateful for the knowledge and skills I acquired, which have undoubtedly propelled my career forward."
Abishek KalliparambilAllianz
"The corporate training program offered by Greater Insights was a remarkable experience. The trainers had a wealth of knowledge and were adept at imparting it effectively. The training materials were comprehensive and provided valuable resources for further exploration. The interactive activities and practical exercises helped me internalize the concepts and apply them in real-world scenarios. This training has been instrumental in my professional development."
Kishor KumarITC Infotech
"I cannot thank Greater Insights enough for the incredible corporate training they provided. The trainers were not only subject matter experts but also skilled at creating a positive and inclusive learning environment. The training sessions were well-structured, and the trainers ensured that we understood the content thoroughly. I am grateful for the valuable insights and skills I gained, which have already made a noticeable difference in my professional life."
Anitha PrashanthIndegene
Previous
Next