Nail Your SQL Interview

Introduction

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

1. Data Definition Language Review

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

2. Data Query Language Review and Logical Operators

• 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

3. Data Manipulation Language Review

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

4. Transaction Control Language

• Creating savepoints and commits in SQL

Conclusion

• Be prepared for your interview