Codesnout Home

SQL Basics Tutorial

Excel Pivot Table Tutorial

This SQL Tutorial will teach you how to utilise SQL using our easy to follow examples.

codesnout.com teaches you SQL in it's unique 3 section style.

• Section 1 - Syntax (What does the SQL look like.)
• Section 2 - What does it do
• Section 3 - Examples

SQL Basics

• SQL Home
• SQL Intro
• SQL SELECT
• SQL DISTINCT
• SQL WHERE
• SQL Wildcards
• SQL AND OR
• SQL IN
• SQL BETWEEN
• SQL LIKE
• SQL ORDER BY
• SQL GROUP BY
• SQL TOP

SQL Create and Change

• SQL ALIAS
• SQL DELETE
• SQL INSERT
• SQL UPDATE
• SQL CREATE DATABASE
• SQL CREATE TABLE
• SQL ALTER

SQL Joins

• SQL INNER JOIN
• SQL FULL JOIN
• SQL LEFT JOIN
• SQL RIGHT JOIN
• SQL UNION
• SQL CONSTRAINTS
• SQL NOT NULL

SQL Functions

• Aggregate Functions
• SQL SUM
• SQL AVG
• SQL COUNT
• SQL MAX
• SQL MIN
• SQL FIRST
• SQL LAST
• SQL GROUP BY
• SQL HAVING
• SQL LIMIT

SQL Data Types

• Microsoft Access Data Types
• MySQL Data Types
• SQL Server Data Types

ASCII for HTML Reference

• ASCII HTML Reference Sheet

The Excel Pivot Table tutorial will show you the basics of Pivot Table reports using our easy to follow examples.

Excel Pivot Table Basics

• Overview
• Step 1: Organise Raw Data
• Step 2: Create Pivot Table
• Step 3: Customise Pivot Table
• Refresh Pivot Table
• Print Pivot Table
• Show Pivot Table Toolbar

Sort Pivot Tables

• Sorting Pivot Tables
• Autosort Pivot Tables
• Pivot Tables: Keyboard Shortcuts