The SQL Workshop : a New, Interactive Approach to Learning SQL.: a New, Interactive Approach to Learning SQL. (2019)

• Record Type: Book
• Other Names: Solomon, Frank; Jayaram, Prashanth; Saqqa, Awni Al
• Contents: 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 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 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 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 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
• Publisher Details: Birmingham : Packt Publishing, Limited
• Publication Date: 2019
• Extent: 1 online resource (285 pages)
• Subjects: 005.75/6; SQL (Computer program language); Relational databases; Relational databases; SQL (Computer program language); Electronic books
• Languages: English
• ISBNs: 9781838649081; 1838649085
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.