-
Introduction to MySQL (1 Hour)
- Overview of SQL and its importance.
- Introduction to MySQL, installation, and setup.
- Basic commands and environment familiarity.
-
First View of Data (1 Hour)
- Understanding the MySQL interface.
- Navigating through the MySQL environment.
- Viewing and exploring sample datasets.
-
Understanding Databases, Tables, and Rows (1 Hour)
- What is a Database?
- The concept of Tables and Rows.
- Practical example of creating a simple database.
-
Data Types and Expressions (1 Hour)
- Introduction to SQL Data Types.
- Understanding expressions in SQL.
- Examples and use cases.
-
Assignment (2/2)
- Practical exercises on MySQL setup, database creation, and exploring data.
- Simple tasks to familiarize students with data types and basic commands.
Total Duration: 4 Hours
-
Creation of Table (1 Hour)
- Understanding Data Definition Language (DDL).
- Syntax and examples of creating tables.
- Practical exercise on creating a table with various data types.
-
Modifying the Structure of a Table (1 Hour)
- ALTER TABLE statement.
- Adding, modifying, and deleting columns.
- Real-world scenarios of table modification.
-
Dropping a Table (0.5 Hour)
- DROP TABLE statement.
- Consequences and best practices.
- Example and cautionary advice.
-
INSERT Statement (0.5 Hour)
- Understanding Data Manipulation Language (DML).
- Syntax and examples of the INSERT statement.
- Inserting data into tables with practical examples.
-
UPDATE Statement (0.5 Hour)
- Syntax and examples of the UPDATE statement.
- Updating records based on conditions.
- Practical exercises.
-
DELETE Statement (0.5 Hour)
- Syntax and examples of the DELETE statement.
- Deleting records based on conditions.
- Practical exercises and best practices.
-
Constraints (0.5 Hour)
- Understanding constraints (Primary Key, Foreign Key, Unique, etc.).
- Implementing constraints during table creation.
- Practical examples and exercises.
-
Assignment (5/1)
- Practical tasks on creating, modifying, and managing tables.
- Exercises on inserting, updating, and deleting data.
- Implementing constraints in real-world scenarios.
Total Duration: 4 Hours
-
SELECT Statement (1 Hour)
- Understanding Data Query Language (DQL).
- Syntax and practical examples of SELECT.
- Querying data from tables with various conditions.
-
WHERE Clause Search Condition (0.5 Hour)
- Applying conditions to queries.
- Using the WHERE clause with various operators.
- Practical examples and exercises.
-
Arithmetic, Comparison, and Logical Operators (0.5 Hour)
- Using operators within SQL queries.
- Practical examples of combining operators with the WHERE clause.
-
Range Operator (0.5 Hour)
- Understanding and using the BETWEEN operator.
- Practical examples and exercises.
-
List Operator (0.5 Hour)
- Using the IN operator in SQL.
- Examples of querying data within a list of values.
-
LIKE Operator (0.5 Hour)
- Using the LIKE operator for pattern matching.
- Practical examples with wildcard characters.
-
Using ORDER BY, DISTINCT, and TOP (0.5 Hour)
- Sorting results with ORDER BY.
- Removing duplicates with DISTINCT.
- Limiting results with TOP.
- Practical exercises and examples.
-
Using IS NULL and IS NOT NULL (0.5 Hour)
- Querying for NULL values.
- Practical examples and scenarios.
-
CASE Statement (0.5 Hour)
- Conditional logic within SQL queries using CASE.
- Practical examples and exercises.
-
Assignment (14/0)
- Practical tasks on querying data with various conditions.
- Exercises on using operators, pattern matching, and sorting.
- Real-world scenarios for data extraction.
Total Duration: 4 Hours
- Comprehensive assessment covering:
- SQL Setup and Basics.
- Database and Table creation, modification, and control.
- Data Querying and retrieval.
- The assessment will consist of:
- Multiple choice questions.
- Practical SQL queries.
- Real-world problem-solving scenarios.