TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

The DELETE Statement in SQL- Tutorial

Tuesday, December 16 2014 by Joseph Brownell
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
access 2013how-tolearnlessonmySQLoverviewSQLSQL Server 2012syntaxteachThe DELETE StatementThe DELETE Statement in SQLtrainingtutorialvideo
Read more
  • Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments

DROP USER and DROP ROLE Statements in SQL

Thursday, November 20 2014 by Joseph Brownell
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
access 2013DCLDDLDROP USER and DROP ROLE Statements in SQLhelphow-tolearnlessonmySQLSQLSQL Serverstatementssyntaxteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Latest, Microsoft, SQL
No Comments

CREATE TABLE Statement in SQL- Tutorial and Syntax

Wednesday, October 22 2014 by Joseph Brownell
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),
helphow-toinstructionsintroductorylearnlessonSQLsyntaxteachthe CREATE TABLE statementtrainingtutorialvideo
Read more
  • Published in Latest, SQL
No Comments

The INSERT Statement in SQL- Tutorial and Video

Wednesday, September 17 2014 by Joseph Brownell
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
accesshow-tolearnlessonmySQLSQLSQL Serverteachthe INSERT statementtrainingtutorialvideo
Read more
  • Published in Latest, SQL
No Comments

SQL Training: Using SQL in Access 2013

Monday, June 23 2014 by Joseph Brownell
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.
access 2013codedatabasedesign queryMicrosoft OfficeSQLSQL Serverstructured query language
Read more
  • Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments

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

Tuesday, May 13 2014 by Keeley Byrnes
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
accessbookclasscodecoursecreate viewdatabasedatabase languageebookmanualmicrosoftprogramprogrammingSQLstructured query languagetrainingtutorialview
Read more
  • Published in Latest, SQL
No Comments

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

Friday, April 18 2014 by Keeley Byrnes
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
classcoursedatabaseebookhelphow-tomanualmySQLonlineprogramprogrammingSQLSQLitetrainingtutorial
Read more
  • Published in Latest, SQL
No Comments

Understanding SQL Functions- Standard Query Language for Databases

Tuesday, April 15 2014 by Keeley Byrnes
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
accessclasscoursedatabasedesign queryebookfunctionguidehelphowhow-tolanguagemanualmySQLqueryreferenceSQLSQLitestructuredtrainingtutorial
Read more
  • Published in Latest, SQL
No Comments
  • 1
  • 2

 

Recent Posts

  • A picture that shows how to create moving elements in Photoshop Elements.

    Moving Elements in Photoshop Elements – Instructions

    Overview of How to Create Moving Elements in Ph...
  • Layer Types in Photoshop Elements: A picture of a user simplifying a Smart Object layer in Photoshop elements.

    Layer Types in Photoshop Elements- Instructions

    Overview of the Layer Types in Photoshop Elemen...
  • A picture of the training interface for the digital download or DVD versions of our Photoshop Elements training, titled “Mastering Photoshop Elements Made Easy™ v.2023.”

    Photoshop Elements Training

    Photoshop Elements Training for Photoshop Eleme...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 0 Days 3 Hours 5 Minutes 34 Seconds      $199 $49 Entire Library!
See Deal