Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
Descriere curs:
Description:To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.
Target audience:Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Estimated Duration:105 Minutes
Lesson Objectives:Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms • recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns. • recognize the steps for using constraints to prevent invalid data entry into tables. • recognize the steps for altering or dropping a table. • identify the steps for creating and manipulating views to view or hide a table's data. • recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name. • create a new table and create and use a sequence, index, and synonym.
Accesul la cursurile comandate este valalbil pentru 3 luni de la data livrari cursului. Cu exceptia cursurilor de limbi straine unde accesul este valabil un an.