Trainings

Trainings Filtern

  • Kategorien

  • Zurücksetzen
Course ID: #20761

20761 Querying Data with Transact SQL

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Dauer: 5 Tage
Price:
CHF3'700CHF13'500 zzgl. MwSt
Course ID: #TBL-P1-3-1
New Training

Certified Data Centre Specialist (CDCS)

The Certified Data Centre Specialist is a three-day course designed to bring participants to the level of a suitable sparring partner with suppliers. They will be able to verify offers provided by vendors for correctness, effectiveness and efficiency. CDCS is a must-have certification for professional data centre managers and personnel. CDCS is a pre-requisite for individuals wishing to achieve the elite CDCE (Certified Data Centre Expert) status.

Dauer: 3 Tage
Price:
CHF2'590 zzgl. MwSt
Course ID: #TBL-P1-3
New Training

Certified Data Centre Professional (CDCP)

Unternehmen sind in zunehmendem Masse von der Unterstützung der IT hinsichtlich geschäftskritischer Prozesse abhängig – vor allem bei der Kundenkommunikation. Dabei stellen die Applikationen bezüglich Hochverfügbarkeit und Effizienz immer höhere Anforderungen an die Rechenzentren. In der Realität weisen viele Rechenzentren in puncto Kapazität, Sicherheit oder Effizienz jedoch erhebliche Defizite auf. Gleichzeitig üben die ständig wechselnden Technologien immer stärkeren Druck auf die RZ-Verantwortlichen und RZ-Mitarbeiter aus, und die Umsetzung von Änderungen und Neuerungen muss immer schneller realisiert werden.

In diesem Kurs setzen sich die Teilnehmer mit den Schlüsselkomponenten eines Rechenzentrums auseinander, um die Wechselwirkungen der Gewerke bzw. die Komplexität eines Rechenzentrums zu verstehen. Die Teilnehmer erwerben ergänzendes Know-how im Umgang mit den wichtigsten Bereichen wie z.B. Energieversorgung, Kühlung, Verkabelung, Licht und Brandschutz für ihre Tätigkeiten in einem Hochverfügbarkeitsrechenzentrum der Zukunft.

Dauer: 2 Tage
Price:
CHF1'790 zzgl. MwSt
Course ID: #

55069 PowerShell for SQL Server Administrators

This 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.

Dauer: 2 Tage
Price:
CHF1'550CHF5'800 zzgl. MwSt
Course ID: #20779

20779 Analyzing Data with Excel

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Dauer: 3 Tage
Price:
CHF2'320CHF7'500 zzgl. MwSt
Course ID: #55073

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

Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help organizations create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized & aligned.

Dauer: 3 Tage
Price:
CHF2'320CHF7'500 zzgl. MwSt
Course ID: #

20778 Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Dauer: 3 Tage
Price:
CHF2'320CHF7'500 zzgl. MwSt
Course ID: #20765

20765 Provisioning SQL Databases

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Dauer: 5 Tage
Price:
CHF3'870CHF12'500 zzgl. MwSt
Course ID: #20764

20764 / 21764 Administering a SQL Database Infrastructure

This five-day course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Dauer: 5 Tage
Price:
CHF3'870CHF12'500 zzgl. MwSt
Course ID: #

Building and Managing High Availability Solutions with SQL Server 2016 and 2014

This is a High-Availability course for the real-world. You’ll learn the essentials for buliding and managing a reliable high availability solution.

Dauer: 3 Tage
Price:
CHF2'320 zzgl. MwSt
Course ID: #10987

10987 Performance Tuning and Optimizing SQL Databases

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Dauer: 4 Tage
Price:
CHF3'090CHF9'900 zzgl. MwSt
Course ID: #

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.

Dauer: 5 Tage
Price:
CHF3'870 zzgl. MwSt
Course ID: #

20465 Designing Database Solutions for Microsoft SQL Server

The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

Dauer: 3 Tage
Price:
CHF2'320 zzgl. MwSt
Course ID: #

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 focuses 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. .

Dauer: 5 Tage
Price:
CHF3'870 zzgl. MwSt
Course ID: #

20467 Designing Business Intelligence Solutions with Microsoft SQL Server

This course teaches how to implement self-service BI and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports.

Dauer: 5 Tage
Price:
CHF3'870 zzgl. MwSt
Course ID: #

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.

Dauer: 5 Tage
Price:
CHF3'870 zzgl. MwSt
Course ID: #

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.

Dauer: 5 Tage
Price:
CHF3'870 zzgl. MwSt
Course ID: #

20461 Querying Microsoft 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.

Dauer: 5 Tage
Price:
CHF3'870 zzgl. MwSt
Course ID: #

55232 Writing Analytical Queries for Business Intelligence

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

Dauer: 3 Tage
Price:
CHF2'320 zzgl. MwSt
Course ID: #

55128 Writing Reports with Report Builder and SSRS Level 2

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.

Dauer: 2 Tage
Price:
CHF1'550 zzgl. MwSt
  • 1
  • 2

ANMELDEN

Newsletter

Erhalten Sie aktuelle Informationen zu neuen Schulungen, Angeboten und Aktionen per E-Mail.

Email Subscription
Prozess- und Qualitätsmanagement
Amazon
Leadership and Professional Development