Skip to Main Content
The SQL Workshop
book

The SQL Workshop

by Frank Solomon, Rakesh Kumar Pandey, Shubham Jain, Prashanth Jayaram, Awni Al Saqqa, Fiodar Sazanavets, Aaditya Pokkunuri, Shashikant Shakya, Dixit Patel, Pradeep Kumar Gupta, Scott Cosentino
December 2019
Beginner content levelBeginner
288 pages
4h 48m
English
Packt Publishing
Content preview from The SQL Workshop

Appendix

About

This section is included to assist the students to perform the activities present in the book. It includes detailed steps that are to be performed by the students to complete and achieve the objectives of the book.

1. SQL Basics

Activity 1.01: Inserting Values into the Products Table in the PACKT_ONLINE_SHOP Database

Solution:

  1. Create the Products table with the same column names that were provided in the Excel spreadsheet:

    use packt_online_shop;

    CREATE TABLE Products

    (

        ProductID INT NOT NULL,

        ProductCategoryID INT NOT NULL,

        SupplierID INT NOT NULL,

        ProductName CHAR(50) NOT NULL,

        NetRetailPrice DECIMAL(10, 2) NULL,

        AvailableQuantity INT NOT NULL,

        WholesalePrice DECIMAL(10, 2) NOT NULL,

        UnitKGWeight DECIMAL(10, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Business Users

SQL for Business Users

O'Reilly Media, Inc.
SQL Antipatterns

SQL Antipatterns

Bill Karwin

Publisher Resources

ISBN: 9781838642358Supplemental Content