Skip to main content
Close

Please choose your language

Level 2

SQL Basics:
Queries & Administration

Register now

Our next dates:

1.600,-€
2 days
On-site
CSB Group (Consulting and Support)
1.600,-€
2 days
On-site
CSB Group (Consulting and Support)

The participants will learn how to use databases independent of the CSB-System using the Microsoft SQL Server Management Studio. The focus is on the practical application of SQL commands and a basic introduction into administration of a Microsoft SQL server.

This course primarily addresses the Microsoft SQL server, highlighting the key differences from Oracle.

It is made clear that all-encompassing database administration is a job on its own, and that the participants can support database administrators and IT officers with their skills. 

Participants will be able to perform basic queries and changes of data on the database using SQL with the Microsoft SQL Server Management Studio. Additionally, they will learn the basic concepts for data backup and be able to use this knowledge to create a test version or export specific data files. They will also acquire the necessary skills to analyze error logs. All of this enables them to support other IT departments.

The participants will know how to apply the skills they acquired with great care to minimize the risk of damages, data loss, or standstill of a production system.

Basic knowledge of the term “table” (for example, from Excel)

Bring your own laptop to install SQL Server and Management Studio

Learning content

Introduction of “Databases”

Why? | Types | suppliers | Tables

Introduction to SQL Server Management Studio

Connection details | Administration of tables, schemas, indexes, and views

SQL query techniques

 Column selection | Alias names | Calculated columns | WHERE statement | BETWEEN, IN, LIKE | Subqueries | Date & time functions | Aggregate functions | GROUP BY + HAVING | Inner + Outer Join

Create, Insert, Update, Delete, Truncate, Drop

Views

Database files and transaction log

Compatibility level

Restore models

Evaluation of error logs

Backup creation and recovery

Table copies

Register for the training session now – it’s quick and easy

Select your date

Please select your participation format: On-site

Do you have any questions?

Marvin Magalhaes

Deputy Head of CSB-College

+49 (0)2451/625-187
marvin.magalhaes@csb.com