Sql Database

Sql Database

SQL Basic

SQL HOME

SQL Intro

SQL Syntax

SQL Select

SQL Distinct

SQL Where

SQL And & Or

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Demo

SQL Try It

SQL Advanced

SQL Top

SQL Like

SQL Wildcards

SQL In

SQL Between

SQL Alias

SQL Joins

SQL Inner Join

SQL Left Join

SQL Right Join

SQL Full Join

SQL Union

SQL Select Into

SQL Create DB

SQL Create Table

SQL Constraints

SQL Not Null

SQL Unique

SQL Primary Key

SQL Foreign Key

SQL Check

SQL Default

SQL Create Index

SQL Drop

SQL Alter

SQL Increment

SQL Views

SQL Dates

SQL Nulls

SQL isnull()

SQL Data Types

SQL Functions

SQL Functions

SQL avg()

SQL count()

SQL first()

SQL last()

SQL max()

SQL min()

SQL sum()

SQL Group By

SQL Having

SQL ucase()

SQL lcase()

SQL mid()

SQL len()

SQL round()

SQL now()

SQL format()

SQL Quick Ref

SQL Hosting

SQL Summary

SQL Quiz

SQL Quiz

Introduction to SQL

« PreviousNext Chapter »

SQL is a standard language for accessing and manipulating databases.

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL is an ANSI (American National Standards Institute) standard

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is a Standard - BUT....

Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

Using SQL in Your Web Site

To build a web site that shows some data from a database, you will need the following:

An RDBMS database program (i.e. MS Access, SQL Server, MySQL)

A server-side scripting language, like PHP or ASP

SQL

HTML / CSS

RDBMS

RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables.

A table is a collection of related data entries and it consists of columns and rows.

« PreviousNext Chapter »

Build Your Professional HTML Website with Wix

Start building your own beautiful website. It’s easy and free!

Wix.com provides an easy-to-use online platform where you can create and publish your own website. Enjoy powerful drag & drop editing tools & customizable website designs.

With total design control, eCommerce features, superior SEO results and free domains, Wix is the ultimate solution for creating your perfect and exquisite HTML website.

Over 20 million users have created their website with Wix.

images

images

images

images

images

images

images

images

images

images

images

images