Explore Our Courses

Business Intelligence in MS SQL Server 2008

14 Hours
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS. The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line. The participant will acquire knowledge of scripting XML / A and MDX.
Read more...

Developing in SQL Server Business Intelligence

35 Hours
Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects. The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself. 4 Top Takeaways from the Course
  1. Make your existing data work harder for you
  2. Integrate diverse data stores to a single repository
  3. Transform raw data to business intelligence
  4. Create eloquent reports from raw data
Read more...

Administration with Powershell

35 Hours
This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration. Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
Read more...

Last Updated:



Testimonials(25)

database optimization, dedicated approach, ability to ask questions, insight/assessment of our database

Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server

Discussing your own database :D

Przemysław - Mikrobit
Course - Administering in Microsoft SQL Server

Extensive knowledge and clear way of translating

Kamil Wróblewski - Mikrobit
Course - Administering in Microsoft SQL Server

Contact from the instructor, explanation of all issues, exercises

Dariusz
Course - Administering in Microsoft SQL Server

Lots of examples, interesting programming facts, practical approach.

Łukasz - Mitsubishi Electric Europe B.V. (Sp. z o.o.)
Course - Administering in Microsoft SQL Server

Lot of content and exactly the requested one.

Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

There were a lot of exercises really good exercises and the trainer passed on his knowledge well.

Zsolt - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Communicative, big knowledge and well presented material

Filip Gotowicki - EY GDS (CS) POLAND SP. Z O.O.
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Open, frank and knowledgeable

Shiva Wagle - Mosaic Primary Care Network
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

It is interactive

Syed Muhammad Mehdi - Mosaic Primary Care Network
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

Being human and talking to us as understandable possible

Sorin
Course - Database Administration Fundamentals for MS SQL Server

All the various ways Darius explained concepts and then put them into our database tables.

James Rodi - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course

Practical exercises for practice and understanding of the concept, clarification provided for any questions.

Safdar Abbas - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course

Transfer of knowledge using simple and understandable examples.

Katsiaryna
Course - SQL language in MSSQL

i really liked the pace of the training, and the exercises given inbetween the explanations

Trana
Course - SQL in SQL Server

Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.

Stefan
Course - SQL in SQL Server

Really enjoyed compression data components

James - Medtech Limited
Course - Transact SQL Advanced

new techniques and style

Goniforte Balane - MORESCO-1
Course - Transact SQL Advanced

Some additional tips given to us that is somewhat outside topic area

John Erzon Tan - MORESCO-1
Course - Transact SQL Advanced

Outside topic tips Randomized new IDS, Indexes, Window function The joke was too funny and realistic

ALBERT SANDIG - MORESCO-1
Course - Transact SQL Advanced

when the trainer lets us do task one by one. the additional tips and ideas given to us and also the joke haha

Carl Sherwin Francis Llenares - MORESCO-1
Course - Transact SQL Advanced

I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.

Tom - Welsh Revenue Authority
Course - Transact SQL Basic

Łukasz was very good. I liked how Łukasz talked about best practices. Pace was good. I liked the exercises. Having a wiki for future reference is good

Jake Real - Welsh Revenue Authority
Course - Transact SQL Basic

Lukasz was very patient and knowledgeable and made learning SQL very fun and informative. Easily one of the most rewarding training sessions of any subject I've had the pleasure of being part of!

Carwyn - Welsh Revenue Authority
Course - Transact SQL Basic

Upcoming Courses

Other regions in Indonesia

Other Countries

These courses are also available in other countries
Online SQL Server BI kursus, Akhir pekan SQL Server BI kursus, Selamat Malam SQL Server BI pelatihan, SQL Server BI kamp pelatihan, SQL Server BI instruktur kepala, Akhir pekan SQL Server BI pelatihan, Selamat Malam SQL Server BI kursus, SQL Server BI pelatih, SQL Server BI Instruktur, SQL Server BI pelatih, SQL Server BI kursus pelatihan, SQL Server BI kelas - kelas, SQL Server BI di tempat, SQL Server BI kursus privat/ pribadi, SQL Server BI pelatihan satu lwan satu
1