0

SQL for the Weary

preview

intended audience

  • Rachel has a master’s degree in cell biology and now works in a research hospital doing cell assays.
  • She learned a bit of R in an undergrad biostatistics course and has been through the Carpentries lesson on the Unix shell.
  • Rachel is thinking about becoming a data scientist and would like to understand how data is stored and managed.
  • Her work schedule is unpredictable and highly variable, so she needs to be able to learn a bit at a time.

prerequisites

  • basic Unix command line: cd, ls, * wildcard
  • basic tabular data analysis: filtering rows, aggregating within groups

learning outcomes

  • Explain the difference between a database and a database manager.
  • Write SQL to select, filter, sort, group, and aggregate data.
  • Define tables and insert, update, and delete records.
  • Describe different types of join and write queries that use them to combine data.
  • Use windowing functions to operate on adjacent rows.
  • Explain what transactions are and write queries that roll back when constraints are violated.
  • Explain what triggers are and write SQL to create them.
  • Manipulate JSON data using SQL.
  • Interact with a database using Python directly, from a Jupyter notebook, and via an ORM.

intended audience

  • Rachel has a master’s degree in cell biology and now works in a research hospital doing cell assays.
  • She learned a bit of R in an undergrad biostatistics course and has been through the Carpentries lesson on the Unix shell.
  • Rachel is thinking about becoming a data scientist and would like to understand how data is stored and managed.
  • Her work schedule is unpredictable and highly variable, so she needs to be able to learn a bit at a time.

prerequisites

  • basic Unix command line: cd, ls, * wildcard
  • basic tabular data analysis: filtering rows, aggregating within groups

learning outcomes

  • Explain the difference between a database and a database manager.
  • Write SQL to select, filter, sort, group, and aggregate data.
  • Define tables and insert, update, and delete records.
  • Describe different types of join and write queries that use them to combine data.
  • Use windowing functions to operate on adjacent rows.
  • Explain what transactions are and write queries that roll back when constraints are violated.
  • Explain what triggers are and write SQL to create them.
  • Manipulate JSON data using SQL.
  • Interact with a database using Python directly, from a Jupyter notebook, and via an ORM.
0

Microsoft is adding a new key to PC keyboards for the first time since 1994

Ars Technica Microsoft is adding a new key to PC keyboards for the first time since 1994 arstechnica.com
preview

Andrew Cunningham (arstechnica.com) - Jan 4, 2024 8:01 am UTC Writes:

Microsoft pushed throughout 2023 to add generative AI capabilities to its software, even extending its new Copilot AI assistant to Windows 10 late last year. Now, those efforts to transform PCs at a software level is extending to the hardware: Microsoft is adding a dedicated Copilot key to PC keyboards, adjusting the standard Windows keyboard layout for the first time since the Windows key first appeared on its Natural Keyboard in 1994.

The Copilot key will, predictably, open up the Copilot generative AI assistant within Windows 10 and Windows 11. On an up-to-date Windows PC with Copilot enabled, you can currently do the same thing by pressing Windows + C. For PCs without Copilot enabled, including those that aren’t signed into Microsoft accounts, the Copilot key will open Windows Search instead (though this is sort of redundant, since pressing the Windows key and then typing directly into the Start menu also activates the Search function).

A quick Microsoft demo video shows the Copilot key in between the cluster of arrow keys and the right Alt button, a place where many keyboards usually put a menu button, a right Ctrl key, another Windows key, or something similar. The exact positioning, and the key being replaced, may vary depending on the size and layout of the keyboard.

We asked Microsoft if a Copilot key would be required on OEM PCs going forward; the company told us that the key isn’t mandatory now, but that it expects Copilot keys to be required on Windows 11 keyboards “over time.” Microsoft often imposes some additional hardware requirements on major PC makers that sell Windows on their devices, beyond what is strictly necessary to run Windows itself.

Read Microsoft is adding a new key to PC keyboards for the first time since 1994

Andrew Cunningham (arstechnica.com) - Jan 4, 2024 8:01 am UTC Writes:

Microsoft pushed throughout 2023 to add generative AI capabilities to its software, even extending its new Copilot AI assistant to Windows 10 late last year. Now, those efforts to transform PCs at a software level is extending to the hardware: Microsoft is adding a dedicated Copilot key to PC keyboards, adjusting the standard Windows keyboard layout for the first time since the Windows key first appeared on its Natural Keyboard in 1994.

The Copilot key will, predictably, open up the Copilot generative AI assistant within Windows 10 and Windows 11. On an up-to-date Windows PC with Copilot enabled, you can currently do the same thing by pressing Windows + C. For PCs without Copilot enabled, including those that aren’t signed into Microsoft accounts, the Copilot key will open Windows Search instead (though this is sort of redundant, since pressing the Windows key and then typing directly into the Start menu also activates the Search function).

A quick Microsoft demo video shows the Copilot key in between the cluster of arrow keys and the right Alt button, a place where many keyboards usually put a menu button, a right Ctrl key, another Windows key, or something similar. The exact positioning, and the key being replaced, may vary depending on the size and layout of the keyboard.

We asked Microsoft if a Copilot key would be required on OEM PCs going forward; the company told us that the key isn’t mandatory now, but that it expects Copilot keys to be required on Windows 11 keyboards “over time.” Microsoft often imposes some additional hardware requirements on major PC makers that sell Windows on their devices, beyond what is strictly necessary to run Windows itself.

Read Microsoft is adding a new key to PC keyboards for the first time since 1994