Practical Guide for Oracle SQL, T-SQL and MySQL
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.
- 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).
Table of Contents
Introduction to SQL and Relational Databases
Brief History of SQL and Relational Databases
Oracle, SQL Server and MySQL Versions
Relational Database Basic Concepts
Types of Relationships
Character Data Types
Number Data Types
Date Data Types
Boolean Data Type
Installation of Oracle, SQL Server and MySQL
Minimum System Requirements
Installation of Oracle 12c
Installation of SQL Server 2016
Installation of MySQL Server 5.7
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
Data Definition Language (DDL)
Data Definition Language Statements
Data Manipulation Language (DML)
Data Manipulation Language
Data Control Language
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
Common Number Functions
Common String Functions
Common Date and time Functions
Advanced SQL Statements
JOIN with USING Clause
Joining with Multiple Tables
Creating Views in Oracle
Creating Views in T-SQL
Creating Views in MySQL
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
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.
To gain access to the instructor resources for this title, please visit theÂ Instructor Resources Download Hub.
You will be prompted to fill out a registration form