Medpace Interview Questions and Answers

Yes, I have experience with SQL.

• Proficient in writing complex SQL queries

• Experience with database design and normalization

• Familiar with stored procedures and triggers

I completed internships at two different software companies, where I gained hands-on experience in software development.

• Internship at Company A focused on front-end development using React and JavaScript

• Internship at Company B involved working on back-end systems using Java and SQL

• Learned about Agile development practices and collaborated with cross-functional teams

• Developed and tested software applications under the g

Different types of joins in SQL

• Inner join: returns only the matching rows from both tables

• Left join: returns all rows from the left table and the matching rows from the right table

• Right join: returns all rows from the right table and the matching rows from the left table

• Full outer join: returns all rows from both tables, including non-matching rows

• Cross join: returns the Cartesian product of both tables