shape
shape
Open to:High School or College Level
Prerequisites:Knowledge of Database Systems and Data Structures
Course Format:Individually Paced
Prerequisites:Typically 3 months
Course Code:DAT
COURSE DESCRIPTION
Business and scientific institutions increasingly use large commercial data base systems. This course teaches the theory and practice for the definition, security, backup, tuning, and recovery of these systems. It has become important to install, configure, and manage the servers in an efficient manner to increase productivity. A number of tasks involved in maintaining a database server is quite different from say administering a computer system or a network. Deeper knowledge of the storage aspects of the server and how different server processes work are needed for successful administration of the server. Typically, the database administrator cares for security of data, backup and recovery, and space management. This course takes a user through the stages of setting up a database server environment, to design of a database, and finally tuning.
DETAILED COURSE INFORMATION
  • Basic concepts of networking. Network topologies. The concept of layered architecture modeling including OSI and the TCP/IP protocol suite. Client-server communications.
  • Physical layer functionalities including signaling, modulation, multiplexing, line coding and synchronization. Transmission media. Network performance measures including throughput, delays are presented. Data vs. signaling rates, channel bandwidth and capacity.
  • Link layer functionalities including frame synchronization, error detection and control including ARQ, flow control mechanisms including sliding windows.
  • Circuit, packet and virtual circuit switching technologies
  • Local area network technologies including ETHERNET, Token Rings. Multiple-access schemes such as CSMA/CD, CSMA/CA and Token-passing. MAC addressing. Switched vs. shared ETHERNETs. Performance evaluation, including throughputs and delays.
  • Internetworking devices including repeaters, bridges, switches, routers and gateways. Network layer protocols, including IP, ARP and ICMP. IP addressing schemes. Subnetting
  • Internet routing including protocols used in the Internet such as RIP, OSPF and BGP.
  • Transport layer protocols including UDP and TCP. Ports and sockets. TCP connection establishment. Error, flow and congestion control in TCP.
  • Applications layer protocols such as HTTP, FTP, DNS, SMTP, TELNET
  • Network security measures including encryption, authentication, data integrity and firewalls.
TUTORIALS/SEMINARS
During the tutorials or seminars, the student will work on case studies and discuss various strategies and techniques.
TECHNICAL REQUIREMENTS
This course requires a properly maintained computer with high-speed internet access and an up-to-date web browser (such as Chrome or Firefox). The student must be able to communicate with the instructor via email. Visit the Technical Requirements and Support page for more details.

This course uses an asynchronous mode and students are provided with tiered video and self-guided learnning modules. Live online interaction with the instructor can be arranged. The “on site” classroom works on standard computers and intructor-led exercises. Detailed handouts with references to material on the Web will be provided. There is no required text book.

Most course lectures may be viewed on mobile devices, but in some cases assignments and quizzes must be completed on a desktop or laptop computer.
END OF COURSE REQUIREMENTS
In fulfillment of the course, students are required to take the final examination, as well as an end-of-course project or research paper.

Queries? Get in touch with us