Course

Unit-1

Introduction to Computers, Computer Science, Computer Systems. Essential components of computer systems: Operating Systems Fundamentals, Principles of Database Systems, Basic concepts in Computer Networks. Installing a Linux virtual machine. Using package manager to install/update software. Understanding disk partitions and obtaining partition information using system tools. Obtaining essential system resource utilization and information using system tools and proc file system: disk utilization, memory utilization, process information, CPU utilization. Pipes and redirection. Searching the file system using find and grep with simple regular expressions. Basic process control using signals: pausing and resuming process from a Linux terminal, terminating a process. Adding/removing from search path using PATH variable. Compressing/uncompressing using tar/gzip and zip tools. Using man pages to understand tool documentation.

Unit-2

Querying a database using simple SQL commands. Writing simple SQL queries. Creating and editing tables. Creating indexes to improve performance. Exporting and importing data from/to database tables to/from Excel.

Unit-3

Obtaining essential system network information using system tools: network interfaces and their addresses, routing table, active processes using network communication. Basic network debugging: using traceroute to discover route to a remote computer, ping to check network connectivity, nslookup for DNS lookup. Understanding basic HTTP client and server using netcat. Using ssh and sftp.

Preamble

The course gives students an overview of computer science: A foundation from which they can appreciate the relevance and interrelationships of further courses in the field. Computer Networks deals with components and principles of networks and its protocols. Operating System acts as a platform of information exchange between a computer’s hardware and the applications running on it. Database Management Systems have become a part of all computer based systems automating real word applications to handle data storage. This course provides an insight on the general structures of operating systems, database management systems and computer networks.

Course Outcomes

The student at the end of the course will

CO – PO Mapping

Text Book

• Brookshear JG. Computer science: an overview. Eleventh Edition, Addison-Wesley Publishing Company; 2011.

Reference Book(s)

• Silberschatz A, Gagne G, Galvin PB. Operating system concepts. Ninth Edition, Wiley; 2012.
• Cobbaut P. Linux Fundamentals. Samurai Media Limited; 2016.
• Silberschatz A, Korth HF, Sudarshan S. Database system concepts. Sixth Edition, McGraw Hill;2010.
• Kurose JF, Ross KW. Computer networking: a top-down approach. Sixth Edition, Pearson;2013.