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
What every developer should know about SQL performance
This book covers everything developers need to know about indexes and nothing more. To be more precise, the book covers the most important index type only: the B-tree index. The structure of the book is tailor made for developers; most chapters correspond to a particular part of an SQL statement.
Author(s): Markus Winand
NA Pages
Covered topics: Pros & Cons of SQL, Basic SQL Components, SELECT Statement , FROM Statement , WHERE Clause , AND OR , ORDER BY Statement , Group Functions , Primary & Foreign Keys, Cartesian Join / Simple Join, Aliases .
Author(s): NA
28 Pages
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
