Nail Your SQL Interview

Focused View

Nichole Pulley

1:00:16

322 View

01 - Introduction

01 - Build confidence for your SQL interview.mp4

00:56

02 - Common SQL terminology.mp4

07:08

03 - What an SQL interview is like.mp4

03:23

02 - 1. Data Definition Language Review

01 - Create and seed a table with data.mp4

05:27

02 - Modify existing tables with ALTER.mp4

04:05

03 - Working with the TRUNCATE and DROP command.mp4

05:42

03 - 2. Data Query Language Review and Logical Operators

01 - Querying the table with logical operator LIKE.mp4

06:31

02 - Querying the table with logical operators IN and BETWEEN.mp4

04:58

03 - Working with the COALESCE command.mp4

03:20

04 - Challenge End of year raises with COALESCE.mp4

01:17

05 - Solution End of year raises with COALESCE.mp4

03:10

04 - 3. Data Manipulation Language Review

01 - Update the table with UPDATE or ALTER.mp4

04:28

02 - Delete data using transactions.mp4

04:18

05 - 4. Transaction Control Language

01 - Creating savepoints and commits in SQL.mp4

03:50

06 - Conclusion

01 - Be prepared for your interview.mp4

01:43

Description

Are you looking for a new job but terrified about having to prove your skills? Worry not. A coding interview may be intimidating, but it shouldn’t stand in the way of your growth and professional development. Even if you’re new to a language like SQL, with the right preparation and the right tools, you can turn the challenge into a learning opportunity that boosts your career. Join instructor Nichole Pulley as she shows you what it takes to nail your SQL interview.

Get an overview of SQL core concepts with practical examples using basic commands. Learn about common SQL interview questions and how to prepare for them on your own. Nichole gives you tips and industry-specific pointers on what to expect when you sit down for an interview, including how to create, seed, query, and manipulate data with logical operators and Transaction Control Language commands. Along the way, you can test out your newly acquired skills on the coding challenges at the end of each section.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Coding Interview

Nichole Pulley

Instructor's Courses

Experienced Software Test Engineer, Teaching Assistant and Tutor with a demonstrated working history in the educational field, non-profit sector as well as computer software industry. Strong research professional skilled in C#||SQL||MVC||.NET, English language learning tutor, and yoga instructor for hire.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.