Professional Training on Informatica Development- ...
Duration: 50 hours prerequisites • basic knowledge of sql and unix is advantageous course contents 1. rdbms concep...
Pimpri- Chinchwad
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
Type
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
Duration: 50 hours prerequisites • basic knowledge of sql and unix is advantageous course contents 1. rdbms concep...
Pimpri- Chinchwad
Duration: 8 weeks( weekdays batch)/9 weekends prerequisites • knowledge of manual testing core java 1. overview of j...
Pimpri- Chinchwad
Duration: 2 months (weekdays batch)/10 weekends prerequisites • there is no pre-requisite for this course html: hyp...
Pimpri- Chinchwad
Duration: 70 hours prerequisites • knowledge of basic programming core java concepts (20 hrs) 1. introduction to jav...
Pimpri- Chinchwad