Database Foundations
Administration
Heads up! This course may be archived and/or unavailable.
Prepare for the MTA: Database Fundamentals Exam (98-364),
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.
Contents:
- Introduction
- 1. Securing the Database Server
- 2. Enforcing Database Roles
- 3. Working with Fixed Database Roles
- 4. Assigning Database Object Permissions
- 5. Creating Database Backups
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 1h 14m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Adam Wilbert |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | IT & Networking Data Science |
Tags | IT Network Administration SQL Server Database Administration Database Development Microsoft SQL Server |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
SQL Server Administrator $77k
IT Conslutant - SQL Server $83k
SQL Server/Oracle DBA $95k
SQL Server Instructor $95k
PHP and SQL Server Developer $103k
SQL Server | BI SQL Server developer $108k
Microsoft SQL Server Developer $109k
Database Administrator SQL Server $115k
SQL Server DBA 5 $122k
SQL Server Architect $138k
SQL Server MVP 5 $156k
SQL Server MVP 3 $163k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 1h 14m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Adam Wilbert |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | IT & Networking Data Science |
Tags | IT Network Administration SQL Server Database Administration Database Development Microsoft SQL Server |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course