Oracle SQL Foundation | Welcome to breEDU

Email: admin@breedu.com Call Us: 510.259.9696

Oracle SQL Foundation

Course Description

This course is aimed to help students learn how to work with SQL Server and build databases. SQL Server provides one of the strongest platforms that allows companies to run some of the most critical applications. Any form of database management will require SQL server foundations and knowledge. Some skills students will learn in this course include: installing, creating, and modifying structures, manage and back up databases.

Hours:

Please call for more details

Instructor:

Please call for more details

Who should attend
  • Anyone who needs to use SQL Server as a job requirement
  • Database administrators
  • Anyone with a computer science background
Course Content

I.

Installing SQL Server

  • Installation Options
  • Upgrades
  • Service Packs

Tools

  • SQL Server Management Studio
  • Transact – SQL
  • SQL Server Configuration Manager
  • Policy-based Management

II.

Storage Structures

  • Creating database and transaction logs
  • File Groups

Managing DB Space

  • Adding files
  • Database options
  • Disk structures

III.

Log-Ins

  • Authorizations
  • Changing server roles
  • Enforcing Passwords
  • Authentications

Database Access

  • Authorizations
  • Adding new users, defining new roles
  • Handling privileges
  • Mismapped logins

IV.

Granting Database-scoped Privileges

Schemas

  • Designing and assigning schemas

Handling Object-Level Permissions

  • Limiting object access
  • Meeting complex permission requirements
  • Examining hierarchies

V.

Backing up databases

  • Recovery Models
  • Transaction Logs
  • Backups
  • Reclaiming space

Restoring Dabatases

  • Recovery and testing

VI.

SQL Server Agent

  • Configuring the agent
  • Setting up database mail

Multistep jobs

  • Defining, creating, and associating jobs and alerts

VII.

Database Management

  • Fragmentation and database corruption
  • Database Maintenance Plan

VIII.

Monitoring SQL Server

  • Ad Hoc monitoring
  • Configuring data collection
  • Reviewing reports

IIX.

Hands on labs and projects

 



© Copyright 2014 breEDU.com. All rights reserved.

Bay Area Web Design by Verecom.com