SolidQ Global

The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. The course provides a dedicated module focusing on query tuning.

A good application starts with a good database design. Data is nowadays the most important assets of a company. In our high competitive world, it is an advantage if decisions are supported with timely information from the data. However, low quality of data leads to unreliable information.
 Data Modeling Essentials is a high-end seminar, intended for SQL Server and other RDBMS professionals, including solution architects and IT managers. The course introduces all modern data models, including relational, dimensional and object-relational. During the course, many design myths are going to be revealed.

Data mining looks very simple when it is presented on various conferences. However, in real life, you need quite advanced knowledge in order to mine the data efficiently. During the seminar, attendees are going to learn how to make an overview and gather basic understanding of your data even before you start to mine it. In addition, we are going to explain how the algorithms work, how they can find patterns. Finally, we are going to discuss how to use data mining in your applications.

SQL Server 2008 now supports Spatial Data. With this technology you are enabled to develop “location-aware” application. In this workshop you are going to learn Spatial Data basics and how to use them effectively in your applications.

Por sexta vez consecutiva, Solid Quality Mentors organiza en Madrid su Summit anual, con intervención de la mayor parte del equipo de mentores de habla hispana, así como algunos invitados de Microsoft y otros partners.

As we celebrate the first decade of .NET development we realize that a lot has changed. In a nutshell, development is now much harder because the complexity of the average application has grown significantly. So now the RAD paradigm privileging productivity and raw performance over everything else no longer applies with the same effectiveness. Development needs more effort and resources, but to be really effective it needs to be sustainable. The class addresses this common need by discussing three aspects of applications: quality of code, modeling and layers. Low quality code has a cost and design principles, common practices (refactoring, testing), static analysis, metrics and frameworks for semantic correctness help keeping it affordable. Today, a successful project is a project whose facts and requisites are well understood and communicated. Modeling is an area with very few certainties as far as best practices are concerned, but just for this reason tools, technologies and practices are revised and refined at a surprising speed. Revisiting pillars of object-orientation, the class introduces domain-centric, behavior-focused modeling techniques that represent an affordable approach for many projects. Pinpointing proper layers in the domain of a solution is a key step to guarantee maintainability, extensibility, and testability across the horizontal sections of a typical application¡Xpresentation, business, data.
The class is rich of examples often based on newest technologies such as Managed Extensibility Framework, Code Contracts, Entity Framework 4, NHibernate, ASP.NET MVC.

This one day seminar will cover best practices for designing and managing Integration Services and Analysis Services. Based on lessons learned and best practices created, we will walk through how BI architects and developers can take advantage of these best practices to create better and more robust BI solutions.

The course will cover the main extensibility points of SQL Server Reporting Services 2008: students will learn how to enhance and extend the product functionality by creating custom controls and developing data processing extensions

This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2008 Integration Services, Analysis Services and Reporting Services

This course will introduce Enterprise Reporting, its characteristics and relation to current business projects.  It will provide System Administrators with the knowledge necessary to understand and manage a SQL Server 2005 Reporting Services Enterprise Reporting Solution, and Report Designers the skills necessary to design different kinds of reports

This workshop focuses on the teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2005

During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2005 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution

During this 5-day instructor led training, you will learn the ins and outs of SSIS and how to apply its enterprise functionality to DBA data management and file handling operations as well as data warehouse ETL systems

This hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information

This three-day, instructor-led course provides students with the knowledge and skills to write MDX expressions, calculations and queries for Microsoft SQL Server 2005 Analysis Services in order to implement the most demanding requirements for a Business Intelligence project

This course provides introductory end-user knowledge of basic ProClarity navigation and collaboration for the thin client. This course includes an introduction to and basic understanding of OLAP technology

This course provides introductory end-user knowledge of basic ProClarity navigation and collaboration. Users will learn how to create and modify queries, change view types, and publish views to a Briefing Book.

Analysts and other advanced users learn how to use ProClarity end user clients in order to create publishable content including business logic, custom data sets and key performance indicators. Attendees will learn how to publish analytic views for others to consume in an analytic client or dashboard

