Welcome to Ed2Ti Blog. - My journey on IT is here.

A Manager Soccer game with IA.

19 July 2022 - Posted in Trebas College by edward

Last week, my professor at Trebas Institute, Mr. Iyad Koteich started a class talking about ER Model. I confess that I really like to design database models(ER Models).

My classmate Ravi Rawat took a picture from a dashboard with a relationship model designer by Professor Iyad Koteich. This picture was the "kick-off" for this project.

First I need to explain the difference between ER Model and R Model.

R Model: Describe a vision of the problem to be resolved that any person can see and understand.

ER Model: Materializing the relational model in an Entity on a database requires some organizations.

I will use "WE" every time because Professor Iyad Koteich is my mentor and some classmates can contribute with us.

We need to understand how this project will be constructed:

Create the full ER Model -> MVP (2022-07-29)
Develop a PHP program to maintain the data (pĺayer, teams, clubs, games, etc) -> MPV (2022-08-31)
Develop a python program, to run in the background, analyzing the teams and the games. (2022-12-31)

The Codes of this project are hosted on GitHub: https://github.com/ed2ti/soccer-game-ia

You can directly download the ER-Model here

Study objectives:

Understand ER Model
Construct a Database (MariaDB or Postgres SQL)
FrontEnd Develop with PHP
BackEnd Develop with PYTON (sklearn, pandas, numpy)

All players were created by a website: https://www.mockaroo.com/. You can directly download it here.

A simple form example with: HTML5, CSS3, PHP and MySQL(MariaDB)

05 July 2022 - Posted in Trebas College by edward

Professor: Iyad Koteich

Objective: Using a MariaDB database, create a simple PHP program to:

Create a new account
Login user

I'm using in this example some technologies like HTML5, CSS3, PHP, and MySQL(MariaDB)

Table: users

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstName` varchar(120) NOT NULL,
  `lastName` varchar(120) NOT NULL,
  `password` varchar(120) NOT NULL,
  `email` varchar(120) NOT NULL,
  `phone` varchar(120) NOT NULL,
  `last` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

All files from this project you can find on GitHub: GitHub-Link

A Cloud experience with MariaDB Database

04 July 2022 - Posted in Trebas College by edward

Professor: Iyad Koteich

On 2022-07-04, I present at class a LAB with AWS using two services:

EC2(Elastic Compute Cloud) Instances
RDS(Relational Database Service) - Database (MariaDB)

The purpose is to compare the configuration and utilization of MariaDB as an IAAS or PAAS.

MariaDB - IAAS(infrastructure-as-a-service)

Create an EC2 Instance with an ubuntu server
Instal MariaDB - apt install mariadb-server
Configure a Security group
Change bind-address to 0.0.0.0
Create a user and give access to him.

Create User:

CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Change Bind Address: /etc/mysql/mariadb.conf.d/ and change bind-address

MariaDB - PAAS(platform-as-a-service)

Create a RDS Instance item
Configure a Security group

Relational Database: MariaDB is Relational Database and what is it?

relationship -> one-to-one [indicate]
relationship -> one-to-many [orders]
[son] relationship -> many-to-many [rent cars]

Data Definition Language.

CREATE DATABASE trebasdb;
** USE trebasdb; **
CREATE TABLE users( id int(4) AUTO_INCREMENT, name varchar(30) NOT NULL, email varchar(50), PRIMARY KEY (id) );

Data Manipulation Language.

SELECT * FROM
DELETE FROM
INSERT INTO

Design patterns.

How to use Helmet at node.js

Best Practices in Production: Safety

21 June 2022 - Posted in Programing - Node Script by edward

.

How to use pandas on python to read a csv file

Trebas Intitute - Python Exercise

13 June 2022 - Posted in Trebas College by edward

Professor: Iyad Koteich

You are organizing a party for your group of students.

Check how many students are interested
You are limited to accept 20 students only

Make a Python program that will choose 20 randomly out of All interested students

import pandas as pd
import numpy as np
df = pd.read_csv("class.csv")
df.head()
data = df.values
array = np.random.choice(16, 10)
array = np.array(array)
for i in array:
    print(data[i][3])

I did an adaptation to attend calss.csv file.

You can find all code at https://github.com/ed2ti/exercise01

Introduction - Kaggle

13 June 2022 - Posted in Data Science Journey by edward

In July I was introduced by my Professor (Iyad Koteich), at Trebas Institute, to the Kaggle platform. I confess that at the first moment I don't gave the necessary attention to him (sorry Professor). After one week, browsing a website, I read a document about Data Science, and the name Kaggle was mentioned again.

Well, I thought to myself, I need to know what Kaggle is and why a lot of people talk about it.

After doing my registering, the Kaggle introduced me to a problem: The Titanic Problem. (was amazing)

This month I'll do my best to get the best points resolving the Titanic Problem at Kaggle platform and I'll share here the steps.

#The logic and the python program. #

Kaggle Website

A little about me!

12 June 2022 - Posted in Uncategorized by edward

Hi guys.

My name is Edward and I live in Montreal/QC/Canada. In this blog, I'll share my journey in all kinds of technology areas that I worked and studied.

I hope you enjoy this blog!

About me:

Degree: Information Systems
Master Degree: Cloud Computing, Project Management, Distributed Systems (not completed)
Certifications:
ASW - Foundation
Microsoft - PMP
ITIL v3
Scrum
(And others!)

At this moment, what you need to know is that my first computer was a MSX (with a Z80 processor). ** 1986 **

A Simples Web Server with GoLang

12 June 2022 - Posted in Trebas College by edward

At Trebas (Computer Hardware & Software Environment), the challenger proposed by Ghazal G.Fard starts with a WebServer in GoLang.

Before commenting on the code, we need to understand two differences between python and GoLang.

1) To "ignore" a line in Python we use # and in Golang we use // Some other languages like C, use #, and others, like PHP, use // or /* */.

2) In python I don't need to define the main() function.

We need to keep in mind that we need to develop clean code. For example, is a good practice to use MVC (Model, View, Controller) techniques.

On the code, we need to import three packages: "fmt", "log", "net/http"

The fmt package we use to give a response. Can be on screen, or in this case, a web response. For the log package, we are just writing a log. The net/http we use to start a webserver.

There are a lot of concepts that we can present in the future.

//# *************************** #
//# College: Trebas Institute 
//# Professor: Ghazal G.Fard
//# Class: Edward
//# Day: 2022-06-21
//# *************************** #

package main
import (
    "fmt"
    "log"
    "net/http"
)

func main() {
    http.HandleFunc("/", func(w http.ResponseWriter, r *http.Request){
        fmt.Fprintf(w, "Hello!")
    })


    fmt.Printf("Starting server at port 8080n")
    if err := http.ListenAndServe(":8080", nil); err != nil {
        log.Fatal(err)
    }
}

In this example, we do not use a concept of routes. Next week I'll start a new project to demonstrate rote on the GoLang web server.

Thank you for your time, and I hope that you can get an answer to your question.