|
Access to data with language SQL.
|
Module 1. Description of language SQL.
- To position language SQL.
-When it is necessary to use language SQL?
- Instructions of language SQL.
- Basic Elements of the syntax.
- The data base Neptune.
|
Module 2. The relational databases.
- The structure of basic storage: The table.
- The restrictions.
- The distribution of the data in different tables.
- The normalization of the data.
|
Module 3. To realize consultations to the data base.
- The necessity to realize consultations.
- Instruction SELECT.
- The clause SELECT and clause FROM.
- Operations with the selected fields.
- The field alias.
- The functions of unique row. |
Module 4. To filter data.
- Clause WHERE.
- The operations of comparison.
- The operator like.
- Operator is null.
- The operator in.
- The logic operators.
|
Module 5. Sumarizar and to group data.
- Sumarizar data with the functions of multiple row.
-Because it is necessary to group?
- Clause GROUP BY.
- To leak after grouping. Clause HAVING. |
Module 6. Consultations to more than a table I.
- The necessity to accede to information of more than a table.
- The types of relation.
- The criterion of the relation.
|
Module 7. Consultations to more than a table II.
- The combination of two tables.
- To combine two tables with clause WHERE.
- The table alias.
- To combine more than two tables with clause WHERE. |
Module 8. Consultations to more than a table III.
- The syntax standard. Clause JOIN.
- The types of combination.
- To combine more than two tables with clause JOIN.
-What is a combination Self JOIN. |
Module 9. To order the results.
- Clause ORDER BY.
- Ascending and descendant Arrangement.
- To order by more of a field. |
Module 10. The subconsultations.
- The necessity to use subconsultations.
- Subconsultas of a unique value.
- Subconsultas of several rows. |
Module 11. Examples of complete consultations.
- The clause UNION.
-What is the Datamining?
- Complete Consultations. |
Module 12. To improve the yield of the consultations.
-What can affect the yield of a consultation?
- Introduction to the indices.
-What is the execution plan?
- The importance of keeping the subconsultations. |
Module 13. The modification of data.
- Instruction INSERT.
- Instruction UPDATE.
- Instruction DELETE.
|
Module 14. The transactions.
- Definition of transaction.
- Characteristic of the transaction.
- Implicit Transactions and explicit transactions.
- Instructions COMMIT and ROLLBACK.
- Introduction to the nested transactions.
|
Module 15. The creation of tables.
- Instructions DDL.
- Instruction CREATE TABLE.
- To create tables starting off of a consultation.
- To modify the design of a table.
- To eliminate tables. |
Module 16. Introduction to the security in the data bases.
- Security in the access to the data base.
- The types of permissions.
- The table permissions.
- Instructions DCL.
|
