From the course: SQL Server 2014 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
What is SQL? - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
What is SQL?
- Before we get into the demonstrations of SQL commands I'd like to talk a little bit about the SQL language in general. SQL is an acronym. It stands for Structured Query Language. It was originally called SEQUEL with a slightly different meaning. Some people still enunciate the acronym as SEQUEL and some people enunciate each individual letter, S-Q-L. They mean the same thing. SQL was first developed in1970 by IBM in conjunction with several projects for the US government and for many years it remained a government-only project. The first product available to the public that utilized the SQL language was in 1979 with Oracle version 2, and Oracle remains one of the premier database systems today. The majority of SQL commands focused on four basic verbs. The first one is SELECT, and SELECT is the tool we use to retrieve data from the database. Then we have UPDATE. UPDATE will modify one or more existing rows in the database. INSERT. INSERT creates one or more new rows in the database…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
What is SQL?3m 34s
-
(Locked)
Basic SELECT statement3m 35s
-
(Locked)
Filtering results with a WHERE clause3m 48s
-
(Locked)
Using wildcards in a WHERE clause2m 38s
-
(Locked)
Sorting results with ORDER BY4m 48s
-
(Locked)
INSERT statements4m 24s
-
(Locked)
UPDATE statements3m 12s
-
(Locked)
DELETE statements2m 42s
-
(Locked)
-
-
-
-
-
-
-
-
-