<

Query data with no SQL code (11)

Posted on
6,059 Points
59 Views
Last Modified:
Published
Experience Level: Beginner
1:36
Máté Farkas
Database Expert with 15+ years experience (SQL, Access, Power BI).
Section 11: Next steps

Course: This course is created for business people or data analysts who want to query data from an SQL Server database but don't want to write codes and queries in SQL language. This course teach you how to use GUI of SQL Server Management Studio Query Designer Tool.

Video Steps

01. In this last section you can see what could be the next steps after this course

Here you get some homework or some hints how to improve your knowledge about the Query Designer.
0
1 Comment
LVL 28

Author Comment

by:Máté Farkas
Jump to prev section:Query data with no SQL code (10) - 10. Using multiple subqueries in a query
0
Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.
A clarification of some common doubts about DBCC CHECKDB for Database Administrators. Includes estimated times to repair database corruption's in production databases.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month