CEIS

How is Malware distributed?

1. SEO manipulation 2. Social Engi neering / click-Jacking 3. Phishing 4. Malvertising S. Compromising legitimate sites 6. Drive-by down loadsS 7. Spam

what are the basic components of Malware?

Crypter protects that malware components from being during analysis 2. Downloader used to download additional malware

Basic SQL data manipulation commands

INSERT, uPDATE, and DELETE, and the transaction management commands COMMIT and ROLLBACK.

hhhh

In this course, we will be using MySQL running in the MS Azure environment to develop our relational database and SQL skills. However, the knowledge you gain is transferable and the concepts are the same regardless of which database product you are using. Only minor changes are needed to convert your SQL code from one DBMS to another. In this lesson, we will be using the world and sakila databases. These databases are already loaded in your MySQL environment in Azure. If you want to install these databases on your own instance of MySQL, you can download them at https://dev.mysgl.com/docindex-other.html e

What is the purpose of the SELECT statement? Give an example.

SELECT statement: Selects attributes from rows in one or more tables or views. Constructing a SELECT query is similar to constructing objects with building blocks. A SELECT query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed. There are many potential clauses, or parts, to a SELECT query, as shown below FROM: Specifies the tables from which data should be retrieved. WHERE: Restricts the selection of rows based on a conditional expression. GROUP BY: Groups the selected rows based on one or more attributes. HAVING: Restricts the selection of grouped rows based on a condition. ORDER BY—sorts the final query result rows in ascending or descending order based on the values of one or more attributes. Data retrieval is done in SQL using a SELECT query. When you run a SELECT command on a table, the RDBMS returns a set of one or more rows that have the same characteristics as a relational table. Each clause in a SELECT query performs a specific function. The function of each clause is key to developing the skills to construct queries to satisfy the reporting needs of the users. For a SELECT query to retrieve data from the database, it will require at least a SELECT column list and a FROM clause. The SELECT column list specifies the relational projection. The FROM clause is used to specify the table from which the data will be retrieved. It is common for queries to retrieve data from multiple tables that have been joined together. The syntax for a basic SELECT query that retrieves data from a table is "SELECT COLUMNISTS" & "FROM TABELIST" The columnlist represents one or more attributes, separated by commas. If the programmer wants all of the columns to be returned, then the asterisk (*) wildcard can be used. A wildcard character is a symbol that can be used as a general substitute for other characters or commands. This wildcard means "all columns." For example, the following query would return all of the data from the PRODUCT table. SELECT * FROM PRODUCT; In the query above, the column list indicates that all columns (and by default all of the rows) should be returned. The FROM clause specifies that the data from the PRODUCT table is to be used. To limit the rows being returned, relational selection (or restriction) must be used. The column list allows the programmer to specify which columns should be returned, as shown in the next query. SELECT P_CODE, P_DESCRIPT, P_PRICE, P_QOH FROM. PRODUCT; This query specifies that the data should come from the PRODUCT table, and that only the product code, description, price, and quantity on hand columns should be included. Notice that only the requested columns are returned and that the columns are in the same order in the output as they were listed in the query. To display the columns in a different order, simply change the order of the columns in the column list. SQL accepts any valid expressions (or formulas) in the computed columns. Such formulas can contain any valid mathematical operators and functions that are applied to attributes in any of the tables specified in the FROM clause of the SELECT statement.

Can you tell us a little bit more about some functions we can apply on fields in a select statement? Can you tell us a little bit more about the where statement and how it is used?

You can add the ASC or DESC function after the ORDER BY clause which lists products sorted in ascending or descending matter. This is great for those wanting to organize fields in a select statement.

if a product does not have a vendor or if you do not yet know the vendor code? In those cases, you would want to leave the vendor code null.

if a product does not have a vendor or if you do not yet know the vendor code? In those cases, you would want to leave the vendor code null. Incidentally, note that the NULL entry is accepted only because the V_CODE attribute is optional