Video tutorials on SQL:
- SQL Basics Tutorial Video:
This video covers the following SQL keywords:
SELECT ... FROM,
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, 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:
- Surrogate Key Video: Explains the concept of surrogate keys, and covers the syntax of the following SQL commands:
SEQUENCE, and NEXTVAL.
|| Copyright © 2013 1keydata.com All Rights Reserved.