1. All topics
  2. Technology
  3. Database Management
  4. Database Administration
Microsoft SQL Server 2016: Installation and Administration Preview

Microsoft SQL Server 2016: Installation and Administration

With Gerry O'Brien Liked by 883 users
Duration: 2h 36m Skill level: Beginner Released: 11/9/2016

Start my 1-month free trial Buy for my team

Course details

SQL Server is the database used with Azure and many on-premises environments and is quickly becoming a very popular RDBMS. Get an overview of installing, administering, and managing SQL Server 2016 in this course with SQL Server expert Gerry O'Brien. Learn how to install the database and tools, configure different instances, optimize performance, and secure your database with user roles and logins. Gerry also covers administrative duties such as backup and restoration, database migration, and high-availability options, including database replication, log shipping, and always-on availability. This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.6 out of 5

135 ratings
  • 5 star
    Current value: 98 73%
  • 4 star
    Current value: 29 21%
  • 3 star
    Current value: 4 3%
  • 2 star
    Current value: 3 2%
  • 1 star
    Current value: 1 <1%
  • Abdulrazzaq K Abdulrazzaq K

    Abdulrazzaq K

    Cybersecurity specialist | Tech Analyst | Frontend Developer | Certified IT Professional

    4/5 November 16, 2023
    enjoyed and going further to discover in-depth about how to use and implement SQL server, but a little bit advanced for beginners
    Helpful · Report
  • Shiva krishna Kamarapu Shiva krishna Kamarapu

    Shiva krishna Kamarapu

    PostgreSQL | SAP Sybase | Oracle | Replication | Scripting | AWS | AZURE | Data Migration

    5/5 October 19, 2023
    Well explained about MS SQL server installation and administration Thanks
    Helpful · Report

Contents

What’s included

  • Learn on the go Access on tablet and phone

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play