Course description
Microsoft SQL Server Administration
This intensive course is aimed at getting students familiar with SQL Server administration skills and tools. Improving database and server performance will be covered. Along with administering databases in the Azure cloud. This will include implementing a database security model. The course will contain the new features in the latest version of SQL Server. This course can be customised for other versions of SQL Server.
Suitability - Who should attend?
Before attending this course, students must have:
- An understanding of relational database concepts
- Experience of querying database tables
- Experience using SQL Server Management Studio
Who’s it for?
This course is designed for those who are responsible for administering SQL Server.
Outcome / Qualification etc.
- Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.
- Course Completion Certificate will be awarded on successful completion of the course.
Training Course Content
SQL Server Overview
- The Role of Database Providers
- Client Side and Server Side Components
- SQL Server Architecture
- SQL Server Developer Tools
- SQL Server Sample Databases
Installing SQL Server
- Preparing for Installation
- Upgrading an Earlier Version
- Installing SQL Server
- Configuring the Server
Working with SQL Server Management Studio
- Getting Started with SSMS
- Exploring the Object Explorer
- Working with the Query Editor
- Using SQL Server Books Online
Designing a Database
- Defining Entities
- Applying Normalisation
- Database Objects
- System Tables
- Defining Databases
- Setting Database Options
- Managing Data and Log File Growth
Implementing Tables
- Creating Tables
- Setting Column Data Types
- Adding and Dropping a Column
- Generating Column Values
- Adding Constraints
- Using the Identity Property
Backup and Recover a Database
- Database Recovery Models
- Backing Up Transactions Logs and Databases
- Backing Up in Management Studio
- Restoring in Management Studio
Design and Administer Security Levels
- Designing security plan
- Administering server and database authentication
- Administering database authorization
- Administering database permissions
- Administering users, groups and roles
Indexing Tables
- Introduction to Indexes
- Index Architecture
- How SQL Server Retrieves Stored Data
- How SQL Server Maintains Index and Heap Structures
- Deciding Which Columns to Index
Managing Transactions and Locks
- Introduction to Transactions and Locks
- Managing Transactions
- SQL Server Locking
- Managing Locks
Accessing Linked Servers
- Introduction to Distributed Queries
- Executing an Ad Hoc Query on a Remote Data Source
- Setting up a Linked Server Environment
- Executing a Query on a Linked Server
- Executing a Stored Procedure on a Linked Server
- Managing Distributed Transactions
- Modifying Data on a Linked Server
- Using Partitioned Views
Monitoring and Tuning
- SQL Servers inbuilt monitoring tools
- Use SQL Profiler to monitor a database
- Describe how the Index Tuning Wizard works and when to use it
- Define database partitioning
Automating Administrative Tasks
- Using SQL Server Agent
- Creating and scheduling job
- Maintenance Plans
- SQL Management Objects (SMO)
Programming Replication
- Overview of SQL Server Replication
- Replication Programming Interfaces
- Configuring Replication
- Synchronizing Data
Using Integration Services
- Importing and Exporting Data
- Integration Services Tools
- Building a Package
- Troubleshooting a Package
New Features in SQL Server
- Always Encrypted
- Stretch Database
- Real-time Operational Analytics
- PolyBase into SQL Server
- Native JSON Support
- Enhancements to AlwaysOn
- Enhanced In-Memory OLTP
Working with Azure SQL Databases
- Creating an Azure SQL Database
- Connecting to an Azure SQL Server
- Exporting data from an on-premises database
- Querying an Azure SQL Database
Azure SQL Database Admin Features
- Security
- Advanced Threat Protection
- Auditing
- Dynamic Data Masking
- Elastic Pools
- Monitoring
- Tuning
Why choose Acudemy Training
100% certified & specialised trainers delivering face-to-face, webinars and on-site courses
5 locations where courses are being delivered, with a concentration on Central London
More than 90% of satisfied individuals and organisations (2000+ students trained so far)
Expenses
Are any Financial Options Provided?
- 0% Interest Free payments available.
Request info
ACUDEMY - MAKING LEARNING SIMPLE
ACUDEMY is a Global training provider of bespoke and accredited courses. Reskill or Upskill for the modern workplace. Outdated competency frameworks are a thing of the past. Upskill or Reskill with popular leading programmes that are focused on Outcome rather...