Jurassic Institute of Management and Technology Database Administration using SQL Server Jurassic Institute of Management and Technology

Course Overview:

  • List the features of SQL Server 2008
  • Describe the SQL Server database architecture
  • Discuss SQL Server Security
  • Install SQL Server 2008
  • Configure network libraries
  • Alter databases
  • Attach and detach databases
  • Create and manage database objects like tables, constraints, indexes, stored procedures, triggers and views.
  • Manage Users, Groups, Roles, and Logins
  • Use the Database Maintenance Plan Wizard
  • Use DBCC for Integrity Checks

Course Contents:

  • List the features of SQL Server 2008
  • Identify the operating systems that support SQL Server 2008
  • Describe the SQL Server database architecture
  • List database objects
  • Discuss SQL Server Security
  • Install SQL Server 2008
  • Upgrade to SQL Server 2008
  • Perform a custom upgrade
  • Configure network libraries
  • Create physical files for SQL Server databases 
  • Create file groups
  • Create databases and databases files
  • Alter databases
  • Manage database by expanding and shrinking
  • Attach and detach databases
  • Create and manage database objects like tables, constraints, indexes, stored procedures, triggers and views.
  • Alter database objects.
  • Design optimization of SQL Server Applications - Indexing, Locking, Recompiling, Optimizing Databases 
  • Troubleshoot Transaction locking using SQL Profiler, Enterprise Manager, or Transact-SQL
  • Use the System Monitor to optimize hardware resources
  • Use Trace and System Monitor - Cache Hits, Connections, Locks, Memory Allocation, Recompilation and Transactional Throughput
  • Set up IIS virtual directories to support XML 
  • Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries
  • Develop and manage DTS packages 
  • Create and Manage linked servers
  • Convert data types
  • Explain Replication and the different types of replication
  • Configure, maintain, and troubleshoot replication services
  • Configure Security Modes
  • Manage Users, Groups, Roles, and Logins
  • Grant,deny, or revoke permissions
  • Configure Security Mapping for Linked Servers
  • Perform security auditing using SQL Profiler
  • Use Views and Stored Procedures to enhance security
  • Describe SQL Server Agent
  • Explain creating and managing Jobs and Alerts
  • Describe SQL Mail and SQL Agentmail Explain disaster recovery
  • Plan and execute backups - 
  • Recover the system state and restore data
  • Describe Log Shipping
  • Use the Database Maintenance Plan Wizard

Benefits of the Course: 

Ministry Approved Certificate

Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained  over 4,00,000 students.

See all Jurassic Institute of Management and Technology courses

IT, Computing and Technology Related Questions

Enquire about this course

You may add more courses here,
your list will be saved.

Rate our content