fbpx
Course length:
Training language:
32 lessons
English
Course fee:

195 500 HUF + VAT (cca. 525 EUR + VAT)


Course dates and application

First training day: 17 June 2024, Further training days: 18., 19., 20.

on working days (09.00 - 16.30)
Application deadline:
7 June 2024
Training language:
Hungarian
Course fee:

195 500 HUF + VAT (cca. 525 EUR + VAT)

First training day: 5 August 2024, Further training days: 6., 7., 8.

on working days (09.00 - 16.30)
Application deadline:
26 July 2024
Training language:
Hungarian
Course fee:

195 500 HUF + VAT (cca. 525 EUR + VAT)

Applying for closed-group training

If you and your colleagues are attending a closed group training course and you have a training date code, you can apply here.

Application without a date

If none of the dates is right for you, but you are interested in the course, please submit your application without a date. When we announce a new date you will be notified.

In the course, students will learn the basics of the Microsoft SQL Server SQL language. They will be able to write complex SQL queries, modify data in databases and create tables and other SQL server objects.

It is recommended for software developers, database administrators, business analysts, software testers and users working on reports with little or no knowledge of SQL.

No previous knowledge is required.

 

Almost every developer needs some level of SQL knowledge, and it is hard to imagine a field of programming today where you can succeed without it. Besides programmers, anybody working with databases could take advantage from learning SQL. In this course, participants will learn the basics of the SQL language and how to to write queries and data modification statements.

 

The course will place a strong emphasis on acquiring practical knowledge. Consequently, students will become familiar with the most commonly used tools for SQL databases. In the final part of the course, students will gain insight into the true power of SQL by creating tables and other objects.

 

Course Outline:

 

1. SQL LANGUAGE AND RELATIONAL DATABASE MANAGERS

1.1. SQL standards
1.2. Data models
1.3. Relational database managers

1.4. Table

1.5. Field
1.6. Relationships between tables
1.7. Set theory
1.8. NULL value

 

2. BASICS OF MICROSOFT DATABASE SERVER

2.1. Microsoft SQL Server versions and variants
2.2. Copies on one machine
2.3. Referring to SQL Server
2.4. SQL Server databases
2.5. Authentication
2.6. Relationship between login, user and schema
2.7. Referring to objects
2.8. Course example database

 

3. TOOLS FOR MICROSOFT SQL SERVER

3.1. SQL Server Management Studio
3.2. Command line tool (osql, sqlcmd)
 

4. SIMPLE SQL QUERIES

4.1. Basics of SQL syntax

4.2. Database selection (USE)

4.3. SELECT statement
4.4. WHERE condition
4.5. Operators (LIKE, BETWEEN, IN, IS NULL)
4.6. ORDER BY - Sorting
4.7. GROUP BY - Grouping
4.8. Aggregation functions (SUM, COUNT, MIN, MAX, AVG)
4.9. HAVING condition
4.10. DISTINCT - Ensuring uniqueness
4.11. Limiting the number of lines retrieved (TOP, OFFSET, FETCH NEXT)
4.12. CASE expression

 

5. BUILT-IN FUNCTIONS

5.1. Numeric functions
5.2. Text-handling functions
5.3. Date and time functions
5.4. NULL functions

 

6. COMPLEX QUERIES

6.1. UNION and UNION ALL
6.2. INTERSECT
6.3. EXCEPT
6.4. Nested queries (EXISTS, IN, ALL, SOME, ANY)
6.5. Linking tables
6.6. INNER JOIN
6.7. CROSS JOIN
6.8. OUTER JOIN
6.9. Self JOIN

 

7. ADVANCED QUERIES

7.1. Multidimensional queries - PIVOT, UNPIVOT
7.2. Creating tables using the SELECT statement
7.3. Higher level aggregations (CUBE, ROLLUP, GROUPING SETS)
7.4. Ranking and analytic functions, using OVER
7.5. Execution order of SELECT statement
7.6. Creating views
7.7. Common table expressions
 

8. DATA MODIFYING STATEMENTS

8.1. Basics of transaction management
8.2. Inserting data (INSERT)
8.3. Modifying data (UPDATE)
8.4. Deleting data (DELETE)
8.5. TRUNCATE
8.6. MERGE

 

9. T-SQL DATA TYPES

9.1. Character types (VARCHAR, CHAR, NVARCHAR, NCHAR)
9.2. Numeric types (TINYINT, SMALLINT, INT, BIGINT, NUMERIC, MONEY, SMALLMONEY, FLOAT, REAL)
9.3. Date types (DATE, TIME, DATETIME, DATETIME2, SMALLDATETIME)
9.4. Large size types (TEXT, NTEXT, IMAGE, BINARY, VARBINARY)
9.5. Special T-SQL types
9.6. ANSI/ISO types
9.7. Type conversions

 

10. DDL STATEMENTS

10.1. DML and DDL statements
10.2. Types of DDL statements
10.3. Using visual tools
10.4. Creating objects
10.5. Modifing objects
10.6. Deleting objects

 

11. MICROSOFT SQL SERVER OBJECT TYPES

11.1. Tables
11.2. Indices
11.3. Constraints
11.4. Other object types 

Qualified mentors of the training


Do you have any questions about the training?