Database Tools & Reporting Software

+Crystal Reports XI: Report Writing Basics +Managing Data and Distributing Reports with Crystal Reports XI

+Getting Started with Crystal Reports 2011

This four-day instructor-led course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system. This course provides training for Oracle DBA to compare and contrast Oracle database management to SQL Server database management.

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2014. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This five-day instructor-led course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform. This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

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 Transact-SQL programming language including improved support for error handling and hierarchical queries, and how programmers can now use .NET languages like C# and Visual Basic to build database objects. You'll also learn about enhancements made to SQL Server 2005 for handling complex data structures, using partitioning, and working with XML. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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 programmers can now use .NET languages like C# and Visual Basic to build database objects. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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 systems will find this course useful for getting up to speed on SQL Server 2000. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

The first part of this course focuses on querying. You’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. You’ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data. This course also focuses on topics that are relevant to multi-user, replication, and Internet/intranet environments. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

Level 1 is for developers coming from Microsoft Access or Visual Basic development backgrounds who have applications that they’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 course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 7.0. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp