Professional Training On M/s Sql Server Dba

25,000
   Pimpri- Chinchwad, Maharashtra
25,000
Wish List  Add to wishlist    |     Write a review    |     Report

Dear User,


Thanks for notify us about Ad ID : 269254.


Our team will review and take appropriate action in next 24 hours. We look forward for your continuous support.


Thanks & Regards
Zamroo Team

×
SUMMARYPosted: 3 months ago

Type

DESCRIPTION

Duration: 2 Months(8 Weeks or Weekends)
Prerequisites
• Knowledge of Basic DBMS
Course Content

1. Introduction To Database Management Systems And Databases
• What are a database and a database management system (DBMS?)
• Introduction to Microsoft SQL Server and its overall SQL Server Data Platform
• History and Current trends of DBMS and Database Administration
• Tasks of a Database Administrator
2. SQL Server 2012 Installation.
• Editions of SQL Server 2012
• Editions of SQL Server 2012
• Hardware and Software pre-requisite for a successful SQL Server installation
• Understanding SQL Server components
• Perform a successful SQL Server 2012 installation
3. SQL Server 2012 Administration and Development Tools
• Using SQL Server Management Studio (SSMS
• Using SQL Server Command Line interface
• Using SQL Server Configuration Manager
4. SQL Server 2012 Architecture.
• Understanding SQL Server system databases.
• Understanding the SQL Server database structure.
• SQL Server files and filegroups.
• SQL Server Transactional logs.
• What is the difference between SQL Server instance and database
• Client-Server Communication
• Attaching and detaching SQL Server databases.
5. SQL Server Database objects
• Understanding Schemas
• Understanding SQL Server data types
• Understanding column properties
• Creating tables, altering tables and adding constraints, relationships
• Understanding the filetable
• Creating database diagrams
6. SQL Server Backup and Recovery
• Introduction to Backup and Recovery strategy for databases
• Full Database backups using SIMPLE Recovery Model
• Full Database and Transactional log backups with FULL Recovery Model
• Backup history and maintenance
• Designing Maintenance plans for Backup Tasks
• SQL Server Agent for scheduling backups
• Database Mail for email notifications to DBAs
7. SQL Server Data Export and Import (Data Movement)
• Partial Data export and import using the command line tools
• Partial Data export and import using GU

...
Rupali

(Not Rated)

••••• •• 366

Safety Tips
  1. Meet in a public place during the daytime when other people will be around.
  2. Don't carry large sums of money with you when going to meet the seller.
  3. Never send advance payment under any circumstances.
Read all safety tips...