sql查询技能_如何找到可利用您SQL技能的奖励性工作
sql查询技能
In 1990 Bill Gates made one of his more memorable keynote speeches at the COMDEX trade show, where he shared a vision of a world in which Microsoft would provide information at your fingertips. Thanks to improvements in technology, that vision (except for it being Microsoft-centric) is a reality 25 years later.
1990年，比尔·盖茨(Bill Gates)在COMDEX贸易展上发表了他更令人难忘的主题演讲之一，在那里他分享了一个微软将在您的指尖提供信息的世界的愿景。 由于技术的进步，这种愿景(除了以Microsoft为中心的愿景除外)在25年后成为现实。
Memory is faster, has orders of magnitude more capacity, and is much more affordable. Hard drives have gone through similar improvements in price and performance, and with more people using mobile devices than desktop or laptop computers, users can access information from practically anywhere. More information at your fingertips means more databases, and this means numerous opportunities for those skilled in structured query language (SQL).
内存速度更快，容量增加几个数量级，并且价格更便宜。 硬盘在价格和性能上都进行了类似的改进，并且使用移动设备的人数超过台式机或笔记本电脑的数量，用户可以从几乎任何地方访问信息。 唾手可得的更多信息意味着更多的数据库，这对于结构化查询语言(SQL)的熟练人员而言意味着无数的机会。
Setting up the Work Environment
搭建工作环境
One of the first issues SQL job seekers need to resolve is whether or not they can work remotely. Companies are more open to the idea of letting employees work outside of the office than they were before, and this includes jobs involving SQL or other database work.
SQL求职者需要解决的第一个问题是他们是否可以远程工作。 公司比以前更愿意让员工在办公室外工作，这包括涉及SQL或其他数据库工作的工作。
If you want to work remotely, you’ll need adequate space and furniture to set up a home office, and a reliable computer with a broadband internet connection. You have all the equipment you need to do most jobs from home. You no longer have to pay a king’s ransom to get decent online speeds. Many affordable plans, like ones offered by Frontier Fios, start as low as $19.99 per month.
如果要远程工作，则需要足够的空间和家具来设置家庭办公室，以及一台具有宽带Internet连接的可靠计算机。 您拥有在家中完成大多数工作所需的所有设备。 您不再需要支付国王的赎金即可获得不错的在线速度。 许多可负担得起的计划，如Frontier Fios提供的计划，每月最低只要$ 19.99。
Which Job Description Fits Better: Database Administrator or Developer?
哪个职位描述更适合：数据库管理员或开发人员？
Most jobs requiring SQL skills fall into two categories: database administrator (DBA) or database developer.
大多数需要SQL技能的工作分为两类：数据库管理员(DBA)或数据库开发人员。
A DBA’s job in a nutshell is to ensure that database operations run smoothly. One of the key requirements for such a job is experience in performance tuning. This could include several tasks like making sure the database has the right amount of space allocated, examining how the number of active connections fluctuates, configuring hardware and operating systems to meet demand, and optimizing execution plans.
简而言之，DBA的工作是确保数据库操作平稳运行。 这项工作的关键要求之一是性能调整的经验。 这可能包括多项任务，例如确保数据库分配了正确的空间量，检查活动连接的数量如何波动，配置硬件和操作系统以满足需求以及优化执行计划。
One type of execution plan that gives DBAs nightmares is the dreaded table scan, where a query must examine every record in a table to find the desired result, because the table is not indexed properly. It’s like looking for a word in an unabridged dictionary page by page, without using lettered tabs, until you find the right word.
导致DBA噩梦的一种执行计划是可怕的表扫描 ，其中查询必须检查表中的每条记录以找到所需的结果，因为表的索引不正确。 这就像在没有字典的字典中逐页寻找单词，而无需使用字母标签，直到找到正确的单词。
DBA job requirements will look mostly at years of experience (including tuning), the size of the databases the applicant worked on, and what kinds of systems, OSs, and hardware the applicant worked with.
DBA的工作要求主要取决于多年的经验(包括调优)，申请人使用的数据库大小以及申请人使用的系统，操作系统和硬件类型。
Database developers typically need to be able to write queries in SQL, and work with other languages like C, C#, Java/JavaScript, or Perl. The combination of the two allows developers to create applications or webpages that access data. Queries can be created on the fly from an application, often known as an ad-hoc query, or through queries that are used frequently and don’t change, known in some SQL environments as stored procedures.
数据库开发人员通常需要能够用SQL编写查询，并能够与其他语言(例如C，C＃，Java / JavaScript或Perl)一起工作。 两者的结合使开发人员可以创建访问数据的应用程序或网页。 可以从应用程序动态创建查询(通常称为即席查询)，也可以通过频繁使用且不会更改的查询(在某些SQL环境中称为存储过程)来创建查询。
Searching for the SQL Job You Want
搜索您想要SQL作业
The old adage that ‘Google is your friend’ applies when it comes to searching for a job, but it isn’t the be-all-and-end-all of the process. Searching on job forums for some combination of keywords like ‘DBAs’, ‘developers’, ‘SQL’ is a good start. Including words like ‘telecommute’ and ‘remote’ might help, but you have to see what kind of results you are getting. If you enter too many keywords at the search engine level, your results may be limited.
谷歌是你的朋友，这句古老的谚语在寻找工作时适用，但这并不是整个过程的全部。 在工作论坛上搜索“ DBA”，“ developers”，“ SQL”等关键字的某种组合是一个不错的开始。 包括“ telecommute”和“ remote”之类的词可能会有所帮助，但您必须查看所获得的结果。 如果您在搜索引擎级别输入的关键字过多，则结果可能会受到限制。
A better approach may be to enter more general keywords at the search engine level, then examine the results. Many results may be posted on job sites, which have their own filtering criteria. If so, then a general search from a search engine followed by a more specific search. As you get more familiar with which job sites have the best quality listings for SQL jobs, it may be easier to use those sites directly and skip the search engine. There is no hard and fast rule for a job search; it takes a lot of trial and error to get the best results.
更好的方法可能是在搜索引擎级别输入更多常规关键字，然后检查结果。 许多结果可能会发布在作业站点上，这些站点具有自己的过滤条件。 如果是这样，则从搜索引擎进行常规搜索，然后再进行更具体的搜索。 当您更加熟悉哪些工作站点具有SQL任务的最佳质量列表时，直接使用这些站点并跳过搜索引擎可能会更容易。 寻找工作没有硬性规定。 要获得最佳结果，需要大量的反复试验。
There are many job opportunities for people who have a background in SQL as long as they have other valued skills to go with it. More than ever, people want information and they want it now. The only way that is possible is with numerous people behind the scenes to build and provide access to what has become a vast data infrastructure.
只要具备SQL的其他有价值的技能，对于拥有SQL背景的人来说，他们就有很多工作机会。 人们比以往任何时候都想要信息，而现在他们想要信息。 唯一可行的方法是在幕后建立大量人员，以构建和提供对已成为庞大数据基础架构的访问。
sql查询技能