Introduction to SQL (Record no. 14156)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 02574nam a22009617a 4500 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | OSt |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20231110085507.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m|||||o||d| 00| 0 |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr || auc||a|a |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 210831s2020 ||||s ||| 000 0 eng d |
| 040 ## - CATALOGING SOURCE | |
| Transcribing agency | QCPL |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| 9 (RLIN) | 2399 |
| Personal name | Iliev, Bobby |
| Relator term | author |
| 245 10 - TITLE STATEMENT | |
| Title | Introduction to SQL |
| Statement of responsibility, etc. | / Bobby Iliev |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | [Place of publication not identified] : |
| Name of producer, publisher, distributor, manufacturer | Bobby Iliev, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2020 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (96 pages) |
| 336 ## - CONTENT TYPE | |
| Source | rdacontent |
| Content type term | text |
| 337 ## - MEDIA TYPE | |
| Source | rdamedia |
| Media type term | computer |
| 338 ## - CARRIER TYPE | |
| Source | rdacarrier |
| Carrier type term | online resource |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Databases |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Tables and columns |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | MySQL |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Installing MySQL |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Accessing MySQL via CLI |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Creating a database |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Configuring .my.cnf |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | The mysqladmin command |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | GUI clients |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Tables |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Data types |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Creating a database |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Creating tables |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Dropping tables |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Allowing NULL values |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Specifying a primary key |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Updating tables |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Basic syntax |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | INSERT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | SELECT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | UPDATE |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | DELETE |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Comments |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Conclusion |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | SELECT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | SELECT all columns |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Formatting |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | SELECT specific columns only |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | LIMIT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | COUNT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | MIN, MAX, AVG, and SUM |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | DISTINCT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Conclusion |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | WHERE |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | WHERE Clause example |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Operators |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | AND keyword |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | OR keyword |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | LIKE operator |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | IN operator |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | IS operator |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Conclusion |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Sorting with ORDER and GROUP by |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | ORDER BY |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | GROUP BY |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | INSERT |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Inserting multiple records |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | UPDATE |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | DELETE |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | JOIN |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Cross join |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Inner join |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Left join |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Right join |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Conclusion |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | The MySQL dump command |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Exporting a Database |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Exporting all databases |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Automated backups |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | SQL (Computer program language) |
| 655 ## - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books |
| 690 ## - LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN) | |
| Topical term or geographic name as entry element | Computers & technology |
| 856 ## - ELECTRONIC LOCATION AND ACCESS | |
| Host name | unglue.it |
| Uniform Resource Identifier | https://unglueit-files.s3.amazonaws.com/ebf/b698a9a6042b416db78f987caf65cf86.pdf |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Dewey Decimal Classification |
| Koha item type | eBook (Free & Open Access) |
| Library use only | Collection code | Permanent Location | Current Location | Date acquired | Source of acquisition | Koha item type |
|---|---|---|---|---|---|---|
| Circulation | Accessible online | Accessible online | 08/31/2021 | Open access | eBook (Free & Open Access) |