Transcript Daniel Black

Daniel Black – SQL Server Developer




What is SetFocus
The SetFocus SQL Master’s Program is an intensive, hands–
on, project oriented program allowing knowledge and
valuable experience putting the SQL skill set to use in a
simulated work environment.
I received over 300 hours of in-depths hands on experience
focused on SQL.
SetFocus projects are real world projects that are distributed
just as I would receive in a position. I received project
specifications and was expected to identify best courses of
action with deadlines set for completion.
Backing up a Database in SSMS
DDL Trigger
User Defined Stored Procedure
Customer Billing Summary
T-SQL – File Group Restore
T-SQL – Using CTE's
SSMS – Setting up mirroring
Resource Governor
SSMS – Scheduled Job Creation
T-SQL – Security Measures
T-SQL – Using CTE's
SSIS – Extract from CSV & Insert/Update Orders & Details Tables – Part 1
SSIS – Extract from CSV & Insert/Update Orders & Details Tables – Part 2
SSIS – Extract from CSV & Insert/Update Table
SSIS – Extract from CSV & Insert/Update Table
SSIS – Package to run the other packages
Designing the Vendor Sales By Year in SSRS
The Finished Report
Designing the Top Vendors & their Top Products Report
Function Designed for the Top Vendors & their Top Products Report
Query Design for the Top Vendors & their Top Products Report
The Top Vendors & their Top Products Report