Course Image
Top Ranked

Database Administrator

Learn how to you can get into database administrator profession with JUSTWIN IT SOLUTIONS. Our database administrator course provides students with the skills and training required to succeed in today’s rapidly growing big data market.The program includes Oracle Workforce Development courses that are necessary to become an Oracle Certified Professional. Since a DBA is generally expected to have experience with one or more of the major database management products, our DBA program provides you with SQL training (Structured Query Language) as well as Oracle based database management software.
Success Rate 100%
Job Placements96%
Professional Growth89%
Live Projects75%

Course Overview

Top ↑

Learn how to you can get into database administrator profession with JUSTWIN IT SOLUTIONS. Our database administrator course provides students with the skills and training required to succeed in today’s rapidly growing big data market.

Course Content

Top ↑

Course Name: Database Administrator
Course Code: DA001
Course Duration: 38 hours
Course Type: Classroom

Section 1
  • Introduction to SQL Server 2014 Database Administration
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
Section 2
  • Installing and Configuring SQL Server 2014
  • Plan SQL Server Installation
  • Install SQL Server 2014 and Post-Installation Configuration
Section 3
  • Work with Databases and Storage
  • Introduction to Data Storage with SQL Server
  • Manage Storage for System Databases and User Databases
  • Move Database Files
  • Configure the Buffer Pool Extension
Section 4
  • Plan and Implement a Backup Strategy
  • SQL Server Recovery Models
  • Plan a Backup Strategy
  • Backup Databases and Transaction Logs
  • Backup Options and Backup Reliability
Section 5
  • Restore SQL Server 2014 Databases
  • Restore Process and Databases Restoration
  • Advanced Restore Scenarios
  • Point-in-Tim Recovery
Section 6
  • Import and Export Data
  • Transferring Data
  • Import and Export Table Data
  • Copy or Move a Database
Section 7
  • Monitor SQL Server 2014
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
Section 8
  • Manage SQL Server Security
  • Introduction to SQL Server Security
  • Manage Server-Level Security and Database-Level Principals
  • Manage Database Permissions
Section 9
  • Audit Data Access and Encrypt Data
  • Audit Data Access in SQL Server
  • Implement SQL Server Audit
  • Encrypt Databases
Section 10
  • Perform Ongoing Database Maintenance
  • Ensure Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance

Who should Attend?

Top ↑

  • Database professionals who administer and maintain SQL Server databases including database maintenance
  • Database professionals who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from SQL Server databases
  • People looking for a professional career with strong growth potential.
  • Individuals with a strong interest in information technology.
  • IT Professionals looking to expand their knowledge.

Learning Outcome

Top ↑

Graduates of this program are able to develop integrated database and business intelligence technologies to industry standards for scalable and secure Information Technology solutions. You will be learning:

  • Core database administration tasks and tools
  • Install and configure SQL Server 2014
  • Configure SQL Server databases and storage
  • Plan and implement a backup strategy
  • Restore databases from backups
  • Import and export data
  • Monitor SQL Server
  • Trace SQL Server activity
  • Manage SQL Server security
  • Audit data access and encrypt data
  • Perform ongoing database maintenance
  • Automate SQL Server maintenance with SQL Server Agent jobs
  • Configure database mail, alerts, and notifications

Schedule

Top ↑

Please look for the next dates in the schedule below:

Modules Start Date Location
 Database Administrator October 6th;2018  Brampton
 Database Administrator(next Batch) November 10th;2018  Brampton