| 1. SQL Overview |
| · Introduction |
| · SQL process |
| · Characteristics of SQL |
| · SQL Command |
| · Data Definition Language |
| · Data Manipulation Language |
| · Transaction Control Language |
| · Creating a Table |
| · What is SQL? |
| · History of SQL |
| · Advantages of SQL |
| · SQL Commands and Statements |
| 2. SQL Data Types |
| · Data Types |
| · Oracle Data Types |
| 3. SQL Operators |
| · What is SQL Operator? |
| · Types of Operator |
| · SQL Arithmetic Operators |
| · SQL Comparison Operators |
| · SQL Logical Operators |
| · SQL Set Operators |
| · SQL Bit-wise Operators |
| · SQL Unary Operators |
| 4. CREATE Database |
| · Create Database statement in SQL |
| 5. SQL Table |
| · SQL CREATE TABLE |
| · TABLE Variable |
| 6. SQL Select statement |
| · SELECT statement |
| · Select Distinct |
| · Select Count |
| · Select Random |
| · Advantage of SQL SELECT |
| · SELECT from Multiple Tables |
| 7. SQL Clause |
| · SQL AND & OR |
| · The AND Operator |
| · Select as |
| 8. SQL ORDER by clause with ascending order |
| 9. SQL ORDER by random |
| · Database table |
| · Using a RANDOM function in the SQL ORDER BY clause |
| · SQL Server |
| 10. SQL index |
| · Why SQL Index? |
| · Create an INDEX |
| · Create UNIQUE INDEX |
| 11. Transactions |
| · Properties of Transactions |
| · Transaction Control |
| · Transactional Control Commands |
| · The ROLLBACK Command |
| · The SAVEPOINT Command |
| · The RELEASE SAVEPOINT Command |
| 12. SQL Wildcard |
| · What are Wildcards in SQL? |
| · Why do we Need Wildcards? |
| · Demo Database |
| 13. Temporary Tables |
| · To Create Temporary Table |
| · Global Temporary Table |
| 14. SQL Subquery |
| · Subquery with SELECT statement |
| · Subquery with the INSERT statement |
Assignment 1: Introduction to SQL
Assignment 2: Advanced SQL Querying and Data Analysis
Assignment 3: Database Management and Optimization
Assignment 4: Advanced SQL Functions and Data Manipulation
Assignment 5: Database Security and Authorization
Assignment 6: SQL Performance Tuning and Optimization
Assignment 7: SQL Data Modeling and Schema Design
Assignment 8: SQL Data Analysis and Reporting
Assignment 9: SQL Database Administration and Maintenance
Assignment 10: SQL Database Migration and Integration
Assignment 11: Inventory Management System
Assignment 12: Library Management System
Assignment 13: Student Enrollment System
Assignment 14: Hospital Management System
Assignment 15: E-commerce Inventory and Order Management System
Assignment 16: University Course Registration System
Assignment 17: Human Resources Management System
Assignment 18: Real Estate Property Management System
Assignment 19: Supply Chain Management System
Assignment 20: Fitness Center Management System
| 1. SQL Overview |
| · Introduction |
| · SQL process |
| · Characteristics of SQL |
| · SQL Command |
| · Data Definition Language |
| · Data Manipulation Language |
| · Transaction Control Language |
| · Creating a Table |
| · What is SQL? |
| · History of SQL |
| · Advantages of SQL |
| · SQL Commands and Statements |
| 2. SQL Data Types |
| · Data Types |
| · Oracle Data Types |
| 3. SQL Operators |
| · What is SQL Operator? |
| · Types of Operator |
| · SQL Arithmetic Operators |
| · SQL Comparison Operators |
| · SQL Logical Operators |
| · SQL Set Operators |
| · SQL Bit-wise Operators |
| · SQL Unary Operators |
| 4. CREATE Database |
| · Create Database statement in SQL |
| 5. SQL Table |
| · SQL CREATE TABLE |
| · TABLE Variable |
| 6. SQL Select statement |
| · SELECT statement |
| · Select Distinct |
| · Select Count |
| · Select Random |
| · Advantage of SQL SELECT |
| · SELECT from Multiple Tables |
| 7. SQL Clause |
| · SQL AND & OR |
| · The AND Operator |
| · Select as |
| 8. SQL ORDER by clause with ascending order |
| 9. SQL ORDER by random |
| · Database table |
| · Using a RANDOM function in the SQL ORDER BY clause |
| · SQL Server |
| 10. SQL index |
| · Why SQL Index? |
| · Create an INDEX |
| · Create UNIQUE INDEX |
| 11. Transactions |
| · Properties of Transactions |
| · Transaction Control |
| · Transactional Control Commands |
| · The ROLLBACK Command |
| · The SAVEPOINT Command |
| · The RELEASE SAVEPOINT Command |
| 12. SQL Wildcard |
| · What are Wildcards in SQL? |
| · Why do we Need Wildcards? |
| · Demo Database |
| 13. Temporary Tables |
| · To Create Temporary Table |
| · Global Temporary Table |
| 14. SQL Subquery |
| · Subquery with SELECT statement |
| · Subquery with the INSERT statement |
Assignment 1: Introduction to SQL
Assignment 2: Advanced SQL Querying and Data Analysis
Assignment 3: Database Management and Optimization
Assignment 4: Advanced SQL Functions and Data Manipulation
Assignment 5: Database Security and Authorization
Assignment 6: SQL Performance Tuning and Optimization
Assignment 7: SQL Data Modeling and Schema Design
Assignment 8: SQL Data Analysis and Reporting
Assignment 9: SQL Database Administration and Maintenance
Assignment 10: SQL Database Migration and Integration
Assignment 11: Inventory Management System
Assignment 12: Library Management System
Assignment 13: Student Enrollment System
Assignment 14: Hospital Management System
Assignment 15: E-commerce Inventory and Order Management System
Assignment 16: University Course Registration System
Assignment 17: Human Resources Management System
Assignment 18: Real Estate Property Management System
Assignment 19: Supply Chain Management System
Assignment 20: Fitness Center Management System
