Practical Guide for Oracle SQL, T-SQL and MySQL
1st Edition
Published on 9. November 2017
Book
Hardback
202 pages
978-1-138-10518-8 (ISBN)
Description
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).
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).
More details
Language
English
Place of publication
London
United Kingdom
Publishing group
Taylor & Francis Ltd
Target group
College/higher education
Illustrations
256 s/w Abbildungen, 256 s/w Zeichnungen, 27 s/w Tabellen
27 Tables, black and white; 256 Line drawings, black and white; 256 Illustrations, black and white
Dimensions
Height: 254 mm
Width: 178 mm
Weight
530 gr
ISBN-13
978-1-138-10518-8 (9781138105188)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Preston Zhang
Practical Guide for Oracle SQL, T-SQL and MySQL
Book
08/2018
1st Edition
CRC Press
€84.36
Shipment within 10-20 days
Preston Zhang
Practical Guide for Oracle SQL, T-SQL and MySQL
E-Book
11/2017
CRC Press
€72.49
Available for download
Preston Zhang
Practical Guide for Oracle SQL, T-SQL and MySQL
E-Book
11/2017
CRC Press
€72.49
Available for download
Person
Preston Zhang has over 20 years of experiences in Oracle, SQL Server and MySQL database system. He works for the University of Georgia as a database administrator and has been a faculty member at Grand Canyon University, where he taught business programming and database structures. He obtained Master of Science degree in Computer Information Systems from University of Wisconsin-Parkside. His research interests including programming, database systems and SQL language.
Content
Introduction to SQL and Relational Databases. Data Types. Installation of Oracle, SQL Server and MySQL. Database Development Tools. Data Definition Language (DDL). Data Manipulation Language (DML). Aggregate Functions and GROUP BY Clause. Functions. Advanced SQL. Joins. Views. Data Import and Export. Index.