Channel Title: Sigma Coding Channel Description: Howdy! My name is Alex, and if you're like me, you enjoy the world of programming. Or you were like me a few years ago and are beginning to take your first step into this exciting world. Well lucky for you, you came across the right channel! Sigma Coding aims to be your one-stop-shop for programming tutorials. While I don't cover every programming language, I aim to cover topics and languages that can be used across a wide variety of platforms. A few of the languages we cover are: 1. Python 2. VBA 3. JavaScript 4. M Language (Used for Power Query & Power BI) 5. SQL This list is continuously changing, and I do my best to make tutorials engaging, exciting, and most importantly, easy to follow! GitHub Repository: https://github.com/areed1192 Facebook Page: https://www.facebook.com/codingsigma/ <video> Access VBA | Working with Query Definitions Description: Inside of Access, we store data in a structured format so that we can easily retrieve it when needed. When it comes to retrieving, creating, and modifying data we use scripts called queries to execute those instructions. Inside of VBA, we can create those queries and add additional information to them so that we can easily customize them to meet our unique needs. In this video, we will cover the QueryDefinition object, how to create them, how to modify them, and how to grab the data that they return from them. Video Resources: -------------------------------------------------- https://github.com/areed1192/sigma_coding_youtube/tree/master/vba/vba-access/query-definitions.vbs Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub Sigma Coding: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Access VBA | Introduction Link: https://youtu.be/_5rfCCkVTNA Title: Access VBA | Working With Query Definitions Link: https://youtu.be/-bB_fdqldUU **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #VBA #Access #QueryDefinitions </video> <video> Getting Started with Python on Windows | Installing Git & VS Code Description: In this video, we will walk through how to install Git and Visual Studio Code. Git will serve as our source control manager to help track our code files as we write them, and VS Code will be our code editor. With VS Code we can customize the application with different extensions that help with a range of tasks like formatting Python scripts all the way to interacting with GitHub. Chapters: -------------------------------------------------- 00:00 - Introduction 02:30 - Installing VS Code 07:30 - Exploring VS Code 10:30 - Extensions in VS Code 13:30 - Customizing VS Code 16:00 - Installing Git 20:30 - Exploring Git Bash GUI 22:00 - VS Code & Git 22:30 - Closing Statements Video Resources: -------------------------------------------------- None Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Use Dictionaries In Python Link: https://youtu.be/pDVgVMlqPd0 Title: Comparing Dictionaries In Python Link: https://youtu.be/R-Z_1tinos4 Title: How To Use Lists In Python Link: https://youtu.be/3ak9SMRAle8 Title: How To Use Loops In Python Link: https://youtu.be/Oy_oOcNjAFk Title: How to Convert A Python File to an EXE File Link: https://youtu.be/g7vmeEA9oVs Title: Using the Datetime Library in Python: Working with Dates Link: https://youtu.be/d5X10LjFpTA Title: How to Use Classes in Python | Pt. 1 Link: https://youtu.be/Y6yQb7ntn5o Title: How to Use Classes in Python | Pt. 2 Link: https://youtu.be/bPnUR3-Sn6U Title: How to Use Classes in Python | Pt. 3 Link: https://youtu.be/qKy79CM6Wyc Title: Using Pathlib in Python Link: https://youtu.be/DOgjN7RmHds Title: Getting Started With Python on Windows | Introduction Link: https://youtu.be/cBXwoqRoXBg Title: Getting Started With Python on Windows | Installing Git & VS Code Link: https://youtu.be/3CE3xvbwZLU Title: Getting Started With Python on Windows | Installing Python Link: https://youtu.be/yVkTExu7X1w **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #Tutorial #VsCode </video> <video> Rethinking the TD Ameritrade Library Description: It's hard to believe, but the TD Ameritrade Library is almost 2 years old! A lot has changed since the library came out and it's time for the TD library to go through a little bit of revamp. In this video, we are going to discuss some of the pain points of the old library and how we plan to fix them in the latest version of the TD library. Video Resources: -------------------------------------------------- https://github.com/areed1192/td-ameritrade-api Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How to Use the TD Ameritrade API | Part 1 Link: https://youtu.be/qJ94sSyPGBw Title: How to Use the TD Ameritrade API | Part 2 Link: https://youtu.be/sVA0PeuDE4I Title: How to Use the TD Ameritrade API | Part 3 Link: https://youtu.be/KPqoC1pt9Vo Title: How to Use the TD Ameritrade Streaming API | Part 1 Link: https://youtu.be/7S0gBn5cjYM Title: How to Use the TD Ameritrade Streaming API | Part 2 Link: https://youtu.be/HNS9B-icOww Title: How to Use the TD Ameritrade Streaming API | Part 3 Link: https://youtu.be/EvtbhouHUYI Title: How to Use the TD Ameritrade Streaming API | Part 4 Link: https://youtu.be/IK3WkBeCDew Title: How to Use the TD Ameritrade Streaming API | Part 5 Link: https://youtu.be/q19zqhwEQAM Title: Building a TD Ameritrade API Client Library in Python: Authentication Pt. 1 Link: https://youtu.be/sGuY91IyDlw Title: Building a TD Ameritrade API Client Library in Python: Authentication Pt. 2 Link: https://youtu.be/C69Uv5OSoII Title: Building a TD Ameritrade API Client Library in Python: Authentication Pt. 3 Link: https://youtu.be/wS_8CxOZbkc Title: Building a TD Ameritrade API Client Library in Python: Authentication Pt. 4 Link: https://youtu.be/vRVdY86HEtk Title: Building a TD Ameritrade API Client Library in Python: Authentication Pt. 5 Link: https://youtu.be/PlzdIV3ZeG0 Title: Building a TD Ameritrade API Client Library in Python: Data Requests Pt. 1 Link: https://youtu.be/ZBleNoKLTSI Title: Building a TD Ameritrade API Client Library in Python: Data Requests Pt. 2 Link: https://youtu.be/SOiVEnXkX9w Title: TD Ameritrade API Python Library: Streaming Pt. 1 Link: https://youtu.be/u2KHcvMcbIw Title: TD Ameritrade API Python Library: Streaming Pt. 2 Link: https://youtu.be/f_wFhvCDVqY Title: TD Ameritrade API Python Library: Streaming Pt. 3 Link: https://youtu.be/1-Ryjrh3Ckg Title: How to Use the TD Ameritrade Python API Library | Pt. 1 Link: https://youtu.be/8N1IxYXs4e8 Title: How to Use the TD Ameritrade Python API Library | Pt. 2 Link: https://youtu.be/0ETR_lftNuM Title: How to Use the TD Ameritrade Python API Library | Placing Orders Pt.1 Link: https://youtu.be/BJHbwcDu0Ok Title: How to Use the TD Ameritrade Python API Library | Placing Orders Pt.2 Link: https://youtu.be/_VnAycipjIA Title: How to Use the TD Ameritrade Python API Library | Placing Orders Pt.3 Link: https://youtu.be/Rlc6ePtNAZI Title: How to Use the TD Ameritrade Python API Library | Streaming API Link: https://youtu.be/GfIIsKc0HZI Title: How to Build a Data Pipeline with the TD Ameritrade Python API Library Link: https://youtu.be/icLy0glrovc Title: Rethining the TD Ameritrade Library Link: https://youtu.be/8tHI1okLNwA **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #Finance # TdAmeritrade </video> <video> Power BI in Python | Workspace Security Settings Description: Okay so now that we have an app registered and see how to access a specific resource like a Dashboard, we are going to spend some more time on authentication and licenses. The reason, we need to cover this more is because the Power BI REST API makes certain endpoints available only if you have certain license. This video will cover the different licenses, how it will impact your experience with the API, and then we will talk about giving your application access to your workspace. Chapters: -------------------------------------------------- 00:00 - Introduction 00:30 - Workspaces & Premium Workspaces 03:00 - License Types 06:00 - Registering a Service Principal 07:00 - Security Groups 09:00 - Workspace Settings 10:30 - Closing Statements Video Resources: -------------------------------------------------- https://github.com/areed1192/power-bi-python-api Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Power BI in Python | Authentication Link: https://youtu.be/_2eGAjm1I4w Title: Power BI in Python | Dashboards & Datasets Link: https://youtu.be/gGDY8MNuK1w Title: Power BI in Python | Workspace Security Settings Link: https://youtu.be/B3v-Z0_ljKc **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. Tags: -------------------------------------------------- #Python #PowerBi #Authentication </video> <video> Getting Started with Python on Windows | Introduction Description: Python is a popular language for those who are interested in learning programming. It's an easy language to read and it allows users to get up and running with their code quick and efficiently. However, there is more to learning python than just writing code. It takes learning the tools you'll use when you write your, debug, test, and share your code. That's why in this series not only will we get you up and running with Python, but we will also show you how to use some of popular tools we use in tandem with python. Chapters: -------------------------------------------------- 00:00 - Introduction 01:30 - Exploring the Tools 09:30 - Discussing the Project 13:00 - Discussing the Resources 14:00 - Closing Statements Video Resources: -------------------------------------------------- None Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Use Dictionaries In Python Link: https://youtu.be/pDVgVMlqPd0 Title: Comparing Dictionaries In Python Link: https://youtu.be/R-Z_1tinos4 Title: How To Use Lists In Python Link: https://youtu.be/3ak9SMRAle8 Title: How To Use Loops In Python Link: https://youtu.be/Oy_oOcNjAFk Title: How To Convert A Python File to an EXE File Link: https://youtu.be/g7vmeEA9oVs Title: Using the Datetime Library in Python: Working With Dates Link: https://youtu.be/d5X10LjFpTA Title: How to Use Classes in Python | Pt. 1 Link: https://youtu.be/Y6yQb7ntn5o Title: How to Use Classes in Python | Pt. 2 Link: https://youtu.be/bPnUR3-Sn6U Title: How to Use Classes in Python | Pt. 3 Link: https://youtu.be/qKy79CM6Wyc Title: Using Pathlib in Python Link: https://youtu.be/DOgjN7RmHds Title: Getting Started With Python on Windows | Introduction Link: https://youtu.be/cBXwoqRoXBg **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #Tutorial #Introduction </video> <video> Power BI in Python | Reports Description: In this video, we will cover the topic of reports and how to access them, delete, them, create them and how to export them. We will also discuss some of the limitations when it comes to exporting reports depending on the type of licenses you have. Chapters: -------------------------------------------------- 00:00 - Introduction 00:30 - What are reports? 02:20 - Using the Reports Client 11:00 - Exporting Reports 14:30 - Limitations 16:25 - Closing Statements Video Resources: -------------------------------------------------- https://github.com/areed1192/power-bi-python-api Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Power BI in Python | Authentication Link: https://youtu.be/_2eGAjm1I4w Title: Power BI in Python | Dashboards & Datasets Link: https://youtu.be/gGDY8MNuK1w Title: Power BI in Python | Workspace Security Settings Link: https://youtu.be/B3v-Z0_ljKc Title: Power BI in Python | Reports Link: https://youtu.be/dogIABwpL4I **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. Tags: -------------------------------------------------- #Python #PowerBi #Reports </video> <video> Using Pathlib in Python Description: Pathlib is a powerful library that makes working with file paths quick and easy. Along with allowing you to manipulate paths, you can also do different I/O operations right from your python script. In this video, we will talk about the Pathlib library, the objects it offers, and some of the common methods and properties of those objects. Video Resources: -------------------------------------------------- https://github.com/areed1192/sigma_coding_youtube/tree/master/python/python-core/pathlib.py Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How to Use Dictionaries in Python Link: https://youtu.be/pDVgVMlqPd0 Title: Comparing Dictionaries in Python Link: https://youtu.be/R-Z_1tinos4 Title: How to Use Lists in Python Link: https://youtu.be/3ak9SMRAle8 Title: How to Use Loops in Python Link: https://youtu.be/Oy_oOcNjAFk Title: How to Convert A Python File to an EXE File Link: https://youtu.be/g7vmeEA9oVs Title: Using the Datetime Library in Python: Working with Dates Link: https://youtu.be/d5X10LjFpTA Title: How to Use Classes in Python | Pt. 1 Link: https://youtu.be/Y6yQb7ntn5o Title: How to Use Classes in Python | Pt. 2 Link: https://youtu.be/bPnUR3-Sn6U Title: How to Use Classes in Python | Pt. 3 Link: https://youtu.be/qKy79CM6Wyc Title: Using Pathlib in Python Link: https://youtu.be/DOgjN7RmHds Chapters: -------------------------------------------------- 00:00 - Introduction 03:30 - Writing the Code 07:10 - PurePath Vs Path 11:30 - Useful Methods and Properties 28:00 - Closing Statements **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #StandardLibrary #Pathlib </video> <video> Power BI in Python | Dashboards & Datasets Description: Now that we have an application registered with the Power BI Rest API and it authenticated with the service, we can move on to the next topic, dashboards & datasets. The contents of this video will focus initially on how to retrieve and create dashboards using the API and how they are organized in a Power BI account. Additionally, we will spend some time on how to upload data in the form of a record set from Python to Power BI using the Post Dataset operation and the Post Dataset Rows operation. Video Resources: -------------------------------------------------- https://github.com/areed1192/power-bi-python-api Chapters: -------------------------------------------------- 00:00 - Introduction 01:45 - Dashboards 05:10 - Workspaces & Groups 08:00 - Tiles 14:20 - Datasets Overview 16:30 - Creating a Dataset 23:00 - Adding Rows to the Dataset 25:40 - Closing Statements Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Power BI in Python | Authentication Link: https://youtu.be/_2eGAjm1I4w Title: Power BI in Python | Dashboards & Datasets Link: https://youtu.be/gGDY8MNuK1w **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #PowerBi #Dashboards </video> <video> Getting Started with Python on Windows | GitHub Description: Now that we have Git installed on our system we can start talking about GitHub and how it fits into the bigger picture. With GitHub we can store our repositories on the internet where other individuals can find it and contribute to your potential project. We will spend a significant amount of time seeing how GitHub is laid out, how to create a new repository, and how to clone a repository to our local system. Video Resources: -------------------------------------------------- https://github.com/areed1192/epa-scraper-project Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Use Dictionaries In Python Link: https://youtu.be/pDVgVMlqPd0 Title: Comparing Dictionaries In Python Link: https://youtu.be/R-Z_1tinos4 Title: How To Use Lists In Python Link: https://youtu.be/3ak9SMRAle8 Title: How To Use Loops In Python Link: https://youtu.be/Oy_oOcNjAFk Title: How To Convert A Python File to an EXE File Link: https://youtu.be/g7vmeEA9oVs Title: Using the Datetime Library in Python: Working With Dates Link: https://youtu.be/d5X10LjFpTA Title: How to Use Classes in Python | Pt. 1 Link: https://youtu.be/Y6yQb7ntn5o Title: How to Use Classes in Python | Pt. 2 Link: https://youtu.be/bPnUR3-Sn6U Title: How to Use Classes in Python | Pt. 3 Link: https://youtu.be/qKy79CM6Wyc Title: Using Pathlib in Python Link: https://youtu.be/DOgjN7RmHds Title: Getting Started With Python on Windows | Introduction Link: https://youtu.be/cBXwoqRoXBg Title: Getting Started With Python on Windows | Installing Git & VS Code Link: https://youtu.be/3CE3xvbwZLU Title: Getting Started With Python on Windows | Installing Python Link: https://youtu.be/yVkTExu7X1w Title: Getting Started With Python on Windows | GitHub Link: https://youtu.be/m8c6-fe6Lnk **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. Tags: -------------------------------------------------- #Python #Tutorial #GitHub </video> <video> Access VBA | Import Excel Tables to Access Pt. 1 Description: Excel is a commonplace to store data that is used in a wide range of activities. However, if we want to ensure our data is accurate and safe, we should store it in a database to ensure certain quality controls when it comes to our data. This series will show you how to import an Excel Data Table (List Object) into an Access Database using only VBA. With this technique, you can take all your scattered data and centralize it to a single location. Video Resources: -------------------------------------------------- https://github.com/areed1192/sigma_coding_youtube/tree/master/vba/vba-access/import-excel-table.vbs Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub Sigma Coding: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Access VBA | Introduction Link: https://youtu.be/_5rfCCkVTNA Title: Access VBA | Working with Query Definitions Link: https://youtu.be/-bB_fdqldUU Title: Access VBA | Import Excel Tables to Access Link: https://youtu.be/o9V6qN5QL0k **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One way I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) and helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #VBA #Access #ExcelTables </video> <video> Getting Started with Python on Windows | Installing Python Description: Now, that we have an overview of the project we can proceed to the first step which is installing Python. In this video, I'll show you how to download Python, install it on the Windows operating system, and verify that the installation happened correctly. Chapters: -------------------------------------------------- 00:00 - Introduction 01:40 - Download Python 03:40 - Exploring the Different Versions 06:50 - Installing Python 09:30 - Verifying the Installation 13:00 - Closing Statements Video Resources: -------------------------------------------------- None Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: How To Use Dictionaries In Python Link: https://youtu.be/pDVgVMlqPd0 Title: Comparing Dictionaries In Python Link: https://youtu.be/R-Z_1tinos4 Title: How To Use Lists In Python Link: https://youtu.be/3ak9SMRAle8 Title: How To Use Loops In Python Link: https://youtu.be/Oy_oOcNjAFk Title: How To Convert A Python File to an EXE File Link: https://youtu.be/g7vmeEA9oVs Title: Using the Datetime Library in Python: Working With Dates Link: https://youtu.be/d5X10LjFpTA Title: How to Use Classes in Python | Pt. 1 Link: https://youtu.be/Y6yQb7ntn5o Title: How to Use Classes in Python | Pt. 2 Link: https://youtu.be/bPnUR3-Sn6U Title: How to Use Classes in Python | Pt. 3 Link: https://youtu.be/qKy79CM6Wyc Title: Using Pathlib in Python Link: https://youtu.be/DOgjN7RmHds Title: Getting Started With Python on Windows | Introduction Link: https://youtu.be/cBXwoqRoXBg Title: Getting Started With Python on Windows | Installing Python Link: https://youtu.be/3CE3xvbwZLU Title: Getting Started With Python on Windows | Installing Python Link: https://youtu.be/yVkTExu7X1w **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #Tutorial #Introduction </video> <video> Building a Trading System in Python | Project Overview Description: A common theme in the channel is that trading can be reduced to automated procedures that follow pre-defined rules. However, trading is just one component of the bigger picture. To make a full-fledge trading system we need to make sure that we have access to adequate data, a user interface to manage our system, and pipelines that we can use to clean and organize our data. In this series, we will explore how to build a simple trading system using Python. Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Building a Trading System in Python | Project Overview Link: https://youtu.be/yZ9BBYzoMbs Chapters: -------------------------------------------------- 00:00 - Introduction 00:43 - Disclosures 03:00 - What is a Trading System? 03:50 - Pros and Cons of Trading Systems 13:20 - Project Overview 15:30 - Framework - Trading System 16:20 - Framework - Strategies 18:00 - Framework - Trigger 21:45 - Framework - Open 23:10 - Framework - Manage 24:30 - Framework - Close 25:00 - Big Picture 27:20 - Closing Statements **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #Finance #TradingSystems </video> <video> Building a Trading System in Python | Azure Data Factories Description: Now that we have the project overview done, we will start with our first mini-project, building a data factory. Like the last video, we won't be doing any coding but instead focus on the user interface, how it's laid out, the different features it offers, and some common terminology that will be helpful when we go through the process. Video Resources: -------------------------------------------------- None Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Building a Trading System in Python | Project Overview Link: https://youtu.be/yZ9BBYzoMbs Title: Building a Trading System in Python | Azure Data Factories Link: https://youtu.be/y_WK1NTyzJk Chapters: -------------------------------------------------- 00:00 - Introduction 02:30 - What is a Data Factory? 05:00 - Data Factory Components 10:00 - ETL as a Service 13:30 - Data Factory with a Trading System 15:00 - Exploring the User Interface 17:20 - Exploring the User Interface - Author 19:40 - Exploring the User Interface - Monitor 20:30 - Exploring the User Interface - Manage 22:10 - Closing Statements **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #Finance #TradingSystems </video> <video> Access VBA | Import Excel Tables to Access Pt. 2 Description: In part two of our series, we will write the main section of our code that will loop through our list object and import the data into our newly defined Access Table. Additionally, we will walk through using the column headers in our table to specify the field we want to insert the value into. That way, we can replicate exactly how the table is structured in Excel and transfer it over to Access. Video Resources: -------------------------------------------------- https://github.com/areed1192/sigma_coding_youtube/tree/master/vba/vba-access/import-excel-table.vbs Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub Sigma Coding: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Access VBA | Introduction Link: https://youtu.be/_5rfCCkVTNA Title: Access VBA | Working with Query Definitions Link: https://youtu.be/-bB_fdqldUU Title: Access VBA | Import Excel Tables to Access Pt. 1 Link: https://youtu.be/o9V6qN5QL0k Title: Access VBA | Import Excel Tables to Access Pt. 2 Link: https://youtu.be/z7Dun3Brvh8 **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One way I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) and helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #VBA #Access #ExcelTables </video> <video> Power BI in Python | Authentication Description: Power BI is a business intelligence tool developed by Microsoft that allows you to create highly dynamic and interactive dashboards for users. Along with dashboarding capabilities, Power BI allows for powerful data transformations and effective data modeling that will allow you to capture the power of your data. In this series, we will explore the Power BI REST API from the perspective of Python. Not only we will register an application that will access the REST API, but we will also show you the library you can use to help get up and running with the REST API quickly. Video Resources: -------------------------------------------------- https://dev.powerbi.com/Apps https://github.com/areed1192/power-bi-python-api https://docs.microsoft.com/en-us/rest/api/power-bi/ https://www.sqlshack.com/how-to-access-power-bi-rest-apis-programmatically/ Chapters: -------------------------------------------------- 00:00 - Introduction 01:45 - Overview of Power BI 08:30 - Power BI Repo 09:45 - Registering an Application 18:00 - Viewing the App in Azure 18:30 - Creating a Config File 22:00 - Authentication 29:00 - Closing Statements Resources: -------------------------------------------------- Facebook Page: https://www.facebook.com/codingsigma Facebook Group: https://www.facebook.com/groups/sigmacoding GitHub: https://github.com/areed1192/sigma_coding_youtube Support Sigma Coding: -------------------------------------------------- Patreon: https://patreon.com/sigmacoding Amazon Associates: https://amzn.to/3bsTI5P ** Related Topics: -------------------------------------------------- Title: Power BI in Python | Authentication Link: https://youtu.be/_2eGAjm1I4w **Amazon Associates Disclosure: -------------------------------------------------- I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel. Tags: -------------------------------------------------- #Python #PowerBi #Authentication </video>

Contacts and Links

Description

Howdy! My name is Alex, and if you're like me, you enjoy the world of programming. Or you were like me a few years ago and are beginning to take your first step into this exciting world. Well lucky for you, you came across the right channel! Sigma Coding aims to be your one-stop-shop for programming tutorials. While I don't cover every programming language, I aim to cover topics and languages that can be used across a wide variety of platforms.

A few of the languages we cover are:

1. Python
2. VBA
3. JavaScript
4. M Language (Used for Power Query & Power BI)
5. SQL

This list is continuously changing, and I do my best to make tutorials engaging, exciting, and most importantly, easy to follow!

GitHub Repository:
https://github.com/areed1192

Facebook Page:
https://www.facebook.com/codingsigma/

Videos from channel