RELEASE NAME....: Lynda.com.Database.Fundamentals.Administration-ELOHiM
RELEASE DATE....: 2015-11-05
RELEASE SIZE....: 12x15Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
Ongoing, regular administration is critical to the security and
performance of databases such as Oracle and SQL Server. It's also a key
topic of the Microsoft Technology Associate (MTA) Exam. Whether you're
studying to pass the test or simply to keep your admin skills up to date,
this course will cover the most current techniques and best practices for
administering a database. Adam Wilbert covers the core concepts, including
securing the server with user authentication and roles, assigning
object-level permissions, and performing a backup and restore. Along the
way, he'll provide tips for working with SQL Server Management Studio and
some challenges to help you practice what you've learned.
Note: This course will also prepare certification candidates for the
"Administer a database" domain of the Microsoft Technology Associate (MTA)
Exam 98-364, Database Administration Fundamentals.
Topics include:
* Securing the database server
* Understanding Windows authentication vs. SQL Server authentication
* Assigning fixed server roles and fixed database roles
* Granting object-level permissions
* Understanding ownership claims
* Creating backups
* Restoring a database
Subject: IT
Software: SQL Server
Author: Adam Wilbert
Level: Beginner
Duration: 1h 14m
Released: Nov 03, 2015