Adfor S.p.a.

Informix Structured Query Language

Adfor S.p.a.
Online

150 
+IVA
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Metodologia Online
Inizio Scegli data
  • Corso
  • Online
  • Inizio:
    Scegli data
Descrizione

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. If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. Objective Describe the basic structure of an SQL SELECT statement List and describe the Informix data types 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 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

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Online
Inizio Scegli data
Luogo
Online

Domande più frequenti

· A chi è diretto?

This basic course is for basic database users and applications developers.

· Requisiti

It is preferred that you have: Basic knowledge of the UNIX or Linux operating system

Opinioni

0.0
Senza valutazione
Valutazione del corso
100%
Lo consiglia
5.0
eccellente
Valutazione del Centro

Opinioni sul corso

Non ci sono ancora opinioni su questo corso
* Opinioni raccolte da Emagister & iAgora

Cosa impari in questo corso?

Web master
SQL

Programma

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 Informix Data Types List and describe the Informix data types The Demonstration Database 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 Single Table SELECT Statements Write a single table SELECT statement List the optional clauses of a SELECT statement Use the WHERE clause Use the ORDER BY clause SELECT Clauses and Aggregates 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 Built-In Functions 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 Joining Tables in a SELECT Statement Access data from two or more tables with SELECT Avoid a Cartesian product Assign aliases to table names Complex Joins 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 Subqueries Write queries that use subqueries Write a SELECT statement that uses nested subqueries Explain the purpose of a correlated subquery Temporary Tables 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 INSERT, UPDATE, and DELETE Statements 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 Other SQL Features 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 SQL Optimization 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


Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto