Oracle Introduction for Experienced SQL Users
|
Summary
|
|
|||||||||||||
Oracle Introduction for Experienced SQL Users
The Oracle Introduction for Experienced SQL Users course is designed to give experienced SQL users practical experience in accessing an Oracle Database. This course is suitable for users of versions 9i, 10g and 11g.
The delegates will practise:
- Using SQL*Plus and SQL Developer to access the database
- Creating and running SQL script files
- Querying the database
- Using Oracle's numeric, character and date functions
- Implementing Oracle's enhanced grouping features
- Creating and altering tables, indexes and views
- Inserting, updating, merging and deleting rows
- Granting and revoking access privileges
- Retrieving information from the data dictionary
Anyone with practical experience of the SQL language who needs to migrate their existing skills to Oracle.
The Oracle Introduction for Experienced SQL Users course provides the skills necessary to query and update an Oracle Database using SQL*Plus and SQL Developer.
Practical experience of using SQL with another relational database is required.
- Oracle PL/SQL
- Oracle Database 10g DBA - Part I
- Oracle Database 11g Release 2 DBA - Part I
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Oracle - a brief overview
- Users and roles
- Object naming rules
- Oracle datatypes
- The data dictionary
- Using SQL*Plus
- Entering and executing SQL statements
- Creating, editing and running SQL scripts
- Using SQL Developer
- Starting SQL Developer
- Configuring a Connection
- Navigation Tabs
- SQL Worksheet
- Overview of the basics
- Traditional Oracle v. ANSI-standard table joins
- Set operators
- Using aggregate functions
- Subqueries and in-line views
- Using the WITH clause
- Hierarchical queries
- Using the table dual
- Numeric functions
- Formatting numeric output
- Character functions and string concatenation
- Default date and timestamp formats
- Accessing the current date and time
- Date and time arithmetic
- Date functions
- Formatting date and time output
- Conversion functions
- NVL and NVL2
- DECODE
- The simple CASE expression
- The searched CASE expression
- The ROLLUP extension
- The CUBE extension
- The GROUPING function
- The GROUPING_ID function
- The GROUPING SETS extension
- Creating tables
- Defining datatypes
- Specifying constraints
- Table, column and constraint operations
- Recovering dropped tables
- Temporary tables
- External tables
- Index-organized tables
- Handling B-tree indexes
- Creating and using views
- Creating and using sequences
- Inserting rows
- Updating rows
- Deleting rows
- Verifying updates
- Multi-table inserts
- Merging rows
- Basic transaction control
- System privileges
- User accounts and roles
- Granting and revoking object privileges
- Using synonyms
- Data dictionary tables
- Querying the data dictionary
- Useful SQL statements
If you want to find out more about Oracle Introduction for Experienced SQL Users, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from Oracle Introduction for Experienced SQL Users, please fill out the following details:
