SQL — Full Course Syllabus

Learn SQL to effectively manage and query relational databases for backend development.

1. 1. SELECT StatementThe SQL command used to select data from a database.
2. 2. WHERE clauseA clause used to filter records in a SQL query based on specified conditions.
3. 3. ORDER BY clauseA clause that specifies the order in which the result set of a query is returned.
4. 4. INSERT StatementThe SQL command used to insert new records into a table.
5. 5. CREATE TABLE StatementThe SQL command used to create a new table in the database.
6. 6. SQL Data TypesThe various types of data that can be stored in a SQL database, such as INT, VARCHAR, DATE.
7. 7. GROUP BY clauseA clause that groups rows sharing a property so aggregate functions can be applied.
8. 8. JOIN operationA SQL operation that combines rows from two or more tables based on a related column.
9. 9. INNER JOINA type of join that returns rows when there is a match in both tables.
10. 10. LEFT JOINA type of join that returns all rows from the left table and matched rows from the right table.
11. 11. RIGHT JOINA type of join that returns all rows from the right table and matched rows from the left table.
12. 12. FULL OUTER JOINA type of join that returns all rows when there is a match in either left or right table.
13. 13. UPDATE StatementThe SQL command used to modify existing records in a table.
14. 14. DELETE StatementThe SQL command used to remove records from a table.
15. 15. ALTER TABLE StatementThe SQL command used to modify an existing table structure.
16. 16. DROP TABLE StatementThe SQL command used to delete a table and its data from the database.
17. 17. PRIMARY KEYA unique identifier for a record in a table, ensuring no duplicate entries.
18. 18. FOREIGN KEYA field in one table that uniquely identifies a row of another table, establishing a relationship.
19. 19. INDEXA database object that improves the speed of data retrieval operations on a table.
20. 20. SQL FunctionsBuilt-in functions in SQL that perform operations on data, such as COUNT, SUM, AVG.
21. 21. HAVING clauseA clause used to filter records after an aggregation has been performed.
22. 22. UNION operatorAn operator that combines the result sets of two or more SELECT statements.
23. 23. CASE StatementA conditional expression that returns values based on specified conditions in a SQL query.
24. 24. ViewsA virtual table based on the result set of a SQL query, providing a way to simplify complex queries.
25. 25. SubqueryA query nested inside another SQL query, used to perform operations on the result of the outer query.
26. 26. TransactionsA sequence of one or more SQL operations that are executed as a single unit of work.
27. 27. ACID propertiesThe set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable transactions.
28. 28. Stored ProceduresA set of SQL statements that can be stored and reused to perform a specific task.
29. 29. TriggersProcedures that are automatically executed in response to certain events on a particular table.