Processing...

Home > Administering Microsoft Sql Server 2014 Databases (course Code 20462)

This 5 day course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Outcomes & Objectives

After completing this course, students will be able to:

  • Describe core database administration tasks and tools.

  • Install and configure SQL Server 2014.

  • Configure SQL Server databases and storage.

  • Plan and implement a backup strategy.

  • Restore databases from backups.

  • Import and export data. Monitor SQL Server.

  • Trace SQL Server activity.

  • Manage SQL Server security.

  • Audit data access and encrypt data.

  • Perform ongoing database maintenance.

  • Automate SQL Server maintenance with SQL Server Agent Jobs.

  • Configure Database Mail, alerts and notifications.

  • Duration

    5 Days (08:30 - 16:00), In-Class, myWay Mentored Learning,

    90 Days Access Per Course, Online, myWay On Demand Distance Learning

  • Course Prerequisites

    Before attending this course, students must have:

    • 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.

  • Who Should Attend

    The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

    The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

Our Delivery Methods

Our innovative "myWay” learning methodology is built around the students individual learning requirement, allowing each student to learn in a style that is most suitable for their skills set, knowledge and schedule.

Online Mentored Learning

Do a course at your pace via our “myWay Online Mentored Learning”, combining self-study with supported interactive online video lectures, an online course mentor, extra resources, questionnaires and more, all supported via out Online Student Portal.

Learn more

Part Time Mentored Learning

Designed for the working professional, our part time programmes provides you with the flexibility and benefit of our myWay Blended Learning with at home exercises/assignments and mentored or in-class lectures at a manageable schedule and pace.

Learn more

Our Hybrid Delivery Methods

Our Hybrid Delivery Methods

myWay Hybrid Learning is a technology mediated delivery method that extends the benefit of flexibility and technology to all students. Each Hybrid delivery method is described in the section below.

#AnywhereAnytime

Have all your classes ready to be downloaded and watched, anytime, anywhere.

#NoStudentLeftBehind

Never miss a classs because of health, traffic, or transport issues.

#Flexibility

A personalized class schedule, attend class on campus, virtually or both.

 

In Class or Virtual Class Based Learning

A technology mediated delivery method allowing campus based class or virtual class attendance, or a combination of both. Classes can be in the form of lecture based or mentored based.

LEARN MORE
 

Mentored Online Learning

A technology mediated, self paced online delivery method with personal mentorship.

LEARN MORE

What you get

This course will help you you prepare for the Exam 70-462. CLICK HERE to learn more about this exam.
This course contributes towards earning your MCSA: SQL Server 2014. CLICK HERE to learn more.

Student Testimonials

"This was the best training and the conduct of the staff was excellent"

Mfanafuthi Cosmos Makhanya, Querying Microsoft SQL Server

"The course does give a good start for the admin work of SQL Server Admin"

Dibuleng Mokgoshing, Administering SQL Server 2014

"Thank you for delicious food! The venue is neat and well lit and the temperature is comfortable.  The course was also great!"

Gwyneth Perfect, Querying SQL Server 2014

Course Video

How to become Database Administrator DBA:

This video shows the steps to become a Database Administrator (Qualifications, Certifications and Work Experience Required).

 

Important Notes

  • Students are to be at the training venue by 08h00 in preparation for a 08h30 start time.
  • Learnfast retains the right to change this calendar without any notification.
  • Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order for the full amount of the training.
  • For full day courses Learnfast will supply you with the relevant training material. A desktop computer to use for the training (where applicable), tea/coffee and a full lunch for full day InClass training hosted at Learnfast only. Catering is not included for OnSite training and laptop is available for hire at an additional cost if required.
  • Cancellation or rescheduling requests must be in writing and reach us via fax or email at least 5 (five) working days prior to the course commencement date. Full course fees may be retained for no shows or requests within 5 working days prior to commencement.
  • Although we go to great lengths to ensure that all training proceeds as scheduled, Learnfast reserves the right to cancel or postpone dates if we require to do so and undertake to inform clients in writing and telephonically of these changes.
  • Learnfast suggests clients wait until a week prior to course commencement that a course has been confirmed to go ahead as scheduled before booking flight and accommodation. Learnfast is NOT responsible for cost associated with cancellation of classes such as flight and accommodation for clients.

