ITEC 1035 – Database and Scripting Fundamentals

Course Overview

Database and Scripting Fundamentals ITEC 1035 is about learning the basics of python scripting as well as the fundamentals of databases and SQL. It explored many aspects of python and how to use it for many applications. It gave practical knowledge on python scripting, giving many exercises to complete with it. It also taught the fundamental buildup of databases and how to build them as well as maintain them. It also briefly went over SQL and how to use it to query a database. It showed how to set up a XAMPP server and how to use MySQL on it.

Course Reflection

I learned more about python than I had previously known, it helped me understand object oriented programming as well as what applications I can use it for. It also showed me how to use and query a database using SQL, while I have used SQL before, it taught me more about how databases are set up and how the relate data to each-other.

Example – A simple FizzBuzz program

def fizz_buzz(start=1, finish=20):
    
    for i in range(start, finish):
        if i % 3 == 0 and i % 5 == 0:
            print "FizzBuzz"
        elif i % 3 == 0:
            print "Fizz"
        elif i % 5 == 0:
            print "Buzz"
        else:
            print i