Nail Your SQL Interview

Go to class
Write Review

Free Online Course: Nail Your SQL Interview provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Nail Your SQL Interview is taught by Nichole Pulley.

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

Syllabus
  • 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