|
|
|
 |
IN613Structured Query Language
In this course you study the Data manipulation language (Data Manipulation Language) - DML, being part Structured Query Language, with detailed learning SELECT operators, INSERT, UPDATE and DELETE. You also learn to use resource DB-Access for access and data modification. The special attention is given complex inquiries to databases (for example, with external links, subrequests). The course contains a plenty of exercises for independent execution.
After learning course you can
- To use SQL operators of data manipulation (Data Manipulation Statements-DML) for change of a contents of a database
- To write simple and complex SELECT operators, including external links, subrequests, temporary tables and the unions
- To define ways of optimization of inquiries
- To define and use transactions
- To understand importance of the control of coincidences
Contents of course
- Introduction in the Structured query language (SQL)
- the Demonstration database "Stores"
- Inquiries SELECT under one table
- Additional functions
- Connections (joins) and subrequests
- INSERT Operators, DELETE, LOAD, UNLOAD
- UNION
- Transactions
- Handle of simultaneous access of users to the data
- Files of customizations of environment
- the Distributed inquiries
Preliminary preparation
Learning of courses IN433 " Designing of Relational Databases " or equivalent knowledge.
Given cource inserted in next comlex programs:
Dadabases Basics Complex programm
Education coast on cource - USD 390
Cource duration (days) - 3
|
|
