ABSTRACT

SQL is a widely used to access most databases, therefore database developers and system administrators should be familiar with it. This hands-on SQL book will help beginner and intermediate users to write queries that apply complex conditions on a table. The book's unique side by side approach makes it easy for the reader to learn three major query languages in the IT industry. The author has over 20 years of experience in database design.

KEY FEATURES:

  • Contains numerous practical screenshots of Oracle SQL, T-SQL, MySQL statements and results.
  • Shows the differences between Oracle SQL, T-SQL and MySQL side by side.
  • Gives a real world experience for SQL developers and database administrators.
  • Sample data is available to work on (available on our website).

chapter 2|4 pages

Data Types

chapter 4|13 pages

Database Development Tools

chapter 5|18 pages

Data Definition Language (DDL)

chapter 6|24 pages

Data Manipulation Language (DML)

chapter 7|9 pages

Aggregate Functions and GROUP BY Clause

chapter 8|24 pages

Functions

chapter 9|15 pages

Advanced SQL

chapter 10|9 pages

Joins

chapter 11|9 pages

Views

chapter 12|20 pages

Data Import and Export

chapter 13|9 pages

Stored Procedures