IT-kurs
Database kurs
PostgreSQL
Hordaland
Du har valgt: Bergen
Nullstill
Filter
Ferdig

-

4 dager 18 000 kr
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their da... [+]
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.   Course Goals After completing this course, students will be able to: Describe the high level architectural overview of SQL Server and its various components. Describe the SQL Server execution model, waits and queues. Describe core I/O concepts, Storage Area Networks and performance testing. Describe architectural concepts and best practices related to data files for user databases and TempDB. Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking. Describe architectural concepts of the Optimizer and how to identify and fix query plan issues. Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache. Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events. Explain data collection strategy and techniques to analyze collected data. Understand techniques to identify and diagnose bottlenecks to improve overall performance.  Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=10987 [-]
Les mer
Oslo 5 dager 24 000 kr
26 Apr
26 Apr
07 Jun
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database i... [+]
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Course goals: After completing this course, students will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Protect data with encryption and auditing Describe recovery models and backup strategies Backup SQL Server databases Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=20764 [-]
Les mer
Oslo 5 dager 24 000 kr
08 Feb
31 May
31 May
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. [+]
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.   Course goals: After completing this course, students will be able to: Provision a Database Server Upgrade SQL Server Configure SQL Server Manage Databases and Files (shared) Provision, migrate and manage databases in the cloud Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=20765 [-]
Les mer
5 dager 24 000 kr
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. [+]
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database. Course goals: After completing this course, students will be able to: Design and Implement Tables. Describe advanced table designs Ensure Data Integrity through Constraints. Describe indexes, including Optimized and Columnstore indexes Design and Implement Views. Design and Implement Stored Procedures. Design and Implement User Defined Functions. Respond to data manipulation using triggers. Design and Implement In-Memory Tables. Implement Managed Code in SQL Server. Store and Query XML Data. Work with Spatial Data. Store and Query Blobs and Text Documents. Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=20762 [-]
Les mer

Lukk Denne siden benytter seg av informasjonskapsler (cookies).
Du kan fortsette å bruke siden som vanlig hvis du godtar dette. Les mer om bruk av informasjonskapsler i vår personvernerklæring.