ORACLE PROGRAMMING AND DBA

SQL


Introduction to SQL
  • Introduction to SQL
  • SQL Developer
  • Logging in SQL*Plus
  • Connecting to Database on windows and Linux
SQL languages- DDL, DML, TCL, DCL
  • Database Objects
  • CREATE TABLE statement
  • Data types
  • Overview of constraint
  • Creating a table using subquery
  • Use the ALTER TABLE statement to add, modify, and drop a column
  • DROP TABLE statement
Accessing Data using Queries
  • Select Statements
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • DESCRIBE command
Restricting and Sorting Data
  • Sorting rows using ORDER BY clause
  • SQL row limiting clause in a query
Using Single-Row Functions to Customize Output
  • 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
  • Manipulate dates with the date functions
Working on Constraints
  • Managing constraints
  • TYPES of Constraints
  • ON DELETE Cascade option
Using the SET Operators
  • Set Operators
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations
Using Conversion Functions and Conditional Expressions
  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Conditional Expressions
Reporting Aggregated Data Using the Group Functions
  • Group Functions
  • Grouping Rows (GROUP BY and HAVING clause)
  • Nesting Group Functions
Displaying Data From Multiple Tables Using Joins
  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • OUTER join
  • Cartesian Joins / Cross Joins
Using Subqueries to Solve Queries
  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries
Dictionary Views
  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary views
    • DBMS_metadata
    • User_source
    • User_views
  • Querying the Data Dictionary Views
Views, Sequences and Synonyms
  • Why Views
  • View TYPES
  • Sequences and its use
  • Using Synonyms
External tables & DBMS_Error
  • SQL*Loader
  • Loading data from excel / text files to tables
  • DBMS_ErrorLog
  • External tables
Indexes
  • Types of Indexes
  • Binary Tree
  • Bit Map
User access control
  • Grant/Revoke privileges to other users
  • With GRANT Option
  • Objects Vs System Privileges
TimeZone
  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  • Working with INTERVAL data types
  • Using Datetime functions in queries

Next Course

RELATED VIDEOS

Example of Embedding YouTube Video inside Bootstrap Modal

Enrolled Students

8565

Education Awards

120

Certified Teachers

193

Library and Labs

150