POWER EDUCATION | Basic SQL

POWER EDUCATION | Basic SQL

1. SQL an Introduction

1. • Select Statement
   • Building new Columns
   • Where Conditions

• Predicates (IN, BETWEEN, LIKE)

1. • Scalar Functions

• String Manipulation
• Calculation
• Date Functions

1. • Case Clause
   • NULL Values
   • Joining Tables and Views

• Inner Join – Left/Right Outer Join – Left/Right Exception Join – Full Join – Cross Join