Administering Microsoft SQL Server 2014 Databases is a five day course which provides essential skills and knowledge to the participants for maintaining Microsoft SQL Server 2014 database. This course mainly focuses on teaching delegates ways to use SQL Server 2014 features
Course Introduction
Administering Microsoft SQL Server 2014 Databases is a five day course which provides essential skills and knowledge to the participants for maintaining Microsoft SQL Server 2014 database. This course mainly focuses on teaching delegates ways to use SQL Server 2014 features and tools to maintain a database.
Overveiw
This training makes a delegate to learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by concentrating on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent. Enhance your Microsoft SQL Skills today with Best Practice Training
Course Content
SQL Server 2014 Database Administration introduction
Introduction of Database Administration
Overview to SQL Server platform
Tools and techniques for database management
Use SQL Server Management studio
Use Sqlcmd Utility
Use Windows PowerShell with SQL Server
Install and Configure SQL Server 2014
Prepare to Install SQL Server
Install SQL Server
Perform Post-Installation Configuration
Working with Databases and Storage
Introduction to Data storage with the help of SQL Server
Managing system databases storage
Manage user databases storage
Moving database files
Configure buffer proof extension
Configure Tempdb storage
Create and attach a database
Planning and Implementing a Backup Strategy
Understand SQL Server recovery Models
Back up strategy planning
Backing up databases and Transaction logs
Use Backup options
Ensure backup reliability
Perform a Partial Backup
Restore SQL Server 2014 Databases
Understand restore process
Restore databases
Advanced restore scenarios
Work with Point in time recovery
Restore database backup
Restore database, differential and Transaction Log Backups
Perform piecemeal restore
Importing and Exporting Data
Introduction to Transferring Data
Import and Export Table Data
Copy or move a database
Learn to use SQL Server Import and Export Wizard
Use the BCP Utility
Use BULK INSERT Statement and OPENROWSET Function
Monitoring SQL Server 2014
Monitoring SQL Server introduction
Dynamic Management Functions and Views
Monitor performance
Collect Baseline Metrics
Monitor workload
Tracing SQL Server Activity
Learn to use traces
Trace SQL Server Workload Activity
Using SQL trace
Capture trace in SQL Server profiler
Generate database tuning
Managing SQL Server Security
SQL Server Security introduction
Manage Server-Level Security
Manage principles at Database level
Manage Database Permissions
Manage Database Level security
Testing Database Access
Auditing Data Access and Encrypting Data
Audit Data Access in SQL Server
Implement SQL Server Audit
Encrypt databases
Performing On-going Database Maintenance
Ensure Database Integrity
Indexes maintenance
Automatic Routine Database Maintenance
Manage Database Integrity and Index Fragmentation
Implement a Maintenance Plan
Automating SQL Server 2014 Management
SQL Server Management automation
SQL Server Agent jobs implementation
Manage SQL Server Agent jobs
Manage job step security contexts
Manage jobs on Multiple Servers
Create and schedule a Job
Job step security contexts configuring
Monitoring SQL Server 2014 by Using Alerts and Notifications
Monitor SQL Server Errors
Database mail configuring
Configure operators, Alerts and Notifications
Configure Database Mail
Operators and Notifications implementation
Implement alerts
Prerequisites
Delegate must possess basic knowledge of Microsoft windows Operating system and its core functions.
Operational knowledge of Transact SQL and Relational databases.
Basic experience of database design.
Target Audience
Intended audience for this course is professionals who are into administering and maintaining SQL Server databases. In this delegates perform database administration along with maintenance as their responsibility in a working environment where databases play a major role in their core job.
Delegates Will Learn How To
Participants will learn Planning and Installing SQL Server.
Easily defining system databases, physical structure of databases and most common configuration options associated to them.
Explaining transaction log concepts and SQL Server Recovery models.
Implementing different backup strategies which are available with SQL server.
Backup and Restoring SQL server databases.
Importing as well as Exporting data using Wizards, Bulk Copy Utility and Data Tier Applications.
Ability to work with SQL Server Security models, Users, Logins and contained databases.
Working with various server roles and database roles.
Permissions to secure resources.
Using SQL Server agent for configuration and executing jobs.
Implementing SQL Server agent security, proxy accounts and credentials.
Configuring database mail, alerts and notifications easily.
Creating database maintenance plans.
Using SQL Server profiler, SQL trace and Distributed relay.
Using Distributed management views and data collection configuration.
Best Practice Training is an independent provider of project management and IT service management training courses.
Since our formation in 2011, we have successfully delivered training courses to both the public and private sectors throughout the UK and internationally.
Our Values
Our main goal is to make a positive difference to your organisation. What you learn should have a direct, lasting impact on your future at a business and personal level. How do we achieve this?
Who We Are?
Best Practice Training is an independent provider of project management and IT service management training courses.
Since our formation in 2011, we have successfully delivered training courses to both the public and private sectors throughout the UK and internationally.
What We Aim to Do?
We aim to have enduring relationships with our customers. Best Practice Training provides authorised certification from highly reputed certification bodies.
What matter to us is teaching to bring real and long-lasting benefit to your work. Our main objective is to provide the highest quality of training so that you can enhance your career in your industry.
What Do We Provide?
Best practice Training provides you with a large variety of professional courses to help you develop your skills. We will help you to implement learned skills effectively in your business.
The variety of courses that we deliver range from Project Management, Technical IT, Systems Architecture, Business Skills, Cyber Security and much more.
On this accelerated 3-day OCA Java SE 8 programming course, you'll be introduced to object orientated programming using the Java language.
Oracle offered another course named ‘Oracle Certified Professional, MySQL 8.0 Database Administrator’ that enables Database Administrators, including other Database Professionals, to enhance and optimize their organization’s investment in MySQL.
HBase is a non-relational database that allows you to read and write massive datasets in real-time. It lets you store a large amount of data in a table format.
Electronic Data and Record Management System.
Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy