ORACLE

Oracle instance is set of Oracle background processes or threads and a shared memory area, which is memory that is shared across those threads or processes running on a single computer.

500+ Students Enrolled
4.4 Rating (325) Ratings

What You'll Learn

  • Learn Become Job Ready to Start Contributing as a Database Developer Day 1.
  • Learn Program in the SQL Language to Solve a Variety of Database Problems.
  • Learn Code along with me to PRACTICE and IMPLEMENT everything you learn.
  • Learn Become a SQL Ninja and Understand How the Oracle Database Works.
  • Learn MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam.
  • Learn Obtain the Skills that are Necessary to Land a Job as a SQL Developer.

Course Content

  • Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary 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.
  • List the features of Oracle Database 11g
  • Discuss the basic design, theoretical, and physical aspects of a relational database
  • Categorize the different types of SQL statements
  • Describe the data set used by the course
  • Save queries to files and use script files in SQL Developer
  • List the capabilities of SQL SELECT statements
  • Generate a report of data from the output of a basic SELECT statement
  • Select All Columns
  • Select Specific Columns
  • Use Column Heading Defaults
  • Use Arithmetic Operators
  • Understand Operator Precedence
  • Write queries that contain a WHERE clause to limit the output retrieved
  • List the comparison operators and logical operators that are used in a WHERE clause
  • Describe the rules of precedence for comparison and logical operators
  • Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC, and MOD functions
  • Perform arithmetic with date data
  • Use the aggregation functions in SELECT statements to produce meaningful reports
  • Divide the data in groups by using the GROUP BY clause
  • Exclude groups of date by using the HAVING clause
  • Create a simple and complex view
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Describe the types of problem that sub-queries can solve
  • Define sub-queries
  • List the types of sub-queries
  • Write single-row and multiple-row sub-queries
  • Describe the SET operators
  • Use a SET operator to combine multiple queries into a single query
  • Control the order of rows returned
  • Describe each DML statement
  • Insert rows into a table
  • Change rows in a table by the UPDATE statement
  • Delete rows from a table with the DELETE statement
  • Create a simple and complex view
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes
Web Development

  This Course includes

  Tutorials

  Articles, Videos

  Full Time Lectures

  Real Scenarios

  Project Work

  Certification of Completion

Related Courses