Basic Function Tables
8+ results
Filters
Subject
Format
Resource type
Programs & methods
Stored Procedures and Functions Complete Lesson | Database Management System
This lesson provides a complete foundation on Stored Procedures and Functions in MySQL, covering procedure creation, parameters, execution, functions, and real-world database logic implementation. Ideal for Computer Science.Designed to help students understand HOW logic is stored, reused, and secured inside the database, using clear syntax, step-by-step examples, and realistic employee-database scenarios. ────────── ⋆⋅☆⋅⋆ ────────── What’s Included 💡 Full Stored Procedures and Functions
10th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
![Preview of Advanced SQL Queries Complete Lesson | Database Management System [DBMS]](https://ecdn.teacherspayteachers.com/cdn-cgi/image/format=avif,quality=70,width=525,height=525,onerror=redirect/thumbitem/Advanced-SQL-Queries-Complete-Lesson-Database-Management-System-15105292-1766321092/750f-15105292-1.jpg)
Advanced SQL Queries Complete Lesson | Database Management System [DBMS]
This lesson provides a complete, concept-clear understanding of Advanced SQL Queries, covering aggregate functions, GROUP BY, HAVING, and subqueries for real-world data analysis. Ideal for Computer Science, ICT, IT Fundamentals, Database Systems, and AP CS–aligned courses.Designed to help students understand HOW complex data analysis and reporting is done using SQL, using clear syntax, structured examples, and realistic employee-database scenarios. ────────── ⋆⋅☆⋅⋆ ────────── What’s Inclu
10th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
![Preview of Relational Model Complete Lesson | Database Management System [DBMS]](https://ecdn.teacherspayteachers.com/cdn-cgi/image/format=avif,quality=70,width=525,height=525,onerror=redirect/thumbitem/Relational-Model-Complete-Lesson-Database-Management-System-15104803-1766320955/750f-15104803-1.jpg)
Relational Model Complete Lesson | Database Management System [DBMS]
This lesson provides a complete, concept-clear foundation of the Relational Model in DBMS, covering tables, keys, relationships, relational schema, operations, and ER-to-relational conversion. Ideal for Computer Science, ICT, IT Fundamentals, Database Systems, and AP CS–aligned courses.Designed to help students understand HOW real-world databases are structured and implemented before writing SQL, using clear tables, diagrams, schemas, and practical examples. ────────── ⋆⋅☆⋅⋆ ────────── Wh
10th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Database Design and Normalization Complete Lesson | Database Management System
This lesson provides a complete foundation in Database Design and Normalization, covering data redundancy, functional dependencies, normalization forms (1NF–BCNF), and real-world design decisions. Designed to help students understand WHY good database design matters before writing SQL, using clear tables, step-by-step decompositions, and exam-ready normalization examples. ────────── ⋆⋅☆⋅⋆ ────────── What’s Included 💡 Full Database Design & Normalization Slide Deck💡 Detailed Teacher No
10th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
![Preview of SQL Joins and Views Complete Lesson | Database Management System [DBMS]](https://ecdn.teacherspayteachers.com/cdn-cgi/image/format=avif,quality=70,width=525,height=525,onerror=redirect/thumbitem/Joins-and-View-Complete-Lesson-Database-Management-System-15107264-1766320897/750f-15107264-1.jpg)
SQL Joins and Views Complete Lesson | Database Management System [DBMS]
This lesson provides a complete understanding of SQL Joins and Views, covering all major join types, advanced join scenarios, UNION operations, and SQL views for data presentation and security. Ideal for Computer Science, ICT, IT Fundamentals, Database Systems, and AP CS–aligned courses. Designed to help students understand HOW data from multiple tables is combined and presented in real databases, using clear diagrams, real-world table examples, and fully worked SQL queries. ────────── ⋆⋅☆⋅
9th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Triggers Complete Lesson | Database Management System
This lesson provides a complete understanding of Database Triggers in MySQL, covering trigger types, timing, events, syntax, automation, and real-world use cases such as logging and data integrity enforcement. ────────── ⋆⋅☆⋅⋆ ────────── What’s Included 💡Full Database Triggers Slide Deck💡 Detailed Teacher Notes & Teaching Guide💡 Complete Assessment Test💡 Full Answer Key💡 Step-by-step trigger examples using real tables💡 Ready for in-person, online, or hybrid classrooms────────── ⋆
10th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
![Preview of Introduction to SQL Complete Lesson | Database Management System [DBMS]](https://ecdn.teacherspayteachers.com/cdn-cgi/image/format=avif,quality=70,width=525,height=525,onerror=redirect/thumbitem/Introduction-to-SQL-Complete-Lesson-Database-Management-System-15104982-1766320858/750f-15104982-1.jpg)
Introduction to SQL Complete Lesson | Database Management System [DBMS]
This lesson provides a complete, beginner-friendly introduction to SQL, covering SQL fundamentals, command categories, table creation, data manipulation, querying, and core MySQL data types. Ideal for Computer Science, ICT, IT Fundamentals, Database Systems, and AP CS–aligned courses. Designed to help students understand HOW SQL is used to interact with databases before advanced queries, using clear syntax examples, tables, and real-world student database scenarios. ────────── ⋆⋅☆⋅⋆ ───────
10th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
SQL Constraints and Indexing Complete Lesson | Database Management System
This lesson provides a complete understanding of SQL Constraints and Indexing, covering data integrity rules, database keys, constraint types, cascading actions, and performance optimization using indexes.Designed to help students understand HOW databases enforce correctness and improve performance, using real-world table designs, full SQL examples, and practical integrity-violation scenarios. ────────── ⋆⋅☆⋅⋆ ────────── What’s Included 💡 Full SQL Constraints and Indexing Slide Deck💡 D
10th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Showing 1-8 of 8+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands