Skip to Main Content

Learn & Network
- Events Calendar
  Check out upcoming NERCOMP events & workshops.
- Annual Conference
  Our community of faculty, researchers, learners, and institutions come together to advance innovation and leadership in higher education.
- Submit A Session Idea
  Do you have an interesting idea or hot topic in the academic information technology field you can share with the NERCOMP community?
- On-Demand Content
  View a large library of previously recorded webinars and access presentations & handouts from past in-person workshops.
- New Horizons
  NERCOMP members save 30% off the list price for all New Horizons classes. This is a great opportunity to take advantage of numerous training and certifications at deeply discounted prices.
- Moodle
  NERCOMP members save 15% on the Moodle Educator Certification (MEC) program. It is a comprehensive teaching and learning curriculum designed to help you develop transferable knowledge and skills to be effective educators in today’s growing digital workplace.
- Canvas
  NERCOMP members save hundreds of dollars on the Canvas Certified Educator (CCE) program. Learn about best practices through this flexible, asynchronous facilitated 36-week program geared toward individuals in teaching roles, instructional design, and professional development/training positions at their institutions with basic familiarity with Canvas.
Membership
- Join Now
  Complete the application for Institutional Membership to start using NERCOMP member benefits now!
- Member Benefits
  Learn why so many institutions have taken advantage of NERCOMP membership for over 60 years.
- Fees & Information
  Discover more about membership requirements and fees.
- Member List
  See all the current participating member schools.
- IR Resources
  Use this Resource page to access information about your important role as an Institutional Representative.
Community
- Job Board
  Find new higher education positions and post jobs for free as a benefit of your NERCOMP membership!
- Leadership Ecosystem
  Learn more about what is happening with NERCOMP's Leadership community including past and upcoming webinars
- Mentorship Program
  The Mentorship Program offers members a platform to engage in ongoing learning and professional growth and highlighting our commitment to providing quality professional development opportunities and fostering a vibrant community of IT professionals.
- NERCOMP Awards
  The NERCOMP Awards Program recognizes the professional accomplishments of individual NERCOMP members.
Partners
- Solutions Partner Agreements
  NERCOMP schools leverage their buying power for deep discounts and valuable warranties and protections.
- Become a Solutions Partner
  Interested in being considered for a three-year partnership agreement with NERCOMP?
- Corporate Associates
  Learn more about NERCOMP partnerships that bring professional development and other valuable expertise to our organization.
About Us
- Who We Are
  We are a professional society for University and Collegiate Information Technology professionals.
- Our Mission
  NERCOMP advances innovation and leadership in educational institutions across the Northeastern United States.
- Strategic Plan
  NERCOMP continually refines its strategic goals to remain relevant to higher education.
- News & Blog
  Featuring information and technology, strategic partnerships, innovation advances and leadership in educational institutions across the Northeast.
- Our History
  NERCOMP has been a pioneer in information technology and professional development for colleges and universities since the 1950’s.
- Our Board & Staff
  NERCOMP is governed by a Board of Trustees elected from NERCOMP member institutions.
- Bylaws
  NERCOMP’s bylaws outline the terms and conditions that govern the NERCOMP Inc. Corporation and its Board of Trustees.
- Committees
  Interested in volunteering your time and energy to help cultivate communities of practice?

Meetings Stub Page [mx-stub]

Course Outline

1 - Introduction to SQL Server 2014 Database Administration

Database Administration Overview
Introduction to the SQL Server Platform
Database Management Tools and Techniques
Lab : Using SQL Server Administrative Tools
Using SQL Server Management Studio
Using the sqlcmd Utility
Using Windows PowerShell with SQL Server

2 - Installing and Configuring SQL Server 2014

Planning SQL Server Installation
Installing SQL Server 2014
Post-Installation Configuration
Lab : Installing SQL Server 2014
Preparing to Install SQL Server
Installing SQL Server
Performing Post-Installation Configuration

3 - Working with Databases and Storage

Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving Database Files
Configuring the Buffer Pool Extension
Lab : Managing Database Storage
Configuring tempdb Storage
Creating Databases
Attaching a Database

4 - Planning and Implementing a Backup Strategy

Understanding SQL Server Recovery Models
Planning a Backup Strategy
Backing up Databases and Transaction Logs
Using Backup Options
Ensuring Backup Reliability
Lab : Backing Up SQL Server Databases
Backing Up Database
Performing Database, Differential, and Transaction Log Backups
Performing a Partial Backup

5 - Restoring SQL Server 2014 Databases

Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Working with Point-in-Time Recovery
Lab : Restoring SQL Server Databases
Restoring a Database Backup
Restoring Database, Differential, and Transaction Log Backups
Performing a Piecemeal Restore

6 - Importing and Exporting Data

Introduction to Transferring Data
Importing and Exporting Table Data
Copying or Moving a Database
Lab : Importing and Exporting Data
Using the SQL Server Import and Export Wizard
Using the bcp Utility
Using the BULK INSERT Statement
Using the OPENROWSET Function

7 - Monitoring SQL Server 2014

Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Performance Monitor
Lab : Monitoring SQL Server 2014
Collecting Baseline Metrics
Monitoring a Workload

8 - Tracing SQL Server Activity

Tracing SQL Server Workload Activity
Using Traces
Lab : Tracing SQL Server Workload Activity
Capturing a Trace in SQL Server Profiler
Generating Database Tuning Recommendations
Using SQL Trace

9 - Managing SQL Server Security

Introduction to SQL Server Security
Managing Server-Level Security
Managing Database-Level Principals
Managing Database Permissions
Lab : Managing SQL Server Security
Managing Server-Level Security
Managing Database-Level Security
Testing Database Access

10 - Auditing Data Access and Encrypting Data

Auditing Data Access in SQL Server
Implementing SQL Server Audit
Encrypting Databases
Lab : Auditing Data Access and Encrypting Data
Implementing Auditing
Implementing Transparent Database Encryption

11 - Performing Ongoing Database Maintenance

Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Lab : Performing Ongoing Database Maintenance
Managing Database Integrity
Managing Index Fragmentation
Implementing a Maintenance Plan

12 - Automating SQL Server 2014 Management

Automating SQL Server Management
Implementing SQL Server Agent Jobs
Managing SQL Server Agent Jobs
Managing Job Step Security Contexts
Managing Jobs on Multiple Servers
Lab : Automating SQL Server Management
Creating a Job
Scheduling a Job
Configuring Job Step Security Contexts

13 - Monitoring SQL Server 2014 by Using Alerts and Notifications

Monitoring SQL Server Errors
Configuring Database Mail
Configuring Operators, Alerts, and Notifications
Lab : Monitoring SQL Server by Using Alerts and Notifications
Configuring Database Mail
Implementing Operators and Notifications
Implementing Alerts

You are using an unsupported version of Internet Explorer. To ensure security, performance, and full functionality, please upgrade to an up-to-date browser.