Learn SQL with practice exercises

advertisement

Learn SQL with practice exercises 

Learn SQL with practice exercises 

Introduction – SQL - Why you should learn it

• SQL is widely used SQL – Structured Query Language – is a widely used language for working with data.
• All organizations have data, and they typically store at least some of it in a database.
• SQL is the language of databases: learning it allows you to use them effectively.

SQL can do many things

    SQL allows you to view data, analyze it, and perform calculations with it. With SQL, you can change the data stored in a database, or change the way the database itself works. SQL also lets you make rules about how data may be changed and who by. This book covers the most common use of SQL: getting data out of databases. It shows you how you to view, analyze, and report on data, which is the first step to becoming a confident SQL user, because it is the skill that lets you see what you are working with.

advertisement

Table of Contents

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
• Finding tables
• Looking at tables
• What tables are
• Rows
• Columns
• Relationships
• Technical terms

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

• Keeping things organized
• 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 Is Null Function
• Other functions

WHERE - How to get the rows you want

• Matching Values Inexactly
• Matching on calculations
• Matching text values inexactly with LIKE
• Color-coding
• Date values and literals
• Dates and times

AND / OR / NOT – How to get the rows you want more precisely

• AND - Ranges
• AND - Multiple conditions
• OR – Being flexible
• Brackets
• NOT – Saying what you don’t want
• DISTINCT - How to remove duplicates

Download full PDF in Comment section

advertisement