Introduction To Structured Query Language (SQL) Part 1
This note covers the following topics: relational databases overview, SQL overview, dml data retrieval select statement examples, dml data retrieval select statement criteria, sql for select exercises with criteria, ddl create table statement from existing table, ddl create table statement with column definitions, ddl create table statement syntax, dml insert statement, ddl create index statement, ddl alter table statement, ddl drop statement, dml update statement, dml delete statement.
Author(s): NA
NA Pages 
This note explains the following topics: Basic Sql Statements, Restricting and Sorting, Join Statements, Multiple Column Subqueries, isqlPlus, Types of Sql Functions, Character Functions, Number Functions, Single Row Numeric Functions, Row Functions, Subqueries, Conversion Functions, Union, Alter Table and Create Table.
Author(s): Technology Promotion Center, Ankara, TR
NA 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
