Class overview :
The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.
Class goals :
Learn to use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations.
• Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
• Understanding basic database security and object privileges.
• Using the powerful set of built-in SQL functions.
• Protecting the database and extending the basic data model using declarative constraints.
• Developing complex SQL*Plus reports and using SQL*Plus scripts.
Content of Oracle SQL 2 users
The target audience for this course is all Oracle professionals. Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.
Onze voordelen :
- Type of training: Inter-company, intra-company and individual
- 100% flexible & personalised training : You choose the place, the dates and the training program
- Offer request : Response within 24 hours
- 50% discount for SME’s from Brussels-Capital Region
- Free parking, lunch & drinks
- Free use of our Digital Competence Centre: Manuals, courses, exercises, …
The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.
PIXYSTREE SCS
Rue Beeckmans, 53
1180 Bruxelles
Tel : +32 2 412 04 10
Fax : +32 2 412 04 19
Gsm : +32 485 212 722
Email : selossej@pixystree.com
Training-brussels - business training center in Brussels 