expertatexcel.com

Database (SQL)

Most of the Jobs I worked at required database or SQL skills.

A database is a collection of data into tables to store information.

All top websites use a database.

There are 4 main actions you take on a database which can go by the acronyms:

Add Browse Change Delete (ABCD)

Create Read Update Delete (CRUD)

These are set based operations as they operate on multiple data at the same time.

The Structured Query Language (SQL) statements to do these functions are:

Add - Insert into table (Field1, field2, field3) values ('abcd',1234,'some more info')

Browse - Select * from table where field1 = 'abcd'

Change - Update table set field1 = 'xyz' where field1 = 'abcd'

Delete - Delete from table where field1 = 'xyz'

A few other concepts to learn are:

Creating objects like Tables, Views, Stored Procedures

SQL Joins

SQL Indexes

SQL Stored Procedures

SQL Case When statement

From Excel we will learn to:

Run SQL statements

Create a SQL User Interface using VBA

Connect to a database

SQL Injection Attacks