Web development with PHP

A PHP tutorial. I advice the visualization of all videos because along the playlist I make some “mistakes” on purpose, that later they become “problems” and need to be fixed. This way I can show why we should do it this or that way. Until now I’ve only created series nbr 7, explaining how to use PHP to connect to a database using PDO and how to structure an application using the MVC design pattern.

You can download the source code here.

  • Web Dev: 01 – PHP
    • Creating the database
    • Creating the SVN repository and the project in Eclipse
    • Connecting to the database
    • Using SELECT
    • Using INSERT
    • What is the MVC design pattern and how to use it
    • Using UPDATE
    • Using DELETE
    • Using prepared statements
    • Using transactions
    • Wraping up the project with CSS and DIVs

Linux basics screen-casts

I’ve prepared a playlist about Linux basics covering:

  • Linux: 00 – Instalação, Configuração e Software
    • Virtual Box configuration
    • Installing Ubuntu
    • Virtual Box snapshots
    • First login
    • System set up
    • Installing software using shell
    • Installing software using Ubuntu Software Center
    • Installing software using Synaptic
    • Installing software using a DEB file
    • Installing software using apt-get
    • Installing software using make (compiling from source)
    • Installing, seting up and using WINE (Windows emulator)
    • Installing and using Compiz
    • Installing and using Emerald
    • How to reinstall Ubuntu

How to make screen-casts

In some of my classes I asked my students to author some screen-casts and upload them to Youtube, so they could show me that they could install and work with Linux. So I ended up creating some screen-casts teaching how to create screen-casts!  I teach how to do it in Linux with the following open source software:

  • Virtual box – to have an isolated sandbox
  • recordmydesktop – to record my desktop and my explanations
  • Pitivi – to edit the video files

I teach how to set up recordmydesktop options, use pitivi to edit the videos, set pitivi options to get an HD video ready for Youtube upload.

I use a desktop do create the screen-casts, and I always get that background sound (BZZZZZZZZ) that seems like a refrigerator, so I also have a second video teaching how to clean up the sound using:

  • Audacity – to clean the sound
  • Pitivi – to remaster the video

Screen-casts in my youtube channel

Some time ago I got to know khan academy, which was awarded a Google prize for its innovation. This is a story of a guy that starts to tutor hes cousins through web conferencing, however it was difficult to set up a time where they could all be on-line at the same time, so Mr. Khan decided he would make some screen-casts and put them on Youtube, so hes cousins could get the tutoring whenever they had the time. From there to more than 3000 screen-casts was a small step. He now has screen-casts that can tutor you throughout high-school, and maybe some University subjects, in a great number of subjects, mostly mathematics but also physics, history, biology and a lot more, all tutored by himself.

Now days, hes project even has an on-line software to monitor students progress with exercises, which tells the students when they are ready to move forward to the next screen-cast and warns teachers when a student is falling back. All and all, its a awesome project!

After that I also found the new boston, which has a lot of computer science screen-casts, but many more subjects also.

However, everything is in English (I was teaching in Portugal), and they don’t have quite what I needed for my students, so I started making my own screen-casts to use with my students and for everyone else who wants to use them. Of course, I don’t have the ambition of creating as many screen-casts as they do, nor with the same quality, but it’s a small contribution.

Check out my own Youtube channel !

I have playlists about: