Skip to content

Latest commit

 

History

History

tutorial

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

Tutorial Ideas/Topics

  • Sketch up what tutorials to include and basic content of each

Beginner

Intro

  • Structured Query Language
  • What it's used for
  • Databases, tables, columns, rows, etc.

Selecting data

  • SELECT .. FROM

Filtering data

  • WHERE clause

Sorting data

  • ORDER BY clause

Aggregating data

  • GROUP BY clause

Simple calculations

Combining data sets

  • JOIN statement

Applying business logic

  • CASE function

Other useful keywords

  • DISTINCT
  • TOP
  • UNION

Intermediate

Understanding data types

Subqueries

Linking Excel to SQL Server

Temporary Tables

Advanced Skills

Pivoting Data

Data structure and design

Performance and optimization

Procedural SQL

Dynamic SQL