- Видео 85
- Просмотров 361 639
Clinton Daniel
Добавлен 10 фев 2016
OSI Model with Practical Demonstration
This video demonstrates the practical use of the OSI model. Specifically, this video covers the TCP/IP Stack. This is a simplified 5 Layer version that overlaps with the traditional 7 Layer version. TCP/IP is more applicable to modern networked systems. The demonstration contextually walks you through some labs that used Linux virtual machines. You can learn a lot about TCP/IP just from watching these demonstrations.
Просмотров: 1 281
Видео
Python Flask development with SQLite
Просмотров 23 тыс.Год назад
This example will walk you through creating a Python Flask app which uses a SQLite database to execute (C)reate, (R)ead, (U)pdate, and (D)elete operations. GitHub source code here: github.com/ISM6225/python-flask-sqlite
Developing a Flask app with Visual Studio Code
Просмотров 9 тыс.2 года назад
This tutorial based on: code.visualstudio.com/docs/python/tutorial-flask
SQL Injection on .NET Web Application Example for Learning Purposes
Просмотров 6 тыс.3 года назад
NOTE: This video is for learning purposes only. This video explains how a SQL Injection attack can be executed on a .NET Web Application that has not been developed with secure coding practices in Visual Studio. Source Code is available on GitHub here: github.com/cedanie2/SQL-Injection-for-Learning-Example and github.com/cedanie2/SQL-Injection-Example-Recorded
Solving Programming Problems in Kattis
Просмотров 6 тыс.3 года назад
This video explains how to fundamentally solve programming problems on the online Kattis platform. I provide a workflow that examines the problem, whiteboards a logical solution, builds the code in C#, and finally submits the code on the Kattis platform.
Python Dash Tutorial
Просмотров 2,6 тыс.3 года назад
I built this tutorial on Python Dash for my Data Visualization course at USF. To replicate this example you will need to: 1. Setup a GitHub Pages site. GitHub Pages is a static site hosting service that takes HTML, CSS, and JavaScript files straight from a repository in GitHub and publishes a website. You need to setup a “GitHub Pages” site on your GitHub account. To do this, follow this tutori...
OOP Introduction Explained with a C# Console Application
Просмотров 8 тыс.5 лет назад
This video explains the basic concepts of Object Oriented Programming with a C# Console Application.
Visual Studio 2019 integration with Git and GitHub demo
Просмотров 23 тыс.5 лет назад
This video demonstrates the integration of a local Git repository and a remote GitHub account repository using Visual Studio 2019.
MVC ASP.NET Core API with Database Example
Просмотров 6615 лет назад
This example demonstrates the use of MVC ASP.NET Core to create an application that gets data from an API, displays data in a web page, and then stores the data to a SQL Server Express database instance. Here is the link to the source code on GitHub: github.com/ISM6225/Simple_API_Database
MVC ASP.NET Core API Simple Example
Просмотров 2985 лет назад
This simple example demonstrates the use of an API to get data using an Http Client instance with MVC ASP.NET Core in C#. Here's the link to the source code in GitHub: github.com/ISM6225/API_Simple
Entity Framework on ASP.NET Core MVC Web Application with Database Example
Просмотров 6 тыс.5 лет назад
This video demonstrates how to create a simple MVC Web Application with a local SQL Server Database using the Entity Framework Core on ASP.NET Core. The source code can be downloaded from GitHub here: github.com/ISM6225/Entity-Framework-DB-MVC-Application-Example
MVC Models
Просмотров 3005 лет назад
Demonstrates the MVC Framework using the ASP.NET Core. Focuses on Models (M in MVC). The source code for this application can be downloaded from GitHub here: github.com/ISM6225/MVC-Models
MVC Basics Controllers Views
Просмотров 7225 лет назад
MVC Basics with ASP.NET Core Web Application Template. Also using C#. This video focuses on the Controllers and Views.
C# Selection Sort and Bubble Sort Algorithm Examples
Просмотров 2,2 тыс.5 лет назад
This video demonstrates a C# Console application that executes both Selection Sort and Bubble Sort Algorithms. The source code can be reviewed or downloaded from GitHub here: github.com/ISM6225/Sort
C# Big O Notation Example
Просмотров 2,8 тыс.5 лет назад
This C# Console application demonstrates Big O notation. The source code for this application can be downloaded from GitHub here: github.com/ISM6225/Big-0
Create C# HelloWorld Console Application and Publish to Git
Просмотров 5 тыс.5 лет назад
Create C# HelloWorld Console Application and Publish to Git
Install Visual Studio and Git Components
Просмотров 1,9 тыс.5 лет назад
Install Visual Studio and Git Components
Data Mart Design - Populate Dimensions and Fact Tables
Просмотров 71 тыс.6 лет назад
Data Mart Design - Populate Dimensions and Fact Tables
Data Mart Design- Further Transformation of Staging Table
Просмотров 7 тыс.6 лет назад
Data Mart Design- Further Transformation of Staging Table
Data Mart Design - Problems with ETL and Staging
Просмотров 6 тыс.6 лет назад
Data Mart Design - Problems with ETL and Staging
Data Mart Design - ETL Process to Populate Staging Table
Просмотров 41 тыс.6 лет назад
Data Mart Design - ETL Process to Populate Staging Table
Data Mart Design - Table Construction
Просмотров 17 тыс.6 лет назад
Data Mart Design - Table Construction
Finally a white man, got really tired of indians
THANK YOU!
Can you share me your previous videos
Hey! Thanks for the C# video on OOP. It's great for refreshing the core concepts, even though I'm building my CLI tool in TypeScript. The principles should apply just as well, right?
Why would you keep all the values in a single FactTable? Is not a FactTable suppose to keep only agg values in order to limit the storage and the cots of DWH?
Great explanation 👍
thank you so much
Nice video for computer science student 🫶
Is this windows?
Thank you Clinton!
Hello my friend. I just want to say that video you made on Flask and SQLite is EXTREMELY useful!! I really wanted to add that video to my playlist so that I can come back to it, but I realized it was marked as a "RUclips kids" video which means I cannot add it to my playlist. Just FYI - hope you change that setting but either way, thanks so much for it and for the github link as well! Great stuff - cheers.
This is Great
amazing snowflake schema video. no BS
Hello, great video. I know it's been a while, but can you perhaps speak on how you would take your data from a staging db and insert it into your fact table after all your dimensions are built, but this time you do not have any IDs for the dimensions in your staging table?
I will be posting an updated version of the data mart design process using SQLite later this year. There are a lot of examples where the data mart design is useful for localized analysis/data science projects rather than enterprise scalable or service oriented deployment. Instead of using a Microsoft tool, I will be showing how all of the data engineering (ETL) is done using Python and SQLite. I'll see if I can include a part of the FACT table example where the ID is not available in a staging table.
Thank you for all the information shared, I’ve just finished the course project. Thanks!!
This is the only series I found that defines datamart with a proper example. Thanks a lot Clinton!
Comprehensive explanation on data marts.
Very clear explanation on the logical process of building data warehouse and data mart.
hey clinton i hav found your ism 3232 lab videos really helpful for my course. Do you have a ISM 3232 lab 2 video? I can't find it on your channel
Hey, I really appreciate this tutorial.
is it a good way of doing warehousing ? I always hear that the staging should be raw, no calculation, no changing etc. but you added surrogate keys ?
Very useful! Thank you
Super helpful!
can you make a tutorial in xamarin forms ?
where were these videos during my semester ? I understand everything at last
I finally understand logically process of etl after long semester.
That was really helpful, thank you!
Hi, Your lectures are really useful to create dashboards using plotly dash in efficient way. Just have one questions ? How we can export these dashboards either in PDF or PPT using dash?
This would be a useful feature. However, I'm not sure that it is available via the server-side. Most likely you would have to write JavaScript to accomplish this. Either way, it doesn't look like an easy process to do. Someone should contribute to the Dash project a module that makes this feature easy for developers.
You are the man, thank you so much! You are saving Panda Jardins
Very clear and excellent explaination! Thank you!
Thanks sir
Hi do you have the dataset?
you normally dont update staging tables or merge any id
I took this class and passes with B+
Wonderful tutorial
Such a wonderful project approach on data mart.Can you please share the dataset because i would love to follow through on hand on ...it will be much appreciated./.Thx again in advance
I am not able to see the Customer model in the dropdown while trying to add controller. Tried many things, any solution?
thank you so much !
Best video ever. You just helped me complete my project. Thanks for the video
I really enjoyed watching this video ::)
Can you please share the dataset you used?.. Thanks
контекст и модель обычно делают в разных папках Ну а так, в целом очень информативно.
Why are we performing conversion while loading into staging?
So as not to mess up the master table, if something goes wrong.
Thank you Clinton for a very concise and useful tutorial for SSIS. By the way, i'd appreciate it if anyone can help me on explaining further how I can build a staging table?
Thank you Sir. Could you please update more videos. And one suggestion please create playlists
Thanks for this nice video, would you do another one for how to do this project from beginning
Please make a video how to build application using .net core / API and ado.net.
Could you please make a video using ado.net and .net core with API.
How the hacker knows what is table name used in the application ??? You showed in the delete command. Pls explain
The example simply shows how SQL was allowed with no defense built into the design. Discovering object names, such as tables or variables, is another topic.
Literally he showed in this video how he can accessed to the db if it's not secured! Watch it again! Quite clear explanation to be honest!
What if the developer using store procedures ? Still it can be done by any hacker ?
The example I recorded here just shows a complete disregard to security. The developer is allowing SQL to be injected within the C# code. A stored procedure would be a better practice. However, it is not excluded from attack if not properly developed.
Get a login stuff simple and let the user only adding any infos after authenticated and give to method an [ Authorize ] attribute or the page! Check Identity stuff and you don't need to worry about so much!