This note explains the following topics: Structured Query Language, Advanced SQL, PLSQL, Control Structures, Stored Procedures, Dynamic SQL.
Author(s): University of Mumbai
273 Pages
Introduction to SQL by Phil Spector
This note covers the following topics: Multiple simultaneous changes to data, Uses of Databases, Ways to Use SQL, Some Relational Database Concepts ,Variable Types, CREATE TABLE statement, Entering observations into a table, Comparison Operators, Updating a Table , The SELECT statement, Selecting based on Summaries, Subqueries, Making Tables from Queries, SELECT with multiple tables.
Author(s): Phil Spector
165 Pages
