Real-world SQL and PL/SQL : advice from the experts /

"This hands-on guide from Oracle Press shows how to fully exploit lesser known but extremely useful SQL and PL/SQL features--and how to effectively use both languages together. Written by a team of Oracle ACE Directors, Real-World SQL and PL/SQL: Advice from the Experts features best practices,...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Nanda, Arup (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2017]
Edición:1.
Colección:Online access with DDA: Askews (Maths)
Temas:
Oracle (Computer file)
PL/SQL (Computer program language)
Relational databases.
PL/SQL (Langage de programmation)
Bases de données relationnelles.
COMPUTERS > Database Management > General.
Relational databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Machine generated contents note: Part 1: The Importance of SQL, PL/SQL and a Good Data Model
  • Chapter 1: SQL, PL/SQL and When to Use Which
  • Chapter 2: Expert Data Modeling and Implementing Business Logic Part 2: Underutilized Advanced SQL Functionality
  • Chapter 3: Handling Advanced and Complex Datasets
  • Chapter 4: Regular Expressions
  • Chapter 5: Edition Based Redefinition Part 3: Essential Everyday Advanced PL/SQL
  • Chapter 6: Running PL/SQL in SQL
  • Chapter 7: Instrumenting, Profiling and Debugging PL/SQL
  • Chapter 8: Dynamic SQL
  • Chapter 9: PL/SQL for Database Management Part 4: Advanced Analytics
  • Chapter 10: In-Database Data Mining Using Oracle Data Mining
  • Chapter 11: Oracle R Enterprise
  • Chapter 12: Predictive Queries Part 5: Database Security
  • Chapter 13: Redaction and masking
  • Chapter 14: Encryption and hashing
  • Chapter 15: SQL Injection & Code Security
  • Chapter 16: Virtual Private Databases (VPD).

Ejemplares similares