Sql Server Tutorial

 SQL Tutorial

SQL -- pronounced sequel -- stands for Structured Query Language. It is the language used to access data stored in a SQL database. With SQL, you can query your database in a variety of ways, using English-like statements. With SQL, data is stored in tables. A table is a set of columns and rows.  Each column is referred to as a field. Each value in a field represents a single type of data. For example, a table might have three fields: name, city, and state. The table will consist of three columns: one for name, one for city, and one for state.  For every row in the table, the name field contains the name, the city field contains the city, and the state field contains the state. A database is a collection of related data. It can also be viewed as a collection of related tables. This tutorial is on storing data in and retieving data from a SQL database.  Introduction SQL Tables Scalable SQL for Windows Definition of Database Tables used by Solomon IV Reading the Reports SQLScope The Menu Bar The View Option Database in Use Conventions Used in this Guide Errors Creating Tables Importing Data Retrieving All Data Retrieving a Single Column Retrieving Multiple Columns Formatting Numbers Ordering Rows Displaying Rows in Descending Order Ordering Multiple Columns Retrieving Specific Rows Multiple Conditions Joining Tables Updating Tables Deleting Rows Inserting Rows