Marsha Baddeley

Iteration Using an Array's forEach() Method - Accessing each Element and Index in One Process

An Introduction to Fetching JSON Data: fetch() and Promises

06_An Example of a Type 1 Dimension Table

Creating Dynamic Partitions in Hive: Fully Managed Table Example

Customizing JSON Transformations in SQL Server Using FOR JSON PATH and Correlated Subqueries

Adding New Elements to Array Keys in MongoDB - UpdateOne/Many With the $push Operator

Implementing Array Prototype Methods on Arrays of JS Objects: reduce() Example

An Introduction to Creating a Pandas DataFrame & Accessing its Elements

01_Initial SSIS Project Set-up For Commencing the Extract Process

4. Creating a Notebook to Load CSV Data for ETL Work Using Pyspark in Azure Synapse Workspace

04_Designing and Configuring a Typical Master Extract Package Control Flow in SSIS

NumPy Shapes, Reshaping, and How Array Shapes Apply to Broadcasting and Vectorization

3. Creating a Spark Pool for Azure Synapse Analytics

Gathering User Input: Accessing value and checked Properties in JavaScript

Hive External Tables

Importing Modules in Python - Using the random Module as an Example

Projecting and Restricting Output in a Mongo Query - Equals and Not Equals Logic

Creating a Partition Function and Scheme on a Fact Table: Examining Query Performance

05_Designing and Configuring a Typical Dimension Table Extract Package in SSIS

Using the Positional Operator in MongoDB to Suppress Array Values That Do Not Match Restrictions

Using Asynchronous Functions to Fetch JSON Data Using JavaScript

Performing An Archive Process for a Partitioned Table: Switching Metadata and Performing a Merge

Variable Declaration vs. Assignment in JS: An Initial Discussion

Solving a Problem w/Pandas DataFrames: Adding Calculated Columns, & Aggregations (min,max, groupby)

Random Methods in Python

Creating Schema in Hive for External Tables

insertOne() and insertMany() Methods in MongoDB Query - Adding Documents to a Collection

Creating Pandas DataFrames from CSV Files or a SQL Server Query: read_csv and read_sql Methods

SQL Server Files and Filegroups: Managing Primary, Logs, and Secondary File Data

Installing and Configuring Sqoop 1.4.7 to run on Hadoop 3.X

03_Configuring Hadoop for Pseudo-Distributed Mode, Formatting the Name Node & Starting Daemons

Using elemMatch() in MongoDB to Implement Accurate Logic for Conditions Found in Array Elements

Reduce Operations in Python: max, min and sum

np.sort and argsort: Sorting Elements in a NumPy 2D Array

SQL Server and ETL: Extracting JSON Data in SQL Server Using OPENROWSET

An Introduction to Comparison Logic in Python and How to Structure a Simple Code Block/Suite

13 Pandas Joins - merge, join, concat

A Simple INSERT INTO SELECT Example

02_Creating the Required Directories for Hadoop Pseudo Distributed Mode

3. Using Sqoop to List SQL Server Tables from a Given Database

Pandas Problem-Solving Case: Replacing Strings, Finding nan, Adding & Dropping Columns

Installing VS Code and Node JS

Mutating an Array in Place by Removing Elements: pop(), shift(), splice()

Starting Steps for Creating a Data Warehouse: Extracting Data Using CTAS Statements

An Introduction to Common Behaviors of Python Sequences

A Review of Create Table as Select Statements (CTAS) to Make a Dimension Table in a Data Warehouse

02_Configuration Steps to Run Hive 3.1.3 on Hadoop

Gathering Input from the Console in Python and Outputting a Response

Using the this Keyword to Find the Checked Radio Button in a Radio Button Group

Changing a Sequence in Python to Another Sequence: Lists to Strings and Strings to Lists