SQL Server Core Administration Skills
(SQLLSEC, Live Instructor-Led Training, 4 days)


Description

This SETC Certified database course introduces the SQL Server relational database management system. Every aspect of SQL Server database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the SQL Server database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a SQL Server database in your organization, this is the course for you.

Dates and Pricing


Jan 9 to Jan 12, 2018$2,500/person Feb 6 to Feb 9, 2018$2,500/person Mar 6 to Mar 9, 2018$2,500/person

Outline

Application Architecture
The Application Tiers: 1, 2 and 3-Tiered Applications
Distributed Applications: Technology and Infrastructure
Web Applications: Technology and Infrastructure.
SQL Server Features and Services
Database Essentials
The Relational Database Management System: SQL Server
Creating Tables
Schemas
Implementing Database Integrity
Domain Integrity
Entity Integrity: Primary Keys
Referential Integrity: Foreign Keys
Retrieving Table and Constraint Information
Manipulating Data
The Basic SELECT Statement
Retrieving Aggregate Values
Modifying Data
Selecting From Multiple Tables
Sub-Queries
Implementing Views
TSQL Programming
Declaring and Using Variables
String Functions
Using the XML Data Type
Using XQuery
DateTime Functions
SQL Server NULL Value Functions
Implementing Error Handling
Creating Functions
Stored Procedures
Triggers
Indexes
Index Architecture
Planning Indexes
Managing Table Data
Rebuilding Indexes
Creating Full Text Indexes
Jobs and Alerts
Scheduling and Using Jobs Tasks
Using Job Operators
Creating Jobs and Tasks Using Management Studio
Server Security
Authorization and Authentication
SQL Server Security
Creating Logins
Creating Users
Assigning Permissions
Backup and Recovery
SQL Server Logging
Performing Database Backups
Recovery
A Complete System Administration Lab for SQL Server