Learn from Scratch
Home
AWS
Computer Layer EC2
Creating an Apache server in AWS
Creating EC2 from AWS CLI
AWS CLI Output Formats
Storage S3
Uploading/Downloading file in S3 from AWS CLI
AWS S3 Policy to Make a Bucket Public
Elasticity, High Availability
Database Layer
Networking Layer
Identity and Access Management
Caching
Atomation
Microservices and Serverless Architecture
Monitoring Services
Building Decoupled Architectures
Disaster Planning and Recovery Option
Oracle SQL
DQL
Retrieving Data
Restricting and Sorting Data
Single Row Functions
Group By Clause
Set Operator
Subqueries
Oracle Join
Group By Clause
Group By, Rollup, Cube
Date & Timezone
Data Definition Language
Altering a table
Data Dictionary Views
View, Index, Sequence, Synonym
User Creation and Privilege
Subqueries
Hierarchical Queries
Regular Expression: Regex
DML
DCL
TCL
Oracle PLSQL
Introduction to PLSQL
Declaring Variables
Composite Datatypes
Execution Section
Interaction with Server
Collections
Writing SQL Statements
Cursor
Exception Section
Stored Procedures
Packages
Triggers
Autonomous Transactions
Menu
DQL (Select)
Home
DQL (Select)
