Administration

• Overview of SQL Server
• Installing MS SQL Server
• Understanding SQL Server Services
• Database Architecture
• System and Database Catalogs
• Creating/Configuring User Databases
• In-Memory OLTP (In Memory Optimization)
• Importing and Exporting Data
• Backup/Restoration Strategy
• Working with Database Snapshots
• Managing SQL Server Security
• Data Partitioning
• Automating Administrative Tasks
• Monitoring SQL Server Activities
• Maintaining High Availability
• Using SQL Server Replication
• Applying RAID Technology
• Policy Base management
• Data Storage and Compression
• Resource Governor

Design

• Database Logical Modeling
• Database Physical Modeling
• Creating and Maintaining Tables
• Implementing Data Integrity
• Accessing Data
• Creating and Maintaining Indexes
• Column store indexes
• Creating Database Objects
• Modifying Data
• Importing and Exporting Data
• Using XML in SQL Server
• Locking in Multi User Applications
• Developing a Security Plan
• Transparent Data Encryption
• Using DML/DDL Triggers
• Event Notification
• Views
• Stored Procedures
• New DataTypes
• FILESTREAM
• File Table
• Change Tracking
• Change Data Capture
• Table-Valued Parameters
• Development GIS in SQL server
• Full Text Search
• Semantic search