Відео

Quickly import a CSV file into SQL Server using Azure Data Studio's flat file import wizard. Check out our Advanced SQL Server for Business Intelligence Analyst Course: codecrewcareers.com/course/advanced-sql-server-for-business-intelligence-analysts/

Quick walkthrough for installing Mongosh How to Install MongoDB Server on Windows ua-cam.com/video/8QzDi-cgc44/v-deo.html 00:04 - Before Starting 00:18 - Navigate to Download Page 00:30 = Find Tools Page 00:55 - Versions of Mongosh 01:00 - Select Windows Platform 01:07 - Select MSI Package 01:45 - Choose Install Location 02:17 - User Install or Computer Install Options 02:50 - Connecting Mongos...

Quick walkthrough for installing MongoDB Compass. How to Install MongoDB Server on Windows ua-cam.com/video/8QzDi-cgc44/v-deo.html 00:16 - Why you might want to skip this video 00:58 - Different Editions of MongoDB Compass 01:42 - Other Tools to Consider Downloading 02:12 - Downloading the Microsoft Installer 03:45 - First look at MongoDB Compass Interface

Full walkthrough of MongoDB Server Install. 00:39 - Downloading the Microsoft MSI 01:26 - Beginning the Install 01:44 - Complete vs Custom Installs 02:23 - Configuring MongoDB as a Microsoft Service 02:57 - Configuring Users 03:52 - Optional MongoDB Compass Install 05:16 - Connecting to MongoDB Server through MongoDB Compass

Learn how to flatten JSON files using the pandas json_normalize() function! Link to Jupyter Notebook: github.com/Data-Craftsman-Learn/Pandas-Functions Key Moments: - How to Open JSON Files - 00:55 - Convert JSON Files to Python Dictionary - 01:51 - Hierarchical JSON Structures - 03:26 - Navigating JSON Levels - 04:05 - Flattening JSON Files with json_normalize() - 07:20 - Creating a DataFrame f...

Learn how to use all parameters in the Pandas read_csv() Function! We walk through examples for each parameter. Comprehensive Guide: github.com/Data-Craftsmans-Guild/pandas-deep-dive/blob/main/read_csv()/read_csv.md Key Moments - Basics of read_csv() - 00:47 - Opening Tab Separated Files - 02:09 - Opening Space Separated Files - 03:26 - Defining Column Headers - 04:27 - Defining Multiple Column...

Install the industry standard version control system, git! Learn how to clone a remote repository: ua-cam.com/video/IcoRmuDAGQ4/v-deo.html

Data Security is extremely important, but for companies to capture data driven insights, they need to grant data access to certain people in the organization. Learn how to manage database users and logins in SQL Server 2019 so that data analysts have appropriate access to data.

Organize your databases with Schemas

Learn how to search through a text file and pull out phone numbers in a structured data format! Subscribe for more tips and how to videos here: ua-cam.com/channels/bfcR3OcQwgHvUT9skblhSA.html

Data Engineers are primarily responsible for data flows. Python makes this task a bit more manageable with its various libraries for extracting and manipulating data. In this video, we discuss how the Pandas library can be used to extract data and transform data.

Realizing data driven opportunities starts with a solid understanding of how the process works. In this video, we discuss the steps to creating and implementing a Machine Learning Solution. What is the role of a data scientist? What is the role of a Data Engineer?

Learn about the Features of SQLite Studio and how you can manage your databases using this GUI. Subscribe for more tips and how to videos here: ua-cam.com/channels/bfcR3OcQwgHvUT9skblhSA.html

Learn how to support your web applications with SQLite Subscribe for more tips and how to videos here: ua-cam.com/channels/bfcR3OcQwgHvUT9skblhSA.html

How to Import SQLite Databases from SQL Scripts

How to Install SQLite Studio on Windows 10

How to Install SQLite on Windows 10