| |
| 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. |
| |
| 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. |
| |
| 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. |
| |
| 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. |
| |
| 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”. |
| |
| 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. |
| |
| 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. |
| |
| SQL CREATE
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 27, 2011
How to create databases, tables, and indices. |
| |
| SQL BETWEEN
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 26, 2011
How to use BETWEEN....AND to find data in a range. |
| |
| SQL Join
Posted in SQL Basics > Miscellaneous by tutorialgrub on Apr 26, 2011
How to select information from multiple tables. |
1 2 3 4 5 6 >> Next |