Module 1: Installing SQL Server 2014
This module introduces the SQL Server 2014 platform. It describes the components, editions, and versions of SQL Server 2014, SQL Server services and configuration options, and service accounts. The module also explains how to assess resource requirements for SQL Server 2014 and how to install SQL Server 2014.
Lessons

  • Introduction to the SQL Server Platform
  • SQL Server Services and Configuration Options
  • Considerations for Installing SQL Server
  • Installing SQL Server 2014
 

Module 2: Working with Databases
This module describes he preinstalled system databases, the physical structure of databases, and the most common configuration options related to them.
Lessons

  • Overview of SQL Server Databases
  • Creating Databases
  • Using Database Files and Filegroups
  • Moving Database Files
  • Buffer Pool Extension
 

Module 3: SQL Server 2014 Recovery Models
In this module, you will consider how to create a strategy that is aligned with organizational needs and see how the transaction logging capabilities of Microsoft SQL Server can help you to achieve an appropriate outcome.
Lessons

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy
 

Module 4: Backup of SQL Server 2014 Databases
In this module, you will explore the key backup types in more depth and learn how to implement the backups. You will also see how to apply options that affect the way that the backups work.
Lessons

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options
 

Module 5: Restoring SQL Server 2014 Databases
In this module, you will see how to restore user and system databases and how to implement point-in-time recovery.
Lessons

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-Time Recovery
  • Restoring System Databases and Individual Files
 

Module 6: Importing and Exporting Data
This module covers the use of the import/export wizards and explains how they relate to SSIS. It also introduces BCP and BULK INSERT.
Lessons

  • Transferring Data To/From SQL Server
  • Importing and Exporting Table Data
  • Inserting Data in Bulk
  • Deploying and Upgrading Data-tier Applications
 

Module 7: Authenticating and Authorizing Users
This module covers SQL Server security models, logins, users, and contained databases.
Lessons

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers
  • Partially Contained Databases
 

Module 8: Assigning Server and Database Roles
This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.
Lessons

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles
 

Module 9: Authorizing Users to Access Resources
This module covers permissions and the assignment of permissions.
Lessons

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
 

Module 10: Protecting Data by Using Encryption and Auditing
This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server audit feature, and how to implement encryption.
Lessons

  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data by Using Encryption
 

Module 11: Automating SQL Server 2014 Management
This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.
Lessons

  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-Server Management
 

Module 12: Configuring Security for SQL Server Agent
This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.
Lessons

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Server Accounts
 

Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
This module covers the configuration of database mail, alerts, and notifications.
Lessons

  • Configuring Database Mail
  • Monitoring SQL Server Errors
  • Configuring Operators, Alerts, and Notifications
 

Module 14: Performing Ongoing Database Maintenance
This module covers database maintenance plans.
Lessons

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
 

Module 15: Tracing Access to SQL Server 2014
This module describes how to use SQL Server Profiler and SQL Trace stored procedures to capture information about SQL Server. It also describes how to use Distributed Replay to capture trace information from multiple servers and how to monitor locking.
Lessons

  • Capturing Activity by Using SQL Server Profiler
  • Improving Performance by Using the Database Engine Tuning Advisor
  • Working with Tracing Options
  • Distributed Replay
  • Monitoring Locks
 

Module 16: Monitoring SQL Server 2014
This module explains how to use Distributed Management Views to monitor SQL Server. It also describes how to configure data collection and the SQL Server Utility.
Lessons

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
    No dates have been specified for this course.
    Please contact The CAD Corporation for more information and dates on this course.

By completing the below online booking, a booking confirmation will be sent out and an invoice will be generated. A place will be reserved on this course and you are expected to attend. If you require a quote first please contact Learnfast offices and speak to a sales consultant.

Administering Microsoft SQL Server 2014 Databases (Course Code 20462)
  1. By booking for this course, an invoice will be generated and you will be liable for the payment of this invoice. If you require a quote, please contact The CAD Corporation Offices.
  2. After the generation of the invoice a training confirmation will be emailed using the details provided above.
  3. The CAD Corporation retains the rights to change this calendar without any notification.
  4. Tea/coffee and a light lunch will be provided.
  5. All university students will receive a 10% discount for cash payments.
  6. The minimum notice of cancellation is 5 (five) working days prior to the course commencement date. If you fail to do so the full amount is payable.
  7. Students are to be at the training venue by 08h00 in preparation for a 08h30 start time.
Delivery Method: 
  • Math Result: