SQL all-in-one for dummies /

Mostrar otras versiones (1)

The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Taylor, Allen G. (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Hoboken, New Jersey : John Wiley & Sons, Inc., [2019]
Edición:3rd edition.
Colección:--For dummies.
Temas:
SQL (Computer program language)
Relational databases.
SQL (Langage de programmation)
Bases de données relationnelles.
COMPUTERS > Programming Languages > SQL.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Book 1. SQL concepts. Understanding relational databases ; Modeling a system ; Getting to know SQL ; SQL and the relational model ; Knowing the major components of SQL ; Drilling down to the SQL nitty-gritty
  • Book 2. Relational database development. System development overview ; Building a database model ; Balancing performance and correctness ; Crating a database with SQL
  • Book 3. SQL queries. Values, variables, functions, and expressions ; SELECT statements and modifying clauses ; Querying multiple tables with subqueries ; Querying multiple tables with relational operators ; Cursors
  • Book 4. Data security. Protecting against hardware failure and external threats ; Protecting against user errors and conflicts ; Assigning access privileges ; Error handling
  • Book 5. SQL and programming. Database development environments ; Interfacing SQL to a procedural language ; Using SQL in an application program ; Designing a sample application ; Building an application ; Understanding SQL's procedural capabilities ; Connecting SQL to a remote database
  • Book 6. SQL, XML, and JSON. Using XML with SQL ; Storing XML data in SQL tables ; Retrieving data from XML documents ; Using JSON with SQL
  • Book 7. Database tuning overview. Tuning the database ; Turning the environment ; Finding and eliminating bottlenecks
  • Book 8. Appendix A: SQL: 2016 reserved words ; Appendix B: Glossary.

Ejemplares similares