19,154 tutorials online
20 tutorials pending review
763 dead links removed





Databases: SQL Basics Tutorials

 

How to Use the Trim Function
Posted in SQL Basics > Miscellaneous by tutorialgrub on May 08, 2011

Sometimes with outputted data, comes unwanted white space. The trim function is used for this in SQL.
1035 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SQL ORDER BY
Posted in SQL Basics > Miscellaneous by tutorialgrub on May 01, 2011

How to use the ORDER BY keywords to return rows in a defined order.
544 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SQL UPDATE
Posted in SQL Basics > Miscellaneous by tutorialgrub on May 01, 2011

How to use the UPDATE statement to update or change rows in a table.
321 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

How to Create a Self-Contained Scalar Subquery in SQL Server
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 30, 2011

This tutorial will show how to create a Self-Contained Scalar Subquery in SQL Server. Using the WHERE and SELECT clauses we are able to retrieve a single result from a table.
233 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Relational Databases
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 30, 2011

This term is used for achieving database efficiency. For a good explanation of what/why click here. This tutorial will show you some common types of this. I will use one example and keep improving it starting from the beginning. The first thing I will do is give you a table structure, then we will improve it using the 2 most common techniques: “1 to 1”, and “1 to many”.
184 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

How to Outer Join Tables in SQL Server
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 29, 2011

This tutorial will show how to outer join tables using the Join keyword. We will show three instances of outer join: left, right, and full.
260 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SQL Exercises
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 28, 2011

Tutorial mainly uses syntax constructions of SQL-92 standard. It will help you to master in wide and varied possibilities for formulating queries of arbitrary complexity to relational databases. Each topic of the tutorial is followed by numbers of exercises, which may be solved online while the system controls the correctness of solutions. Some structures specific for MS SQL Server 2005 are also considered, in particular, the string and temporal functions.
219 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SQL CREATE
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 27, 2011

How to create databases, tables, and indices.
220 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SQL BETWEEN
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 26, 2011

How to use BETWEEN....AND to find data in a range.
427 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SQL Join
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 26, 2011

How to select information from multiple tables.
335 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial


1  2  3  4  5  6    >>  Next