Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: SQL Server Tools and Installation|
SQL Server Tools and InstallationMy First LecturePreview
SQL Server 2012 Components and Their UsesPreview
Planning SQL Server InstallationPreview
Installing SQL Server 2012
Demo - Installing SQL Server 2012
Demo - Exploring the Installed Components
|Section 2: Managing the Database Server|
Managing the Database Server
Server Properties and sp configure
Demo - Viewing Server Properties and Using sp configure
Demo - Enabling Advanced Options, and Viewing and Modifying Them
CPU and Memory Architectures
Demo - Working with CPU Affinity and Memory Configurations
Configuring Database Mail
Demo - Set up Database Mail
|Section 3: Managing Databases|
Types of Databases
Demo - Creating User and Contained Databases
Demo-Looking at Auto Close and Auto Shrink and Checking Disk Space of a Database
Demo - Moving between File Groups
|Section 4: SQL Server Security|
SQL Server Security
Security Model and Types of Accounts in SQL Server
Demo - Using Accounts in SQL Server
Demo - Managing Server Roles
Demo - Using GRANT and DENY
Database Roles and Permissions
Demo - Using Database Roles
|Section 5: Advanced Security in SQL Server|
Advanced Security in SQL Server
Working with Digital Certificates
Private and Public Keys
Certificate Based Logins
Demo - Creating Certificate Based Logins
Auditing and Policies
Demo - Creating and Viewing Audits
Policy Based Management
Demo - Setting up Policy Based Management
Encryption and Compression
Demo - Using TDE and Compression
|Section 6: Working with Indexes and Files|
Working with Indexes and Files
Introduction to Full Text Indexing
Column Store Index
|Section 7: Maintaining Reliability of SQL Server Installations|
Maintaining Reliability of SQL Server Installations
Detaching and Attaching Databases
Detach and Attach a Database_Demo
Database Backup and Restoration
|Section 8: Optimizing Servers|
Benchmarking Server Performance
DMVs and SQL Profiler
|Section 9: Troubleshooting Errors in SQL Server|
Troubleshooting Errors in SQL Server
SQL Server Errors and Handling Issues
With a clear motto to upgrade the skills of students from high school goers to professionals, Compaq learning started its tutoring journey in 2013. But within two years, an effort by three IT professionals that started as a blog went on to become one of the largest course developing company in the e learning industry.
We kick started our stint in the e-learning world by mentoring high school students. The passion for teaching and mentoring students gave us the confidence and courage to plunge into the e learning industry and provide various guidance for high school students to IT professionals. Until now we have trained around 15,000 students in various subjects ranging from simple mathematics to android app development. We have a group of fine instructional designers, graphic designers and SMEs who ensure that our products are original and valuable.