Nail Your SQL Interview
1hBeginner2022-04-19
Authors
Nichole Pulley
Experienced Software Test Engineer and Online English Tutor
Course details
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.
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.
Skills covered
Hiring and InterviewingSQLDatabase AdministrationJob SearchingDatabase DevelopmentDatabase ManagementCareer DevelopmentData AnalysisHuman ResourcesProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Build confidence for your SQL interview
- 02 - Common SQL terminology
- 03 - What an SQL interview is like
1. Data Definition Language Review
- 04 - Create and seed a table with data
- 05 - Modify existing tables with ALTER
- 06 - Working with the TRUNCATE and DROP command
2. Data Query Language Review and Logical Operators
- 07 - Querying the table with logical operator LIKE
- 08 - Querying the table with logical operators IN and BETWEEN
- 09 - Working with the COALESCE command
- 10 - Challenge - End of year raises with COALESCE
- 11 - Solution - End of year raises with COALESCE
3. Data Manipulation Language Review
- 12 - Update the table with UPDATE or ALTER
- 13 - Delete data using transactions
4. Transaction Control Language
- 14 - Creating savepoints and commits in SQL
Conclusion
- 15 - Be prepared for your interview
Related courses
- Human Resources: Writing an Effective Job Description
- Interviewing a Job Candidate for Recruiters
- Interviewing Techniques for Hiring Managers
- Five Questions to Never Ask in Your Next Job Interview
- Employee Engagement: Making Sustainability Part of Everybody’s Job
- Creating a Great Candidate Experience
- How AI in Hiring Can Expand Economic Opportunity - with Aneesh Raman and Papia Debroy
- Interview Mistakes You Can’t Take Back