By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

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


  •    
    Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit