Название: Practical Guide for Oracle SQL, T-SQL and MySQL Автор: Preston Zhang Издательство: CRC Press Год: 2017 ISBN: 9781138105188 Формат: pdf Страниц: 190 Размер: 17 mb Язык: English
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.
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
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
Внимание
Уважаемый посетитель, Вы зашли на сайт как незарегистрированный пользователь.
Мы рекомендуем Вам зарегистрироваться либо войти на сайт под своим именем.
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Комментарии пользователей