MARC Close

• LDR

  05140cam a2200553M 4500

• 001

  000000534874

• 005

  20210114163246

• 006

  m d

• 007

  cr |||||||||||

• 008

  200105s2019 xx o 000 0 eng d

• 015

  ▼a  GBC066768
  ▼2  bnb

• 016

  ▼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  248023

• 050

  ▼a  QA76.73.S67

• 082

  ▼a  005.75/6
  ▼2  23

• 100

  ▼a  FRANK SOLOMON;PRASHANTH JAYARAM;AWNI AL SAQQA.

• 245

  ▼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

  ▼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

  ▼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

  ▼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

  ▼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

  ▼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

  ▼a  SQL (Computer program language)

• 650

  ▼a  Relational databases.

• 650

  ▼a  Relational databases.
  ▼2  fast
  ▼0  (OCoLC)fst01093575

• 650

  ▼a  SQL (Computer program language)
  ▼2  fast
  ▼0  (OCoLC)fst01102869

• 655

  ▼a  Electronic books.

• 776

  ▼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

  ▼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  강리원

• 991

  ▼a  eBook

• 994

  ▼a  92
  ▼b  N$T