Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Wise Owl run courses in SQL, SSRS, SSIS and SSAS. Since that's a serious acronym list (SAL?), let's look at each of these in more detail.
We haven't included Report Builder in this list because it's basically the same as Reporting Services.
SQL is the language most commonly used to extract information from relational databases like SQL Server. Here's some SQL:
-- use correct database
USE History
-- link the continent and country tables together
SELECT
ev.EventName AS Event,
CONVERT(varchar(10),ev.EventDate,103) AS 'Formatted date',
cy.CountryName AS Country
FROM
tblEvent AS ev
INNER JOIN tblCountry AS cy ON ev.CountryId=cy.CountryId
INNER JOIN tblContinent AS cn ON cn.ContinentId=cy.ContinentId
WHERE
ContinentName='Asia'
ORDER BY
EventDate ASC
Beautiful, isn't it? On our two-day introduction to SQL course, you'll learn how to write commands like the one above, including:
Using WHERE clauses to pick out the rows you want;
Using INNER and OUTER JOIN to link tables together; and
Using GROUP BY to aggregate data.
We also run an advanced two-day SQL course, which will teach you how to use SQL as a programming language, rather than just how to extract data.
You should already be comfortable with SELECT statements in SQL before attending the advanced course.
Here's a stored procedure (the sort of thing you'll learn on the advanced course):
USE Training
GO
-- create a table variable to hold course idsd
DECLARE @TechieCourse TABLE (
ScheduleId int
)
-- insert into this table ids of all C# courses
INSERT INTO @TechieCourse (
ScheduleId
)
SELECT
s.ScheduleId
FROM
tblSchedule AS s
INNER JOIN tblCourse AS c
ON s.CourseId=c.CourseId
WHERE
c.CourseName LIKE '%C#%'
-- now add in ids of all course given by trainer 2936 (Gabriella Montez)
INSERT INTO @TechieCourse (
ScheduleId
)
SELECT
s.ScheduleId
FROM
tblSchedule AS s
WHERE
',' + s.TrainerIds + ',' LIKE '%,2936,%'
-- check this has worked (need to avoid duplicates)
SELECT DISTINCT
t.ScheduleId,
s.StartDate,
c.CourseName,
s.TrainerIds
FROM
@TechieCourse AS t
INNER JOIN tblSchedule AS s
ON s.ScheduleId=t.ScheduleId
INNER JOIN tblCourse AS c
ON s.CourseId=c.CourseId
ORDER BY
s.StartDate
As you see, programming in SQL is a bit scarier.
Reporting Services allows you to create pretty reports like this one:
The sort of report you'll create on our introductory two-day SSRS course.
Reports can include lots of fancy features - gauges, anyone?
A report including radial gauges, the ultimate gimmick in SSRS.
In addition to the introductory course mentioned above, we also run an advanced course (again two days) for those who are already completely comfortable with creating reports in SSRS.
You can think of SSIS as like a marble run. You put marbles (ie data) in at the top, and they go down the run, splitting and recombining until they come out at the bottom or get lost in the system:
A typical SSIS package.
Integration Services packages allow you to extract, transform and load data (it's often called ETL software), and our two-day introduction to SSIS course will show you how to create pretty diagrams like the one above!
From SQL Server 2012 onwards, you can now create a completely different type of model using Analysis Services, which is remarkably similar to PowerPivot in Excel. We run a two-day course on tabular models in SSAS:
A tabular model is a model of your database, but with columns and tables renamed and simplified.
If you've used PowerPivot in Excel, you're well on the way to using SSAS tabular models (they even use the same underlying DAX expression language).
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.