Nail Your SQL Interview

Introduction

• Build confidence for your SQL interview
• Common SQL terminology
• What an SQL interview is like

• Create and seed a table with data
• Modify existing tables with ALTER
• Working with the TRUNCATE and DROP command

• Querying the table with logical operator LIKE
• Querying the table with logical operators IN and BETWEEN
• Working with the COALESCE command
• Challenge: End of year raises with COALESCE
• Solution: End of year raises with COALESCE

• Update the table with UPDATE or ALTER
• Delete data using transactions

• Creating savepoints and commits in SQL

• Be prepared for your interview