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

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 FOR Loop in JavaScript- Tutorial

The FOR Loop in JavaScript- Tutorial: A picture from
The FOR Loop in JavaScript: Overview             Loops are useful in JavaScript when you want to execute the same code over and over with a different value each time. The for loop in JavaScript is used to create a loop in JavaScript. The for Loop in JavaScript loops through a block of code a number
Read more
No Comments

The UNION Operator in SQL- Tutorial

The UNION Operator in SQL- Tutorial: A picture from the video lesson for
The UNION Operator in SQL: Overview             The UNION operator in SQL allows you to combine the result sets of two or more individual SELECT statements into a single result set. Note that the UNION operator in SQL is not a JOIN, but rather a way to combine the data within two result sets into
Read more
No Comments