Microsoft SQL Server 2016: Installation and Administration

Microsoft SQL Server 2016: Installation and Administration

Microsoft SQL Server 2016: Installation and Administration is an Intermediate level study on Business, compiled by an expert, Gerry O'Brien. This study is a critical foundation for a person who needs to excel in his/her Business skills. It provides you a strong understanding on Business, Developer, Web, Servers, Databases, SQL Server, Business, Developer, Web, Servers, Databases and SQL Server.

Free Download - Microsoft SQL Server 2016: Installation and Administration
Author Gerry O'Brien
Publish Date 11/9/2016
Skill Intermediate
Duration 2h 35m
Topic Business
Video Tutorials 37
Last Update N/A

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.

Topics include:

  • Installation and configuration considerations
  • Data storage strategies
  • Configuring database instances
  • Performance considerations
  • Security considerations
  • Managing roles and users
  • Managing data
  • High-availability options

Microsoft SQL Server 2016: Installation and Administration : Video Lessons

  • Welcome1m 7s
  • What you should know47s
  • Introduce installation options2m 26s
  • Installation options continued4m 32s
  • Database storage strategies2m 53s
  • Capacity and growth considerations2m 43s
  • Understanding service accounts3m 38s
  • Install SQL Server7m 32s
  • Setting up the database4m 5s
  • Configure instance properties8m 46s
  • Configure instance properties continued5m 23s
  • Collation and Unicode support4m 15s
  • Configure linked servers5m 38s
  • Database engine services management5m 47s
  • Locks, blocking, and deadlocks3m 9s
  • Using the profiler5m 41s
  • Auditing the database7m 4s
  • Resource governor5m 16s
  • Manage roles3m 52s
  • Manage server logins4m 53s
  • Manage database users3m 36s
  • Manage database roles2m 28s
  • Implement server permissions4m 22s
  • Implement database permissions6m 17s
  • Logon triggers4m 17s
  • Backup and restore strategies3m 30s
  • Backup demonstration5m 26s
  • Moving database files4m 41s
  • Ensure data integrity5m 43s
  • Manage indexes and data maintenance4m 50s
  • Database replication9m 36s
  • Log shipping5m 54s
  • Database mirroring2m 16s
  • Always On2m 32s
  • Next steps53s

Recommended video tutorials from YouTube.

  • SQL Server 2016 Installation -By Daniel AG
  • https://www.empiredatasystems.com/ I hope this video will help you to download and install SQL Server 2016 Installation on your machine. Feel free to call me ...

  • DateTime : 2016-09-10 14:38:49
  • Source : EmpireDataSystems
  • How to Install SQL Server 2016 on Windows 10
  • How to Install SQL Server 2016 on Windows 10 In this tutorial, you will learn How to Install SQL Server 2016 on Windows 10. First of All, you need to do ...

  • DateTime : 2017-09-01 10:37:32
  • Source : Zeee Gaming
  • How to Install SQL Server 2016 Express and SQL Server Management Studio 2016 Express
  • SQL Server 2016 Express installation, This step by step tutorial showing how to install SQL Server 2016 express and how to install SQL Server Management ...

  • DateTime : 2017-03-24 19:35:14
  • Source : Sachin Samy
HELP THE AUTHOR

Please consider buying this course - Microsoft SQL Server 2016: Installation and Administration directly from the author - Gerry O'Brien. This way you could help the author create more great content, also you may get personal help.

The links being shared are only for poor students who really cannot afford to pay. So, if you are capable of paying please do consider it once before trying the free download links.

Categorised in: , , , , ,

Kindly note, we have recently migrated to a new server. In case of download links not working at all it means that we are undergoing maintenance at the backend. In such case please try after 24 hours. Also make sure your internet connection is persistant else the file may endup corrupted.