logo jbmd   0747600700 
קורס Administering Microsoft SQL Server 2012&2014 Databases
אודות הקורס
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
מטרת הקורס
  • Plan and install SQL Server.
  • Describe system databases, the physical structure of databases, and the most common configuration options related to them.
  • Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Import and export data by using wizards, the bulk copy utility, and data-tier applications.
  • Work with SQL Server security models, logins, users, and contained databases.
  • Work with server roles and database roles.
  • Use permissions to secure resources.
  • Use SQL Server audit and Transparent Data Encryption.
  • Work with SQL Server Agent to configure and execute jobs.
  • Implement SQL Server Agent security, proxy accounts, and credentials.
  • Configure database mail, alerts, and notifications.
  • Create database maintenance plans.
  • Use SQL Server Profiler, SQL Trace, and Distributed Relay.
  • Use Distributed Management Views and configure data collection.

מבנה והיקף מסלול הלימודים
40 שעות אקדמיות.
קהל יעד
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
תכנית הלימוד של המסלול
 Module 1: Installing SQL Server 2014
 Module 2: Working with Databases
 Module 3: SQL Server 2014 Recovery Models
 Module 4: Backup of SQL Server 2014 Databases
 Module 5: Restoring SQL Server 2014 Databases
 Module 6: Importing and Exporting Data
 Module 7: Authenticating and Authorizing Users
 Module 8: Assigning Server and Database Roles
 Module 9: Authorizing Users to Access Resources
 Module 10: Protecting Data by Using Encryption and Auditing
 Module 11: Automating SQL Server 2014 Management
 Module 12: Configuring Security for SQL Server Agent
 Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
 Module 14: Performing Ongoing Database Maintenance
 Module 15: Tracing Access to SQL Server 2014
 Module 16: Monitoring SQL Server 2014

21462 מק"ט
חזרה לראש העמוד


צור קשר שירות לקוחות מפת האתר דרושים כנסים סניפים שירותים אודות דף הבית