Description |
1 online resource |
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 |
Summary |
Cut through the noise and get real results with a step-by-step approach to learning SQL. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
SQL (Computer program language)
|
|
Relational databases.
|
|
Relational databases |
|
SQL (Computer program language) |
Other Form: |
Print version: Solomon, Frank. SQL Workshop : A New, Interactive Approach to Learning SQL. Birmingham : Packt Publishing, Limited, ©2019 9781838642358 |
ISBN |
1838649085 (electronic bk.) |
|
9781838649081 (electronic bk.) |
|