SQL Home
Virtual Asistant
November 28, 2017
SQL Tutorial SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
SQL Intro
Virtual Asistant
November 28, 2017
Introduction to SQL SQL is a standard language for accessing and manipulating databases. What is SQL? SQL stands for Structured Que...
SQL Syntax
Virtual Asistant
November 28, 2017
SQL Syntax Database Tables A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers...
SQL Select
Virtual Asistant
November 28, 2017
SQL SELECT Statement The SQL SELECT Statement The SELECT statement is used to select data from a database. The data returned is stored in...
SQL Select Distint
Virtual Asistant
November 28, 2017
SQL SELECT DISTINCT Statement The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (dif...
SQL Where
Virtual Asistant
November 28, 2017
SQL WHERE Clause The SQL WHERE Clause The WHERE clause is used to filter records. The WHERE clause is used to extract only those records t...
SQL And,Or,Not
Virtual Asistant
November 28, 2017
SQL AND, OR and NOT Operators The SQL AND, OR and NOT Operators The WHERE clause can be combined with AND, OR, and NOT operators. The AND...
SQL Order
Virtual Asistant
November 28, 2017
SQL ORDER BY Keyword The SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ...
SQL Insert Into
Virtual Asistant
November 28, 2017
SQL INSERT INTO Statement The SQL INSERT INTO Statement The INSERT INTO statement is used to insert new records in a table. INSERT...
SQL Null
Virtual Asistant
November 28, 2017
SQL NULL Values What is a NULL Value? A field with a NULL value is a field with no value. If a field in a table is optional, it is possib...
SQL Update
Virtual Asistant
November 28, 2017
SQL UPDATE Statement The SQL UPDATE Statement The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax UPDATE...
SQL Delete
Virtual Asistant
November 28, 2017
SQL DELETE Statement The SQL DELETE Statement The DELETE statement is used to delete existing records in a table. DELETE Syntax DELETE ...
SQL Select Top
Virtual Asistant
November 28, 2017
SQL TOP, LIMIT or ROWNUM Clause The SQL SELECT TOP Clause The SELECT TOP clause is used to specify the number of records to return. The ...
SQL Min and Max
Virtual Asistant
November 28, 2017
SQL COUNT(), AVG() and SUM() Functions The SQL COUNT(), AVG() and SUM() Functions The COUNT() function returns the number of rows ...
SQL Count Avg Sum
Virtual Asistant
November 28, 2017
SQL COUNT(), AVG() and SUM() Functions The SQL COUNT(), AVG() and SUM() Functions The COUNT() function returns the number of rows ...
SQL Like
Virtual Asistant
November 28, 2017
SQL LIKE Operator The SQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There ar...
SQL Wildcards
Virtual Asistant
November 28, 2017
SQL Wildcards SQL Wildcard Characters A wildcard character is used to substitute any other character(s) in a string. Wildcard characters a...
SQL In
Virtual Asistant
November 28, 2017
SQL IN Operator The SQL IN Operator The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthan...
