Practical Guide for Oracle Sql, T-Sql and Mysql

List of contents

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.

About the author

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.

Summary

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.

Product details

• Authors: Preston Zhang
• Publisher: Taylor & Francis Ltd.
• Languages: English
• Product format: Paperback / Softback
• Released: 30.09.2018
• EAN: 9781138347526
• ISBN: 978-1-138-34752-6
• No. of pages: 202
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Programming languages; COMPUTERS / Software Development & Engineering / General, COMPUTERS / Programming / General, Computer programming / software engineering, Databases, Programming & scripting languages: general, Programming and scripting languages: general, Computer Programming / Software Development, COMPUTERS / Database Administration & Management, COMPUTERS / Languages / General