Fundamentals of SQL Language for Users
This two day training is designed for those who are starting their journey in SQL. It offers an introduction to relational databases as well as writing simple queries. The purpose of this course is to get you familiar with basic knowledge required for constructing SQL queries and is aimed for users who need it for writing uncomplicated SELECT statements and who also want to display and filter data or know how to order it. If any extension of the gained knowledge is required, we offer additional courses Writing Queries Using SQL and Writing Advanced Queries Using SQL.
The course uses Microsoft platform with the Transact-SQL dialect.
Code
SQL-Jazyk 0
Course length
2
days
(8:30 – 16:00)
Form
In our classroom or online
Dates
This course is intended for
Users who want to learn SQL for basic simple querying, reporting or data analysis.
Syllabus
Module 1: Introduction to SQL and Relational Databases
- History
- Relational databases (entities, atributes, relations)
- Vendors & Tools
Module 2: Introduction to SQL Language
- Types of Commands (DML, DDL, DCL)
- Language Elements (Expressions, Operators, Variables)
Module 3: Data Types and Built-In Function
- Data Types
- Built-In Functions
Module 4: The SELECT Statemoent
- Syntax
- Distinct
- Aliases
Module 5: Joining Tables and Sets
- JOIN
- SET Operators (Union, Except, intersect)
Module 6: Sorting and Ordering Data
- ORDER BY
- WHERE
Students will be able to
- Understand the principles of relational databases
- Construct simple queries in SQL, join tables and filter data
Course requirements
- WIlling to learn something new, gain knowledge about relational databases and the concept of querying data.
Hardware
Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.
Literature
All participants will get internal materials.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Similar courses
Take a look at some similar courses from our wide range.
Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM
High Availability in SQL Server MSSQL-HA
Developing SQL Databases DB-DEV
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
