Administering Microsoft SQL Server Databases Training

by Bilginc IT Academy Claim Listing

This five-day instructor-led course provides delegates 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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Bilginc IT Academy Logo

img Duration

5 Days

Course Details

This five-day instructor-led course provides delegates 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.

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.

 

You Will Learn:

  • 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.
  • Auckland CBD Branch

    Commercial Bay, 7 Queen Street, Auckland CBD, Auckland

Check out more SQL Server courses in New Zealand

AH Accounting & Training Services Logo

Certificate in Oracle Database

This course is in preparation for the The Oracle Database 11g Administrator (OCA 11g) certification exam. The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise.

by AH Accounting & Training Services [Claim Listing ]
Koenig Step Forward Logo

Microsoft Secure Database Administration With Development

The Microsoft Secure Database Administration with Development certification is aimed at professionals who handle database management and development with a focus on security.

by Koenig Step Forward [Claim Listing ]
Bilginc IT Academy Logo

Distributed Data Processing With NoSQL Training

We are witnessing the growth of “Internet” that we know since mid-90s. But this phenomenon couldn’t end to make open source achievements, which disrupt the industry both in terms of infrastructure and analytics, available for others.

by Bilginc IT Academy [Claim Listing ]
Lumify Group Logo

Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL

This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database ...

by Lumify Group [Claim Listing ]
Victoria University of Wellington Logo

Databases

This course introduces the principles of database definition, design, access and implementation.

by Victoria University of Wellington [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy