| LDR | | 05140cmm u2200553M 4500 |
| 001 | | 000000317506 |
| 003 | | OCoLC |
| 005 | | 20230525182742 |
| 006 | | m d |
| 007 | | cr ||||||||||| |
| 008 | | 200105s2019 xx o 000 0 eng d |
| 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.) |
| 035 | |
▼a 2340737
▼b (N$T) |
| 035 | |
▼a (OCoLC)1134853935
▼z (OCoLC)1134853487 |
| 037 | |
▼a 25CBEC6B-54EE-4FE3-AD8A-327153EAF876
▼b OverDrive, Inc.
▼n http://www.overdrive.com |
| 040 | |
▼a YDX
▼b eng
▼c YDX
▼d OCLCQ
▼d EBLCP
▼d TEFOD
▼d OCLCF
▼d UKAHL
▼d UKMGB
▼d N$T
▼d 248032 |
| 049 | |
▼a MAIN |
| 050 | 4 |
▼a QA76.73.S67 |
| 082 | 04 |
▼a 005.75/6
▼2 23 |
| 100 | 1 |
▼a FRANK SOLOMON;PRASHANTH JAYARAM;AWNI AL SAQQA. |
| 245 | 10 |
▼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 Master record variable field(s) change: 050, 082, 650 - OCLC control number change |
| 650 | 0 |
▼a SQL (Computer program language) |
| 650 | 0 |
▼a Relational databases. |
| 650 | 7 |
▼a Relational databases.
▼2 fast
▼0 (OCoLC)fst01093575 |
| 650 | 7 |
▼a SQL (Computer program language)
▼2 fast
▼0 (OCoLC)fst01102869 |
| 655 | 4 |
▼a Electronic books. |
| 776 | 08 |
▼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 | 40 |
▼3 EBSCOhost
▼u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2340737 |
| 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 |
| 990 | |
▼a 관리자 |
| 994 | |
▼a 92
▼b N$T |