Basic Function Tables
25+ results
Filters
Subject
Format
Resource type
Audience
Programs & methods
DHCP | CCNA 200-301 Prep and Networking Lessons
This lesson is on Dynamic Host Configuration Protocol (DHCP). Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CompTIA Network+, or CCNP), it explains how DHCP automates IP address assignment and network configuration, allowing devices to connect efficiently without manual setup. Things we’ll coverThe purpose of DHCPBasic functions of DHCPConfiguring DHCP in Cisco IOS◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Formats Provided✯ Cisco Packet Tracer Simulation File (.pkt)✯ PPTX (editable
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
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
Introduction to OSPF Part 1 | CCNA 200-301 Prep and Networking Lessons
This lesson is on Open Shortest Path First (OSPF) – Part 1. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it covers basic OSPF operations, an introduction to OSPF areas, and fundamental OSPF configuration. Students will learn how OSPF enables efficient dynamic routing, organizes networks using hierarchical areas, and is implemented on routers for scalable, reliable network communication. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverBasic
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Introduction to Dynamic Routing | CCNA 200-301 Prep and Networking Lessons
This lesson is on Introduction to Dynamic Routing. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it explains how dynamic routing automatically updates and maintains routing tables, allowing routers to adapt to network changes and ensure efficient data delivery across interconnected networks. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverIntroduction to dynamic routing protocolsTypes of dynamic routing protocolsDynamic routing protocol metr
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Network Address Translation Part 2 | CCNA 200-301 Prep and Networking Lessons
This is a lesson on Network Address Translation (NAT) – Part 2. Continuation of Part-1. Designed for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, CompTIA Network+), it builds on the basics of NAT (from Part 1) and explores advanced NAT types, configurations, and use cases that are essential for modern enterprise networks. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverMore about static NATDynamic NATDynamic PAT◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Formats Provided✯ Cisco Packet Tracer
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Switch Interfaces | CCNA 200-301 Prep and Networking Lessons
This lesson is on Switch Interfaces. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it explains the different types of interfaces found on network switches and their functions. The lesson covers topics such as access ports, trunk ports, and management interfaces, helping learners understand how switches connect and communicate with other devices, manage traffic within a network, and support efficient network design and configuration
9th - 12th, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Introduction to Network Devices | CCNA 200-301 Prep and Networking Lessons
This lesson is on Introduction to Network Devices. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it introduces the essential hardware components that make up a network. The lesson explains the functions of common devices such as routers, switches, hubs, access points, and firewalls, helping learners understand how each device contributes to data transmission, connectivity, and overall network performance. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Virtual Routing & Forwarding (VRF) | CCNA 200-301 Prep and Networking Lessons
This is a lesson on Virtual Routing & Forwarding (VRF). Perfect for teaching ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, CompTIA Network+), it provides everything you need to explain, demonstrate, and reinforce how multiple routing tables can coexist on a single device to securely segment network traffic. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverIntro to VRFVRF Configuration◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Formats Provided✯ PPTX (editable PowerPoint)✯ PDF (print-friendly v
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
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
Introduction to IPv6 Part 1 | CCNA 200-301 Prep and Networking Lessons
This lesson is on IPv6 – Part 1. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CompTIA Network+, or CCNP), it covers the fundamentals of Internet Protocol version 6 (IPv6) including a review of hexadecimal, the need for IPv6, the basics of IPv6 addressing and structure, and how to configure IPv6 addresses on network devices for modern connectivity and scalability. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverHexadecimal (review)Why IPv6?Basics of IPv6Configuring
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
OSPF Part-3 | CCNA 200-301 Prep and Networking Lessons
This lesson is on Open Shortest Path First (OSPF) – Part 3. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it covers OSPF network types, OSPF neighbor and adjacency requirements, and OSPF Link-State Advertisement (LSA) types. Students will learn how OSPF functions across different network topologies, the conditions required to form adjacencies, and how LSAs share routing information to maintain an accurate and efficient network topolog
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Ethernet LAN Switching | CCNA 200-301 Prep and Networking Lessons
This lesson is on Ethernet LAN Switching. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it explains how Ethernet switches operate within a local area network to forward frames efficiently. The lesson covers key concepts such as MAC address learning, frame forwarding, switching tables, and collision domains, helping learners understand how switches improve network performance, reduce congestion, and enable reliable communication be
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
OSI MODEL & TCP/IP SUITE | CCNA 200-301 Prep and Networking Lessons
This lesson is on the OSI Model & TCP/IP Suite. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it explains the structure and purpose of the OSI (Open Systems Interconnection) model and the TCP/IP protocol suite. The lesson breaks down each layer’s functions, protocols, and interactions, helping learners understand how data is processed, transmitted, and received across networks. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Formats Provided✯ Cisco Packet
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
![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
Network Time Protocol | CCNA 200-301 Prep and Networking Lessons
This lesson is on Network Time Protocol (NTP). Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CompTIA Network+, or CCNP), it explains how NTP synchronizes time across network devices, ensuring accurate timestamps for logs, security events, and coordinated network operations. Things we’ll coverWhy is time important for network devices?Manual time configurationNTP basicsNTP configuration◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Formats Provided✯ Cisco Packet Tracer Simulation File (.p
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
![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
FTP & TFTP | CCNA 200-301 Prep and Networking Lessons
This is a lesson on File Transfer Protocol (FTP) and Trivial File Transfer Protocol (TFTP). Perfect for ICT, Computer Science, Networking, or certification prep (CCNA, CompTIA Network+, CCNP), it explains how these protocols are used to transfer files across networks and compares their features, use cases, and security implications. Things we’ll coverThe purpose of FTP/TFTPFTP/TFTP functions & differencesIOS File SystemsUsing FTP/TFTP in IOSFormats Provided✯ Cisco Packet Tracer Simulation File
10th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
SNMP| CCNA 200-301 Prep and Networking Lessons
This lesson is on Simple Network Management Protocol (SNMP). Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CompTIA Network+, or CCNP), it explains how SNMP is used to monitor, manage, and maintain network devices, enabling administrators to track performance, detect faults, and ensure efficient network operations. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverSNMP overviewSNMP versionsSNMP messagesSNMP configuration (basic)◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Formats Provided✯ Ci
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
Introduction to the Cisco IOS CLI | CCNA 200-301 Prep and Networking Lessons
This lesson is on Introduction to the Cisco IOS CLI. Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it introduces learners to the Cisco Internetwork Operating System (IOS) and its Command-Line Interface (CLI). The lesson covers essential navigation commands, user modes, and configuration techniques, helping students gain confidence in interacting with Cisco devices, managing network settings, and performing basic troubleshooting task
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
First Hop Redundancy Protocols | CCNA 200-301 Prep and Networking Lessons
This lesson is on First Hop Redundancy Protocols (FHRP). Ideal for ICT, Computer Science, Networking, or certification prep (CCNA, CCNP, or CompTIA Network+), it explains how FHRPs such as HSRP, VRRP, and GLBP provide gateway redundancy and network reliability, ensuring continuous connectivity even if a default router fails. ◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆◇◆ Things we’ll coverThe purpose of FHRPsHSRP (Hot Standby Router Protocol)VRRP (Virtual Router Redundancy Protocol)GLBP (Gateway Load Balancing Pr
9th - 12th, Adult Education, Higher Education
Computer Science - Technology, Engineering, Instructional Technology
Also included in: The Ultimate CCNA & Networking BUNDLE [ From Zero to Network Pro ]
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-24 of 25+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands