ITonlinelearning Academy

Introduction

Learning Objectives

1.1 Your First SELECT Statement

1.2 Filtering with WHERE

1.3 Sorting & Limiting Results

1.4 Column Aliases & Expressions

2.1 INNER JOIN: Linking Tables Together

2.2 LEFT JOIN & Other Join Types

2.3 Aggregation with GROUP BY

2.4 Filtering Groups with HAVING

3.1 INSERT: Adding New Records

3.2 UPDATE: Changing Existing Records

3.3 DELETE: Removing Records

3.4 Transactions: Keeping Changes Safe

4.1 Finding Duplicates

4.2 Completeness & Validity Checks

4.3 Data Profiling with SQL

4.4 Building Reusable Quality Queries

Course Feedback Form