Nothing here yet.
Nothing here yet.
Sep 6, 2023 路 41 min read 路 Course 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...
Join discussionApr 25, 2023 路 1 min read 路 Though, 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...
Join discussionFeb 7, 2023 路 4 min read 路 A 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 ...
Join discussionDec 8, 2022 路 3 min read 路 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...
Join discussionDec 8, 2022 路 2 min read 路 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...
Join discussion