Data Networks and TCP/IP

Data Networks and TCP/IP

The Introduction to Data Networking and TCP/IP course presents the basic theory of network hardware and software. It starts with the OSI Reference Model and data structure, explains the Ethernet protocol and LAN switching, continues with the basics of IPv4 operation and addressing, continues with TCP, UDP and how they Read more…

SQL for Data Analysis: Advanced SQL Querying Techniques

SQL for Data Analysis: Advanced SQL Querying Techniques

This is a hands-on, project-based course designed to help you move beyond the “Big 6” clauses into advanced querying techniques. We’ll start by reviewing the basics and conducting multi-table analyses, including basic joins, self-joins, cross-joins, and unions. Next, we’ll cover different ways of working with nested queries by writing subqueries and common table expressions, or CTEs. Read more…

Windows Server 2025: DHCP and DNS

Windows Server 2025: DHCP and DNS

DHCP is an important concept to understand for any network or systems administrator, as it allows you to automatically assign IP address information to all your endpoints. DNS, meanwhile, is essential to resolve names to IP addresses to make Active Directory and name resolution work correctly. In this course, professor Read more…