SQL Programming

If you can't find what you want, Ask Us.

Refine Your Results

reset

Filter by Category

Location

Dates

FEATURED VENDORS

Showing 1-20 of 40 results Sort by:

Courses

  • 1 Request Info

    MySQL Fundamentals

    MySQL training will take you from novice to expert in two information-packed days. In this hands-on workshop, our experienced instructor will introduce you to the MySQL Server environment and database administration. See our website for locations and schedule.
  • 2 Request Info

    SQL Programming Training Course

    This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
  • 3 Request Info

    20461 Querying a Microsfot SQL Server

    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.
  • 4 Request Info

    20462 Administering Microsoft SQL Server Databases

    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.
  • 5 Request Info

    20463 Implementing a Data Warehouse with Microsoft SQL Server

    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.
  • 6 Request Info

    20466 Implementing Data Models and Reports with Microsoft SQL Server

    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.
  • 7 Request Info

    20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014

    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.
  • 8 Request Info

    20464 Developing Microsoft SQL Server Databases

    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.
  • 9 Request Info

    20465 Designing Database Solutions for Microsoft SQL Server 2014

    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
  • 10 Request Info

    40074 Microsoft SQL Server 2014 for Oracle DBAs

    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.
  • 11 Request Info

    MDX with SQL Server 2008/2012

    This course applies to SQL Server 2005, 2008, 2012 and level of this courses is 300/400 (Intermediate to Advanced ) For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 12 Request Info

    SSRS (SQL Server Reporting Services)

    This course applies to SQL Server 2012 and level of this courses is 300/400 (Intermediate to Advanced ) For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 13 Request Info

    SSAS (SQL Server Analysis Services)

    This course applies to SQL Server 2012 and level of this courses is 300/400 (Intermediate to Advanced ) For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 14 Request Info

    SSIS (SQL Server Integration Services)

    This course applies to SQL Server 2012 and level of this courses is 300/400 (Intermediate to Advanced ) For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 15 Request Info

    MSBI - SSIS - SSAS - SSRS

    This course applies to SQL Server 2005, 2008, 2012 and level of this courses is 300/400 (Intermediate to Advanced ) For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 16 Request Info

    Working With Data in T-SQL For The Non-Database Administrator

    This three-day, comprehensive course provides students with the necessary knowledge and skills to work with the data in SQL Server 2008R2. Students will learn how to use the built-in tools included with SQL Server to construct queries, do tuning, analyze a query and its performance along with how to modify existing data, perform joins, create indexes and work with XML. The new features are discussed and their impact is explained. This course includes instructional videos on each of the covered topics that are intended for student retention for use after the formal training. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 17 Request Info

    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 destinations. 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
  • 18 Request Info

    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 build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 19 Request Info

    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. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp
  • 20 Request Info

    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 Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and Visual Basic to build database objects. For other SQL Server classes please visit http://www.wintrac.com/courses/coursesSQL.asp