course overview
Overview
This instructor-led course provides students who manage SQL Server and Azure SQL databases with the knowledge and skills needed to administer a SQL server database infrastructure. The material will also be useful to individuals who develop applications that deliver content from SQL Server databases.
Virtual Learning
This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.
Audience
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
Skills Gained
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Prerequisites
Course M55315, Introduction to SQL Databases would give you a solid introduction for this course.
Outline
100s of Microsoft Training Courses
Microsoft is one of the largest and most renowned companies in the computing world. They are responsible for designing, developing, manufacturing and licensing an ever-increasing array of different software products. The two most notable ones are the Windows operating system and the Office suite of applications. In addition they provide comprehensive support for all users, ensuring they can use their products effectively.
Whatever your area of interest, whether it is system architecture, development, administration, web applications, communications, networking, project management, security or design, there is Microsoft software you can utilise. The products are high quality and reliable. In addition they also receive regular updates to improve features, performance and security.
CourseMonster understand the value Microsoft software can offer. That is why we encourage businesses to make use of it. To help them with this we offer over a directory of 500 different Microsoft training courses. Each of them is organised, detailed, and will help learners to build their skills. We have fantastic customer satisfaction rates and ensure that every learner receives the support they need.
We are able to provide either public or customised training, adapting to suit the specific needs of each business. Whether it is a large class or a smaller group, we will ensure they are trained to a very high standard.
Over the years we have provided Microsoft training courses for respected companies from a wide array of different industries. We can cater for each of their needs and build long lasting relationships because they know we are a reliable training provider.
We hold training dates spanning:
Whether your interest is in architecture, development, system administration, web applications, design, communications, security, networking, project management, or business applications, with over 500 Microsoft training courses in our directory you will can quickly find the training you need on CM Training.
Contact us to get more information the vast array of Microsoft certification and training available through CM training.
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.
All $ prices are in USD unless it’s a NZ or AU date
SPVC = Self Paced Virtual Class
LVC = Live Virtual Class
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.
