SQL Programming

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.

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

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 course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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 Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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 build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, you’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 understanding of what SQL Server 2005 offers. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, you’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 – features you can use for high-availability, stability, reliability, and scalability of databases. Other topics covered include understanding and implementing security, analyzing performance, automating administrative tasks, and disaster recovery. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. 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. You’ll learn about the new enhancements to the Transact-SQL programming language and how 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

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 large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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 security, and Microsoft's new Business Intelligence (BI) suite. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

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 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007 For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp

his five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with Sql 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Re-porting Services, Report Builder 3.0, Sql 2010 Integration, Reporting Services Content Types, PerformancePoint Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp