Practical Guide for Oracle SQL, T-SQL and MySQL

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

Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.

• Programação e linguagens de script: geral
• Bases de Dados