Developing, Testing & Experimenting

Data is more than just your job. You live and breathe data. And, mostly, that’s a good thing. Why?...

$1.00

Sunil Biswas

Categories: DEVELOPMENT
31 Students Enrolled

0
Mar 12, 2019

OVERVIEW
CURRICULUM
FEATURED REVIEW (0)

Limitless Learning, Limitless Possibilities

In this module, you will learn how to quickly installing MSSQL Server for a test environment:

You will download the free edition of SQL Server
You will use the SQL Server installation wizard
Basic SQL Server configuration
Will be using SQL Server Configuration Manager
You will install SQL Server Management Studio
In the end, you will install a Sample Database

Microsoft SQL Server has also expanded the number of opportunities to tune database operations automatically, along with tools and reports to allow monitoring and optimization of queries and workloads. Comprehensive diagnostic features including Query Store allow SQL Server to identify performance issues quickly from the Test environment, you will learn the benefit of setting up a Pre-Production Server to push or deploy code for final testing before implementing to Production.

During the training session you will learn..

Transparent Data Encryption(TDE)
Performance monitoring, troubleshooting and tuning
Replication, Log-shipping, Mirroring, Windows Failover Clustering, Always on High Availability
SQL Server Reporting Services
SQL Server Integration Services
Microsoft Power BI
Visual Studio/Data Tools
T-SQL
Upgrade/Migration
Assisting for Microsoft Certification Exam

In the end, you will learn the Do’s and Don’t in a Production environment of MSSQL Server.