| LDR | | 05567cmm u22005531i 4500 |
| 001 | | 000000317801 |
| 003 | | OCoLC |
| 005 | | 20230525183424 |
| 006 | | m d |
| 007 | | cr ||||||||||| |
| 008 | | 200519s2020 enk o 000 0 eng d |
| 015 | |
▼a GBC065854
▼2 bnb |
| 016 | 7 |
▼a 019807053
▼2 Uk |
| 019 | |
▼a 1157096269 |
| 020 | |
▼a 1838981705 |
| 020 | |
▼a 9781838981709
▼q (electronic bk.) |
| 020 | |
▼z 9781838984762 (pbk.) |
| 035 | |
▼a 2490091
▼b (N$T) |
| 035 | |
▼a (OCoLC)1174731395
▼z (OCoLC)1157096269 |
| 037 | |
▼a 9781838981709
▼b Packt Publishing |
| 040 | |
▼a UKMGB
▼b eng
▼e rda
▼e pn
▼c UKMGB
▼d OCLCO
▼d EBLCP
▼d UKAHL
▼d UAB
▼d N$T
▼d 248032 |
| 049 | |
▼a MAIN |
| 050 | 4 |
▼a QA76.73.S67 |
| 082 | 04 |
▼a 005.756
▼2 23 |
| 100 | 1 |
▼a Bush, Josephine,
▼e author. |
| 245 | 10 |
▼a Learn SQL database programming :
▼b query and manipulate databases from popular relational database servers using SQL /
▼c Josephine Bush. |
| 260 | |
▼a Birmingham :
▼b Packt Publishing,
▼c 2020. |
| 300 | |
▼a 1 online resource |
| 336 | |
▼a text
▼2 rdacontent |
| 337 | |
▼a computer
▼2 rdamedia |
| 338 | |
▼a online resource
▼2 rdacarrier |
| 500 | |
▼a Table of ContentsIntroduction to Relational Database Management SystemsInstalling and Using MySQL WorkbenchUnderstanding Data TypesDesigning and Creating a DatabaseImporting and Exporting DataQuerying a Single TableQuerying Multiple TablesModifying Data and Table StructuresWorking with ExpressionsGrouping and Summarizing DataAdvanced Querying TechniquesProgrammable ObjectsExploring and Processing Your DataTell a Story with Your DataBest Practices for Design and QueryingSQL Appendix. |
| 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. |
| 588 | |
▼a Description based on CIP data; resource not viewed. |
| 590 | |
▼a Master record variable field(s) change: 050 |
| 650 | 0 |
▼a SQL (Computer program language) |
| 650 | 0 |
▼a Database management. |
| 655 | 4 |
▼a Electronic books. |
| 776 | 08 |
▼i Print version:
▼z 9781838984762 |
| 856 | 40 |
▼3 EBSCOhost
▼u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2490091 |
| 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 |
| 990 | |
▼a 관리자 |
| 994 | |
▼a 92
▼b N$T |