Sql Server Portfolio

|
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 76 views
of 16

Please download to get full document.

View again

Description
1. SQL Server Portfolio<br />For<br />Brian Hertzke<br />Email: brian.hertzke@gmail.com<br /> 2. Contents<br…
Share
Transcript
  • 1. SQL Server Portfolio<br />For<br />Brian Hertzke<br />Email: brian.hertzke@gmail.com<br />
  • 2. Contents<br /><ul><li>Introduction
  • 3. Database Design/Development
  • 4. TSQL Coding
  • 5. XML Querying and Shredding
  • 6. SQL Server Integration Services (SSIS)
  • 7. SQL Server Reporting Services (SSRS)</li></li></ul><li>Introduction<br />This portfolio is meant to give brief examples of my work and progress through the SetFocus SQL Server Master’s Program. Inside are snapshots of different aspects of our projects showing the diversity and depth of the program. <br />
  • 8. Design/Development<br />This is a database designed for a movie rental company much like Netflix. This database contains :<br /> - Customer information<br /> - Product information<br /> - Inventory<br /> - Sales history<br /> - Rental history<br />
  • 9. TSQL Queries<br />Queries using: <br /> - Grouping <br /> - Aggregate functions<br /> - Sub-queries<br /> - Table joins<br />
  • 10. TSQL Coding<br />Stored procedures:<br /> This stored procedure will<br /> renew a customers library<br /> membership for a year.<br />
  • 11. TSQL Coding<br />DDL & DML Triggers <br />
  • 12. XML Coding and Shredding<br />XML Manipulation:<br /> - Creating<br /> - Reading/Querying<br /> - Exporting/Importing<br />
  • 13. XML Coding and Shredding<br />- Creating XML from an<br /> OLE data source<br />
  • 14. XML Coding and Shredding<br />- Importing XML into a database<br />
  • 15. SQL Server Integration Services (SSIS)<br />
  • 16. SQL Server Integration Services (SSIS)<br />Using SSIS for business intelligence solutions<br />
  • 17. SQL Server Integration Services (SSIS)<br />OLE Data/File<br /> manipulation <br />
  • 18. SQL Server Reporting Services (SSRS)<br />Reporting company sales<br /> by product type<br />
  • 19. This report shows library <br /> member information and fee<br /> histories<br />
  • 20. SQL Server Reporting Services (SSRS)<br />Reporting employee sales in a<br /> matrix view<br />
  • Related Search
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks