IBM - Informix Structured Query Language
Seminar
In Berlin
Beschreibung
-
Kursart
Seminar
-
Ort
Berlin
-
Dauer
4 Tage
-
Beginn
auf Anfrage
IBM - Informix Structured Query Language: This is a basic course for basic database users and applications developers._x000D_. 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.. Gerichtet an: This is a basic course for basic database users and applications developers._x000D_. 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. Learn how to use functions and expressions in SQL statements and how to format the query results. In...
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Basic knowledge of the UNIX or Linux operating system is preferred._x000D_
Meinungen
Erfolge dieses Bildungszentrums
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
- Access
- Datenbank
- SQL
- Basic
- Informix
- IBM
Inhalte
IBM - Informix Structured Query Language: This is a basic course for basic database users and applications developers._x000D_
_x000D_
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. Learn how to use functions and expressions in SQL statements and how to format the query results. In addition, learn how to perform insert, update, and delete operations, and how to select rows that contain large object and other non-standard data types. This course replaces course FN613 and FN757.
ZIELGRUPPE
This is a basic course for basic database users and applications developers._x000D_
_x000D_
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. Learn how to use functions and expressions in SQL statements and how to format the query results. In addition, learn how to perform insert, update, and delete operations, and how to select rows that contain large object and other non-standard data types. This course replaces course FN613 and FN757.
KURSINHALT
Kursziele
- Describe the basic structure of an SQL SELECT statement
- Explain the relationship of tables in the Informix demo database
- Select rows from a single table
- Use various SELECT statement clauses
- Obtain query results using aggregate functions
- Use built-in functions in the SELECT list and ORDER BY clause
- Write queries that use simple and complex joins between tables
- Write queries that use subqueries and temporary tables
- Perform insert, update, and delete operations in a query
- Describe locking granularity and control isolation levels in a query
- Control the format of query input and output using functions and operators
- Write queries that involve large objects and complex data types
- Use SET EXPLAIN to determine how a query is optimized
Introduction to Structured Query Language
- Define the term Structured Query Language (SQL)
- Identify the different categories of SQL statements
- Identify the topics covered in this course
- List and describe the Informix data types
- Describe the major concepts of relational databases
- Identify the tables in the stores_demo database
- Identify the relationships between these tables
- Install a copy of this database
- Use DB-Access to edit and run queries
- Write a single table SELECT statement
- List the optional clauses of a SELECT statement
- Use the WHERE clause
- Use the ORDER BY clause
- Recognize arithmetic expressions
- Use aggregate functions in a SELECT statement
- Use the GROUP BY clause
- Use the HAVING clause
- Put SELECT data into a temporary table with the INTO TEMP clause
- Use NULL values in expressions
- Use date and time functions
- Convert DATE or DATETIME values to character strings
- Perform case-insensitive searches
- Use string manipulation functions
- Use the concatenation operator
- Remove leading and trailing characters
- Use numeric functions
- Write conditional expressions
- Access data from two or more tables with SELECT
- Avoid a Cartesian product
- Assign aliases to table names
- Describe the differences between inner and outer joins
- Describe the different types of outer joins
- Use various types of complex joins in queries
- Describe the purpose of a self join and use in a query
- Use the UNION operator in an SQL statement
- Write queries that use subqueries
- Write a SELECT statement that uses nested subqueries
- Explain the purpose of a correlated subquery
- Write queries that explicitly create temporary tables
- List reasons why temporary tables are needed in queries
- Use the WITH NO LOG option when creating temporary tables
- Write an INSERT statement to enter data into a table
- Write an UPDATE statement to change data in a table
- Write a DELETE statement to remove data from a table
- Write a LOAD statement to add rows into a table from a file
- Write an UNLOAD statement to create a file that contains data from a database
- Use synonyms and views in place of tables in a query
- Access remote tables in a query
- Write queries to select and insert simple and smart large objects
- Explain how to query on tables that contain user-defined data types
- Explain how to use user-defined routines in a query
- Explain the purpose of the Informix optimizer
- Define the choices of access paths available to the optimizer
- Describe the different types of indexes and their importance to query optimization
- Use SET EXPLAIN to obtain information about how a query is optimized
- Identify the choices made by the optimizer based on information written to the sqexplain.out file
- Use optimizer directives to influence the optimization path for a query
Day 1
- Welcome
- Unit 1: Introduction to Structured Query Language
- Unit 2: Informix Data Types
- Unit 3: The Demonstration Database
- Exercise 1
- Unit 4: Single Table SELECT Statements
- Exercise 2
- Unit 5: SELECT Clauses and Aggregates: Aggregates
- Exercise 3
- Unit 5: SELECT Clauses and Aggregates: NULL Values
- Exercise 4
- Unit 6: Built-In Functions: Date and Time Functions
- Exercise 5
- Unit 6: Built-In Functions: String Functions
- Exercise 6
- Unit 6: Built-In Functions: Numeric Functions and Conditionals
- Exercise 7
- Unit 7: Joining Tables in a SELECT Statement
- Exercise 8
- Unit 8: Complex Joins: Outer Joins
- Exercise 9
- Unit 8: Complex Joins: Self Joins
- Exercise 10
- Unit 8: Complex Joins: The UNION Operator
- Exercise 11
- Unit 9: Subqueries
- Exercise 12
- Unit 10: Temporary Tables
- Exercise 13
- Unit 11: INSERT, UPDATE, and DELETE Statements
- Exercise 14
- Unit 12: Other SQL Features
- Exercise 15
- Unit 13: SQL Optimization
- Exercise 16
Course material will be in English.
VORRAUSSETZUNG
Basic knowledge of the UNIX or Linux operating system is preferred._x000D_
IBM - Informix Structured Query Language