SQL school training courses in Concord, NH (public, in-house or online)

MobiLink technology allows SQL Anywhere remotes and UltraLite applications to synchronize data with Sybase SQL Anywhere and Adaptive Server Enterprise (ASE), Microsoft SQL Server, Oracle, and DB2. This course presents an overview of how MobiLink technology works, discusses basic to advanced level implementation techniques, and indicates when MobiLink technology is most suitable for your applications.
Course Objectives :
Upon completion of this course, you will be able to:
Understand t...

Full archival course description>>

Acquire an understanding of the basics of bi-directional replication of information between enterprise systems and remote devices in an asynchronous environment. Explore the design and implementation of a replicated Adaptive Server Anywhere database. Implement remote database architecture in the classroom. Learn publications, subscriptions, and conflict resolution, as well as, database design considerations. Gain familiarity with the principles of administering a replication system. Design and i...

Full archival course description>>

Gain an understanding of mobile and workgroup database functionality and administration. Learn how to develop and manage standalone and server databases. Insert and retrieve data; meet enterprise standards for data availability, security, consistency and integrity. Design databases, queries, and stored procedures for optimal performance.
Course Objectives :
Upon completion of this course, you will be able to:
Develop and manage standalone network databases
Insert data into and ret...

Full archival course description>>

An excellent refresher for entry-level programmers and database administrators. Gain practical, hands-on experience writing database queries that retrieve, organize, and summarize data managed by an Adaptive Server. Learn to construct simple and complex queries using both ANSI-89 standard SQL and Transact-SQL extensions.
Course Objectives :
Upon completion of this course, you will be able to:
Describe the basic concepts surrounding a relational database
Access an Adaptive Server d...

Full archival course description>>

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence are trained to possess an in-depth knowledge of Microsoft SQL Server 2005 Business Intelligence Development.

These professionals have an understanding in database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the Microsoft .NET Framework. These specialists can create database queries, use SSAS data mining algorithms, and write and deploy SQ...

Full archival course description>>