Programming Online/Live Training Courses
School(s) providing online training for Computer and Network Programming Skills

SQL Server 2005 Transact SQL (T-SQL)
Course Type: Online
School/Trainer: Software Training Academy [>>]
Training Centers: Toronto,Canada

In this course, you’ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you’ll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You’ll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and ......

Course description>>

 

In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You’ll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you cr......

Course description>>

 

This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development ......

Course description>>

 

In this course, you’ll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you’ll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You’ll learn about the new enhancements to the Transact-SQL pro......

Course description>>

 

In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to b......

Course description>>

 

Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics—features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing l......

Course description>>

 

Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure �combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control. This compreh......

Course description>>

 

This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications. Learning how to create efficient, scalable PL/SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different......

Course description>>

 

This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle’s implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEA......

Course description>>

 

This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreads......

Course description>>

 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 12 13 14

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.