Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C,"Answers to Quizzes and Exercises," for answers.
Quiz
1:
Can a database on a server be accessed from another server?
2:
What can a company use to disseminate information to its own employees ?
3:
Products that allow connections to databases are called what?
4:
Can SQL be embedded into Internet programming languages?
5:
How is a remote database accessed through a Web application?
Exercises
1:
Connect to the Internet and take a look at various companies' home pages. If your own company has a home page, compare it to the competition's home pages. Ask yourself these questions about the pages:
Does the page come up quickly or is it bogged down with too many graphics?
Is the page interesting to read?
Do you know anything about the company, services, or products after reading the available information?
If applicable , has access to the database been easy?
Do there appear to be any security mechanisms on the Web page? Can a login be entered to access data that may be stored in a database?
2:
Visit the following Web sites and browse through the content, latest technologies, and the companies' use of data on the Web (data that appears to be derived from a database):