SQL Server

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 38 results Sort by:

Courses

  • 1 Request Info

    Webinar on Data Visualization and Mapping Tools for Accountants

    This course defines data visualization, mapping and graphic design tools that instantly improve the visual appeal of any accounting report. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Data-Visualization-and-Mapping-Tools-for-Accountants-506730/MAY-2018-ES-TRAININGREGISTRY
  • 2 Request Info

    SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS) Training Course

    Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing the newly designed charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps. One day is reserved for SSIS. Students will learn the basics of creating SSIS packages using SQL Server Data Tools to create Extract Transform and Load solutions used to populate data warehouses and marts. In the final day, based on a populated data warehouse they have created, students will then learn how to develop an SSAS multidimensional (cube) model using Multidimensional Expressions (MDX) syntax. Cubes will be customized to include Key Performance Indicators (KPIs), Calculated Members, Named Sets, Navigational Hierarchies, and Perspectives.
  • 3 Request Info

    Microsoft SQL Server 2016 Administration Training Course

    This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure. The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
  • 4 Request Info

    Analyzing Data with Power BI Training Course

    This course gives students a solid understanding of data analysis with Power BI. Topics include creating visualizations; connecting to Excel files; creating a Power BI dashboard; developing reports using the Power BI desktop App; using DAX syntax; accessing data in Azure SQL Data Warehouses; using the Power BI Mobile App and the Developer API.
  • 5 Request Info

    SQL Server 2016 Business Intelligence: Integration Services and Analysis Services Training Course

    The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources. Students will learn how to design and build data warehouses and marts using SQL Server Management Studio. In a series of exercises, students develop SSIS packages designed to maintain a data warehouse using the Data Flow control flow task. Also demonstrated are other control flow tasks that can interact with an NTFS file system, FTP server, execute Win32 processes, send emails, and run .NET scripts. Based on the populated data warehouse they have created, students will then learn how to develop both Multidimensional and Tabular SSAS models using the languages Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).
  • 6 Request Info

    SQL Server 2017 Reporting Services Training Course

    This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps. The student will gain experience with the new Report Services Web portal, which enables publishing content other than paginated reports, such as Excel and Power BI. Students will also learn how to include KPIs (Key Performance Indicators) directly from a shared data set.
  • 7 Request Info

    Microsoft Transact-SQL Programming Training Course

    This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views. 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 stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
  • 8 Request Info

    55119 SQL Server 2012 Reporting Services

    This three-day instructor-led is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2012 Reporting Services. During this course, attendees will learn how to Report Designer in SSDT and Report Builder, work with solutions and projects, design basic reports, enhance reports with formatting and images, effectively group and summarize data, work with parameterized reports, incorporate charts and custom maps, and work with drill-through reports, and manage reports.
  • 9 Request Info

    55069 PowerShell for SQL Server Administrators

    This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.
  • 10 Request Info

    55144 SQL Server 2014 Performance Tuning and Optimization

    This 5-day course is designed to give the right amount of internals knowledge combined with a wealth of practical tuning and optimization techniques that students can put into production. The course offers comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimizing transaction log operations, temp db and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines to benchmark SQL Server performance, how to analyze workload, and how to find and fix performance problems. Also included is an introduction to, and coverage of, two exciting new technologies: in-memory tables and stored procedures.
  • 11 Request Info

    10977 Updating Your SQL Server Skills to Microsoft SQL Server 2014

    This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.
  • 12 Request Info

    55073 Master Data Services, Data Quality Services with SQL 2012-2014 and Excel

    Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.
  • 13 Request Info

    MCSA: SQL Server Bootcamp

    The Microsoft MCSA SQL Server certification boot camp is a 9 day comprehensive deep dive into the SQL Server covering topics such as including query, administration and data warehousing. This instructor led training program will teach you the skills needed to support an SQL 2014 environment. Theprogram incorporates Microsoft Official Courses: 20461 Querying Microsoft SQL Server & 20462 Administering Microsoft SQL Server Databases & 20463 Implementing a Data Warehouse with Microsoft SQL Server. While attending this training program - you take three exams to test and certify for the Microsoft Certified Solutions Associate (MCSA): SQL Server official certification. If your goal is to learn how to use SQL Server and pass the certification exams (70-461, 70-462 & 70-463)
  • 14 Request Info

    Accelerated Microsoft Business Intelligence (SQL 2008)

    For other SharePoint classes and outlines please visit SharePoint training .This four-day, comprehensive course provides students with the knowledge and skills to develop using SQL Server 2008.
  • 15 Request Info

    SQL Server 2008 Integration Services

    For other SQL Server classes and outlines please visit SQL Server training . This course will enable technology professionals with little or no ETL experience to be comfortable with the technologies.
  • 16 Request Info

    SQL Server 2008 Analysis Services

    For other SQL Server classes and outlines please visit SQL server training .In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services and Business Intelligence solutions.
  • 17 Request Info

    Microsoft SQL Server 2008 Reporting Services

    For other SQL Server classes and outlines please visit SQL Server training .In this course, you will learn how to use SQL Server 2008 Reporting Services.
  • 18 Request Info

    Microsoft SQL Server 2008 for Developers

    For other SQL Server classes and outlines please visit SQL Server training .In this course, you'll see an overview tour of SQL Server 2008 including its editions, components, and tools.
  • 19 Request Info

    T-SQL 2008

    For other SQL Server classes and outlines please visit SQL Server training .In this course, you will learn about the features are available in SQL Server like how to design the language of SQL Server.
  • 20 Request Info

    MICROSOFT SQL SERVER 2005

    For other SQL Server classes and outlines please visit SQL Server training .SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data.