learnscart

Section Intro

Install SSDT Templates

Install SQL Server Data Tools

Visual Studio workloads

Install Visual Stuio

Installation Requirements

What is Visual Studio

Install Sample AdventureworksDW Database

Install Sample Adventureworks Database

Connect SSMS to SQL Server

Operator Precedence

BitWise Operators

Logical Operators with Non-Booleans

Logical Operators with Non-booleans

Ternary Operators

Equality Operators

Comparison Operators

Assignment Operators

Arithmetic Operators

Index and Match Functions

Other LOOKUP Functions

V Lookup and H Lookup

Working with AND, OR, NOT Functions

Working with IF and Related Functions

Valuating Investment with FV (Future Value) Function (Part 1)

Valuating Investment with FV (Future Value) Function (Part 2)

Valuating Investment with NPER (Number of Periods) Function (Part 1)

Valuating Investment with NPER (Number of Periods) Function (Part 2)