CSc 250: Lecture Material
January 12, 2017
- Topics
- General course introduction and syllabus review.
- Begin our introduction to the UNIX operating system:
- General introduction to UNIX
- File systems
- Bash, and a few simple bash commands
- Lecture Notes
January 17, 2017
- Topics
- Continue learning UNIX basics.
Learning about a few command line tools, including
cat, rev, head, tail, touch, cat, and more.
Also learning about man pages and command-line arguments.
- Lecture Notes
January 19, 2017
- Topics
- Continue learning UNIX basics.
Learning to use bash variables.
Standard input, standard error, and standard output.
Learning to write and execute a bash script file.
- Lecture Notes
January 24, 2017
- Topics
- UNIX: Regular expressions, bash conditionals, and subshells.
- Lecture Notes
January 26, 2017
- Topics
- Regular expressions, continued
- Lecture Notes
January 31, 2017
- Topics
- Start learning python!
- Cover the history and function of python as a language.
- Difference between python 2 and python 3.
- Writing a basic “Hello World” program.
- Math
- Lecture Notes
February 2, 2017
- Topics
- Python: Variables, data types, and math operators
- Lecture Notes
February 7, 2017
- Topics
- Python scripts
- Defining and calling functions
- Lecture Notes
February 9, 2017
February 14, 2017
- Topics
- Defining and calling functions (continued)
- ifs, and while-loops
- Lecture Notes
February 16, 2017
- Topics
- ifs, and while-loops (continued)
- reading from standard input
- Lecture Notes
February 21, 2017
- Topics
- String manipulation
- lists and for loops
- Lecture Notes
February 23, 2017
- Topics
- lists and for loops
- Dictionaries
- Lecture Notes
February 28, 2017
- Topics
- Finish up lists/loops
- Dictionaries
- Lecture Notes
March 2, 2017
- Topics
- Reading and writing files
- Lecture Notes
March 7, 2017
- Topics
- Exam review
- Reading and writing files (cont)
- Lecture Notes
March 9, 2017
March 14, 2017
March 16, 2017
March 21, 2017
- Topics
- Exam 2 review
- Reviewing lists, dictionaries, and file I/O
- Lecture Notes
March 23, 2017
- Topics
- Python command line arguments
- Lecture Notes
- Other Resources
March 28, 2017
- Topics
- Intro to databases and DBMS
- Lecture Notes
- Databases and DBMS slides
March 30, 2017
- Topics
- Introduction to SQL and SQLite
- Lecture Notes
April 4, 2017
- Topics
- The sqlite3 library in python
- Lecture Notes
April 6, 2017
- Topics
- The sqlite3 library in python (cont)
- Lecture Notes
- Code
April 11, 2017
- Topics
- The sqlite3 library in python (cont)
- SQL Injection in python
- Lecture Notes
- Code
April 13, 2017
- Topics
- Advanced SQL and SQLite features
- Lecture Notes
- Advanced SQL and SQLite slides
April 18, 2017
April 20, 2017
- Topics
- Exam 3 solution review
- Go over the final project specification
April 25, 2017
- Topics
- Regular expressions in python
- Lecture Notes
- Resources
April 27, 2017
- Topics
- Regular expressions in python (cont)
- Modules and code refactoring
- Lecture Notes
- Resources
May 2, 2017
- Last day of (normal) class
- Topics
- Brief Final Exam review
- Python modules, abstraction, code refactoring
- Lecture Notes