oracle sql online training classes

1

• Online classroom Corporate
• Training certifications placements support
• CONTACT US
• MAGNIFIC TRAINING
• INDIA 91-9052666559
• USA 1-678-693-3475
• info_at_magnifictraining.com
• www.magnifictraining.com

2
Our magnific it company

• Magnific technology is a leading training
  institute in the online world
• We provide work based training, according to your
  specific educational and technical needs
• We have one excellent centre fully operational
  training
• We provide 24/7 access server to help our
  trainees practice exercises
• Magnific name ORACLE DBA 247 technical
  support
• Faculty real time experience
• Magnific trainings it is a brand and providing
  quality online and offline trainings to students
  in world wide
• We are providing best online training for ORACLE
  DBA

3
Oracle SQL online training

• Introduction to the sql server
• Microsoft SQL Server is a relational database
  server, developed by Microsoft. it is a software
  product whose primary function is to store and
  retrieve data as requested by other software
  applications, be it those on the same computer or
  those running on another computer across a network

4
Oracle SQL online training classes

• Enabling Remote Connections
• 1. TCP/IP
• 2. Named Pipes
• Changing Port numbers
• Authentications
• 1. Windows Authentications
• 2. SQL Server Authentications
• Securities
• 1. Logins
• 2. Users
• 3. Roles
• 4. Password Management
• 5. Database Assignment
• 6. Privileges
• 7. Schema

5
Oracle SQL online classes

• Databases
• System Databases
• User Databases
• Database Designing
• Creating Database
• Altering Database
• Files And File Groups
• Data Files
• Log Files
• Primary File Group
• Memory Architecture
• Data Pages
• Header and Description
• Extents

6
Oracle SQL online training classes in usa

• Backups and Planning
• 1. Full
• 2. Differential
• 3. Transaction Log
• 4. Files and File Groups
• 5. Temporary
• 6. Jobs and Schedules
• 7. Back up Device
• 8. Append and Over write
• Restorations
• 1. Complete restoration
• 2. Point in Time restoration
• 3. Restoration Options

7
Oracle SQL online training classes in south africa

• Up gradation
• Replication
• 1. Publisher
• 2. Publication
• 3. Subscriber
• 4. Subscription
• 5. Distributor
• 6. Agents
• 7. Snap Shot Publication
• 8. Transactional Publication
• Log Shipping
• 1. Primary Servers
• 2. Secondary Servers
• 3. Monitoring Servers
• 4. Jobs and Schedules
• 5. Blocking of Jobs
• 6. High Availability

8
Oracle SQL online training classes

• Mirroring
• 1. Principle Server
• 2. Mirror Server
• 3. Witness Server
• 4. Mirror_Error
• 5. Stand by Server
• SQL SERVER AGENT
• 1. Jobs
• 2. Schedules
• 3. Alerts
• 4. Operators
• 5. Error Logs
• Database Mail
• Maintenance Plan
• 1. Through SSMS
• 2. Through SSIS

9
Contact US