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

125 500 HUF + VAT (cca. 330 EUR + VAT)


Course dates and application

First training day: 27 May 2024, Further training days: 28.

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

125 500 HUF + VAT (cca. 330 EUR + VAT)

Apply

The application deadline has already expired. Please submit your application and we will try our best to provide a seat for you!

First training day: 24 June 2024, Further training days: 25.

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

125 500 HUF + VAT (cca. 330 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 this course, students will learn the basics of writing Oracle SQL queries.

No previous knowledge is required.

 

Writing SQL queries is no longer required only for software developers, and is increasingly expected in the fields of analysis, design, testing or reporting. In this course, students will first learn the basics of the SQL language, and how to write queries.

In addition to the standard SQL statements, they will be able to use these stand-alone query languages effectively with specific knowledge of Microsoft Transact SQL.

Throughout the course, there will be a strong emphasis on practical knowledge, so students will learn about the most commonly used tools for SQL databases.

Our Oracle training courses are based on the curriculum developed by Masterfield.

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. Conversion functions
5.5. 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

Qualified mentors of the training


Do you have any questions about the training?