SQL Server Basic (conducted in English) kursus

You will learn

Microsoft SQL Server is one of Microsoft's most important server products and is one of the most used Database tools in organisations. Besides being used as a database tool in a large number of applications for both OLTP and DSS systems it is also used in a number of Microsoft's own applications like SharePoint and Navision. The course is focusing on common administration tasks like configuring a SQL Server instance, plan and implement backup/restore, security, and automating SQL Server management.
  • Configuring a SQL Server instance
  • Create, alter, and drop databases
  • Create, alter, and drop tables
  • Schemas
  • Data integrity
  • Create, alter and drop indexes
  • Create and planning backup strategies
  • Implement and plan security on a SQL Server instance
  • Create jobs and schedules
  • Handling transactions and locking

You get

During the course
  • Teaching by the most experienced instructor team in our cosy and fully updated classrooms located in the centre of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopaedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.

After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.


We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course

Get the best benefit from the course

This is a technical course and we expect that you have attended our "SQL Basic course” or have acquired similar experience with T-SQL.

At the course Microsoft SQL Server 2014 is used.

Course Details

Module 1 – Introducing Microsoft SQL Server
This module describes how to prepare the installation of a SQL Server instance and how to configure an existing SQL Server instance. You will be introduced to the most important client tools used for administration, configuration and querying.

The following will be covered:
  • Prepare to install a SQL Server instance
  • Microsoft SQL Server client tools
  • Configuring an existing SQL Server instance

Module 2 - Implementing Databases
This module describes how to create and maintain databases and database files, and how to move them.
  • Databases and Database Files
  • Transaction log
  • File Groups
  • Maintaining Databases

Module 3 - Implementing tables

This module describes how to create, alter, and drop tables. The different data types used in tables is also discussed

The following will be covered:
  • Data Types
  • Creating Tables
  • Maintaining Tables
  • Schemas

Module 4 - Data Integrity

This module describes implementing and planning data integrity.

The following will be covered:
  • Constraint Types
  • Default Constraint
  • Primary Key Constraint
  • Unique Constraint
  • Check Constraint
  • Referential Integrity

Module 5 – Introducing index

This module describes the use of index and the different types of index. Other tasks like planning indexes and using the Database Engine Tuning Advisor is also discussed.

The following will be covered:
  • Introducing Index
  • Index Architecture
  • Planning Indexes
  • Creating Index
  • Composite Index
  • Introducing the Database Engine Tuning Advisor

Module 6 - Backup and Restore
This module describes how to plan and implement a disaster recovery strategy. The different backup types are discussed and you will be able to plan for an effective backup strategy.

The following will be covered:
  • Planning for a Backup Strategy
  • The Transaction log and Recovery
  • Recovery Models
  • Full Backup
  • Log Backup
  • Differential Backup
  • Restoring Databases
  • Backup and Restore the master Database

Module 7 – Implementing Security
This module describes the SQL Server Security Framework and how to implement security on server and database level.

The following will be covered:
  • Microsoft SQL Server Security Framework
  • Creating Windows Logins
  • Creating SQL Logins
  • Server Roles
  • Database Users
  • Creating Database Users
  • Database Roles


Module 8 - Automating SQL Server Management
This module describes how to use SQL Server Agent to automate jobs, create alerts, and send notifications using database mail.

The following will be covered:
  • Configuring Microsoft SQL Server Agent
  • Configuring Database Mail
  • Creating Jobs and Schedules
  • Create and use Operators
  • Create Alerts

Module 9 - Transactions and Locks
This module describes how to handle transactions and locks. Isolation levels, blocking, and deadlocks is discussed.

The following will be covered:
  • Transactions
  • User defined Transactions
  • Locks
  • Locks and Isolation levels
  • Blocking and Deadlocks

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
Tirsdag: 08.30 - 16.30
Onsdag: 08.30 - 16.30
Torsdag: 08.30 - 16.30
Fredag: 08.30 - 16.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K