Posts

Showing posts from July, 2024

SQL 101 : CH 1 Notes : Teach yourself SQL

These notes should be more than enough to revise and learn stuff. No need to go to book after it. Examples are also included for better revision and understanding of concepts. SQL session commands : 1)     CONNECT - Command is used to connect to a database. This command can either invoke a connection or change the connection to the database. Ex. connected as USER1 and gave command of USER2, the command will terminate the previous user connection and establish the connection for USER2.     Syntax: CONNECT user@database.       link:  Official documentation for CONNECT command     Takeaway -> Initializing a database can be tricky and not as simple as opening a Jupyter book. Be thorough with the process. All SQL servers are password-protected. 2)     DISCONNECT AND EXIT ->   Use to disconnect a user from a database.           Exit: While giving the disconnect command, the soft...

IBM Introduction to data engineering : Module 4 review

What I learn in module 4 of IBM data engineering? Module 4 of IBM Data Engineering is about careers and opportunities in the DE field. I find this module particularly important because I have been researching how to be a data engineer for the past month. The content on the internet is confusing.  What I learned from the internet in the past month about being a data engineer is that it is a highly technical field. There are no sure-shot paths to be a DE, no curriculum and a lot of noise. I took my time researching for a month before becoming laser-focused on what to do in the shortest time possible. A view of what I learned in the past month's internet search is learning SQL, NoSQL, Postgre SQL, Python and Java. This module added some more valuable inputs in what to learn. The question would be why Java, why not Scala because a lot of interview requirements are either Java or Scala? I found out that one can't learn Scala if they don't have a prerequisite understanding of Jav...