Zhang Practical Guide for Oracle SQL, T-SQL and MySQL

Erscheinungsjahr 2017
ISBN: 978-1-351-59037-2
Verlag: Taylor & Francis
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 202 Seiten

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

Autoren/Hrsg.

Zhang, Preston

Fachgebiete

• Mathematik | Informatik EDV | Informatik Daten / Datenbanken
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmier- und Skriptsprachen
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Software Engineering

Inhaltsverzeichnis

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

Über Autor(innen)

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.