Course Oracle database: SQL Basics

Duration (days): 3
Price (CZK): 12000

Oracle database: SQL Basics topics:

• Relational Databases & SQL
• About relational databases
• Elements of SQL
• Using SQL*Plus
• About SQL*Plus
• Using the ms windows SQL*Plus tool
• Using the iS QL*Plus web tool
• Entering commands & syntax
• Building a select statement
• About the select statement
• Selecting columns
• Using alias names
• Building a where clause
• About logical operators
• Equality operator
• Boolean operators
• Null & between operators
• Finding text strings
• In operator
• Ordering the result table
• About the order by clause
• Multiple column sorts
• Specifying the sort sequence
• About null values within sorts
• Using column aliases
• Pseudo columns & functions
• About pseudo columns & functions
• Using ROWID
• Using ROWNUM
• Using the functions
• Using the dual table
• Sessiontimezone function
• Joining tables
• About joins
• Inner join
• Reflexive join
• Non-key join
• Outer join
• Using set operators
• About the set operators
• Set operator examples
• Summary functions
• About summary functions
• Summary functions with distinct
• Using subqueries
• About subqueries
• Standard subqueries
• Correlated subqueries
• Creating & selecting groups
• About summary groups
• Finding groups within the base tables
• Selecting data from the base tables
• Selecting groups from the result table
• Sql*Plus commands
• About SQL*Plus commands
• More about script files
• Invoking operating system commands
• Saving session output
• Build simple SQL*Plus reports
• About the SQL*Plus report features
• Session output with set
• Format column output with column
• Defining report breaks with break
• Produce subtotals with compute
• SQL data definition language
• About SQL DDL
• Create table statement
• Alter table statement
• Drop table statement
• Supportive statements
• SQL data manipulation language
• About SQL DML
• About the insert statement
• About the delete statement
• About the update statement
• About transactions
• Truncate table
• Complex table references
• Conclusion

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs