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
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
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
Comparison of different SQL implementations (T. Arvin)
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Learning SQL Using phpMyAdmin (Marc Delisle)
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
PagesAdvertisement
