
Developing, Testing & Experimenting
Data is more than just your job. You live and breathe data. And, mostly, that’s a good thing. Why?...
- 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
About This Course
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.
Developing, Testing & Experimenting
-
Learning the Process of setting up a Testing Environment, Pre-Prod environment, and Production environment