Week1: Introduction to 'Computer Systems (Database) (SBE306)'

class: left, middle
# Information about your TA

--
* My name is ayman Anwar, graduate of 2016 class.
* e-mail: `ayman.anwar.bio@gmail.com`
* Office hours and materials are available on the course page.
* Main research interests: Brain Computer Interface (BCI) , Machine and Deep Learning

---
class: left, middle
# Information about our course

--
* Aims to understanding various levels off full stack development.
* Understanding database management systems.
* Modern Frontend/BackEnd languages and frameworks (technologies).
* This course doesn't aim to teach Web application design but its a good way to learn database system practically through full stack webdevelopment frame.
* We still aim to write a very clean and simple C++ code.
* We will also learn and practice on version control systems like git.

---
class: left, middle
# Attendance

* Attendance is a requirement to pass the courses.
--
* Not showing in more than 25% of lectures or tutorials is penalized by failing in the course(According to faculty rules).

---
class: left, middle

---
class: left, middle

---
class: left, middle
# Front End

---
class: left, middle
# Back End

---
class: left, middle
# Back End (What Language !!??)

## what ever your prefer
--
 * C++ 
 * Java
 * Python
 * php
 * Ruby
 * NodeJS ..... etc

---
class: left, middle
# Database

## SQL Database 
 * SQL server
 * MySQL
 * Sqlite3

--
## NoSQL Database
* MongoDB
* H-Base

-- 
### During this course we will use MySQL as database engine

---
class: left, middle

# database

is a collection of related data organized in TABLES

* Represents some aspect of the real world, logically coherent not random, and designed for a specific purpose.

A database-management system (DBMS) is a is system software for
managing databases, it facilitates the processes of:

* Defining a database: in terms of data types, structures and constraints,
 * Constructing the database: store the data on a storage medium,
 * Manipulating the database: retrieve, update, delete, and generate reports
 * Sharing the database: among various users and applications.

---
class: left, middle

# Relational Database

The relational model represents the database as a collection of relations
 * is a collection of schemas, tables, queries, reports, views, and other elements.

Each table (which is sometimes called a relation) contains one or more data
categories in columns.

Relational model terminology:
table is called an entity
* row is called a tuple
* column header is called an attribute
* table is called a relation
* the data type describing the types of values that can appear in each column is
represented by a domain
--
## so lets get started with MySQL

---
class: left, top
# Thank you