我需要有关基于SQL Server 2012的考试的帮助 [英] I need help with an SQL server 2012 based exam
问题描述
尊敬的专家，电脑向导和光荣的老师，
我需要你的帮助。
在接下来的几周里，我的SQL技能将被测试，我需要演示以下内容：
涉及SELECT，FROM和WHERE的简单查询
使用SQL中的参数过滤数据
了解LEFT JOIN和INNER JOIN
了解DBA正在使用的数据库
分组和数据汇总
展示案例陈述
任何人都可以通过以下方式努力：
创建一些示例数据库和表格，我可以将其添加到我的SQL Server 2012 Express中。
请求6-10个查询，我可以在上面演示我将在此发布的内容线程。
最后，请检查我的工作，给我一些反馈。
有我需要通过的考试，我真诚地感谢你的帮助。
我会欢迎你的建议，或者任何在线教程，我可以指向的测试为了提高我的理解。
谢谢
我尝试了什么：
我在家里创建了一个数据库，我将其拆分为表格。然而，根据我的需要，这些都很好地排序和格式化，我认为我不能用来测试自己。
Dear esteemed experts, computer wizards and honourable teachers,
I need your help.
In the coming weeks my SQL skills are to be put to the test and I need to demonstrate the following:
A simple query involving SELECT, FROM and WHERE
Use of parameters within SQL to filter data
Understand the LEFT JOIN and the INNER JOIN
Understand the database the DBA is using
Grouping and Aggregation of data
Demonstrate Case Statements
Would anyone kind enough to go through the effort of the doing following:
Create some sample database and tables that I can add into my SQL Server 2012 Express.
Request 6-10 queries from me where I can demonstrate the above which I will post in this thread.
Finally, please check my work, leaving me some feedback.
There is an exam that I need to pass and I would sincerely appreciate your help.
I would welcome your advice, alternatively, any online tutorials, tests that I can be pointed towards in order to improve my understanding.
Thank you
What I have tried:
I have created a database at home which I have split into tables. However, this is all nicely ordered and formatted according to my needs which I don't think I can use to test myself.
推荐答案
祝你好运考试，但这是你的作业，而不是我们的作业：尝试查看Microsoft的NorthWind示例数据库：下载示例数据库| Microsoft Docs [ ^ ]并查看您获得的距离。
I wish you good luck with the exam, but this is your homework, not ours: try looking at the NorthWind sample DB from Microsoft: Downloading Sample Databases | Microsoft Docs[^] and see how far you get.
这篇关于我需要有关基于SQL Server 2012的考试的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
