Linux, Python, Data Security, Networking

COURSE DESCRIPTION

Topics include Linux, Database concepts & SQL programming, Programming in Python3, Data security, and Networking concepts. The course concepts and practical labs are intended to provide a background for working with data -- and particularly "big data" -- at an advanced level in future courses and in later career activities.

At the end of the course, the participants will be able to;

• Understand concepts of, and work at an introductory level with, the Linux Operating System
• Work with Relational Database Management Systems (RDBMS) as both an administrator and an end-user
• Write SQL statements to access and update relational data
• Design and write simple Python programs to manipulate non-relational data
• Apply best practices to data security and privacy of data in a network-centric environment

Importantly, the participants will be doing lab exercises throughout the course, as the course in intended to be both conceptual and hands-on. The lab exercises are a critical and essential element in understanding the concepts and applying them in practical situations.

COURSE LEARNING OUTCOMES

Upon successful completion of the course, students will be able to:

1. Understand concepts of, and work at an introductory level with, the Linux Operating System and relational database systems both as administrator and end-user.
2. Write SQL statements to access and update relational data.
3. Design and write simple Python programs to manipulate non-relational data.
4. Apply best practices to data security and privacy of data in a network-centric environment.

The embedded Google Doc below contains code, comments and discussion related to Python. The proficiency with Python that I gained in this class will allow me to identify or create high quality materials that will help guide my students as they learn to program. Additional comments and explanations are provided in the Google Doc.

The embedded Google Doc below walks through the lines of code necessary to create a complex program. I will use this knowledge to create detailed reference materials for the library and classroom. Additional comments and explanations are provided in the Google Doc.