This course is for persons who want to correctly design and build AS 2005 cubes from scratch that will perform well being browsed by ProClarity applications. This training also includes the two-day Analyst Training course on the ProClarity Analytics Family

Written and delivered by industry experts, this two-day course provides students with the technical skills required to design and develop basic business models for budgeting, to manage budget cycles and to create management reports using Microsoft Office PerformancePoint Server 2007 (PPS) Planning

Written and delivered by industry experts, this three-day course provides students with the technical skills required to design, develop and manage interactive dashboards using Microsoft Office PerformancePoint Server (PPS) 2007 Monitoring

Written and delivered by industry experts, this five-day course provides students with the technical skills required to design, develop and manage solutions using Microsoft Office PerformancePoint Server 2007 (PPS)

Written and delivered by industry experts, this two-day course provides students with the technical skills required to design, develop and manage scorecards using Microsoft Office Business Scorecard Manager 2005 (BSM)

Written and presented by industry experts, this intensive five-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting and analytics solutions using Microsoft Business Intelligence

Written and presented by industry experts, this intensive five-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting and analytics solutions using Microsoft Business Intelligence

During this 4-day instructor led training, you will learn the ins and outs of SSIS and how to apply its enterprise functionality to data warehouse ETL systems

This one day dimensional modeling workshop focuses on the basic design patterns for building relational database structures for data mart or data warehouse applications on SQL Server

Building a great BI system is not just about being able to use the software; it’s also about getting the overall design right. This course is essentially vendor neutral; it specifically doesn’t cover how to drive any particular software.

During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2008 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution

During this 3-day course, you will learn to deploy, operate and tune an Analysis Services solution. You begin by learning how to prepare for the successful deployment of an Analysis Services solution. You will then learn to update data in a production environment while minimizing its impact on performance. Finally, you will learn to collect and analyze data to improve processing and querying performance

In this course attendees learn how to use Data Mining to find advanced patterns in their data and perform predictions based on the patterns found using SQL Server 2008 Analysis Services

In this course attendees learn how to use Data Mining to find advanced patterns in their data and perform predictions based on the patterns found using SQL Server 2005 Analysis Services

This three-day, instructor-led course provides students with the knowledge and skills to properly manage the SQL Server database development lifecycle in an agile environment. The student will learn how to manage changes to the database structure, ensuring quality through T-SQL unit testing, and how to automate the building and deploying of SQL Server databases

This course is intended for T-SQL developers, DBAs and SQL Server power users who work with SQL Server and need to write queries and develop code using Transact-SQL—SQL Server’s dialect of the standard ANSI-SQL language.

This workshop prepares the database professional with the skills needed for applying SQL Server 2005 & 2008 Integration Services (SSIS) to enterprise DBA and data architecture tasks, including SSIS administration

This seminar teaches you how to identify queries that need tuning and how to tune them. The seminar starts by describing in detail a query tuning methodology developed by Solid Quality Mentors and practiced in production systems

This five day intensive course is designed to give attendees a broad look at the performance tuning concepts and methods found in SQL Server 2005 and SQL Server 2008. This course is designed to prepare the SQL Server DBA for a transition to SQL Server 2005 or SQL Server 2008 while discussing best practices for a variety of performance topics that SQL Server DBAs will face in their day-to-day job functions

Microsoft® SQL ServerTM 2005 High Availability Bootcamp is an advanced, five-day, skills-based course for Microsoft® SQL ServerTM 2005 High Availability solutions. This course provides the SQL ServerTM 2005 database administrator the advanced knowledge and hands-on experience necessary to design, implement, and administer SQL ServerTM 2005 High Availability solutions

Data Modeling Essentials seminar is a high-end course, intended for SQL Server and other RDBMS professionals, including solution architects and IT managers. The course introduces all modern data models, including relational, dimensional and object-relational. Data quality issues are covered as well. During the course, many design myths are going to be revealed. 

The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. The course provides a dedicated module focusing on query tuning.