Instructor Led Database Concepts Training Classes

Microsoft SQL Server 2000 Database Development ...his class will allow the student to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; more...

FileMaker Pro Part I This course teaches students fundamental database concepts and terminology, and the basic features of FileMaker Pro. Students will learn how to open an existing database and create a new database, how to create, edit, and sort records, and how to search for records in a database. more...

Core Data Access with Microsoft Visual Studio 2005 ...cations   Have a good understanding of basic relational database concepts   Be able to use basic SQL commands   Have a good understanding of XML including XML declaration, elements, attributes, and namespaces   Be able to explain XML schema concepts   Workshop Outline Unit 1: Connecting to Databases and Reading Data This unit introduces the fundamental skills required to connect to more...

Spatial Databases and Database Development ...nclude data standards, standards organizations, metadata, database concepts, database development and quality control and assurance. The new ESRI Geodatabase format is also explored through a series of hands-on exercises. Who should attend Professionals using GIS or newly introduced to the technology gain an indepth understanding or the unique nature of spatial databases. This course is more...

Oracle Database 10g Introduction to SQL ...roduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large more...

Administering a Microsoft SQL Server 2000 Database ...ional and Server An understanding of basic relational database concepts, including: Logical and physical database design.   Data integrity concepts.   Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).   How data is stored in tables (rows and columns).   For students who do not meet these prerequisites, the following more...