,
,Table of Contents
Answers
Table of Contents
Copyright
Disclaimer
Introduction – SQL - Why you should learn it
SQL is widely used
SQL can do many things
SQL skills are transferable
Learning SQL is simple
Microsoft SSMS – How to get free SQL software
The big picture
What to download
Where to download it from
Choosing between 32-bit and 64-bit
Completing the download
Installing
Northwind – How to get a free database to practice on
The big picture
Download your database
Install your database
Connect to your database in SMSS
Tables – What’s in a database
Introduction
Finding tables
Looking at tables
What tables are
Rows
Columns
Relationships
Technical terms
, The next step
SELECT – How to query (get data from) a database table
Making New Queries
The Query
The explanation
Linked answers
How to get specific columns
A note on how this book formats queries
SELECT - How to do calculations within rows
Introduction
An example
Keeping things organised
A note on units of currency
More math - operators
Constants
SELECT without FROM
Modulus
Brackets
Text Strings
String literals
String literals with AS
Functions
Null
The IsNull Function
Other functions
The next step
WHERE - How to get the rows you want
Matching values
Comments
Case
Clauses
,Table of Contents
Answers
Table of Contents
Copyright
Disclaimer
Introduction – SQL - Why you should learn it
SQL is widely used
SQL can do many things
SQL skills are transferable
Learning SQL is simple
Microsoft SSMS – How to get free SQL software
The big picture
What to download
Where to download it from
Choosing between 32-bit and 64-bit
Completing the download
Installing
Northwind – How to get a free database to practice on
The big picture
Download your database
Install your database
Connect to your database in SMSS
Tables – What’s in a database
Introduction
Finding tables
Looking at tables
What tables are
Rows
Columns
Relationships
Technical terms
, The next step
SELECT – How to query (get data from) a database table
Making New Queries
The Query
The explanation
Linked answers
How to get specific columns
A note on how this book formats queries
SELECT - How to do calculations within rows
Introduction
An example
Keeping things organised
A note on units of currency
More math - operators
Constants
SELECT without FROM
Modulus
Brackets
Text Strings
String literals
String literals with AS
Functions
Null
The IsNull Function
Other functions
The next step
WHERE - How to get the rows you want
Matching values
Comments
Case
Clauses