YOUR CART
- No products in the cart.
Subtotal:
€0
Overview
This course takes you through installing, creating and maintaining Microsoft SQL Server.
No prior knowledge is required, but some database knowledge would be beneficial
Course Objectives
You will learn the foundations and become proficient in Microsoft SQL Server. You will be
able to create, manage and maintain databases, and the SQL Server environment.
Content
Introduction
- Overview of Microsoft SQL Server
- Data Platform Components
- Cross-Box Scale Limits
Installation
- The Upgrade Advisor
- System Requirements and
- Prerequisites
- Installation
- Verifying the Installation
Management Tools
- SQL Server Management Studio
- Registering Additional Servers
- Using the Object Explorer
- Using the Query Editor
Creating Databases
- Introduction to Database
- The Transaction Log
- Database Options
- Modifying Databases
- Database Snapshots
Database Objects
- Tables, Stored Procedures, Views
- Database Diagrams
- Datatypes
- Indexes, Locks
- Triggers
Securing SQL Server
- Authentication
- Creating Login Accounts
- Users and Roles
- Fixed Roles
- Securing Database Objects
- Permissions
- Managing Application Security
Backing up Databases
- Preventing Data Loss
- SQL Server Backup
- Performance Considerations
- Restoring Databases
Automating Administrative Tasks
- Introduction to Automation
- Writing Events to the Log
- Automating Routine Tasks
- Creating Jobs
- Creating Alerts
- Assigning a Fail-Safe Operator
- Automating Multiserver Jobs
Performance Monitoring and Tuning
- Why Monitor SQL Server
- Factors that Affect Performance
- Tools for Monitoring SQL Server
- Common Monitoring Tasks
You will learn how to
- Create and manage a document file structure.
- SQL Server Overview
- Installing and configuring SQL Server
- Configuring SQL Server Agent and SQL
- Working with SQL Server Management Studio
- Managing Security
- Managing Permissions
- Managing Application Security
- Implementing permissions
- Managing Database files
- Viewing and changing database options using Transact SQL
- Backing up databases
- Performing differential backup
- Restoring databases
- Creating jobs and operators
- Using SQL Mail
- Creating alerts
- Assigning a fail-safe operator
- Transferring Data
- Importing data from a query
- Monitoring SQL Server
Audience
If you work with or want to work
with Microsoft SQL Server, this
course is ideal for you.
Classroom and Virtual training
options
Duration
3 Days
More Courses...
Contact us...
Relevant, industry-focused learning and development
Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.
