Last Update On:23-12-2024

Oracle DB SQL

Oracle Database SQL
SQL forms the cornerstone of all relational database operations. The ability to write the SQL language is essential for those who develop database applications. This course provides a solid foundation of the SQL programming language that enables students to build, query and manipulate databases.
COURSE CONTENT:
INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL)
• Explain the relationship between a database and SQL
• Describe the purpose of DDL
• Describe the purpose of DML
• Build a SELECT statement to retrieve data from an Oracle Database table RESTRICTING AND SORTING DATA
• Use the ORDER BY clause to sort SQL query results
• Limit the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at runtime USING SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT
• Use various types of functions available in SQL
• Use character, number, and date and analytical functions in SELECT statements USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS
• Describe various types of conversion functions that are available in SQL
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Apply conditional expressions in a SELECT statement REPORTING AGGREGATED DATA USING THE GROUP FUNCTIONS
• Describe the use of group functions
• Group data by using the GROUP BY clause

• Include or exclude grouped rows by using the HAVING clause DISPLAYING DATA FROM MULTIPLE TABLES
• Describe the different types of joins and their features
• Use SELECT statements to access data from more than one table using equijoins and nonequijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by using outer joins USING SUBQUERIES TO SOLVE QUERIES
• Define subqueries
• Describe the types of problems subqueries can solve
• Describe the types of subqueries
• Query data using correlated subqueries
• Update and delete rows using correlated subqueries
• Use single-row and multiple-row subqueries USING THE SET OPERATORS
• Describe set operators
• Use a set operator to combine multiple queries into a single query
• Control the order of rows returned MANIPULATING DATA
• Truncate data
• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions USING DDL STATEMENTS TO CREATE AND MANAGE TABLES
• Describe data types that are available for columns
• Create a simple table
• Create constraints for tables
• Drop columns and set column UNUSED
• Create and use external tables

CONTROLLING USER ACCESS
• Differentiate system privileges from object privileges
• Grant privileges on tables and on a user
• Distinguish between privileges and roles MANAGING SCHEMA OBJECTS
• Describe how schema objects work
• Create simple and complex views
• Create, maintain and use sequences
• Create and maintain indexes including invisible indexes and multiple indexes on the same columns
• Perform flashback operations MANAGING OBJECTS WITH DATA DICTIONARY VIEWS
• Using data dictionary views MANAGING DATA IN DIFFERENT TIME ZONES
• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types