Computer systems(Database) (SBE306) - Fall 2020

Teaching Staff

Instructor: Dr. Ahmed Kandil.

Demonstrators: Eng. Ayman Anwar.

Section Hours

Section Day Time Slot
1 Thursday from 11 AM to 1 PM
2 Thursday from 4 PM to 4 PM

Office Hours

Day Time
Thursday from 9 AM to 11 AM
Thursday from 2 PM to 4 PM

extra office hours requested via E-Mail to ayman.m.anwar@eng.cu.edu.eg (Subject : EXOFH)

Course Outline

Week Content Tasks
1 Introduction to full stack development and database management systems —-
2 ER model and basic SQL statements —-
3 Join statment —-
4 Introduction to python —-
5 python with mysql-connector —-
6 Midterm —-
7 Flask Apps —-

Required installations

visit AMPPS and download the latest version according to your distributions.

  1. windows
    • for installation please follow regular installation steps (next » next » finish)
    • please make sure you have internet connection during installation
  2. Linux
    • please make sure you have internet connection during installation. type the following command after routing to download directory.
      cd /download/location
      chmod 0755 Ampps-<version>-<arch>.run
      sudo ./Ampps-<version>-<arch>.run
      

      To run ampps

      sudo /usr/local/ampps/Ampps
      

      On startup

      You should see something like this indicating the server has started properly.

common issues for LINUX installation

if you have a problem installing ampps on linux type the following:

cd /usr/local/ampps/apache/lib
sudo mkdir backup
sudo mv ./libapr* ./backup/
sudo apt-get -y install libaprutil1 libaprutil1-dev libapr1 libapr1-dev 

then restart your device and run the following every time you want to start it.

cd ~
sudo QT_X11_NO_MITSHM=1 /usr/local/ampps/Ampps 

Tutorials

HEMN230

Practical assignments:

«««< HEAD

Project