SQL project

71 %
29 %
Information about SQL project

Published on December 31, 2016

Author: PingYin8

Source: slideshare.net

1. Expenses for City of Dallas in 2013 & 2014 Ping Yin 9/20/2016

2. Overview Purpose: Querying data to find features Steps: Step 1: Preparing data Step 2: Querying data

3. Overview Data source: www.dallasopendata.com/Financial 

4. Step 1: Preparing data  1.Defining library and uploading data

5. Step 1: Preparing data  2.Importing data and generating SAS data sets

6. Step 1: Preparing data  3.Using data step to format data sets

7. Step 1: Preparing data  3.Using data step to format data set

8. Step 1: Preparing data  3.Using data step to format data set

9. Step 2: Querying data  1.A glance of data sets

10. Step 2: Querying data  2.Total expenses in both years

11. Step 2: Querying data  3.Displaying payments monthly

12. Step 2: Querying data  3.Displaying payments monthly

13. Step 2: Querying data  4.Top 10 max payments

14. Step 2: Querying data  4.Top 10 max payments

15. Step 2: Querying data  5.Creating two tables grouped by vendors

16. Step 2: Querying data  5.Creating two tables grouped by vendors

17. Step 2: Querying data  6.Top 10 vendors

18. Step 2: Querying data  6.Top 10 vendors

19. Step 2: Querying data  7.Top 10 new vendors in 2014

20. Step 2: Querying data  8.Top 10 vendors amount increased from 2013 to 2014

21. Step 2: Querying data  9.Top 10 vendors amount decreased from 2013 to 2014

22. Step 2: Querying data  10.Top 10 vendors by percent

23. Step 2: Querying data  10.Top 10 vendors by percentage

24. Step 2: Querying data  11.Top 10 vendors percentage increased from 2013 to 2014

25. Step 2: Querying data  12.Top 10 vendors percentage decreased from 2013 to 2014

26. Thanks!

Add a comment

Related pages

SQL Server Projects - msdn.microsoft.com

Create a new SQL Server project by clicking the File menu, selecting Project, and then selecting SQL Server Project in the New Project Dialog Box.
Read more

SQL Server Projects | 1000 Projects

SQL Projects topics with beginner projects for students with source code and project report for free download.
Read more

Projects (SQL Server Management Studio) - MSDN - Microsoft

SQL Server script projects are displayed in the Solution Explorer component of Management Studio. A script project can contain zero or more project files.
Read more

SQL Server Database Development in Visual Studio

This article discusses using a SQL Server database project in Visual Studio and letting VS do all the work. Unfortunately this only handles very small situations. 1.
Read more

Create an Access project - support.office.com

An Access project is an Access file (.adp) that provides a direct, efficient connection to a Microsoft SQL Server database through the OLE DB component architecture.
Read more

Creating A New Database Project - SQL Server Tips ...

By: Armando Prato Overview. We will now go over creating the initial database project. Explanation. After starting Visual Studio 2010, create a new project as follows
Read more

Free SQL Server Projects and Samples | SQL Server 2005 ...

CodePlex offers hundreds of great free SQL Server 2008 and 2005 projects and samples at the Microsoft SQL Server Community Projects & Samples page.
Read more

SQL Jobs for January 2017 | Freelancer

Freelancer; Jobs; SQL; 1 SQL Jobs and Contests Get your SQL development project outsourced from an efficient and reliable team. Freelancer.com is the ideal ...
Read more

sql - What is the difference between Select and Project ...

What is the difference between Select and Project ... Please note that this question is about relational algebra operators as opposed to SQL's ... Project Operation ...
Read more

Build Database Projects by Using SQL Server Management Studio

A database script project is an organized set of scripts, connection information, and templates that are all associated with a database or one part of a database.
Read more