Book a Free Demo

Need help?

+91-9441803173 info.svtechhub@gmail.com
Reviews (20)
Avatar

Chapter 1:

Planning and Installing SQL Server 2012

  • Planning Your Installation
  • Evaluating Installation Requirements
  • Designing the Installation
  • Planning Scale Up versus Scale out Basics
  • Shrinking and Growing Databases
  • Designing the Storage for New Databases
  • Remembering Capacity Constraints
  • Identifying a Standby Database for Reporting
  • Identifying Windows-Level Security and Service-Level Security
  • Performing a Core Mode Installation
  • Benchmarking a Server

Chapter 2:

Configuring and Managing SQL Server Instances

  • Configuring SQL Server Instances
  • Instance-Level Settings
  • Database Configuration and Standardization
  • Distributed Transaction Coordinator
  • Configuring Database Mail
  • Revision on chapter 1 and chapter 2
  • Q and A session

Chapter 3:

Configuring SQL Server 2012 Components

Lesson 1: Configuring Additional SQL Server Components

  • Deploying and Configuring Analysis Services
  • Deploying and Configuring Reporting Services
  • Deploying and Configuring SharePoint Integration
  • Configuring SQL Server Integration Services Security
  • Managing Full-Text Indexing
  • Configuring FILESTREAM
  • Configuring File Tables

Lesson 2: Managing and Configuring Databases

  • Designing and Managing File groups
  • Configuring and Standardizing Databases
  • Understanding Contained Databases
  • Using Data Compression
  • Encrypting Databases with Transparent Data Encryption
  • Partitioning Indexes and Tables
  • Managing Log Files
  • Using Database Console Commands

Chapter 4: Migrating, Importing, and Exporting

Lesson 1: Migrating to SQL Server 2012

  • Upgrading an Instance to SQL Server 2012
  • Migrating a Database to a SQL Server 2012 Instance
  • Copying Databases to Other Servers
  • Migrating SQL Logins

Lesson 2: Managing and Configuring Databases

  • Designing and Managing File groups
  • Lesson porting Data
  • Copying and Exporting Data
  • Using the SQL Server Import and Export Wizard
  • Using BCP to Import and Export Data
  • Importing Data by Using BULK INSERT
  • Importing Data by Using OPENROWSET (BULK)
  • Using Format Files
  • Preparing Data for Bulk Operations
  • SELECT INTO

Chapter 5: SQL Server Logins, Roles, and Users

Lesson 1: Managing Logins and Server Roles

  • SQL Logins
  • Server Roles
  • User-Defined Server Roles
  • Credentials

Lesson 2: Managing Users and Database Roles

  • Database Users
  • Database Roles
  • Contained Users
  • Least Privilege
  • Application Roles

Chapter 6: SQL Server Agent, Backup, and Restore

Lesson 1: Managing SQL Server Agent

  • Executing Jobs by Using SQL Server Agent
  • Managing Alerts
  • Managing Jobs
  • Monitoring Multi-Server Environments

Lesson 2: Configuring and Maintaining a Backup Strategy.

  • Understanding Backup Types
  • Backing up System Databases
  • Backing up Replicated Databases
  • Backing up Mirrored Databases
  • Backing up AlwaysOn Replicas
  • Using Database Checkpoints
  • Using Backup Devices
  • Backing Up Media Sets
  • Performing Backups
  • Viewing Backup History

Lesson 3: Restoring SQL Server Databases

  • Restoring Databases
  • Performing File Restores
  • Performing Page Restores
  • Restoring a Database Protected with Transparent Data
  • Encryption
  • Restoring System Databases
  • Restoring Replicated Databases
  • Checking Database Status

Chapter 7: Securing SQL Server 2012

Lesson 1: Managing Database Permissions

  • Understanding Securable
  • Assigning Permissions on Objects
  • Managing Permissions by Using Database Roles
  • Protecting Objects from Modification
  • Using Schemas
  • Determining Effective Permissions

Lesson 2: Troubleshooting SQL Server Security

  • Troubleshooting Authentication
  • Troubleshooting Certificates and Keys
  • Troubleshooting Endpoints
  • Using Security Catalog Views

