Excel Functions & SQL Insert, Delete Query

Excel- More Functions

More Functions in Excel

In the following 2 videos, learn how to modify basic functions like SUM(), COUNT() and AVERAGE() to perform operations that meet specific criteria.

SQL- Inserting & Deleting Records

INSERT INTO Query

SQL is all about writing queries to extract and modify data in the databases. We will focus mainly on practicing different queries in the following sections.

DELETE Query

Practice more SQL

To brush up on SQL queries, practice from "SQL Delete" to "SQL Like" sections.

Data in Action

Practice Exercises