 |
|
|
| |
Current Database Training
Course Catalog |
|
|
is targeted toward the new SQL Server administrator. This
one-day course will give you a jump-start on how to install and
manage
your SQL Server 2000. You'll get an overview of SQL Server 2000
and the administrative tools that you will use to manage the
SQL Server. The course combines lecture and lab, simulating a
first-time installation, including creating and configuring a
database, creating and loading tables, and creating indexes and
views. You'll use DTS (data transformation services) to load
data into SQL Server tables from external data sources. In the
labs you will have an opportunity to set up scheduled jobs to
ensure appropriate and timely backups of both the data and the
log components of SQL Server. You'll learn how to automate administrative
tasks via operators and alerts, and how to use the various wizards
that SQL Server implements to assist you with the most complex
administrative tasks, including performance monitoring and tuning.
Length: 1 day
Format: lecture-lab
Pre-requisites: familiarity with computers, previous experience
with databases helpful but not necessary
Cost: contact us
is an introduction to programming in Structured Query Language. This
two-day course will give you an introduction to Transact-SQL, or
T-SQL, the native programming language of Microsoft SQL Server.
In this course we cover the basics of database programming, simple
and advanced queries, data modification statements, data definition
and data control language, and record locking schemes. The course
is set up so that the lectures alternate with hands-on lab time,
ensuring that you get plenty of opportunity to practice your newly-learned
skills.
Length: 2 days
Format: lecture-lab
Pre-requisites: familiarity with computers, previous experience
with programming helpful but not necessary
Cost: Contact Us
is a comprehensive course that will take
you from the fundamentals of data awareness to the intricacies
of database design in four
days, using structured principles of entity-relationship modeling.
You will learn what constitutes a good design, how to determine
and incorporate business requirements, how to create and test ERMs,
and how to test for proper levels of data normalization. In the
accompanying lab time you will create your own database model using
PowerDesigner, CASE software provided by Sybase, Inc., and integrate
it with SQL Server 2000, "pushing" your model to build
a SQL Server database.
Length: 4 days
Format: lecture-lab
Pre-requisites: familiarity with computers, familiarity with databases,
familiarity with systems analysis and design methods
Cost: Contact Us
|
|
|
|
|
|
Courses Developed for University College,
University of Denver, Denver, Colorado
http://www.universitycollege.du.edu/oncampus/cis/courselongdescriptions.asp?offset=1
This course introduces databases and database system concepts. Held
in a combined classroom-lab environment, this course is meant to
give students a solid comprehension of the benefits and limitations
of databases, while allowing them to get hands-on experience building
a user interface to an existing database. All application development
will be done in a graphical environment, using a popular desktop
database workbench. Prior programming experience is not needed.
Selected file processing issues will also be introduced. (Prerequisite:
Recommended for students new to databases)
http://www.universitycollege.du.edu/oncampus/cis/courselongdescriptions.asp?offset=25
This class is an introduction to database system concepts. It
concentrates on the relational model and the conceptual, logical,
and physical
phases of database design and development. Entity-relationship
modeling, data normalization to third normal form, and Structured
Query Language programming are core components of the class. The
class also addresses organizational concerns, exploitation of technology
in today's market, and retention of data integrity. (Prerequisites:
MCIS 3400, Database Fundamentals, MCIS 4210, Operating Systems
or approval of instructor)
http://www.universitycollege.du.edu/oncampus/cis/courselongdescriptions.asp?offset=26
This course builds on Database Design and SQL Programming. It
includes additional data modeling techniques and upper Normal Forms
(Boyce/Codd,
Fourth, and Fifth). It delves into the concepts of database integrity
and transaction management, concurrency protocols (locking and
time stamping), and security schemes. The class also covers database
optimizers, performance and tuning, and advanced SQL topics. (Prerequisite:
MCIS 4425, Database Design and Processing)
http://www.universitycollege.du.edu/oncampus/cis/courselongdescriptions.asp?offset=28
This course examines advanced concepts of databases using ORACLE
RDBMS as the database engine. Topics covered
will include database turning, performance, and other concepts
of modern databases. (Prerequisites:
MCIS 4428, Advanced Database Design)
http://www.universitycollege.du.edu/oncampus/cis/courselongdescriptions.asp?offset=59
This course will integrate the
entire database course sequence of classes. The
student will approach the class from the perspective of a senior
database professional. The
primary focus will be the
case study project, which will include all major deliverables of
a small but significant database solution. The secondary focus
will be the analysis and review of issues regarding management
of database technology, installation, and implementation. (Prerequisites:
Full acceptance as a degree candidate, completion of at least 36
quarter hours which includes core courses, concentration courses;
Capstone Advisor approval)
|
|
|
