PITSC

Pakistan I.T Institutes and Skills Center

Database Management Essentials

Dbase Experts

  • Home
  • Database Management Essentials
thumbnail
thumbnail
feature icon
Database Management Essentials

In This 2 Months Certificate, Microsoft SQL Server is a powerful, enterprise class database platform that is designed to store and retrieve all types of data quickly and efficiently. It includes tools that allow for the rapid development of SQL program code, enterprise server administration and powerful, data-driven reports. Microsoft SQL Server is the backbone for thousands of industry leading software applications including Microsoft SharePoint and SAP. You will learn how to design, develop, administer and troubleshoot Microsoft SQL databases and servers.

Contact Now
  • Audience
  • Minimum requirement of formal education is Matric or Intermediate

    People looking for career in database Administration

    Want to learn about management, back up and availability of data produced and utilized by organizations

  • Certificate
  • On successful completion of the Course Participants will be awarded a Participation Certificate from PITSC (Pakistan I.T Institutes and Skills Center)

    All Students of PITSC (Pakistan I.T Institutes and Skills Center) can apply for MCSA SQL 2016 Database Administrator Exams.

Course Information

Classes: 8 Weeks, With 3 classes of 3 hours in a week

feature icon

Course Outlines:

  • Fundamentals of databases (Applications / Tools)
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Plan SQL Server Installation
  • Install SQL Server and Post-Installation Configuration
  • Introduction to Data Storage with SQL Server
  • Manage Storage for System Databases and User Databases
  • Move Database Files
  • Configure the Buffer Pool Extension
  • Plan and Implement a Backup Strategy
  • Restore SQL Server Databases
  • Import and Export Data
  • Monitor SQL Server , Tracing SQL Server Activity, Manage SQL Server Security
  • Audit Data Access and Encrypt Data
  • Perform Ongoing Database Maintenance
  • Automate SQL Server Management
  • Monitor SQL Server Using Alerts and Notifications