SQL Ebook

SQL (Structured Query Language) is the standardised language for database management systems. SQL is the best way to get fast answers out of a database.

This SQL ebook introduces basic and advanced SQL usage with working examples and applications. The implementation of embedded SQL within Powerbuilder 10 is also discussed. Here are some example of what you can do with SQL:

Create a database
Create and modify database table structures
Retrieve data from multiple tables in a database
Perform calculations and data manipulation
Update table data

So if you want to learn SQL here is your chance.

A good place to start is our free sql trial ebook. I want the free SQL Trial Ebook

We also offer our main SQL Ebook for 10.95USD. To get this book, simply follow this link:

Main SQL Ebook

The main book is now available to registered members of our Joomla PHP Site.

To provide you with more information we have summarized the contents of this SQL book:

SUMMARY OF CONTENTS - SQL Ebook

SQL Basics.

Brief History
SQL definitions
SQL Ansi
DDL and DML
SQL syntax
Data and Metadata
Table schemas
SQL Methodology

SQL - setting up a database and tables

Creating a database
Creating tables - Create Table Statement
Data load; Data Import

Data Definition Language (DDL)

DDL Commands - create,alter,drop,truncate
Create table statement
Drop table statement
Alter table statement
Truncate table statement
Creating and modifying tables

Database Design

Codd's principles
Advantages of RDBMSs
Data normalization
Data redundancies
Data dependancies and partial dependancies
Denormalization of data
Set processing

Introduction to Data Query Language - SQL select statement

Select all | distinct
The select list
The into variable list (embedded SQL)
The from table clause
The where condition
The count function
The like operator
The % wildcard

SQL DataTypes

String: character, variable character eg:
- country_code char(5)
- country_name varchar(50)
Numeric data types
- decimal
- double
- float
- integer
- money
- numeric
- smallint
Date and Timestamp
Binary data types
Domain data types

Data Queries - multiple tables

Creating and populating additional tables
The sum function
Using aliases
The group by clause
Natural table joins
join ON keyword
Order by clause
Using correlation names
The having clause
Top and Start keyword
Set operators
- Union
- Intersect
- Except
Table join examples
SQL comments

SQL Functions

Aggregate functions
- AVG (average of the result set)
- COUNT [distinct] (count rows / groups in result set)
- MAX (maximum value in result set
- MIN (minimum value in result set)
- SUM (total of a column in the result set)
Data Type conversions
- Cast
- IsDate
- Isnumeric
Date and Time functions
- Date
- DateAdd
- DateDiff
- DateName
- DatePart
- Day
- DayName
- DOW
- GetDate
- MonthName
- Year
Numeric functions
String fuctions
Column and table aliases

SQL Select Statement

	select [all | disinct] select-list | * 
	into variable-list from
	[outer] table-name [table-name,…]
	[where condition]
	[group by column-list][having condition]
	[order by column-list][asc|desc]

Specifying where conditions (search conditions)
Embedded sql variables
Combining conditions
Boolean and | or
IN and BETWEEN clauses
Pattern matching - Like keyword - % wildcard
Order by ASC | DESC
Using aggregate functions
Embedded SQL examples
Using the HAVING clause
Table joins
- inner join
- left outer join
- full outer join
SQL nested select statements: sub-queries
- structure of a subquery
- subquery examples

SQL Stored Procedures

Stored Procedure dialects
- Transact-SQL (T-SQL)
- Watcom SQL
Programming Constructs
- Sequence
- Iteration (looping)
- Selection (choose)
Create procedure
Alter procedure
Call procedure
Drop procedure
Stored procedure examples using T-SQL

Common Table Expressions (CTE)

SQL WITH Clause
Reference temporary result sets
CTE examples
Multiple aggregate functions
Recursive queries

SQL Transactions

Logic unit of work
Data integrity
Data modification statements
- Insert
- Update
- Delete
Begin transaction
SQL Rollback
SQL Commit
Implicit and explicit transcation

SQL Cursors

Manipulating data - row by row
Cursor positions
Using cursors in embedded SQL
- declare cursor
- open cursor
- fetch cursor
- close cursor
Navigating a cursor

Embedded SQL

Placing SQL in procedural languages
Embedded SQL in C++
Embedded SQL in Powerscipt (Powerbuilder)
Static and Dynamic SQL
- Embedded SQL
- Dynamic SQL
- Four dynamic formats

Advanced SQL examples

String manipulation
Testing conditions - SQL group by | having
Using SQL RollUp
Querying from different objects
Combining aggregate functions
Table Joins
- Cartesion product join
- Self joins
- Natural join
- Outer Joins
- Joining multiple tables
Nested queries
SQL Views
Create View, alter view, drop view
Derived tables

SQL Command | Statement Reference

Alter
Backup,Begin
Call, Case, Close, Connect, Commit, Create
Declare, Delete, Disconnect, Drop
Except, Execute, End
Fetch
Grant
If, Insert, Intersect
Load, Lock, Loop
Prepare
Raiserror, Restore, Return, Revoke, Rollback
Select, Set
Truncate
Union, Unload, Update
Whenever, While

Static and Dynamic SQL

Embedded SQL
Dynamic SQL
Four dynamic formats

SQL Error Codes

SQLcode
SQLErrText

How to get this SQL ebook

To purchase this book for 10.95 USD just follow this link to a secure payment processor

We also offer this SQL ebook as a free bonus if you purchase or have purchased our

Powerbuilder ebook.

Then you just need to send an email to RDS Ebooks to claim your bonus SQL ebook.

SQL EBook

The main book is now available to registered members of our Joomla PHP Site.