SQL Server Training

28/12/2014 Professional & Short Term Course

Price: Check with seller

Description









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