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.
  • 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
  • Data Types
  • Creating Tables
  • Maintaining Tables
  • Schemas

Module 4 - Data Integrity


This module describes implementing and planning data integrity.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Transactions
  • User defined Transactions
  • Locks
  • Locks and Isolation levels
  • Blocking and Deadlocks

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K