Changing the Inbox View in Outlook – Instructions

Changing the Inbox View in Outlook - Instructions: A picture of the “Advanced View Settings” dialog box in Outlook.
Changing the Inbox View in Outlook: Overview Changing the Inbox View in Outlook by Selecting a Different, Existing View             By changing the Inbox view in Outlook, you can organize your email to better suits your individual needs. The first step in changing the Inbox view in Outlook is to
Read more
No Comments

The DROP Statement in SQL – Tutorial

The DROP Statement in SQL - Tutorial: A picture of the general syntax of the DROP DATABASE, DROP TABLE, and TRUNCATE TABLE commands in SQL.
The DROP Statement in SQL: Overview             You use the DROP statement in SQL to delete created database objects. You can use the DROP statement in SQL to delete databases, tables and indexes. You can also use the DROP statement in SQL in conjunction with the ALTER TABLE statement to delete fields
Read more
No Comments

NULL Values in SQL – Tutorial

NULL Values in SQL - Tutorial: A picture of the main bullet points of the lesson on NULL values in SQL.
NULL Values in SQL: Overview             When creating tables in SQL, you will need to deal with NULL values in SQL. A NULL value is a value that is unknown. These values can occur within database tables when a user who is performing data entry skips entering a value into a field. When a value
Read more
No Comments

The UPDATE Statement in SQL- Tutorial

The UPDATE Statement in SQL- Tutorial: A picture of the core SQL of the UPDATE statement in SQL.
The UPDATE Statement in SQL: Overview             After you have data within the tables in your database, you will often need to update those records. SQL uses the UPDATE statement to update field data within specified records in a table. The core SQL of the UPDATE statement is shown below. Note that the “table_name” parameter
Read more
No Comments

The SELECT Statement in SQL- Tutorial

The SELECT Statement in SQL- Tutorial: A picture of the SELECT statement syntax in SQL.
The SELECT Statement in SQL: Overview             You use the SELECT statement in SQL to choose specific records to view from a table, or from related tables, within a temporary table called a result set. We will start the examination of the SELECT statement by looking at the SELECT statement in its simplest form when
Read more
No Comments

CREATE DATABASE Statement- Tutorial

CREATE DATABASE Statement: Overview             Within many relational database management systems, the CREATE DATABASE statement is used to create the database. The core SQL of the statement is shown below. CREATE DATABASE database_name             In this statement, the “database_name” parameter is the name you want to give to the database. Note that while most versions
Read more
No Comments

The DELETE Statement in SQL- Tutorial

The DELETE Statement in SQL- Tutorial: A picture from the video lesson
The DELETE Statement in SQL: Overview             The DELETE statement in SQL is used to remove specified records from a table. Like the UPDATE statement, it includes a WHERE clause that you should ensure is correct before executing the DELETE statement in SQL. If you do not specify a WHERE clause within the DELETE statement
Read more
No Comments

DROP USER and DROP ROLE Statements in SQL

DROP USER and DROP ROLE Statements in SQL: A picture from the video lesson titled
DROP USER and DROP ROLE Statements in SQL: Overview             This blog post discusses using the DROP USER and DROP ROLE statements in SQL. You can use the DROP USER statement in SQL to delete a user from the database. Note that this statement is technically classified as Data Definition Language (DDL), as it defines
Read more
No Comments