Cargando…
SQL WORKSHOP;A NEW, INTERACTIVE APPROACH TO LEARNING SQL
Cut through the noise and get real results with a step-by-step approach to learning SQL.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
PACKT Publishing,
2019.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000M 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_on1134853935 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr ||||||||||| | ||
| 008 | 200105s2019 xx o 000 0 eng d | ||
| 040 | |a YDX |b eng |c YDX |d OCLCQ |d EBLCP |d TEFOD |d OCLCF |d UKAHL |d UKMGB |d N$T |d OCLCO |d K6U |d OCLCQ |d OCLCO |d TMA |d OCLCL |d OCLCQ | ||
| 015 | |a GBC066768 |2 bnb | ||
| 016 | 7 | |a 019669289 |2 Uk | |
| 019 | |a 1134853487 | ||
| 020 | |a 1838649085 |q (electronic bk.) | ||
| 020 | |a 9781838649081 |q (electronic bk.) | ||
| 029 | 1 | |a UKMGB |b 019669289 | |
| 035 | |a (OCoLC)1134853935 |z (OCoLC)1134853487 | ||
| 037 | |a 25CBEC6B-54EE-4FE3-AD8A-327153EAF876 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.73.S67 | |
| 082 | 0 | 4 | |a 005.75/6 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a FRANK SOLOMON;PRASHANTH JAYARAM;AWNI AL SAQQA. | |
| 245 | 1 | 0 | |a SQL WORKSHOP;A NEW, INTERACTIVE APPROACH TO LEARNING SQL |
| 260 | |a [Place of publication not identified] |b PACKT Publishing, |c 2019. | ||
| 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 Cover -- FM -- Copyright -- Table of Contents -- Preface -- Chapter 1: SQL Basics -- Introduction -- Understanding Data -- An Overview of Basic SQL Commands -- Creating Databases -- The Use of Semicolons -- Data Types in SQL -- Creating Simple Tables -- Exercise 1.01: Building the PACKT_ONLINE_SHOP Database -- Populating Your Tables -- Exercise 1.02: Inserting Values into the Customers Table of the PACKT_ONLINE_SHOP Database -- Activity 1.01: Inserting Values into the Products Table in the PACKT_ONLINE_SHOP Database -- Summary -- Chapter 2: Manipulating Data -- Introduction | |
| 505 | 8 | |a The INSERT Operation -- Performing a Simple INSERT -- Exercise 2.01: Inserting One Row of Data into a Table -- Multiple Inserts -- Exercise 2.02: Specifying Default Values -- Using an INSERT Statement to Add Data from Another Dataset -- The DELETE Operation -- Exercise 2.03: Deleting a record from a table -- The ALTER Operation -- Exercise 2.04: Manipulating the Auto-Increment Values in a Table -- The UPDATE Operation -- The Basic UPDATE Statement -- ALIASING -- Conditional Update of Records -- Limiting the Records Using an UPDATE Statement -- Exercise 2.05: UPDATE Using Computed Values | |
| 505 | 8 | |a The DROP Operation -- Activity 2.01: Inserting Additional values to the Products table -- Summary -- Chapter 3: Normalization -- Introduction -- Primary Key Constraints -- Foreign Key Constraints -- Preserving Data Integrity -- Types of Data Integrity -- The Concept of Normalization -- First Normal Form (1NF) -- Second Normal Form (2NF) -- Third Normal Form (3NF) -- Denormalization -- Exercise 3.01: Building a Relationship between Two Tables -- Activity 3.01: Building a Relationship between the Orders and the OrderItems table -- Summary -- Chapter 4: The SELECT Statement -- Introduction | |
| 505 | 8 | |a What Does the SELECT Statement Do? -- Retrieving All Columns of a Table -- Selecting Limited Columns -- Exercise 4.01: Selecting Columns from a Table -- Using Naming Aliases -- Exercise 4.02: Aliasing the Column Headers -- Activity 4.01: Displaying Particular Columns from the Table -- Ordering Results -- Ordering Rows According to a Particular Column -- Ordering Rows According to Multiple Columns -- Using LIMIT -- Exercise 4.03: Using the LIMIT Keyword -- Using DISTINCT -- Using Mathematical Expressions -- Exercise 4.04: Calculating the Line Item Total -- Exercise 4.05: Calculating Discount | |
| 505 | 8 | |a Activity 4.02: Extracting the Top Five Highest Priced Items -- Summary -- Chapter 5: Shaping Data with the WHERE Clause -- Introduction -- The WHERE Clause Syntax -- Exercise 5.01: Implementing Logical Operators in the WHERE Clause -- Exercise 5.02: Using the BETWEEN Operator -- The Not Equal Operator -- Exercise 5.03: Using the!= and Operators -- The LIKE Operator -- Exercise 5.04: Using the LIKE Operator to Check a Pattern at the Beginning of a String -- Exercise 5.05: Using the LIKE Operator to Check for a Specified Length -- Checking for NULLS -- Exercise 5.06: Searching for NULL Values | |
| 520 | |a Cut through the noise and get real results with a step-by-step approach to learning SQL. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 758 | |i has work: |a The SQL Workshop (Text) |1 https://id.oclc.org/worldcat/entity/E39PCXVypBChHBtxFpR6MCpRTd |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Solomon, Frank. |t SQL Workshop : A New, Interactive Approach to Learning SQL. |d Birmingham : Packt Publishing, Limited, ©2019 |z 9781838642358 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=6002333 |z Texto completo |
| 938 | |a YBP Library Services |b YANK |n 301036820 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH37098045 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6002333 | ||
| 938 | |a EBSCOhost |b EBSC |n 2340737 | ||
| 994 | |a 92 |b IZTAP | ||