Practical Guide for Oracle SQL, T-SQL and MySQL

NOTE EDITORE

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).

SOMMARIO

Introduction to SQL and Relational Databases Brief History of SQL and Relational Databases SQL Standards Oracle, SQL Server and MySQL Versions Relational Database Basic Concepts Constraints Data Integrity Types of Relationships Summary Data Types Character Data Types Number Data Types Date Data Types Boolean Data Type Summary Installation of Oracle, SQL Server and MySQLMinimum System Requirements Installation of Oracle 12c Installation of SQL Server 2016 Installation of MySQL Server 5.7 Summary Exercise Database Development Tools Command Line Tools Installation of Oracle SQL Developer 4.3 Installation of SQL Management Studio 2016 Installation of MySQL Workbench 6.3 Summary Exercise Data Definition Language (DDL) Data Definition Language Statements Summary Exercises Data Manipulation Language (DML) Data Manipulation Language Data Control Language Summary Exercises Aggregate Functions and GROUP BY Clause Aggregate Functions GROUP BY and HAVING Clause GOUNP BY with AVG ( ) Function GROUP BY with COUNT ( ) Function GROUP BY with HAVING Condition Summary Exercises FunctionsCommon Number Functions Common String Functions Common Date and time Functions Conversion Functions Summary Exercises Advanced SQL Advanced SQL Statements Summary Exercises Joins INNER JOIN JOIN with USING Clause Joining with Multiple Tables LEFT JOIN RIGHT JOIN FULL JOIN Summary Exercise Views Creating Views in Oracle Creating Views in T-SQL Creating Views in MySQL Updating Views Summary Exercise Data Import and Export Oracle Data Export from Query Results SQL Server Data Export from Query Results MySQL Data Export from Query Results Oracle Data Import Tool SQL Server Data Import Tool MySQL Data Import Tool Summary Exercise Index

AUTORE

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.

ALTRE INFORMAZIONI

• Condizione: Nuovo
• ISBN: 9781138105188
• Dimensioni: 10 x 7 in Ø 1.16 lb
• Formato: Copertina rigida
• Illustration Notes: 256 b/w images, 27 tables and 256 line drawings
• Pagine Arabe: 190
• Pagine Romane: xii