- What is SQL and How is it Used?
- NTC Hosting: Structured Query Language (it's worth exploring this site, not just this singular posting)
- The Star Schema
- The Snowflake Schema
- Star Schema vs. Snowflake Schema
- What is data modeling – An Introduction for Business Analysts
- Data Modeling 101
- Dataconomy: SQL vs. NoSQL - What You Need to Know
- TechRepublic: NoSQL keeps rising, but relational databases still dominate big data
- SiliconRepublic: Data Science Skills: Is NoSQL Better than SQL?
- What is difference between SQL, SQL*PLUS, PL/SQL
- Oracle - Database Administrator's Guide
- Oracle - Database Performance Tuning Guide
- Oracle / PLSQL: Oracle Error Messages
- Oracle PL/SQL Technet
- Oracle Dual Table
- System Tables
- Anonymous Block
- Oracle DB Naming Conventions
- DBMS_OUTPUT and SET SERVEROUTPUT ON
- Oracle / PLSQL: Comments within SQL
- Pseudocolumns
- DESCRIBE Command
- Subprograms
- Union vs Union All
- BETWEEN
- Oracle Data Types
- Declaring variables
- %TYPE Attribute
- PL SQL Delimiters
- Scope Rules
- Bind Variables
- PGA(Program Global Area)
- CREATE TABLE Statement
- CREATE TABLE AS Statement
- ALTER TABLE Statement
- DROP TABLE Statement
- TRUNCATE TABLE Statement
- VIEW
- Indexes
- SELECT Statement
- INSERT Statement
- DELETE Statement
- DISTINCT Statement
- WHERE Clause
- AND, OR and NOT Operators
- Operators
- IN Operator
- NULL Values
- Operator Precedence
- LIKE Operator
- ORDER BY Keyword
- Aliases
- || Concatenation Operator
- BETWEEN Operator
- EXISTS Condition
- Joins
- MINUS Operator
- Oracle / PLSQL: Oracle Error Messages
- Overview of PL/SQL Run-Time Error Handling
- Exception types
- Reraising a PL/SQL Exception
- Handling Raised PL/SQL Exceptions
- Overview of PL/SQL Compile-Time Warnings
- SQLCODE
- SQLERRM
- RAISE_APPLICATION_ERROR
- Using PL/SQL Subprograms
- Developing and Using Stored Procedures
- Using Single-Row Functions
- SQL Server Functions
- What is a Package?
- Reasons to Use Packages
- Package Specification
- Package Body
- Package Instantiation and Initialization
- Package State
- SERIALLY_REUSABLE Packages
- Package Writing Guidelines
- Package Example
- How STANDARD Package Defines the PL/SQL Environment
- PL/SQL Optimizer
- Candidates for Tuning
- Minimizing CPU Overhead
- Bulk SQL and Bulk Binding
- Chaining Pipelined Table Functions for Multiple Transformations
- Updating Large Tables in Parallel
- Collecting Data About User-Defined Identifiers
- Profiling and Tracing PL/SQL Programs
- Compiling PL/SQL Units for Native Execution