Developing Applications Using IBM Informix ESQL/C Eğitimi

Ön Kayıt ve Fiyat Bilgi Formu




Tarih ve lokasyonlar


Bu eğitimi özel sınıf olarak kendi kurumunuzda talep edebilirsiniz.
Lütfen bizimle iletişime geçin:


info@bilginc.com

+90 212 282 7700

Talep Formu
Eğitim Tipi ve Süresi


Eğitim Sağlayıcı ve Kategori

IBM  » Informix Eğitimler

Developing Applications Using IBM Informix ESQL/C (IX150G )

IBM Course Code: 2X150G

In this course, you will use IBM Informix ESQL/C tools to write applications that contain embedded SQL commands and queries. You will write applications to perform queries that return single and multiple rows; insert, update, and delete rows; create and use forms to display one or more rows of data; manage cursors, and handle various types of data, including large objects.

What You'll Learn

  • Include SQL statements in a C program to add, retrieve, and alter data in an Informix database
  • Set up a cursor structure for manipulating a set of rows
  • Work with all SQL data types
  • Set up and execute dynamically defined SQL statements
  • Write effective, efficient SQL-based applications in C

Who Needs to Attend

This intermediate course is for application developers.

Prerequisites

You should complete:

  • IBM Informix Structured Query Language or equivalent knowledge
  • ANSI C programming or C programming experience

Follow-On Courses

There are no follow-ons for this course.

Course Outline

  • Unit 1: Introduction to IBM Informix ESQL/C
  • Exercise 1
  • Unit 2: The Demonstration Database
  • Exercise 2
  • Unit 3: Embedding SQL Statements
  • Exercise 3
  • Unit 4: Using CONNECT TO
  • Exercise 4
  • Unit 5: Compiling an ESQL/C Program
  • Exercise 5
  • Unit 6: ESQL/C Data Types
  • Unit 7: Character and String Data Types
  • Exercise 6
  • Unit 8: Numeric Data Types
  • Exercise 7
  • Unit 9: Inserting Rows
  • Exercise 8
  • Unit 10: The SQL Communications Area
  • Exercise 9
  • Unit 11: SQL Exception Testing
  • Exercise 10
  • Unit 12: Using GET DIAGNOSTICS
  • Exercise 11
  • Unit 13: Singleton Queries and Lookups
  • Exercise 12
  • Unit 14: An Overview of Cursors
  • Exercise 13
  • Unit 15: Using Scroll Cursors
  • Exercise 14
  • Unit 16: Using Scroll Cursors Effectively
  • Unit 17: Using an Update Cursor
  • Exercise 15
  • Unit 18: Using an Insert Cursor
  • Unit 19: Time Data Types
  • Exercise 16
  • Unit 20: Simple Large Objects
  • Exercise 17
  • Unit 21: Dynamic SQL
  • Exercise 18
  • Unit 22: Dynamic SQL: Constructing INSERT Statements
  • Unit 23: Working with the Database Server
  • Exercise 19



Eğitim içeriğini PDF olarak indir