ArchiTech IT

Course information

Oracle DBA : Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.

Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-premises, on-cloud, or as a hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware

To migrate Oracle databases to SQL Server, you must connect to the Oracle database that you want to migrate. When you connect, SSMA obtains metadata about all Oracle schemas, and then displays it in the Oracle Metadata Explorer pane. SSMA stores information about the database server, but does not store passwords.

Your connection to the database stays active until you close the project. When you reopen the project, you must reconnect if you want an active connection to the database.

Metadata about the Oracle database is not automatically updated. Instead, if you want to update the metadata in Oracle Metadata Explorer, you must manually update it. For more information, see the "Refreshing Oracle Metadata" section later in this topic.

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