Lesson 3: Auditing SQL Server Instances

  • Using SQL Server Audit
  • Configuring Login Auditing
  • Using c2 Audit Mode
  • Common Criteria Compliance
  • Policy-Based Management

Chapter 8:a) Mirroring, Replication

Lesson 1: Mirroring Databases

  • Database Mirroring
  • Mirroring Prerequisites
  • Configuring Mirroring with Windows Authentication
  • Configuring Mirroring with Certificate Authentication
  • Changing Operating Modes
  • Role Switching and Failover
  • Monitoring Mirrored Databases
  • Upgrading Mirrored Databases

Lesson 2: Database Replication

  • Replication Architecture
  • Replication Types
  • Snapshot Replication
  • Transactional Replication
  • Peer-to-Peer Transactional Replication
  • Merge Replication
  • Replication Monitor
  • Controlling Replication of Constraints, Columns, and Triggers
  • Heterogeneous Data

Chapter 8: b) Log shipping

Lesson 1: Transaction Log shipping

  • Log shipping Prerequisites
  • Benefits of Log shipping
  • Configuring Log shipping between two servers
  • Troubleshooting Log shipping issues

Chapter 9: Clustering and Always On

Lesson 1: Clustering SQL Server 2012

  • Fulfilling Edition Prerequisites
  • Creating a Windows Server 2008 R2 Failover Cluster
  • Installing a SQL Server Failover Cluster
  • Multi-Subnet Failover Clustering
  • Performing Manual Failover
  • Troubleshooting Failover Clusters

Lesson 2: AlwaysOn Availability Groups

  • What Are AlwaysOn Availability Groups?
  • Meeting Availability Group Prerequisites
  • Configuring Availability Modes
  • Selecting Failover Modes
  • Configuring Readable Secondary Replicas
  • Deploying AlwaysOn Availability Groups
  • Using Availability Groups on Failover Cluster Instances

Chapter 10: Troubleshooting SQL Server 2012

Lesson 1: Working with Performance Monitor

  • Getting Started with Performance Monitor
  • Capturing Performance Monitor Data
  • Creating Data Collector Sets

Lesson 2: Working with SQL Server Profiler

  • Capturing Activity with SQL Server Profiler
  • Understanding SQL Trace
  • Reviewing Trace Output
  • Capturing Activity with Extended Events Profiler

Lesson 3: Monitoring SQL Server.

  • Monitoring Activity
  • Working with Activity Monitor

Lesson 4: Using the Data Collector Tool.

  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Lesson 5: Identifying Bottlenecks

  • Monitoring Disk Usage
  • Monitoring Memory Usage
  • Monitoring CPU Usage

Chapter 11: Indexes and Concurrency

Lesson 1: Implementing and Maintaining Indexes

  • Understanding the Anatomy of a Balanced Tree (B-Tree)
  • Understanding Index Types and Structures
  • Designing Indexes for Efficient Retrieval
  • Understanding Statistics
  • Creating and Modifying Indexes
  • Tracking Missing Indexes
  • Reviewing Unused Indexes

Lesson 2: Identifying and Resolving Concurrency Problems

  • Defining Transactions and Transaction Scope
  • Understanding SQL Server Lock Management
  • Using AlwaysOn Replicas to Improve Concurrency
  • Detecting and Correcting Deadlocks
  • Using Activity Monitor
  • Diagnosing Bottlenecks
  • Using Reports for Performance Analysis

Introduction to SQL

  • What is SQL?
  • What Can SQL do?
  • RDBMS

SQL Syntax

  • Database Tables
  • SQL Statements
  • Overview of Most Important SQL Commands
  • SELECT
  • UPDATE
  • DELETE
  • INSERT
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • CREATE INDEX
  • DROP INDEX

SQL SELECT Statement

  • SELECT syntax
  • Demo Database
  • SELECT Column Example
  • SELECT * Example

SQL Distinct

  • SELECT DISTINCT Statement
  • SELECT DISTINCT Syntax
  • SELECT DISTINCT Example

