Chapter 1: Review of C and PythonChapter goal: Load up all of the software eg sqlite3, C, Python etc
1.1: Pythona. Defining different types of variablesb. Reading in data from command linec. Arithmetic operationsd. Switches (user-written)e. If-then-elsef. Arraysg. For loopsh. Stringsi. Math functionsj. User-written functionsk. Dictionariesl. File usem. Use of Matplotlibn. Create typical programs in Python using SDK1.2: C
a. Read and write characters
b. Arithmetic operationsc. Switchesd. If-then-elsee. Arraysf. For loops and Do loopsg. Stringsh. Data arraysi. Structuresj. Math functionsk. User-written functionsl. File usem. Create typical programs in C using SDKExercises
Chapter 2: SQL in C Chapter goal: Load up all of the software eg sqlite3, C compiler, Python etc. Demonstrate using SQL in C by writing separate C programs to: -
a) create a table
b) insert a row of data into the tablec) select a row or rows of data in the tabled) amend a row of data in the tablee) delete a row of data from the tableExercises
Chapter 3: SQL in Python Chapter goal: Load up appropriate eg sqlite3, Python etc. Demonstrate using SQL in Python by writing separate Python programs to: -a) create a table
b) insert a row of data into the tablec) select a row or rows of data in the tabled) amend a row of data in the tablee) delete a row of data from the tableExercises
Chapter 4: Embedded Python in Ca. Introduction to why you might want to embed python in cb. Basic example "hello"c. Plot a graph with preset points in python program d. Plot a graph with user-entered points in pythone. Print from a dictionaryExercises
Chapter 5: Sockets in Python a. Show basic server-client programs
b. Show basic threaded programs
c. Show basic chat programs
Exercises
AppendicesC Programming Code GuidePython Programming Code Guide