|
Video tutorials on SQL:
- SQL Basics Tutorial Video:
This video covers the following SQL keywords:
SELECT ... FROM,
DISTINCT,
WHERE,
ORDER BY,
GROUP BY, and
HAVING. After you finish watching this video, you'll be able to write basic SQL queries to retrieve data from a relational database.
- Union, Intersect, Minus Video: This video discusses how to combine two sets of results together in SQL. The following SQL keywords are covered:
INTERSECT,
UNION,
UNION ALL,
INTERSECT, and EXCEPT.
- Table Management Video: This video discusses how to manage a table in SQL. The following SQL commands are covered:
CREATE TABLE, DROP TABLE, and TRUNCATE TABLE.
- Table Constraint Video: Discusses how to put constraints on a column so only certain values are allowed. The following types of constraints are discussed:
NOT NULL,
DEFAULT,
UNIQUE, and
CHECK.
- Surrogate Key Video: Explains the concept of surrogate keys, and covers the syntax of the following SQL commands:
AUTO_INCREMENT,
IDENTITY,
SEQUENCE, and NEXTVAL.
|
| Copyright © 2013 1keydata.com All Rights Reserved.
Privacy Policy |
|
