PowerPoint Slide 1

 

PowerPoint Slide 2

 

PowerPoint Slide 3

 

PowerPoint Slide 4
Use relative file paths when referencing other pages in your website.
PowerPoint Slide 5

Relational databases are often used by businesses to keep track of employees, inventory, and customers. They are helpful for distinguishing relationships between entities in a company.

The pioneer of relational databases, Edgar Codd, designed what is jokingly known as "Codd's Twelve Commandments". (Technically there's 13 because the number scheme starts at zero). If you want to read about them, the link is here!

PowerPoint Slide 6

 

PowerPoint Slide 7
PowerPoint Slide 8

 

PowerPoint Slide 9

 

PowerPoint Slide 10

 

PowerPoint Slide 11

 

PowerPoint Slide 12

 

PowerPoint Slide 13

Content management systems are how normal human beings (not CS people) manage websites

They are pretty powerful though! Check out the Collegian website, it runs on WordPress. There are a lot of little tweaks and addons you can implement to make a CMS do some pretty heavy lifting.

PowerPoint Slide 14

It's open source. But like all open source code, you should consider paying for the pro version when you're running a business

PowerPoint Slide 15

 

PowerPoint Slide 16

 

PowerPoint Slide 17

 

PowerPoint Slide 18

 

PowerPoint Slide 19

 

PowerPoint Slide 20

 

PowerPoint Slide 21

Creating users with privileges gives you a system of access control

PowerPoint Slide 22

Watch out for DROP DATABASE -- you're gonna have a bad time if you do this on accident. Or someone else decides to do it for you.

PowerPoint Slide 23

Sanitize to avoid code injection! Security is fun.

  • IT Crowd If you're having a bad day, here is something funny.