1travelintexan

Module 1

• Week 1. Day 1. Lecture. What is your favourite TV show / series?
• Week 1. Day 2. Lecture. What is your favourite hobby?
• Week 1. Day 3. Lecture. Is gif pronounced as ‘gif’ or ‘jif’ ?
• Week 1. Day 4. Lecture. If you could watch just one movie for the rest of your life which one would it be ?
• Week 1. Day 5. Lecture. If you had a superpower, what would it be and why?

---

1travelintexan

//make a state for the image file
 const [image, setImage] = useState(null);
// Make a input of type file
  <label>
          Project Image:
          <input
            type="file"
            name="image"
            onChange={(e) => setImage(e.target.files[0])}
          />

1travelintexan

1. Typescript Resources

Remember that typescript is built on top of Javascipt, meaning that if you understand Javascript then you know 90% of Typescript Here are a list of links to help learn Typescript:

Scrimba

This is the best free resource to learn typescipt fundamentals
Link

Typescript Slides

Slides to learn the basics of TS
Link

Free Code Camp

This is one of the best youtube channels to learn coding
Link

Web Dev Simplified

1travelintexan

-- Create a database
 -- CREATE TABLE users(
 -- 	id SERIAL PRIMARY KEY,
	-- username VARCHAR(20),
	-- email VARCHAR(30),
	-- password VARCHAR(12),
	-- age INTEGER,
	-- isAdmin BOOLEAN
 --  );
-- Create a database

1travelintexan

1. Cloudinary account setup

Go to this link https://cloudinary.com/ and create your cloudinary account, verify your email and go through or skip the initial questions

After you are done you should be able to see the following in your dashboard:

• Cloud Name
• API key
• API Secret

1travelintexan

//Video going step by step to create cloudinary account and upload image
//https://www.youtube.com/watch?app=desktop&v=Y-VgaRwWS3o



//before anything on the React code, create a free account with Cloudinary and follow the video above to create a upload preset
//you will need the cloudinary dashboard for data to put inside your POST request


//create a state for the image

1travelintexan

#These are the basics of python
#create a variable
#*******variable types in Python*****
string = "Hello World"	#string	
integer= 20	#int	
a_float = 20.5	#float	
complex_variable = 1j	#complex	
a_list = ["apple", "banana", "cherry"]	#list	
tuple_list = ("apple", "banana", "cherry")	#tuple (cant have repeating elements)
a_range = range(4,6)	#range is a method that gives a range of nums starting at 0 or with two arguments (inclusive)

1travelintexan

--*************************** BASIC QUERIES ****************************
--Find all employees
SELECT *
FROM employee;
--find all clients
SELECT * 
FROM client;
--Find all employees ordered by salary
SELECT *

1travelintexan

--***********************EMPLOYEE TABLE **************************
--This creates the employee table but the super_id and branch_id are going to be forgein keys later. 
CREATE TABLE employee(
    emp_id INT PRIMARY kEY AUTO_INCREMENT,
    first_name VARCHAR(40),
    last_name VARCHAR(40),
    birth_date DATE,
    sex VARCHAR(1),
    salary INT,
    super_id INT,

1travelintexan

--TABLE CREATION OR MODIFICATION
-- **************************************************
--Creates a new table with three columns, student_id being the primary key
--INT is interger, VARCHAR is string and the 2 is up to 20 in length
    --NOT NULL means that this value cannot be null or undefined
    --UNIQUE means it has to be unique 
    --AUTO_INCREMENT means the student id will keep counting base on the last entry
CREATE TABLE student (
    student_id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(20) NOT NULL,