INTRODUCTION TO DATABASE DESIGN AND SQL PROGRAMMING T5202
The efficient management of data requires the use of a relational database management system (RDBMS). Your hands-on introduction to this important business tool covers concepts and components of relational database models; database design and considerations; file system data management; management issues of database design; creating the database structure; distributed database management systems; and practical applications of relational database systems. Structured Query Language (SQL) is the native programming language of all relational database management systems. The course explores topics such as Data Definition Language (DDL) for building, modifying and removing database objects such as tables, views and indexes; Data Control Language (DCL) and Data Manipulation Language (DML); querying single/multiple rows and columns; subselects and correlated subselects; inner and outer joins; unions; functions; expressions; and data processing. Students also receive an overview of report processing with SQL.
Prerequisite: Introduction to Database Design and SQL Programming
Section 51
Dates: 02/02/2010 - 03/09/2010
Time: 06:30 PM - 09:30 PM
Day: Tuesday, Thursday
Instructor: Eric Adolph
Cost: $ 957
Hofstra University Continuing Education college courses, classes, and programs are served to the following areas of Nassau County (Long Island), Suffolk County (Long Island), Queens, Brooklyn, Manhattan (New York City; NYC), and the Bronx:
Amityville, Babylon, Baldwin, Bayside, Bellerose, Bellmore, Bethpage, Carle Place, Cedarhurst, East Meadow, East Norwich, East Rockaway, Elmont, Farmingdale, Floral Park, Franklin Square, Freeport, Garden City, Great Neck, Hewlett, Hicksville, Island Park, Jamaica, Jericho, Levittown, Little Neck, Long Beach, Lynbrook, Malverne, Manhasset, Massapequa, Massapequa Park, Merrick, Mineola, New Hyde Park, Oceanside, Old Bethpage, Old Westbury, Plainview, Port Washington, Queens Village, Rockville Centre, Roosevelt, Rosedale, Roslyn, Roslyn Heights, Seaford, Syosset, Uniondale, Valley Stream, Wantagh, West Hempstead, Westbury, Williston Park, Woodbury, Woodmere
