Practical Guide for Oracle SQL, T-SQL and MySQL

Practical Guide for Oracle SQL, T-SQL and MySQL

by Preston Zhang

Paperback(Reprint)

$160.00
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Thursday, February 21

Product Details

ISBN-13: 9781138347526
Publisher: Taylor & Francis
Publication date: 08/28/2018
Edition description: Reprint
Pages: 190
Sales rank: 1,006,435
Product dimensions: 7.00(w) x 10.00(h) x (d)

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.

Table of Contents

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 MySQL
Minimum 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

Functions
Common 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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews