Home Company Information Consulting Course Catalog Contact Us Request a Quote Government Corporate
 


We are here to help...
Let us answer your questions.
With easy ways to get the answers you need:
Call Me
Or call us at:
      1-888-742-3214


Profile


e-Catalog
Contact
Search
Cart
SQL Programming: Data Handling Techniques

Course Status: Released
Course Language: English
Course Duration: 12 Hours
Deployment Options: Online, Interactive CDs, Network, Downloads, Intranet

Audience
Programmers working in a relational database environment, database administrators, and database designers
Prerequisites
The courses SQL Programming: Database Queries and Relational Principles; programming experience is not absolutely necessary
Course Aim
To demonstrate the use of SQL in defining database structures and controlling data security
Learning Objectives
Describe and use the data manipulation commands INSERT, UPDATE, and DELETE.
Describe how to embed SQL in a C routine using the EXEC SQL command.
Use data definition commands to create, manipulate, and remove base tables, indexes, and views.
Use data control commands to extend and revoke privileges to end-users.
Topics Covered
DML: Modification commands
- INSERT
- UPDATE
- DELETE
- Transaction statement
Embedded SQL
- Introduction to embedded SQL
- Application prolog
- Embedded SQL in a C program
- Static and dynamic SQL
- API
Data definition language (DDL)
- Introducing the DDL
- Creating tables
- Defining constraints
- Maintaining tables
- Views
- Indexes
Data control language (DCL)
- Security
- Granting privileges
- Removing privileges
- Naming tables and synonyms