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

CREATE TABLE Statement in SQL- Tutorial and Syntax

The CREATE TABLE Statement in SQL: Overview             One of the most commonly used SQL statements when creating a database is the CREATE TABLE statement, which is used to create tables within a database. The general syntax of the CREATE TABLE statement is shown below. CREATE TABLE table_name ( field_name data_type(size), field_name1 data_type(size), field_name2 data_type(size),
Read more
No Comments

The INSERT Statement in SQL- Tutorial and Video

The INSERT Statement: A picture of the video lesson on the INSERT statement in SQL.
The Insert Statement in SQL: Overview             After examining the core SQL statements used to create objects within relational database management systems, you should next learn how to add, edit, delete and select data within these same systems. SQL uses the Data Manipulation Language statements to accomplish these tasks. The first statement to learn is
Read more
No Comments

SQL Training: Using SQL in Access 2013

SQL Training: Using SQL in Access 2013- A picture of the Code Editor window in Access 2013 with ANSI-92 SQL code contained within it.
              The SQL training “Mastering Introductory SQL Made Easy™ v.1.0” discusses SQL in Access 2013. Access 2013 is a RDBMS that creates self-contained databases and provides visual tools to allow users to make relational databases without the need for SQL. As such, there are few places to use SQL in Access.
Read more
No Comments

SQL Training: Using the CREATE VIEW Statement in SQL- Structured Query Language for Databases

Need training for SQL? Click here for the complete video training.               About Views A view is a virtual table that is based on the results of a SELECT statement. They are very much like the result set of a query. They always display the most recent data from
Read more
No Comments

Using the CREATE Statement in SQL- Structured Query Language for Databases

For the complete tutorial, click here                   The CREATE Statement The first statement that you will learn in SQL is the CREATE statement. The CREATE statement is often the first statement that you will execute in SQL if you are using SQL to design a database within
Read more
No Comments

Understanding SQL Functions- Standard Query Language for Databases

To view the complete tutorial, click here             Understanding SQL Functions Functions serve a wide range of purposes within SQL. You can use aggregate functions to perform calculations on grouped values within a query. That is one very common use of functions within SQL. However, there are other types of
Read more
No Comments