LitArk » Books » Home and family

Julian Phillips - SQL Stepping Stones For SQL Server

Here you can read online Julian Phillips - SQL Stepping Stones For SQL Server full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2021, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Book:
SQL Stepping Stones For SQL Server
Author:
Julian Phillips
Genre:
Books / Home and family
Year:
2021
Rating:
3 / 5
Favourites:
Add to favourites
Your mark:
- 60
- 1
- 2
- 3
- 4
- 5

Description
Author's other books
Similar books

SQL Stepping Stones For SQL Server: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "SQL Stepping Stones For SQL Server" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Aims Of The BookDo you need to know SQL? Perhaps it has become part of your job. You might have used it a little in the past. Maybe you have tweaked other peoples scripts without quite understanding what was going on.This book is aimed at anyone who needs to quickly feel confident with applying the key SQL principles .Book ContentIt has 6 chapters on the main topics. Each one has demonstration scripts and around 10 exercises for you to test yourself. All these chapters use the same specially created database.Extra ExercisesHaving covered all the main topics, you can move on to a further chapter, for a different specially created database, with 100-plus exercises to consolidate your knowledge.

Database Scripts

The scripts that create the 2 databases are at the end of the book and are also available as a download from the designated web address.

Julian Phillips: author's other books

Who wrote SQL Stepping Stones For SQL Server? Find out the surname, the name of the author of the book and a list of all author's works by series.

SQL Stepping Stones For SQL Server — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "SQL Stepping Stones For SQL Server" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Reset

Interval:

↓

↑

Bookmark:

Make

SQL Stepping Stones Contents

Introduction

What Is In This Book

This book covers the basics of SQL, the version that goes with Microsoft SQL Server, and which is also called Transact-SQL or T-SQL. It provides the steps you need to become a competent and confident user of the SQL language.

Examples And Exercises

There is a chapter for each main topic, starting with the most basic, giving examples and exercises to test yourself, at each stage. The examples are for the SQLBasics database. Other versions of this database are used, under different names, by a variety of books and websites. One of the best-known websites is probably SQL Tutorial (w3schools.com) .

However, it does not use T-SQL so not everything in this book will work there.

Extra Exercises

In addition to the exercises within each topic, there is a chapter of exercises only, using another database, the SQLBasicsPlus database, enabling you to test yourself on each main topic, but with another dataset.

Exercise Solutions

There is a chapter with the answers to all the exercises from both databases.

Database Creation Scripts

You can download these scripts from the web address http://amble-wood.com/downloads . These scripts are also in the Database Creation Scripts chapter at the end of this book.

Installing Microsoft SQL Server Management Studio

Microsoft SQL Management Studio is the tool you should use to create and manage your SQL scripts.

Installing Microsoft SQL Server Management Studio

Microsoft SQL Management Studio is the tool you should use to create and manage your SQL scripts.

If, necessary, you can install it, using a free download from the web address https://docs.microsoft.com/en-gb/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 .

The SQLBasics Database

Data Diagram

Data Relationships

Parent Table	Primary Key	Child Table	Foreign Key
CATEGORIES	categoryid	PRODUCTS	categoryid
SUPPLIERS	supplierid	PRODUCTS	supplierid
SHIPPERS	shipperid	ORDERS	shipperid
EMPLOYEES	employeeid	ORDERS	employeeid
CUSTOMERS	customerid	ORDERS	customerid
PRODUCTS	productid	ORDERDETAILS	productid
ORDERS	orderid	ORDERDETAILS	orderid

Data Tables

Shippers
Column Name	Data Type
shipperid	number
shippername	text
phone	text

Categories
Column Name	Data Type
categoryid	number
categoryname	text
description	text

Suppliers
Column Name	Data Type
supplierid	number
suppliername	text
description	text
contactname	text
address	text
city	text
postalcode	text
country	text
phone	text

Customers
Column Name	Data Type
customerid	number
customername	text
contactname	text
address	text
city	text
postalcode	text
country	text

Employees
Column Name	Data Type
employeeid	number
firstname	text
lastname	text
birthdate	date
photo	text

Products
Column Name	Data Type
productid	number
productname	text
supplierid	number
categoryid	number
unit	text
price	number

Orders
Column Name	Data Type
orderid	number
customerid	number
employeeid	number
orderdate	date
shipperid	number

Orderdetails
Column Name	Data Type
orderdetailid	number
orderid	number
productid	number
quantity	number

Database Description

The SQLBasics database is for a company that buys food products from its suppliers and then sells them to its customers. Each customer places an order for various products. An employee looks after the order and sends its contents to the customer, using a shipper. Each item in the PRODUCTS table is for a particular category within the CATEGORIES table and comes from a particular supplier within the SUPPLIERS table. Each item in the ORDERS table is received by a particular customer within the CUSTOMERS table, is handled by a particular employee within the EMPLOYEES table and is sent via a particular shipper within the SHIPPERS table.

Each item in the ORDERDETAILS table is part of a particular order in the ORDERS table and relates to a particular product in the PRODUCTS table.

Basic SQL Syntax

Basic SQL Statement

All Columns

The following retrieves all the data from the CATEGORIES table. The columns are in the order used when the table was created. Select * From categories

Some Columns

The following retrieves a list of names and descriptions. The columns are in the same order that you write them. Select categoryname, description From categories

Arithmetic Filtering Operators

Filtering With Equal

The following retrieves only customers who are in Berlin.

Select customername, city
From customers Where city = 'Berlin'

Filtering With Less Than

The following retrieves only products with a price less than 10. Select productname, price
From products
Where price < 10

Filtering With Greater Than

The following retrieves only employees born after 1960. Select firstname, lastname, birthdate
From employees
Where birthdate > '1960-12-31'

Filtering With Not Equal

The following are three ways of showing products that are not in category 1. Select productname, categoryid From products Where categoryid != 1 Select productname, categoryid
From products
Where categoryid <> 1 Select productname, categoryid From products Where Not categoryid =

The BETWEEN Operator

With Numbers

The following retrieves only products with a price in the range 75 to 125 inclusive. Select productname, price From products Where price Between 75 And 125

With Dates

The following retrieves only employees born between 1st January 1961 and 31st December 1970 inclusive. Select firstname, lastname, birthdate From employees Where birthdate Between '1961-01-01' And '1970-12-31'

Light

Font size:

↓

↑

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «SQL Stepping Stones For SQL Server»

Look at similar books to SQL Stepping Stones For SQL Server. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

Ian Abramson

Oracle Database 12c: Install, Configure & Maintain Like a Professional

Michael McLaughlin

Oracle Database 11g & MySQL 5.6 Developer Handbook

Ahmad Osama

Professional Azure SQL Managed Database Administration: Efficiently manage and modernize data in the cloud using Azure SQL, 3rd Edition

Feiler

Introducing SQLite for Mobile Developers

Date

Database in depth: relational theory for practitioners

Juba Salahaldin

Learning PostgreSQL: create, develop, and manage relational databases in real-world applications using PostgreSQL

Adrian W. West

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

Dusan Petkovic

Microsoft SQL Server 2019: A Beginner’s Guide

Chris Fehily

SQL (Database Programming)

Mike McGrath

PHP 7 in easy steps

Adrian W. West

Practical PHP and MySQL Website Databases: A Simplified Approach

Mike Gunderloy

Absolute Beginners Guide to Microsoft Office Access 2003

Reviews about «SQL Stepping Stones For SQL Server»

Discussion, reviews of the book SQL Stepping Stones For SQL Server and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.