SQL Server Training

Sponsored Ads

Price: Check with seller

Introducing SQL ServerOverview of the SQL Server suite of productsFundamentals of the relational database engineSQL Serv...

  • Category: Professional & Short Term Course
  • Published: 28/12/2014
  • Current Rating: /5 0 Vote


    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

    Related Ads

    Leave your comment

    Copyright © 2016 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us: query[at]tuffclassified.com