Captain’s Log Star Date 2024.07.05

Captain’s Log Star Date 2024.07.05

Reading

“Data Pipelines – Pocket Reference, Moving and Process Data for Analytics” – James Densmore – Chapter 7 Orchestrating Pipelines

“The Enterprise Big Data Lake, Delivering the Promise of Big Data and Data Science” – Alex Gorelik – Chapter 5 From Data Ponds/Big Data Warehouses to Data Lakes

“The Making of a Manager: What to Do When Everyone Looks to You” – Julie Zhou – Chapter 5 Managing Yourself

The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win” – Gene Kim, Kevin Behr, George Spafford 

“Microsoft SQL Server 2012, T-SQL Fundamentals” – Itzik Ben-Gan – Chapter 4 Subqueries

Courses

A Cloud Guru – “DevOps Essentials” – Chapter 4 DevOps Tools

Udemy – “Complete Agile Scrum Master Certification Training” – Section 1 Introduction

Udemy – “6 Practice Exams – AWS Certified Cloud Practitioner” – Exam 2

Notes

This is my first foray back into my tech learning after taking a few weeks off to concentrate all of my free time on healthy living. It does feel good to be back at it again.

Yes, I started a new book without finishing any of my other books. I found that I needed to pivot over to learning more SQL, specifically T-SQL so I can perform job duties more efficiently. There is so much in T-SQL that I do not use and much in SSMS itself that I could utilize also. I’ve actually had this book for some while on my shelf, hence why I am on chapter four. I read the first two chapters some time ago when I was working as a DBA and wanted to know how SSMS worked. Since then it’s been sitting on my shelf reminding me of my failure to execute my learning path. It actually feels great to start reading it again. There are some things for sure I learned and also some rounding out knowledge of those I already know. Here are a few things I found interesting –

Using self-contained scalar subqueries by assigning variables – I can’t believe I never thought of using this before. I always query the data for a value, then key it in statically into the query itself. Of course this is only when I am researching a data set but I know I’ve tried to inline a subquery before that just wouldn’t work.

DECLARE @maxid AS INT = (SELECT MAX(orderid) FROM Sales.Orders);

The Exists/Not Exists predicate – I’ve never used this predicate before but will in the future. I typically write a query to check to see if a value is in the subquery, which is really inefficient. EXISTS and NOT EXISTS checks to see if at least one row is created in the subquery.