Nail Your SQL Interview

Get quick tips and coding techniques to nail your SQL interview and take your programming career to the next level.

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