0% completed

All LessonsFree Lessons (3)

Get Started

CRUD Operations

Question: Insert a Record Answer: Insert a Record Question: Update a Value Answer: Update a Value Question: Delete a Record Answer: Delete a Record

Aggregate Functions

Question: Aggregate Records Using SUM Answer: Aggregate Records Using SUM Question: Aggregate Records Using AVG Answer: Aggregate Records Using AVG Question: Aggregate Records Using MIN/MAX Answer: Aggregate Records Using MIN/MAX Question: Aggregate Records Using COUNT Answer: Aggregate Records Using COUNT

Date and Time Functions

Question: Extract a Value From a Date Answer: Extract a Value From a Date Question: The DATE Column and Calculations Answer: The DATE Column and Calculations

Filtering

Question: Filter with the WHERE Clause Answer: Filter with the WHERE Clause Question: Filter with the LIKE Operator Answer: Filter with the LIKE Operator

Grouping

Question: The GROUP BY Clause and the AVG Function Answer: The GROUP BY Clause and the AVG Function Question: The GROUP BY Clause and the SUM Function Answer: The GROUP BY Clause and the SUM Function

Sorting

Question: Sorting the Records Answer: Sorting the Records Question: Sorting and Calculations Answer: Sorting and Calculations

Constraints

Question: The NOT NULL Constraint Answer: The NOT NULL Constraint Question: The UNIQUE Constraint Answer: The UNIQUE Constraint Question: The PRIMARY KEY Constraint Answer: The PRIMARY KEY Constraint Question: The FOREIGN KEY Constraint Answer: The FOREIGN KEY Constraint

Working with JOINs

Question: Using LEFT JOIN Answer: Using LEFT JOIN Question: Using RIGHT JOIN Answer: Using RIGHT JOIN Question: Using INNER JOIN Answer: Using INNER JOIN Question: Combining JOIN Statements Answer: Combining JOIN Statements

Subquery

Question: Subquery in the SELECT Clause Answer: Subquery in the SELECT Clause Question: Subquery and Calculations Answer: Subquery and Calculations

Final Remarks

Practice Mock Interview

SQL Interview Preparation/

...

/

Conclusion

Conclusion

Review what you have learned in this course.

We'll cover the following...

Advanced topics
Next steps
Feedback

Congratulations on completing this course! We hope your interview preparation has gone well and you enjoyed the content.

Press + to interact

In this course, we have covered interview questions related to the following topics:

Data types and operators
CRUD
Functions: aggregate, date, time
Clauses
Subqueries
Aliases ...