Sql Server DBA

Duration : 40 Hrs
   PREREQUISITES:
  •  Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
  • Any Programming Language is an advantage.
  • No prior SQL Server experience is presumed.
OBJECTIVE:
 AT THE END OF COURSE PARTICIPANTS WILL BE
  • Plan and install SQL Server.
  • Describes the system databases, the physical structure of databases and the most common configuration options related to them.
  • Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
  • Create SQL Server Backups.
  • Restore SQL Server databases.
  • Use the import/export wizards and explain how they relate to SSIS.
  • Work with SQL Server security models, logins and users.
  • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
  • Work with permissions and the assignment of permissions.
  • Implement SQL Server agent security, proxy accounts and credentials.
  • Configure database mail, alerts and notifications.
  • Create database maintenance plans.
  • Work with SQL Profiler and SQL Trace stored procedures.
  • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
DELIVERY APPROACH:
  • Instructor led online training
  • Knowledge Transfer will happen with respect to proposed content with suitable demos.
  • Blend of theory and hands on with assignment based approach is adopted
  • This course aims to provide participants with the solid experience and know-how to do SQL Server 2005 & 2008,R2,and 2012 Administration.
  • This course has been developed for real-world scenarios,   for Production Server and Development environments with explaining real time issues. See below for detailed syllabus.
 Introduction SQL Server 2012.
  • SQL-Architecture.
  • GAM, SGAM, Pages, Extents.
  • Database engine,
  • Service Broker,
  • Multiple instances,
  • Sql server2012 editions,
  • SQL Server 2012 databases and Objects,
  • Database Storage (Data Files and File groups, Log Files)
  • Sql Server Physical Structure.
  • What is new for DBAs in SQL Server 2012?
Installing SQL-Server 2012.
  • Hardware Requirements.
  • System Configuration Checker (SSC).
  • Installation Methods,
  • Installation Options,
  • Installation issues.
 SQL Server 2012Databases.
  • System Databases,
  • User Databases,
  • Database Planning,
  • Creating databases with multiple files.
  Security.
  • Assigning Permissions.
  • SQL Server Authentication Modes,
  • Principals, Permissions,
 TDE (Transparent Data Encryption)
  • Symmetric keys, asymmetric keys
  • Master Key
  • Encryption & Decryption,
  • Algorithms
  • Certificates
 Index maintenance
  • Index Architecture,
  • Types of Indexes,
  • Creating Altering, and droping indexes,
  • Index maintenance.
  • Index Fragmentation & Defragmentation
  • Rebuilding & Reorganizing.
  Disaster Prevention and Recovery
  • Recovery Models,
  • Backup Types,
  • Backup Options,
  • Backup Strategies,
  • Restoring Databases,
  • Mirrored backup,
  • Database Snapshots.
  High Availability
  • Introduction to High Availability
  • Failover Clustering,
  • Log Shipping,
  • Database Mirroring
  Logshipping
  • Logshipping configuration
  • Log shipping maintenance
   Mirroring
  • Mirroring configuration
  • Mirroring Modes
  • Mirroring maintenance
  Replication
  •  Replication Basics,
  • Replication Agents, Types,
  • Replication Models,
  • Replication Topology,
  • Planning for Replication,
  • Setting Up Replication in Management Studio,
  • Replication Management Objects (RMO).

 Performance tuning and monitoring.

Tools:
  • SQL Server management Studio,
  • Log file Viewer,
  • Sql Server Profiler,
  • Database Engine Advisor’s Server Cofiguration Manager.
  • Command Line Tools (SQL CMD, BCP)
  • Activity Monitor.
  • Capacity planning,
  • Policy based management
  • Resource governor
  • AWE
  • Auditing,
  • Service broker
  • Lock and Deadlocks
 Automating Administrative tasks.
  • Database Mails,
  • Server Agent (creating, schedules, operators, Alerts)
  • Maintenance Plans.
  FAQ Discussion
 Partial List Of Other Courses  Offered
  • Android
  • Business Analyst
  • Cognos 8 BI & Tm1
  • Data Stage
  • DB2 DBA
  • Dot Net
  • DAC
  • Hyperion Essbase , Planning
  • IBM Lotus Notes (Development)
  • IBM Lotus Notes Domino Server Administration
  • IBM Message Broker
  • IBM MQ Series
  • IBM Web Sphere Application Server Administration (WAS)
  • IBM WAS Portal server Development
  • Informatica
  • I Phone
  • Java/J2EE
  • MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
  • Microstrategy
  • MicroSoft Business Intelligence
  • MicroSoft Dynamics CRM
  • OBIEE 11 g
  • Oracle APPS – HRMS
  • Oracle APPS – SCM
  • Oracle APPS – Financial
  • Oracle APPS – Technical
  • Oracle BI Apps
  • Oracle BI Publisher
  • Oracle DBA 11g
  • Oracle Fusion SOA , B2B,
  • Oracle SQL , PL SQL
  • PHP
  • Perl Scripting
  • SAP SD & BO & ABAP
  • Sales Force CRM
  • SharePoint Server 2010
  • Shell Scripting
  • Siebel CRM , EAI, E-Scripting
  • SQL Server DBA
  • Springs and Hibernate
  • Testing Tools - QTP, QC, Load Runner, Selenium
  • TIBCO BW, BE, CIM, TIBCO I Process
  • Unix Administration
  • WCF, WPF, LINQ, AJAX, SILVER LIGHT
  • Webmethods
  • Webservices , SOAP ( JAVA)

Reviews

No reviews

Post Review

Name
Email
Review Title
Rating
Review Content
View All Categories

Quick Enquiry

captcha

Technology Portfolio

Loading...