Class overview :
This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users.
Class goals :
A summation of relational database principles and an introduction to the Oracle relational database server.
• Using the iSQL*Plus web-based database interface and other traditional interfaces.
• Writing simple SQL queries and moderately complex SQL queries using various join techniques.
• Summarizing, grouping and sorting data.
• Advanced query techniques such as correlated subqueries.
• Developing simple SQL*Plus reports.
• Creating and maintaining database tables.
• Taking advantage of new features such as the use of regular expressions.
• 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.
• Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax.
• Developing complex SQL*Plus reports and using SQL*Plus scripts.
Content of Oracle SQL 1 users
The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:
• Application designers and developers.
• Database administrators.
• Business users and non-technical end users.
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, …
This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users.
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 