RBRukayat Baloguninblog.rukayatbalogun.xyz路Sep 6, 2023 路 41 min readFoundation of Big Data Systems: Course OverviewCourse Overview Big Data Fundamentals Data Storage and Management Data Processing Data Integration and ETL Distributed Systems Data Warehousing and Analytics Data Security and Privacy Scaling and Performace Optimization Course Overview Intr...00
RBRukayat Baloguninblog.rukayatbalogun.xyz路Apr 25, 2023 路 1 min readHow to connect MSSQL to Jupyter notebook on MAC OSThough, it seems impossible to connect MSSQL to Jupyter Notebook because you can not install MSSQL directly on your MAC OS. This tutorial will help in connecting MSSQL to Jupyter Notebook on MAC OS. brew install msodbcsql17 mssql-tools This will ins...00
RBRukayat Baloguninblog.rukayatbalogun.xyz路Feb 7, 2023 路 4 min readWorking With Multiple Tables In SqlA lot of times, a database administrator would require to fetch data from two tables where they have something in common. In this case, you will have to work on joining these tables where they share similar information. In SQL, we call this joins as ...00
RBRukayat Baloguninblog.rukayatbalogun.xyz路Dec 8, 2022 路 3 min readData Query Language (DQL)Data Query Language (or simply DQL) consists of commands that perform data selection, which is the main focus of relational database users in the world of SQL. The statement used is SELECT that can be accompanied by other clauses or options so that y...00
RBRukayat Baloguninblog.rukayatbalogun.xyz路Dec 8, 2022 路 2 min readData Manipulation Language (DML)Data Manipulation Language (or simply DML) consists of SQL commands that handle data maintenance functions. This means that you can manipulate the data contained within the relational database objects. The command statements, which read like normal E...00