SQL Server Training

28/12/2014 Professional & Short Term Course

Price: Check with seller


Introducing SQL Server

  • Overview of the SQL Server suite of products

  • Fundamentals of the relational database engine

  • SQL Server Agent, BIDS and Management Studio

  • Overview of SQL Server services


Building the Database

  • Constructing a relational database

  • Choosing optimal file size and growth parameters

  • Working with database schemas

  • Defining tables

  • Specifying appropriate data types

  • Indexing tables with Management studio

  • Adding, modifying or removing columns

  • Safeguarding data with constraints

  • Enforcing uniqueness through primary key constraints

  • Validating conditions with check constraints

  • Protecting relationships with foreign keys


Leveraging Server Programmability

  • Retrieving data with Transact-SQL

  • Employing Query Designer to construct select statements

  • Inserting new rows into tables

  • Updating targeted data

  • Deleting specific rows

  • Creating stored procedures for productivity

  • Writing user-defined functions to simplify queries

  • Deploying triggers to capture change events


Administering SQL Server Databases

  • Executing the Maintenance Plan Wizard

  • Defragmenting data and checking database integrity

  • Improving performance by rebuilding indexes

  • Automating administrative tasks

  • Scheduling repeating jobs

  • Implementing a backup strategy

  • Monitoring SQL Server resources

  • Displaying current activity and expensive queries

  • Running reports with Management Studio

  • Securing the database infrastructure

  • Authenticating SQL Server and Windows logins

  • Assigning users to database and server roles

  • Granting or revoking permissions

  • Comparing authentication modes

  • Defining logins

  • Creating user-defined server roles

  • Enforcing password policy

  • Granting database access

  • Contrasting users and logins

  • Defining new roles

  • Delegating privileges with predefined roles

  • Repairing mismapped logins


Setting up SQL Server

  • Selecting installation options

  • Installing a named instance

  • Leveraging essential tools

  • SQL Server Management Studio

  • Configuration Manager

  • Transact-SQL

  • sqlcmd

  • Dedicated Administrator Connection


Constructing and Managing Databases

  • Inspecting storage structures

  • Relating servers, databases and files

  • Creating databases and transaction logs

  • Designing file groups

  • Maximizing storage utilization

  • Placing tables on file groups

  • Upgrading and moving databases

  • Choosing between upgrade and migration

  • Detaching and attaching databases

  • Controlling database space

  • Permitting automatic database growth

  • Adding database files to expand databases


Handling Server and Database Security Granting and Revoking Permissions

  • Managing database-scoped privileges

  • Permitting object creation

  • Giving blanket permissions

  • Defining object-level permissions

  • Limiting object access

  • Meeting complex permission requirements with roles


Backup and Recovery

  • Backing up databases

  • Selecting a recovery model

  • Investigating the transaction log

  • Running full, log and differential backups

  • Restoring databases

  • Performing a post-crash log backup

  • Recovering user and system databases


Streamlining Tasks with Jobs, Alerts and Database Mail

  • Configuring SQL Server Agent

  • Setting agent properties

  • Implementing database mail

  • Defining jobs to handle routine tasks

  • Creating alerts and operators

  • Initiating multi-step jobs

  • Associating alerts with jobs


Database Maintenance and Monitoring

  • Handling fragmentation and database corruption

  • Identifying and curing fragmentation

  • Repairing database corruption

  • Building database maintenance plans

  • Scheduling plan execution

  • Notifying operators of success or failure

  • Resolving contention problems

  • Identifying blocked processes

  • Killing blockers

More Details

Total Views:8
Reference Id:#541127
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com