Learn SQL database programming : query and manipulate databases from popular relational database servers using SQL /

SQL is a powerful querying language used to store, manipulate, and retrieve data. This is a comprehensive guide for who are new to SQL, which will have you up-to-speed and using SQL to streamline your work in no time. It gives users enough confidence to use SQL queries for retrieving and manipulatin...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bush, Josephine (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, 2020.
Temas:
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données > Gestion.
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Table of Contents; Introduction to Relational Database Management Systems; Installing and Using MySQL Workbench; Understanding Data Types; Designing and Creating a Database; Importing and Exporting Data; Querying a Single Table; Querying Multiple Tables; Modifying Data and Table Structures; Working with Expressions; Grouping and Summarizing Data; Advanced Querying Techniques; Programmable Objects; Exploring and Processing Your Data; Tell a Story with Your Data; Best Practices for Design and Querying;SQL; Appendix.
  • Cover
  • Title Page
  • Copyright and Credits
  • About Packt
  • Contributors
  • Table of Contents
  • Preface
  • Section 1: Database Fundamentals
  • Chapter 1: Introduction to Relational Database Management Systems
  • Understanding SQL
  • Elements of SQL
  • Understanding databases
  • Tables
  • Fields
  • Records or rows
  • Columns
  • Understanding data integrity
  • Types of integrity
  • Entity integrity
  • Unique constraints
  • Not null constraints
  • The primary key
  • Referential integrity
  • Domain integrity
  • Database normalization
  • The first normal form
  • The second normal form
  • The third normal form
  • Types of RDMS
  • Oracle
  • MySQL
  • SQL Server
  • PostgreSQL
  • RDMS SQL differences
  • Summary
  • Questions
  • Chapter 2: Installing and Using MySQL Workbench
  • Technical requirements
  • Installing MySQL Workbench
  • Installing on Windows
  • Installing MySQL on Windows
  • Configuring MySQL on Windows
  • Installing on Mac
  • Installing MySQL Server on Mac
  • Checking the status of MySQL Server on Mac
  • Installing MySQL Workbench on Mac
  • Using MySQL Workbench
  • Connecting to your local instance
  • Connecting to another instance or setting up your local instance
  • Restoring a database
  • Summary
  • Questions
  • Chapter 3: Understanding Data Types
  • Understanding string data types
  • String data types in MySQL
  • MySQL string data type table summary
  • String data types in other RDMS
  • Oracle
  • PostgreSQL
  • SQL Server
  • String data types RDMS table comparison
  • Understanding numeric data types
  • Numeric data types in MySQL
  • MySQL numeric data type table summary
  • Numeric data types in other RDMSes
  • SQL Server
  • Oracle
  • PostgreSQL
  • Numeric data types table comparison
  • Understanding date and time data types
  • Date and time data types in MySQL
  • MySQL date and time data type table summary
  • Date and time data types in other RDMSes
  • Oracle
  • PostgreSQL
  • SQL Server
  • Date and time data types table comparison
  • Understanding other data types
  • Other data types in MySQL
  • Other data types in other RDMSes
  • Oracle
  • PostgreSQL
  • SQL Server
  • Choosing the right data type
  • Examples of choosing a data type
  • Summary
  • Questions
  • Chapter 4: Designing and Creating a Database
  • Technical requirements
  • Creating a database
  • Guidelines for naming conventions
  • Avoiding keywords
  • Avoiding spaces
  • Descriptive and accurate naming
  • Case and separating words
  • Allowed characters when naming database objects
  • Learning how to create a database
  • Creating a database via the MySQL Workbench interface
  • Creating a database via MySQL Workbench with a SQL script
  • Understanding SQL code errors
  • Understanding table relationships
  • Understanding entity-relationship diagrams
  • Understanding one-to-one table relationships
  • Understanding one-to-many table relationships
  • Understanding many-to-many table relationships
  • Creating a table in the database

Ejemplares similares