7 Working with SQL
This chapter covers
- Building SQL databases and tables
- Inserting and updating data
- Retrieving data
- Using data validation before writing to SQL
Anyone who has worked in IT long enough has inevitably received a call from a panicked department head saying that the Excel spreadsheet or Access database the entire department is reliant on has broken. As you investigate, you discover a mess of spaghetti code macros that have been cobbled together over the years. As you are racking your brain trying to reverse engineer it, you keep thinking to yourself, how did this happen?
I have found that these are often the result of one person taking some initiative to try to improve their job—in much the same way an automator thinks. However, ...
Get Practical Automation with PowerShell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
