1 / 22

Consult America Technology Consulting Services

Learn how to import data from Excel and create new tables with query instructions in Microsoft SQL Server. Executing queries and managing database elements efficiently.

braddock
Download Presentation

Consult America Technology Consulting Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft SQL Server 1. Import Data From Excel Spreadsheet 2. Creating New Table and Query Instruction Consult America Technology Consulting Services

  2. Microsoft SQL Server Microsoft SQL Server: Microsoft SQL Server is a relational database management system developed by  Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applicationswhich may run either on the same computer or on another computer across a network (including the Internet). GUID: Graphics User Interface Development Free Download Microsoft SQL Server 2014 video URL: https://www.youtube.com/watch?v=tNMA41lyq8M&t=17s

  3. Microsoft SQL Server 1. Import Data From Excel Spreadsheet Step by Step: (1) Launch the application (2) Connect EXPORT

  4. Microsoft SQL Server (3) Create new data table ”Employees” (4) Import data table (5) Import step (6) Import step

  5. Microsoft SQL Server (7) Import step (8) Import step (9) Import step (10) Import step

  6. Microsoft SQL Server (11) Import step (12) Import step (13) Import step (14) Import step

  7. Microsoft SQL Server (15) Import step (16) Import successful (17) Refresh (F5) (18) Check data table

  8. Microsoft SQL Server (19) Connect and Execute (20) View imported full table

  9. Microsoft SQL Server (20) For example: • Find out those employees who have commission? SELECT first_name,last_name, salary, commission_pct, salary+salary*commission_pct FROM Employees.dbo.export WHERE commission_pct is not NULL; • Find out the top 10 salaried employees? SELECT first_name,last_name, salary FROM (SELECT first_name, last_name, salary FROM Employees.dbo.export ORDER BY salary DESC) WHERE rownum<=10; • Find out those employees who get more then avg salary? SELECT first_name,last_name, salary FROM Employees.dbo.export WHERE salary>(SELECT AVG(salary) FROM Employees.dbo.export);

  10. Microsoft SQL Server • Find out departments who do not have employees? (SELECT e.first_name,e.last_name,e.department_id, d.department_name FROM employees.dbo.export e, departments d WHERE e.department_id(+)=d.department_id) MINUS (SELECT e.first_name,e.last_name,e.department_id, d.department_name FROM employees.dbo.export e, departments d WHERE e.department_id=d.department_id); • Find out managers of the employees? SELECT e.first_name employee_first_name, e.last_name employee_last_name, m.first_name manager_first_name, m.last_name manager_last_name FROM Employees.dbo.export e, Employees.dbo.export m WHERE m.employee_id=e.manager_id

  11. Microsoft SQL Server 2. Creating New Table and Query Instruction : The following is the creation of "Library management system“ database process Library DB(database)

  12. Microsoft SQL Server Create new folder(database): Library DB Create new file (data table): • dbo.BorrowBook • dbo.Studen • dbo.Book • dbo.Press • dbo. Book Type • dbo.Author

  13. Microsoft SQL Server SQL Data Type : • 1. Binary Data Type (Binary, Varbinary, Image) • 2. Character Data Type (Char, Varcher, Text) • 3. Unicode (Nchar, Nvarchar, Ntext) • 4. Date and Time Date Types (Date Time, Small Date Types) • 5. Digital Data Types (Int, Smallint, Tingint, Decimal, Numeric) • 6. Money Data Types (Money, Small money) • 7. Special Data Types (Time Stamp, Bit, Unique identifier)

  14. Microsoft SQL Server Create student data table: (student data table structure) SQL data table type:

  15. Microsoft SQL Server Create Data table: dbo.BorrowBook dbo.Student dbo.Book

  16. Microsoft SQL Server dbo.Press dbo. Book Type dbo.Author

  17. Microsoft SQL Server 1. Query name is "Mike" student ID, mobile number and e-mail address. 2.Query name is not called "Mike" student ID, mobile and e-mail address.

  18. Microsoft SQL Server 3.Check out between the ages of 20-25 the students ID and names. 4.Discover students who do not fill out the "age" of information. 5. Query name is "Mike", "John", "Bob" of the student ID and age.

  19. Microsoft SQL Server 6. Query which student to borrow books 7. Statistics for each category in the highest price: (using nested queries)

  20. Microsoft SQL Server 8. Query students to borrow books from more than two books: (using nested queries) 9.Export Data Table

  21. Microsoft SQL Server 10. The author of the most books on the query More query.....

  22. THANKYOU

More Related