49071

Analyze, design, write, test, and debug shell scripts. Students learn basic shell scripting techniques and develop scripting skills needed for Unix/Linux System Administration courses. The bash shell is used.

Introduction to using the Unix/Linux operating system. Unix/Linux file management and common text processing utilities including searching.

An advanced course in the use of MySQL techniques to process database objects. Design and develop MySQL program units: stored procedures, functions, and database triggers. Work with dynamic SQL and with XML data.

Students install and configure a MySQL server and create and manage user accounts. Issues
pertaining to optimization, security, privileges, tuning, troubleshooting, and performing upgrades are
studied and practiced.

A course in the use of SQL database management systems to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the SQL language. It also covers a brief overview of NoSQL (Not Only SQL) data sources such as JSON and MongoDB.

Programming techniques for processing XML data. Comparison of programming approaches, including SAX, SAX-like, and DOM interfaces. Navigating, filtering, and modifying XML. Transformation of XML data. Use of XML with databases and serialization.

Ruby is interpreted, interactive, and object-oriented. Recommended for general-purpose programming, system administration, or web programming with the Ruby on Rails web framework. Write stand-alone programs that perform tasks including interfacing or system calls and libraries, processing text using regular expressions, and retrieving information from web sites.

This course covers programming fundamentals using the Python language. Python is interpreted, interactive, and object-oriented. Recommended for general-purpose programming, system administration, or web programming. Topics include classes, objects, inheritance, polymorphism, design and implementation of abstract data types, dictionaries, lists, list comprehensions, files, modules, and mutable and immutable types.

This class covers using PHP for database connectivity to build scalable, dynamic websites. Assignments emphasize using PHP for user authentication, site personalization, content management, session tracking, and user-driven database updating. Class project demonstrates using PHP and a database (MySQL) to build a scalable, object oriented, template-based web application.

Introduction to the open source Web scripting language PHP. Build dynamic Web applications. Semantics and syntax of the PHP language, including discussion on the practical problems that PHP solves. Write server-side cross-platform HTML-embedded scripts to implement dynamic Web pages that interact with databases and files.