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.
Audience
This course is designed for those who are responsible for administering SQL Server.
Prerequisites
Before attending this course, students must have:
An understanding of relational database concepts
Experience of querying database tables
Experience using SQL Server Management Studio
Course Objectives
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.
7 Top Takeaways From The Course
Improve database design
Improve query performance
Improve database resilience with a backup policy
Secure data stores by restricting user access
Access remote data stores
Integrate diverse data stores to a single repository
Reduce infrastructure costs by storing data in the cloud
Course Content
Module 1: 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
Module 2: Installing SQL Server
Preparing for Installation
Upgrading an Earlier Version
Installing SQL Server
Configuring the Server
Module 3: Working with SQL Server Management Studio
Getting Started with SSMS
Exploring the Object Explorer
Working with the Query Editor
Using SQL Server Books Online
Module 4: Designing a Database
Defining Entities
Applying Normalisation
Database Objects
System Tables
Defining Databases
Setting Database Options
Managing Data and Log File Growth
Module 5: Implementing Tables
Creating Tables
Setting Column Data Types
Adding and Dropping a Column
Generating Column Values
Adding Constraints
Using the Identity Property
Module 6: Backup and Recover a Database
Database Recovery Models
Backing Up Transactions Logs and Databases
Backing Up in Management Studio
Restoring in Management Studio
Module 7: Design and Administer Security Levels
Designing security plan
Administering server and database authentication
Administering database authorization
Administering database permissions
Administering users, groups and roles
Module 8: 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
Module 9: Managing Transactions and Locks
Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks
Module 10: 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
Module 11: 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
Module 12: Automating Administrative Tasks
Using SQL Server Agent
Creating and scheduling job
Maintenance Plans
SQL Management Objects (SMO)
Module 13: Programming Replication
Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication
Synchronizing Data
Module 14: Using Integration Services
Importing and Exporting Data
Integration Services Tools
Building a Package
Troubleshooting a Package
Module 15: 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
Module 16: 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
Module 17: Azure SQL Database Admin Features
Security
Advanced Threat Protection
Auditing
Dynamic Data Masking
Elastic Pools
Monitoring
Tuning
An Introduction To Verhoef
For over 30 years Verhoef Training has been delivering quality ‘Technical Training for IT Professionals’ throughout the world. Our UK training centre was established in the World Heritage City of Bath in 1993.
From there we deliver training throughout the UK, Europe and the Middle East. We have a range of over two hundred classes for IT professionals from all disciplines.
We Support
Operating Systems: IBM z/OS, IBM i, UNIX and Linux, Fujitsu VME and Windows.
Middleware: WebSphere AS, MQ, App Connect Enterprise and Cloud Technologies.
Databases: DB2, Oracle, SQL Server, MySQL, NoSQL and Business Intelligence.
Development Lifecycle: Analysis and Design, Agile, Programming and Testing.
Programming Languages: Java, Visual Studio, Web Development, Mobile Development, System z and more.
Project and Programme Management: PRINCE2, MSP and MS Project.
Audit and Security: Both Practice and Technology.
Our Services
A public schedule and one-company options in Bath or on-site.
Equipment hire, including server and clients with all software installed.
Instructor led courses delivered over the Internet.
Training Needs Analysis (TNA) and bespoke course development
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another compu...
Database designers and developers are now being considered the key part of the IT infrastructure of any organization.
This excellent SQL Queries course familiarises you with the most essential and daily used statement of SQL..
SQL (Structured Query Language) is the most extensively used database global language, and a wide range of database systems adopts it to create queries and manipulate data.
This is a database specialist package designed to give you enhanced knowledge and understanding of the various softwares and applications for database management.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy