Become an Σxpert at Σxcel.com
|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 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