Writing Queries Using SQL
The three-day course aims to acquaint students with the basics of SQL. Its content is a description of language syntax, definition of data structures, queries, and data manipulation.
Code
SQL-Jazyk 1
Course length
3
days
(8:30 – 16:00)
Form
In our classroom or online
Dates
This course is intended for
- Database administrators, developers, IT architects
- Users who will use SQL to query, report and analyze
Syllabus
- Relational Databases and SQL Language
- Basic SELECT Statement
- Data Types, Conversions, and Built-in Functions
- Sorting and Filtering Results
- Multi-table Queries
- Data Aggregation
- Combining Results – SET Operators
- Creating Tables, Inserting, Deleting, and Modifying Data
Students will be able to
- Create and use queries in SQL
- Manipulate with data
- Define and work with database objects
Course requirements
- Refresh, master, and learn new SQL knowledge
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.
Implementing a SQL Data Warehouse DB-DW
Developing SQL Databases DB-DEV
Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM
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?
