CIS4365: Database Applications
Fall, 2017

SQL Tutorials

This page is intended to add coverage to the material presented in the lectures, lecture slides and material otherwise available on this website. It IS NOT intended as a substitute for attending class.

NOTE: Topics available for the Tutorial Assignments are those which DO NOT have links to them.

Please Choose from the Topics below:

  SQL
 4.00100 What is SQL?
 4.00110 What Data types are available in SQL? 
 4.00120 How would we create tables in other languages?  
 4.00130 What are schemas?
 4.00140 Are there guidelines for creating tables? 
   
 4.00150 What are scripts? How do we create them? 
 4.00160 How do we assign constraints? 
 4.00170 How do we secure a database?
 4.00170B  How do we secure a database? 
 4.00190 How do we modify a database?
 4.00200 How do we modify a database structure?
 4.00210 How do we select data from a database? 
 4.00220 How do we use operators in SQL?
 4.00230 What add in operators are there in SQL?
 4.00240 How do we join tables in SQL?
 4.05000 What Questions should I be able to answer?

 

This page was last updated on 11/28/03