Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2020.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1174731395 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr ||||||||||| | ||
| 008 | 200519s2020 enk ob 001 0 eng d | ||
| 040 | |a UKMGB |b eng |e rda |e pn |c UKMGB |d OCLCO |d EBLCP |d UKAHL |d UAB |d N$T |d AFU |d OCLCF |d UMI |d YDX |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 015 | |a GBC065854 |2 bnb | ||
| 016 | 7 | |a 019807053 |2 Uk | |
| 019 | |a 1156995323 |a 1157096269 |a 1199323025 | ||
| 020 | |a 1838981705 | ||
| 020 | |a 9781838981709 |q (electronic bk.) | ||
| 020 | |z 9781838984762 |q (pbk.) | ||
| 029 | 0 | |a UKMGB |b 019807053 | |
| 029 | 1 | |a AU@ |b 000067259210 | |
| 029 | 1 | |a AU@ |b 000067299376 | |
| 035 | |a (OCoLC)1174731395 |z (OCoLC)1156995323 |z (OCoLC)1157096269 |z (OCoLC)1199323025 | ||
| 037 | |a 9781838981709 |b Packt Publishing | ||
| 050 | 4 | |a QA76.73.S67 | |
| 082 | 0 | 4 | |a 005.756 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bush, Josephine, |e author. | |
| 245 | 1 | 0 | |a Learn SQL database programming : |b query and manipulate databases from popular relational database servers using SQL / |c Josephine Bush. |
| 264 | 1 | |a Birmingham : |b Packt Publishing, |c 2020. | |
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 505 | 0 | |a 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. | |
| 588 | 0 | |a CIP data; resource not viewed. | |
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a 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 manipulating data relevant to their work-related tasks. | ||
| 504 | |a Includes bibliographical references and index. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 776 | 0 | 8 | |i Print version: |z 9781838984762 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781838984762/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH37377508 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6215709 | ||
| 938 | |a EBSCOhost |b EBSC |n 2490091 | ||
| 938 | |a YBP Library Services |b YANK |n 301311504 | ||
| 994 | |a 92 |b IZTAP | ||