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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: FRANK SOLOMON;PRASHANTH JAYARAM;AWNI AL SAQQA
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Place of publication not identified] PACKT Publishing, 2019.
Temas:
SQL (Computer program language)
Relational databases.
SQL (Langage de programmation)
Bases de données relationnelles.
Relational databases
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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

Ejemplares similares