Course Description
MS SQL Server is a world-class Relational Database Information System platform widely used by small to medium sized companies across the world. Preston IT’s SQL Server database administration course will provide an introduction to this platform and related tools, basic to advanced skill sets training to enhance your desirability in the job market.
SQL Server Course Outline
- • Database Introduction
- • Installation and Configuration of MS SQL Server 2019
- • Administration and Development tools
- • MS SQL Server 2019 Architecture
- • Database Creation
- • Database objects
- • Transact SQL (TSQL)
• SQL Server Backup and Recovery - • SQL Server Agent
- • SQL Server Data Export and Import (Data Movement)
- • SQL Server Security
- • Performance Tuning
- • SQL Server High Availability
- • SQL Server Replication
- • PROJECTS (Patching a SQL Server, SQL Server Migration, Upgrades, In place parallel migration)
