SQL Server Training

28/12/2014 Professional & Short Term Course

Price: Check with seller

Sponsored Ads


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:7
Reference Id:#541127
Current Rating: /5 0 Vote


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