Newbie-Intermediate sensible expertise in Database Administration (DBA) SQL Server. Good for Microsoft examination 70-462.
What you’ll study
Create Backups and Restore Databases, understanding the totally different restoration fashions
Handle logins and server roles, and import and export information
Implement and keep indexes, and handle and configure databases, together with compression and concurrency issues
Handle SQL Server Agent and audit SQL Server cases
Acquire and analyse troubleshooting information
Plan and set up SQL Server and associated providers, together with implementing a migration technique
You don’t want any prior DBA data previous to taking this course.
It might be useful if you happen to knew how one can create easy T-SQL statements (SELECT, FROM, WHERE, GROUP BY) for some elements of the course, however not important
When you want to finally take the 70-462 examination, you would want to memorize numerous T-SQL desk names.
If you wish to know sufficient T-SQL to help you together with your SSRS work, please take a look on the first two periods of my 70-461 programs.
You don’t want any type of SQL Server to already be put in in your laptop; I’ll present you need to download it and set up it – at no cost.
Do you wish to acquire sensible expertise in Database Administration in SQL Server? Are you wanting to arrange for the official Microsoft examination 70-462 “Administering Microsoft SQL Server”? Both approach, welcome.
On this course, study a few of the abilities that Microsoft need you to know, and add one other instrument to your CV or resume, and even go for the official Microsoft certification.
SQL Server is among the fundamental database instruments that’s requested within the job market, and the power to having the ability to do DBA for SQL Server could possibly be very helpful on your present work, and your subsequent job hunt.
We’ll download and set up at no cost SQL Server Developer, which supplies you the entire capabilities of the full-cost Enterprise version (although with out having the ability to use it for business functions). We’ll begin by downloading an illustration database, and studying how one can backup and restore this database, and what restoration fashions are applicable for different databases, to allow you to supply Level in Time restoration.
We’ll handle logins and server roles, so you’ll be able to management who will get entry to what information, implement and keep indexes, so you’ll be able to pace up searches, and import and export information. We’ll take a look at managing SQL Server Agent, so you’ll be able to automate routine duties, and in addition be alerted to issues, we’ll handle and configure databases, and take a look at compression, each of which aids with administrating massive databases. And far more.
The course will take round 10 hours to finish, however finishing this may allow you to versed in Database Administration duties, providing you with hands-on expertise.
The course will increase in problem slowly, so that you’ll manually backup a database, however then later we’ll use SQL Server Agent to automate this. On this Half 1 course, we’ll solely do actions that require one laptop, as an alternative of a number of servers or virtualization.
The course is pretty relaxed – there will probably be just a few “wrong turns”, so you’ll be able to see what issues may come up, however each lesson works in direction of an finish aim at a comparatively sluggish tempo, so you’ll be able to observe by yourself laptop simply. I assume that you know the way to make use of a pc, together with putting in applications, however the precise DBA will probably be at a fundamental degree, and I’ll introduce each part as we go on.
No data of T-SQL is required, as I’ll display every little thing I can via the GUI (Graphical Person Interface) in addition to T-SQL. Nonetheless, if you’ll go for the official Microsoft examination, the equal data as per my first two programs in 70-461 T-SQL is important.
On the finish of the course, you’ll be able to download a certificates of completion, so you’ll be able to present everybody your new-found abilities, and proceed your preparations for the official Microsoft certifications.
The course is recorded on SQL Server 2017, however may even work totally in 2016, 2014 and 2012, and principally in 2008R2 and 2008.
Who this course is for:
- This course is for you if you need apply expertise in SQL Server Database Administration
- No prior expertise with T-SQL is required, though the extra data you’ve it, the higher.
- On this course we’ll cowl a number of points that are examined in Microsoft’s 70-462 examination “Administering Microsoft SQL Server”
- Though the examination particularly says “SQL Server 2012/2014”, all elements of this course are relevant for the 2016 and 2017 variations, and most within the 2008 and 2008R2 variations.
- This course shouldn’t be for you if you need superior coaching on Database Administration.
Created by Phillip Burton
Final up to date 10/2020
English, Italian [Auto], 2 extra
Measurement: 4.45 GB
The put up 70-462: SQL Server Database Administration (DBA) .
DISCLAIMER: No Copyright Infringement Supposed, All Rights Reserved to the Precise Proprietor. This content material has been shared beneath Academic Functions Solely. For Copyright Content material Removing Please Contact the Administrator or E mail at Getintocourse@gmail.com