Oracle Database 19c: SQL Workshop
Gain a thorough command of SQL on Oracle Database 19c.
About this course
Gain a thorough command of SQL on Oracle Database 19c. You will retrieve, filter and sort data, apply single-row, conversion and aggregate functions, and combine tables with joins, subqueries and set operators. From there you move on to changing data and controlling transactions, creating tables, constraints, views, sequences, synonyms and indexes, and exploring the data dictionary.
What you'll learn
- Retrieve data using SELECT, filtering, sorting, and formatting output
- Use SQL functions, joins, and subqueries for data analysis
- Create and manage views, indexes, sequences, and synonyms
- Perform DML and manage transaction control
- Control access and work with time zone–aware data types
Curriculum
- Syntax, expressions, operators
- Column aliases, arithmetic expressions
- WHERE clause filters
- Order By
- Text, number, date functions
- Function nesting
- To_char, To_date, Nvl, Coalesce
- Case, Decode
- Count, Avg, Sum, Min, Max
- Group By, Having
- Inner, outer, self joins
- ANSI and Oracle syntax
- Single-row, multiple-row, correlated subqueries
- Exists, In, Not in
- Union, Intersect, Minus
- Insert, Update, Delete
- Commit, Rollback
- Create, Alter, Drop
- Table/column constraints
- User_tables, All_tables
- Metadata overview
- Auto-increment values
- Access simplification, performance optimization
- Simple/complex views
- Managing updatable views
- Dropping, renaming, truncating objects
- Modifying columns, constraints
- Complex subquery patterns
- GRANT, REVOKE, roles
- System/object privileges
- MERGE, multi-table INSERT
- Time zone-aware types
- Formatting/conversions
Who it's for
Developers, analysts, report writers and aspiring DBAs who need solid SQL skills on Oracle.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Oracle Database →Oracle Database 19c: PL/SQL
Oracle Database
View course →Oracle Access Management 12c: Administration Essentials
Oracle Database
View course →Oracle Database 19c: Administration Workshop
Oracle Database
View course →Oracle Database 19c: Advanced PL/SQL
Oracle Database
View course →Oracle Database 19c: Backup and Recovery
Oracle Database
View course →Oracle Database 19c: Data Guard Administration Workshop
Oracle Database
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.