Gain insights into effective security techniques including patching, cryptography, and phishing prevention. Explore practices to make systems resistant and vulnerabilities more detectable, enhancing defense against attacks.

docker.tar.gz

network-commands

node

It seems like hardly a week goes by without a high-profile computer breach. Why do these happen? How can you prevent them? This course doesn’t have all the answers, but it does outline practices that make life harder for attackers and that will help tide you over until you get a full-time security team in place.

In this course, you will learn 5 simple, yet effective, techniques for preventing attackers from getting into your system. These techniques are related to: patching, software vulnerabilities, cryptography, windows security, and phishing. Within each chapter you will learn the best practices for preventing vulnerabilities and how to make them more detectable. 

This course is based on the Pragmatic Programmers’ book, Practical Security, and is aimed at developers, admins, team leads, architects, technology generalists, and all others who stand guard against the things that disrupt the network.

Practical Security: Simple Practices for Defending Your Systems

## Problem statement
Write an SQL query that returns the `Body` and `CreatedTimestamp` of all the journal entries based on a first and last name.

### Sample input
`FirstName` = "Frankie" \
`LastName` = "Manning"

### Sample output

| CreatedTimestamp | Body |
| --- |  --- |
| 2020-04-21 11:28:00 | Everybody shim sham! |
| 2020-04-21 11:28:00 | Time for lindy hop.|

## Coding exercise

Try to recall SQL nesting for this one. Good luck!

# Problem statement
Write an SQL query that returns the `Body` and `CreatedTimestamp` of all the journal entries based on a first and last name.

## Sample input
`FirstName` = "Frankie" \
`LastName` = "Manning"

## Sample output

| CreatedTimestamp | Body |
| --- |  --- |
| 2020-04-21 11:28:00 | Everybody shim sham! |
| 2020-04-21 11:28:00 | Time for lindy hop.|

# Coding exercise

Try to recall SQL nesting for this one. Good luck!

Let's try an exercise to write a generalized SQL query.

Introduction

Patching

Vulnerabilities

Cryptography

Windows

Phishing

Challenge: Write a Generalized Query

Problem statement

Sample input

Sample output

Coding exercise

CreatedTimestamp	Body
2020-04-21 11:28:00	Everybody shim sham!
2020-04-21 11:28:00	Time for lindy hop.