Making Use of for Training Opportunities

In feedback provided to Library IT, many staff have shown an interest in learning more about using SQL and SharePoint. Library IT is listening, so we wanted to share with you the topics and courses available at is an online subscription library that teaches the latest software tools and skills through high-quality instructional videos taught by recognized industry experts. The full range of content is available to all Yale University staff.

To access, visit, and log in using your NetId and password. The beauty of is it is available to you anytime, anywhere. The courses range in level from beginner to advanced instruction. Instructors provide exercise materials — so you are not only listening and watching, but also participating in the lessons.

Figure. 1: Search results allow you to filter

When you search for specific topics at, such as “SQL,” you will get a wide variety of courses specific to that search, “SQL”. In Figure 1, you will see that you can filter the search results based on your level of experience, allowing you to go at your own pace or delve deeper into a topic. Another option available is to see if the topic you are interested in is part of a Learning Path.

Learning Paths has developed “Learning Paths” for users who would like to learn about a topic in a structured and comprehensive manner. A Learning Path it is a set of sequential courses complete with quizzes and practice sessions for students to build their knowledge of a chosen topic. You can learn about a new topic or brush up on one you know as a refresh. Learning Paths cover a wide variety of topics.

After students complete a “Learning Path,” they can share the certificate of completion they receive on their LinkedIn account. You can complete the individual courses at your own pace, and fit it into your schedule based on when you have time available.  If you are taking it as a refresher, you can also skip ahead to focus on material of most interest to you.


Just a few courses that might be of interest:

  • Learning SQL. A beginners course.
  • SQL Tips Tricks and Techniques. An intermediate course, teaching you the top 12 must-have SQL techniques for data science.
  • SQL: Data Reporting and Analysis. An intermediate course that teaches you how to get the data you want by writing a bit of SQL code. You will be able to pull data out of the database and manipulate it to create reports.
  • Advanced SQL for Data Scientists. Advanced course, requires prior knowledge of SQL. This course is designed to help you learn how to perform common data science tasks, including finding, exploration, and extraction within relational databases.
  • SharePoint for Project Management. Learn how to use the built-in features in SharePoint to manage projects.
  • SharePoint Tips Weekly. This weekly series is designed to provide quick tips you can use to get the most out of the features in SharePoint.
  • SharePoint 2016 and SharePoint Online New Features. Office 365 integration is a big win, as well as role creation control, new compliance features, and the touch-friendly interface for mobile devices. Learn about all these

Service interruption for BorrowDirect, Sharepoint and more


Library IT is pleased to report that BorrowDirect access is returning for users on and off campus, but the change may take effect over several hours. Please let us know if you encounter any issues with BorrowDirect tonight or over the weekend. Additional updates:

•         SharePoint ( will be unavailable over the weekend. Library IT will update again on Monday with more information on SharePoint. A big thank you goes out to our SharePoint stakeholders who got in touch with us; your input was extremely helpful. At this time, Library staff do not need to take any actions with SharePoint.

•         LIT will address other smaller systems and services living on this server after SharePoint has been restored properly.

Please let us know if you have questions or concerns- we again thank you for your patience as we resolve this issue.

To report problems or ask a question about this or any of our other services, please fill out a problem report, or send email to


Thank you very much for your continued patience as we work to address the issues regarding and

Library IT has assessed the impact to library services and systems and come up with a plan to maintain or restore those services after this server goes offline:

1)    BorrowDirect:
Our first priority is to maintain access to Borrow Direct.

2)    SharePoint:
Following that, we are working to ensure continued access to SharePoint. Cindy Greenspun will be reaching out to major SharePoint stakeholders; please get in touch with her ASAP if your department uses SharePoint as a part of its daily work.

3)    LIT will address other smaller systems and services living on this server after these two major services are restored properly.

Once again, if a service or system you use is accessible through a URL that starts with or, it is safe to assume it will be unavailable. Please email to confirm if you are unsure.


There has recently been a security issue on one of our servers ( that will result in Central ITS taking it offline sometime today. This means that the following two major services will be unavailable:

BorrowDirect (

Sharepoint (

Additionally, many smaller services and systems hosted on will also be unavailable. If a service or system you use is accessible through a URL that starts with, it is safe to assume it will be unavailable. Please email to confirm if you are unsure.


We do not yet have an estimate on when services will be restored. Library IT will follow up with an estimate as soon as possible.