This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.
This course teaches experienced SQL Server 2000 database administators how to replicate data effectively using Microsoft SQL Server 2000 replication in complex production environments.
This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times.
This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005.
This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers.
The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005.
Optimising performance of SQL Server databases and applications is one of our passions! We've combined two Microsoft Official Curriculum courses to address performance analysis and optimisation with SQL Server databases and applications. During this comprehensive week we'll not only cover Microsoft's Official Curriculum for optimising SQL Server, but you'll also learn some great tips, tricks and in-depth skills directly from Australia's top SQL performance experts !
Sign up this special offer before April 14th and get the entire week of training for only $1999 – that's $750 off the standard course rate!
This 4-day instructor-led course is designed to teach Oracle DBAs how to leverage their skills and experience as an Oracle DBA to manage a SQL Server system
This three-day instructor-led workshop teaches advanced techniques for accurately
and efficiently fetching and manipulating data using SQL Server 2005 databases using
the Transact-SQL language. The workshop is intended for people who want to learn advanced techniques
to access and manipulate their data more effectively. It is most suited to those
who are regularly producing reports using T-SQL and who would like to learn how
to write more effective queries and T-SQL programs.
This learning product will teach database professionals and developers to successfully author, deploy, and manage reports in their organization using MS Reporting Services.
This course provides students with the knowledge and skills necessary to design relational star schema structures, to design data extract, transform, and load programs, and to populate relational data marts using Data Transformation Services.
This course provides students with the knowledge and skills necessary to use MDX expressions to add calculated members and other dynamically calculated values to an Analysis Services cube.
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution
This two-day instructor-led course provides students with the knowledge and skills to design databases for Microsoft SQL Server 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques).
This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.
This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005.
This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005.
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution
The purpose of this 5-day instructor-led course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005.
This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times.
This three-day instructor-led workshop teaches advanced techniques for accurately
and efficiently fetching and manipulating data using SQL Server 2005 databases using
the Transact-SQL language. The workshop is intended for people who want to learn advanced techniques
to access and manipulate their data more effectively. It is most suited to those
who are regularly producing reports using T-SQL and who would like to learn how
to write more effective queries and T-SQL programs.
This two-day instructor-led workshop introduces fundamental querying techniques,
such as returning and manipulating data in a SQL Server 2005 database using the
Transact-SQL language. The workshop is intended for people who want to learn about how to control
their data more effectively through the use of T-SQL. People who have experience with
T-SQL may still learn a lot from the course, although it is also suited to those who have
little or no experience with the language.
The purpose of this 5-day instructor-led course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005.
21-Feb-2008 Over 100 people from Melbourne's SQL Server community were in attendance on Tuesday at Freshwater place, Melbourne's Microsoft Head Quarters for February's SQL Server user group meeting to see Solid Quality Learning's Rob Farley present new language features including MERGE, Table Valued Parameters, Row Constructors and += for SQL Server 2008.
Rob Farley’s February 4th T-SQL Querying Fundamentals course is a proven success!
08-Feb-2008 The next scheduled T-SQL course will be held in Sydney on the 28th of April and then the 5th of May in Melbourne, Solid Quality Learning advises to reserve places while they are still available.
T-SQL Querying Fundamentals with Rob Farley
29-Jan-2008 This two-day instructor-led workshop to be held in Sydney, Brisbane and Melbourne introduces fundamental querying techniques, such as returning and manipulating data in a SQL Server 2005 database using the Transact-SQL language.
