Courses Solid Global Home

Advanced T-SQL Querying, Programming and Tuning for SQL Server 2008 and 2005 (compact)

Thu, 12 Aug 2010 07:20:23 GMT

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.

Data Modeling Essentials One-day-Seminar

Sat, 28 Aug 2010 19:45:39 GMT

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 with SQL Server 2008 R2

Tue, 20 Jul 2010 13:21:05 GMT

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 Spatial Data Support

Mon, 19 Jul 2010 09:50:14 GMT

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.

SQLU Summit Madrid 2010

Mon, 07 Jun 2010 13:12:06 GMT

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.

Workshop: Patterns and Practices of Architecting .NET Applications

Mon, 07 Jun 2010 07:55:59 GMT

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.

Advanced Business Intelligence Practices

Sat, 05 Jun 2010 10:55:54 GMT

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.

SQL Server 2008 Reporting Services for Developers

Tue, 10 Aug 2010 13:44:33 GMT

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

SQL Server 2008 End-to-End Business Intelligence Workshop

Tue, 10 Aug 2010 13:43:53 GMT

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

SQL Server 2005 Reporting Services

Tue, 10 Aug 2010 13:43:29 GMT

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

SQL Server 2005 End-to-End Business Intelligence Workshop

Tue, 10 Aug 2010 13:42:59 GMT

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

SQL Server 2005 Analysis Services

Tue, 10 Aug 2010 13:42:35 GMT

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

SQL Server 2005 & 2008 Integration Services End-to-End

Tue, 10 Aug 2010 13:42:15 GMT

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

Solving Business Problems with MDX in SQL Server 2008

Thu, 03 Jun 2010 09:05:17 GMT

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

Solving Business Problems in MDX

Tue, 10 Aug 2010 13:41:46 GMT

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

ProClarity Web Standard Client End User Training

Tue, 10 Aug 2010 13:41:18 GMT

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

ProClarity Professional Client End User Training

Tue, 10 Aug 2010 13:40:48 GMT

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.

ProClarity Analyst Training

Tue, 10 Aug 2010 13:40:27 GMT

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

ProClarity Administrator Training (Analysis Services 2005)

Tue, 10 Aug 2010 13:40:05 GMT

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

Microsoft Office PerformancePoint Server 2007 Planning

Wed, 01 Sep 2010 21:14:32 GMT

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

Microsoft Office PerformancePoint Server 2007 Monitoring & Analytics

Tue, 10 Aug 2010 13:38:36 GMT

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

Microsoft Office PerformancePoint Server 2007 End-to-End

Wed, 01 Sep 2010 21:07:42 GMT

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)

Microsoft Office Business Scorecard Manager 2005

Tue, 10 Aug 2010 13:07:27 GMT

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)

Microsoft BI Bootcamp: SQL Server 2008, Office System 2007 and PerformancePoint Server 2007

Thu, 03 Jun 2010 09:04:05 GMT

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

Microsoft BI Bootcamp: SQL Server 2005, Office System 2007 and PerformancePoint Server 2007

Tue, 10 Aug 2010 13:06:40 GMT

Enterprise ETL with SQL Server Integration Services 2005 & 2008

Tue, 10 Aug 2010 13:05:59 GMT

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

Dimensional Modeling

Tue, 10 Aug 2010 13:05:21 GMT

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

Designing Effective BI Systems

Thu, 03 Jun 2010 09:03:15 GMT

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.

Designing and Developing Solutions with SQL Server 2008 Analysis Services

Tue, 10 Aug 2010 13:04:52 GMT

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

Deploying, Operating, and Tuning an Analysis Services 2008 Solution

Tue, 10 Aug 2010 13:04:26 GMT

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

Data Mining with SQL Server 2008

Thu, 03 Jun 2010 09:03:02 GMT

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

Data Mining with SQL Server 2005

Tue, 10 Aug 2010 13:03:48 GMT

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

Agile Database Techniques Using Visual Studio Team System 2008

Tue, 10 Aug 2010 13:03:24 GMT

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

T-SQL Fundamentals

Fri, 13 Aug 2010 04:32:52 GMT

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.

SQL Server 2005 & 2008 Integration Services for Database Professionals

Thu, 03 Jun 2010 09:02:24 GMT

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

Query Tuning for SQL Server 2000 & 2005

Tue, 10 Aug 2010 13:02:42 GMT

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

Microsoft SQL Server Performance Tuning Bootcamp

Tue, 10 Aug 2010 13:02:07 GMT

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 Server High Availability Bootcamp (2005)

Tue, 10 Aug 2010 13:01:40 GMT

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

Thu, 03 Jun 2010 08:57:21 GMT

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.

Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005 & 2008

Tue, 22 Jun 2010 05:00:45 GMT

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.