This is personal study note Copyright and original reference: https://www.youtube.com/watch?v=_ODY0tQwTe8&list=PLVsNizTWUw7HhYtI-4GGmlJ5yxNdwNI_X ================================================================================ In database, there are other components aside from table, such as, index, stored procedure, trigger, function, cursor, etc ================================================================================ Create table ================================================================================ Insert data into table (indexTBL) by using data from emplyees (db) employees (table) ================================================================================ ================================================================================ When you use WHERE, search is done by "full table scan" "full table scan" means that if there is 500 records, 500 records are searched to find one queried record ================================================================================ Create index with respect to indexTBL.first_name Run select again Non-unique key lookup (by using index) ================================================================================ View: virtual table ================================================================================ Create view with respect to memberTBL Actually, when part time worker runs SELECT * FROM uv_memberTBL; following statement is executed SELECT memberName, memberAddress FROM memberTBL; ================================================================================ Stored procedure Programming functions in MySQL ================================================================================ Run 2 statements ================================================================================ Create stored procedure