Learning Tree Releases New Hands-On Course: SQL Queries for Microsoft SQL Server.Business Editors/Hi-Tech Writers RESTON, Va.--(BUSINESS WIRE)--Jan. 10, 2002 Learning Tree International, Inc. (NASDAQ NASDAQ in full National Association of Securities Dealers Automated Quotations U.S. market for over-the-counter securities. Established in 1971 by the National Association of Securities Dealers (NASD), NASDAQ is an automated quotation system that reports on NM: LTRE) is today announcing the release of a new Hands-On Course, SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. Queries for Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. . "This new Learning Tree course provides developers with the knowledge and skills they need to write robust and reliable SQL queries while using the most efficient method to write queries for their particular application," said John Moriarty John Moriarty may refer to:
During this 4-day course, practicing real-world experts lead participants in hands-on exercises using Transact-SQL to create queries for both SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. 7 and 2000. Attendees quickly master the skills to: 1. Effectively utilize inner joins, outer joins and self joins for faster query of multiple tables 2. Extend SQL's query power by transforming data with built-in and user-defined functions 3. Facilitate data summary using aggregation and grouping techniques 4. Solve complex query problems using correlated and simple subqueries This course is valuable for developers, consultants, software engineers, analysts and others who are developing systems using SQL Server databases. SQL Queries for Microsoft SQL Server will augment the already extensive library of Learning Tree SQL Server courses, which includes a full range of SQL Server 7 and SQL Server 2000 database administration and application development courses, including SQL Server 2000 Introduction, SQL Server 2000 Database Administration, SQL Server 2000 Data Transformation Services Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. , SQL Server 2000 Transact-SQL Programming, Microsoft SQL Server 7 Introduction and SQL Server 7 Transact-SQL Programming. The current course schedule for SQL Queries for Microsoft SQL Server is as follows: -- Boston, MA - January 29 - February 1, 2002 and March 12 - 15, 2002 -- Washington, DC - January 29 - February 1, 2002 and March 19 - 22, 2002 -- Philadelphia, PA - March 5 - 8, 2002 -- New York, NY - March 12 - 15, 2002 -- Los Angeles, CA - March 26 - 29, 2002 Learning Tree International plans to add even more dates later in 2002. This schedule may be subject to change. For further information, please call 1-800-THE-TREE (1-800-843-8733) or visit Learning Tree's Web site at www.learningtree.com. About Learning Tree International Learning Tree International is a leading worldwide provider of education and training to information technology (IT) professionals in business and government organizations. The company develops, markets and delivers a broad, proprietary library of instructor-led courses focused on operating systems Operating systems can be categorized by technology, ownership, licensing, working state, usage, and by many other characteristics. In practice, many of these groupings may overlap. , Web development, computer networks, programming languages, databases, client/server systems, object-oriented technology See object technology. and IT management. Learning Tree also tests and certifies IT professionals, and the American Council on Education Established in 1918, the American Council on Education (ACE) is a United States organization comprising over 1,800 accredited, degree-granting colleges and universities and higher education-related associations, organizations, and corporations. recommends its courses for college credit. For more information about Learning Tree products and services, call 1-800-THE-TREE, or visit www.learningtree.com. |
|
||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion