Informix Structured Query Language (IX131CZ)

IBM, DB2, Informix

In this course, you will learn to write queries using ANSI standard Structured Query Language (SQL) with IBM Informix extensions. You will start with simple queries to select rows from a single table, then advance to more complex queries that involve subqueries or multitable joins. You will learn how to use functions and expressions in SQL statements and how to format the query results. In addition, you will learn how to perform insert, update, and delete operations, and how to select rows that contain large object and other non-standard data types.

Location, current term course



Brno
9/9/2020 - 9/11/2020
Order
11/4/2020 - 11/6/2020
Order
VirtualPro
8/17/2020 - 8/19/2020
Order
10/12/2020 - 10/14/2020
Order
Vlastní Školení na míru (termín, lokalita, obsah, délka)

The course:

Hide detail
  • 1. Unit 1: Introduction to Structured Query Language
  • 2. Unit 2: Informix Data Types
  • 3. Unit 3: The Demonstration Database
  • 4. Unit 4: Single Table SELECT Statements
  • 5. Unit 5: SELECT Clauses and Aggregates
  • 6. Unit 6: Built-In Functions: Date and Time Functions
  • 7. Unit 7: Joining Tables in a SELECT Statement
  • 8. Unit 8: Complex Joins
  • 9. Unit 9: Subqueries
  • 10. Unit 10: Temporary Tables
  • 11. Unit 11: INSERT, UPDATE, and DELETE Statements
  • 12. Unit 12: SQL Optimization
Assumed knowledge:
You should have basic knowledge of the UNIX or Linux operating system is preferred.
Schedule:
3 days (9:00 AM - 5:00 PM )
Course price:
1 264.29 € (1 529.79 € incl. 21% VAT)
Language:
English