SQL WHERE Clause

  • WHERE Clause
  • WHERE Clause Example
  • Operators in the WHERE Clause

SQL AND & OR Operators

  • AND Operator Example
  • OR Operator Example
  • Combining AND & OR

SQL ORDER BY

  • ORDER BY Syntax
  • ORDER BY Example
  • ORDER BY DESC Example
  • ORDER BY Several Column Examples

SQL Insert Into

  • INSERT INTO Syntax
  • INSERT INTO Examples
  • Insert Data into Specified Columns

SQL UPDATE

  • UPDATE Syntax
  • UPDATE Example
  • Watch out UPDATE statement.

SQL DELETE

  • DELETE Syntax
  • DELETE Examples
  • Delete All the Data

SQL Aliases

  • SQL Alias Syntax for Columns
  • Alias Example for Table Columns
  • Alias Example for Tables.

SQL Joins

  • Different SQL JOINs
  • INNER JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN

SQL UNION

  • UNION Syntax
  • UNION Example
  • UNION ALL Syntax
  • UNION ALL Example

SQL Insert Into Select

  • INSERT INTO SELECT Syntax
  • INSERT INTO SELECT Examples

SQL Create Table

  • CREATE TABLE Syntax
  • CREATE TABLE Example

SQL Constraints

  • CREATE TABLE + CONSTRAINT Syntax
  • NOT NULL Constraint
  • UNIQUE Constraint
  • UNIQUE Constraint on CREATE TABLE
  • UNIQUE Constraint on ALTER TABLE
  • To DROP a UNIQUE Constraint
  • PRIMARY KEY Constraint
  • PRIMARY KEY Constraint on CREATE TABLE
  • PRIMARY KEY Constraint on ALTER TABLE
  • To DROP a PRIMARY KEY Constraint
  • FOREIGN KEY Constraint
  • FOREIGN KEY Constraint on CREATE TABLE
  • FOREIGN KEY Constraint on ALTER TABLE
  • To DROP a FOREIGN KEY Constraint
  • CHECK Constraint
  • CHECK Constraint on CREATE TABLE
  • CHECK Constraint on ALTER TABLE
  • To DROP a CHECK Constraint
  • DEFAULT Constraint on CREATE TABLE
  • DEFAULT Constraint on ALTER TABLE
  • To DROP a DEFAULT Constraint

SQL Create Index

  • CREATE INDEX Syntax
  • CREATE UNIQUE INDEX Syntax
  • CREATE INDEX Example

SQL DROP Command

  • The DROP INDEX Statement
  • The DROP TABLE Statement
  • The DROP DATABASE Statement
  • The TRUNCATE TABLE Statement

SQL ALTER Command

  • The ALTER TABLE Statement
  • ALTER TABLE Example
  • Change Data Type Example
  • DROP COLUMN Example

SQL VIEWS

  • CREATE VIEW Statement
  • CREATE VIEW Syntax
  • CREATE VIEW Examples
  • CREATE OR REPLACE VIEW Syntax
  • Dropping a View

SQL NULL Values

  • Working with NULL Values
  • IS NULL
  • IS NOT NULL

SQL NULL Functions

  • NVL()
  • COALESCE()

Reviews

5
60% Complete
60% Complete
60% Complete
60% Complete
60% Complete

Santosh
SV Tech Hub is best place to learn and take low price when compared with other institutes. Excellent course content, faculties are really knowledgeable and 24x7 support system is good. Anyone can join this institute, without a second thought. Overall great experience.

Mahesh Reddy
I did MS SQL Server training from SV Tech Hub. It is good for beginners. They have provided pre-recorded sessions of previous batches which gives opportunities for learners to listen classes when they have doubts. Suggest everyone to experience it at least once. Thanks to everyone in SV Tech Hub team for offering industry oriented training to have great career.

Vikram Patra
It was great experience to get trained from SV Tech Hub. The faculty has great hold on subject, who came with industry experience. Quality of training, training material, project, assignments etc are top notch. Thank you.