WGU D427- Data Management
- Applications All Lab Solutions
, This is a chapter by chapter D427 lab solution guide. Do yourself a favor, try to figure each lab out yourself,
and only use this if your truly stuck.
Chapter 1 - Relational Databases
Contains 0 labs as of 12/16/2023
Chapter 2 - Complex Queries
Contains 6 labs as of 12/16/2023
2.9 LAB - Select number of movies grouped by year
SELECT Year, COUNT(*) as Total
FROM Movie
GROUP BY Year
2.10 LAB - Select movie ratings with le join
SELECT m.Title, m.Year, r.Description
FROM Movie AS m
LEFT JOIN Rating AS r
ON m.RatingCode = r.Code;
2.11 LAB - Select employees and managers with inner join
SELECT e1.FirstName AS Employee, e2.FirstName AS Manager
FROM Employee AS e1
INNER JOIN Employee AS e2
ON e1.ManagerId = e2.ID AND e1.ManagerID IS NOT NULL
ORDER BY e1.FirstName
2.12 LAB - Select lesson schedule with inner join
- Applications All Lab Solutions
, This is a chapter by chapter D427 lab solution guide. Do yourself a favor, try to figure each lab out yourself,
and only use this if your truly stuck.
Chapter 1 - Relational Databases
Contains 0 labs as of 12/16/2023
Chapter 2 - Complex Queries
Contains 6 labs as of 12/16/2023
2.9 LAB - Select number of movies grouped by year
SELECT Year, COUNT(*) as Total
FROM Movie
GROUP BY Year
2.10 LAB - Select movie ratings with le join
SELECT m.Title, m.Year, r.Description
FROM Movie AS m
LEFT JOIN Rating AS r
ON m.RatingCode = r.Code;
2.11 LAB - Select employees and managers with inner join
SELECT e1.FirstName AS Employee, e2.FirstName AS Manager
FROM Employee AS e1
INNER JOIN Employee AS e2
ON e1.ManagerId = e2.ID AND e1.ManagerID IS NOT NULL
ORDER BY e1.FirstName
2.12 LAB - Select lesson schedule with inner join
