MS SQL Server Training and Seminars

SSAS 2008 R2 Sql Server Analysis Services Do you have data sitting in your corporate SQL Server database, but not know how to make use of it? If you already know SQL, maybe it s time to learn about multi-dimensional reporting using cubes. Speed up your reports, analyse your KPIs and improve your data-mining with SQL Server Analysis Services. This course concentrates on practical teaching and exercises, to allow you to create and modify  more...

SSRS 2008 R2 Sql Server Reporting Services SQL Server Reporting Services 2008 R2 is THE way to publish reports to your corporate intranet. Not only can you include tables of data, matrices (you may know these as pivot tables), charts, lists and subreports, but SSRS 2008 R2 also includes whizzy new report items like indicators, gauges and sparklines. On this three-day course you will use SQL Server 2008 R2 Business Intelligence Development  more...

Microsoft SQL Server 2005 DBA Program Objective: This course is targeted for those who have good knowledge and hands-on experience on using SQL Server 2000 database environment as it mainly focuses on database administrative tasks that an administrator generally needs to perform in a production environment for maintaining SQL Server 2005 databases and components related to the SQL Server environment. Pre-requisites: SQL Server  more...

Microsoft SQL Server 2008 for Developers In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools. Then you will learn about the steps to install, and/ or upgrade to SQL Server 2008 and configuring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management  more...

T-SQL 2008 In this course, you will learn about the features that are available in SQL Server like how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for  more...

Accelerated Microsoft Business Intelligence SQL 2008 This four-day, comprehensive course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2. 0, SharePoint 2007  more...

MICROSOFT SQL SERVER 2005 SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You'll learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing  more...

MICROSOFT SQL SERVER 2005 ADDITIONAL TOPICS 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 topicsa features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing  more...

MICROSOFT SQL SERVER 2005 CORE SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, youa ™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. Youa ™ll learn about the new enhancements to the Transact-SQL programming language  more...

MICROSOFT SQL SERVER 2005 ADMINISTRATOR SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, youa ™ll learn about the administrative features that are available in SQL Server. This course also examines other SQL Server 2005 essential application, support, and maintenance topics a features you can use for high-availability, stability, reliability, and scalability  more...

MICROSOFT SQL SERVER 2005 DEVELOPER SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, youa ™ll learn the skills necessary to transition from other development backgrounds to SQL Server 2005. Even developers who have already used Oracle, MySQL, DB2, or other relational database management systems will find this course to useful in achieving a more thorough  more...

SQL SERVER 2005 ANALYSIS SERVICES 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  more...

MICROSOFT SQL SERVER 2005 INTEGRATION SERVICES 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  more...

SQL SERVER 2005 REPORTING SERVICES 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 create in the  more...

SQL SERVER 2005 REPORTING SERVICES DEVELOPER 1 WORKSHOP This two-day, interactive workshop is designed for new users of Microsoft SQL Server Reporting Services 2005. Some of the topics covered include a review of the software features, administrative tasks, report design, creation of presentation quality reports, and report deployment. The course incorporates a number of hands-on exercises to reinforce the learning process. You can get a complete  more...

MICROSOFT SQL SERVER 7.0 - LEVEL 1 Level 1 is for developers coming from Microsoft Access or Visual Basic development backgrounds who have applications that theya ™re hoping to upsize to SQL Server. Learn some of the issues with installation and configuration, database design issues, how to import non-Jet data, and how to either share data between SQL Server and Jet, or completely upsize data to SQL Server. This introductory  more...

MICROSOFT SQL SERVER 7.0 - LEVEL 2 The first part of this course focuses on querying. Youa ™ll learn how to create a basic query using SELECT statements and then move into more advanced types of queries. Then, you'll learn techniques for making the best use of Microsoft SQL Server. Youa ™ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data. This course also focuses on topics  more...

INTRODUCTION TO MICROSOFT SQL SERVER 2000 a LEVEL 1 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. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000. Even developers who've already used Oracle, Sybase, DB2 or other relational database management  more...

MICROSOFT SQL SERVER 7.0 - LEVEL 3 (sql) Level 3 covers how to use ADO and how to begin building client/ server applications with Visual Basic / SQL Server. You'll also learn how to scale your Visual Basic / SQL Server applications to n-tier and the Internet. You can get a complete list of other Sql server classes at http://www.wintrac.com/courses/coursesSQL.asp  more...

PROGRAMMING DATABASES WITH MICROSOFT SQL SERVER 2000 - LEVEL 2 This course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases. You can get a complete list of other Sql server classes at  more...

EXTENDED FEATURES IN MICROSOFT SQL SERVER 2000 - LEVEL 3 SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. Learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.  more...

WRITING T-SQL QUERIES IN SQL SERVER 2005 In this course, youa ™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  more...

T-SQL 2005 WITH ADVANCED TOPICS In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build 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  more...

SQL Server 2008 Integration Services This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and  more...

SQL Server 2008 Analysis Services In this course, you will learn how to use Microsoft SQL Server 2008 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 2008 developer the tools to  more...

Microsoft SQL Server 2008 Reporting Services In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. Youa ™ll then explore tabular and list reports that employ datasets and data regions. As you progress youa ™ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL  more...