Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 19 Minute(s)
Language
English
Taught by
Compaq learning
Rating
Course Overview
Learn how to build and use databases in SQL Server platform
Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 2012, a step higher into the administration of the data system. It is an excellent platform for students to build database systems, ensure effective operation of the systems apart from storing, and securing data from any kind of unauthorized access. The course intends to target all data professionals including data analysts and other aspiring professionals who wants to get ready for exam 70-462, also known as Administering Microsoft SQL Server 2012 Databases.
Towards the end of this course our participants will have a thorough knowledge on maintaining various databases including the instances, trouble shooting and optimizing apart from data management and contriving high availability and security.
This course is that is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence. The main idea of this course is to make our students cognize SQL Server 2012 databases administration. You will be comprehending a lot about the various issues and other decisions that are part of SQL Server installation and configuration.
Apart from this as a student you will keen to look into the various operations involved including backup and restore operations that can be performed. You will also find it both challenging and interesting to learn how databases and database files are moved. There will also be a discussion on some of the important topics namely, instance, database and object security strategies. Some of the high availability technologies will also be discussed as part of the training.
Our training is broken down to 115 lecture sessions that will cover all objectives. As add on, we are also providing demos on other major concepts so that participants understand how the steps learned are implemented in real time.
Course Content
- 10 section(s)
- 98 lecture(s)
- Section 1 SQL Server Tools and Installation
- Section 2 Managing the Database Server
- Section 3 Managing Databases
- Section 4 SQL Server Security
- Section 5 Advanced Security in SQL Server
- Section 6 Working with Indexes and Files
- Section 7 Maintaining Reliability of SQL Server Installations
- Section 8 Optimizing Servers
- Section 9 Troubleshooting Errors in SQL Server
- Section 10 Advanced Server Management
What You’ll Learn
- Store and manage data in SQL Server
- Elevate performance and troubleshoot problems
- Apply high availability
- Construct server security
- Connect and organize SQL Server
- Sustain instances and databases
Skills covered in this course
Reviews
-
KKamil Kamil
If you really want to know more about administering od SQL Server, then look for another course - this one very briefly touches some of the features. The tutor doesn't explain, what is he doing when covering examples (there were eamples, when he didnt say anything - just writing). Not to mention that these examples were pretty starightforward. He could also save way more time by preparing scripts and then explaining them to us. The tutor surely doesn't want to share his knowledge in a straight manner.
-
TTsholofelo Diphoko
I liked the course content, but half of the demos were blurry in the beginning so it was hard to follow along and say confidently I would know where to go in SQL server to perform these functions
-
JJordan Berman
I got some points out of this (how to use SSMS, basically), but at some points the demos didn't really explain that well what was going on. All that was repeated was the PowerPoint slides, and as I just recently learned the SQL syntax, it was sort of a jump to go from that to this. It's still good for what it's worth, but it could be better.
-
GGeorgi Georgiev
Until now, I am very satisfied with the way he presents the content. He points to the issue itself and explains the most important things. Very professional!
