Course Details
SQL
Coursee Description
Module 1: Introduction to Databases and SQL • What are databases and their importance • Introduction to relational databases • Understanding SQL and its role in database management • Basic SQL commands (SELECT, INSERT, UPDATE, DELETE) Module 2: Creating and Modifying Tables • Creating databases and tables • Specifying data types for table columns • Adding and dropping columns • Defining primary keys and foreign keys Module 3: Querying Data with SELECT • Retrieving data from a single table using SELECT • Using WHERE clause for filtering data • Sorting results with ORDER BY • Limiting results with LIMIT Module 4: Querying Multiple Tables with Joins • Understanding table joins (INNER JOIN, LEFT JOIN, RIGHT JOIN) • Using aliases for table and column names • Handling NULL values with OUTER JOINs • Combining multiple tables in a single query Module 5: Data Filtering and Manipulation • Filtering data with various conditions (AND, OR, NOT) • Using aggregate functions (SUM, AVG, COUNT, MIN, MAX) • Grouping data with GROUP BY • Filtering grouped data with HAVING Module 6: Modifying Data with INSERT, UPDATE, and DELETE • Inserting data into tables with INSERT INTO • Updating existing records with UPDATE • Deleting data from tables with DELETE Module 7: Data Constraints and Transactions • Understanding data constraints (NOT NULL, UNIQUE, CHECK, DEFAULT) • Defining primary keys and foreign keys • Introduction to database transactions and ACID properties Module 8: Working with Views • Creating and using views in SQL • Modifying and dropping views