Tech Expert Tutorials
Tech Expert Tutorials
  • 52
  • 54 280
Azure Data Factory XML To SQL Pipeline Tutorial
ADF XML to SQL Pipeline:
In this video you will learn how to move XML formatted data in a file to an online Azure SQL Server database.
We will show you how to move and store files into Azure blob storage accounts, how to setup credentials for ftp'ing those files from an external location, to that account. Also, how to set up an Azure SQL Database to store that data. And Create an ETL dataflow in Azure Data Factory to move, and flatten, the data contained in the xml file. Finally, we validate that the pipeline ran successfully, along with discussing some issues you may have along the way.
Popular Videos:
▶️ Data Factory Intro: ua-cam.com/video/s4wW79LKrfE/v-deo.html
▶️ Azure SQL Server: ua-cam.com/video/asIGeq4dbvI/v-deo.html
▶️ Windows SQL Server: ua-cam.com/video/DzUW-6T7eKU/v-deo.html
▶️ Gemini AI Assistant: gemini.google.com/
Related Videos:
▶️ Install MySQL on Your Desktop (zip version): future video
▶️ Install Oracle on Your Desktop: ua-cam.com/video/irmy4eZ60SY/v-deo.html
▶️ Install MS SQL Server on Your Desktop: ua-cam.com/video/DzUW-6T7eKU/v-deo.html&list=PLkTmsEazx3GVRnn0X1nPqT0jrYQSuvF7j
▶️ Install Postgres on AWS: ua-cam.com/video/tw4cJyADEZ0/v-deo.html
OCR related Videos:
▶️ Pytesseract OCR Video: ua-cam.com/video/UBpFPBVlINw/v-deo.html
▶️ Python, Conda and VSCode Video: ua-cam.com/video/lGRwEcCHNtA/v-deo.html
▶️ Azure OCR Video: ua-cam.com/video/67mudgk74hs/v-deo.html
▶️ GCP OCR Video: ua-cam.com/video/hkKKfEqZvn4/v-deo.html
▶️ OpenAI OCR Video: ua-cam.com/video/wlIFVfIYrPM/v-deo.html
▶️ Gemini AI OCR Video: ua-cam.com/video/r2YGuPDECaE/v-deo.html
▶️ AWS OCR Video: ua-cam.com/video/6h7fZ6brhsY/v-deo.html
Other OCR Related Videos/Playlists:
▶️ Google Cloud Vision API (Part 1): OCR Text Extraction Tutorial - ua-cam.com/video/q8QRd4CUuvs/v-deo.html
▶️ Google Cloud Vision API (Part 2): Object Detection Tutorial - ua-cam.com/video/i2yFD8PsMvQ/v-deo.html
▶️ Google Cloud Vision API (Part 3): Landmark Detection Tutorial - ua-cam.com/video/FZsdFvJLoa0/v-deo.html
▶️ Google Cloud Vision API (Part 4): Facial Detection Tutorial - ua-cam.com/video/sZ4dP6JJhio/v-deo.html
▶️ Google Cloud Vision API (Part 5): Label Detection Tutorial - ua-cam.com/video/s5doqd2VOds/v-deo.html
▶️ Google Cloud Vision API Playlist - ua-cam.com/play/PLkTmsEazx3GVcEtCSLauTw4x4NgTSEGqM.html
💻 Our channel: youtube.com/@TechExpertTutorials
💥 link to subscribe: ua-cam.com/channels/niqO7kiYpJymnMfMFWS8XA.html
▶️ Most recent video: ua-cam.com/video/G1jNf7P-2aw/v-deo.html
www.youtube.com/@TechExpertTutorials
💛 Follow me on Instagram: techexpertvideos
💛 Follow me on Tumblr: www.tumblr.com/techexperttutorials
💛 Follow me on Twitter/X: x.com/TechXpertVideos
💛 Follow me on Facebook: profile.php?id=61557239930873
Переглядів: 142

Відео

Claude AI Vision OCR API with Python: API for OCR Text Extraction
Переглядів 38519 годин тому
Claude AI API for OCR - Extract Information from Images using Python In today's video, we will show you how to create your own application using the Claude AI Vision API in a python script. We will include creating an Anthropic account, adding credit so you can start sending messages, and using an API key to connect to Anthropic Claude AI online. Finally, we Show you an application using the AP...
Claude AI OCR Tutorial: Account Setup and Demo
Переглядів 195День тому
Claude AI OCR: Learn how to easily create a free account with Anthropic's powerful Claude AI. This tutorial shows you how to set up your account and explore its capabilities, including creating chatbots, extracting text from images (OCR), and even getting coding assistance. We also compare Claude AI's OCR accuracy to industry leaders like OpenAI and Gemini. Watch now and unlock the potential of...
BeautifulSoup 4 + Requests in Python : Web Scraping Tutorial
Переглядів 15414 днів тому
BeautifulSoup - Learn how to perform efficient web scraping using the Python Beautiful Soup library. Learn how to extract text or data from web pages, using the BeautifulSoup and Requests Python packages. This data could be historical data from financial sites either to summarize or to use for building a model to make predictions, or maybe player statistics data from a sports website to predict...
Install MySQL 9.1 on Windows 11 (2024) : Community Edition
Переглядів 33214 днів тому
Description: Install MySQL Server 9.1 Community Edition and Workbench on Windows: In this video, we will show you how to install the newest MySQL Database server for windows, version 9.1. Version 9.1 includes several exciting new features that we will cover later in the video. We will select the free COMMUNITY Edition, and we will also install Workbench, a visual tool for interacting with your ...
Install SQLite on Windows 11 2024: SQLite3 Tutorial
Переглядів 20721 день тому
In today's video we will teach you how to install and setup the most recent version of SQLite on Windows. There are many desktop databases you can run on Windows. You would select the SQLite database if you are looking for a quick and easy setup, only need one connection at a time, or may need to port over from windows to Linux or a mobile device. Key Advantages of SQLite: Self-Contained: SQLit...
Upgrade MySQL Server: Best Practices
Переглядів 87Місяць тому
How to Upgrade a MySQL Database and Workbench and Avoid Common Mistakes: Learn how to successfully upgrade your MySQL database server on Windows! This comprehensive guide covers all main aspects of the upgrade process, including: database backup and restore using Workbench, MySQL installation with the MSI installer, troubleshooting common issues, and ensuring data integrity. We also discuss bes...
Install Postgres 17 in Windows: Tutorial including pgAdmin - New 2024 Version
Переглядів 198Місяць тому
In this video we will show you how to install both the PostgreSQL Database, and PgAdmin 4, the GUI interface to access your database. We will also show a few simple commands to test the database application installation. Links: Postgres docs: www.postgresql.org/docs/current/datatype.html Gemini AI Assistant: gemini.google.com/ Reference links: ▶️ Postgres docs: www.postgresql.org/docs/current/d...
Create Azure SQL DB - Free Version available
Переглядів 216Місяць тому
Azure SQL Database: Setup SQL Server Database on Azure Free Tier In today's video, we will show you how to create an Azure Cloud SQL Server Database, and connect to it, from your desktop, using SSMS. We will also cover some key configuration and connecting to the database service using the Azure console. Reference links: ▶️ Free Offer: learn.microsoft.com/en-us/azure/azure-sql/database/free-off...
Install and Upgrade MySQL Server 5.7 and Workbench on Windows
Переглядів 4532 місяці тому
Install and Setup MySQL Server Community Edition and Workbench on Windows: In this video, we will show you how to install a MySQL Free Community Edition Database Server on Windows, and Workbench, a visual tool for interacting with your database. We will also be performing some initial setup. We will cover EVERYTHING you need to know in order to get started with MySQL. We will show you the proce...
Install SQL Server 2022 on Windows 11 With SSMS: Developer Edition
Переглядів 2053 місяці тому
Install SQL Server 2022 Developer Edition: SSMS Installation Included In this video, we will show you how to install Microsoft SQL Server version 2022 on your Windows desktop, along with some initial setup. We will be selecting the FREE developer version.We will also cover how to install SSMS to access your database. We will cover several topics with everything you will need to know in order to...
Azure OpenAI Application with OCR Vision: Use GenAI GPT-4 with Vision on Images, Documents and Data
Переглядів 9293 місяці тому
Using Azure OpenAI On Your Data: Includes Vision OCR capability! This video will help you to create an Azure OpenAI Chatbot with BYOD and OCR capability. There are many reasons to add an OpenAI GPT application to your business or personal website. Large Language Models like ChatGPT help us to create new applications that were previously too difficult to build. For this reason, many businesses a...
How to Install Oracle Database on Windows 11 - Free Version- Install Oracle on Windows
Переглядів 1,4 тис.3 місяці тому
Description: Installing the Free version of Oracle version 23ai on your desktop: In this video we are going to teach you how to install the free version of Oracle Database for Windows and show you some simple examples on how to use your database. We will be using Oracle version 23ai which is the newest version currently available at the time of this video, and installing on Windows 11 OS. Oracl...
Tesseract OCR Text Extraction for Windows - Tesseract OCR for Windows Tutorial
Переглядів 1 тис.4 місяці тому
Description: Tesseract OCR Windows Application for Text Extraction - Demo In this video we are going to teach you how to install Tesseract OCR for Windows and show you some simple examples on how to use the application to extract text from images. Tesseract is an command line OCR application written in the C/C language. It was originally created by Hewlett Packard and the University of Nevada L...
Python Code Formatting using Black: For Clean and Readable Code
Переглядів 1354 місяці тому
Description: Python Black Code Formatter Package - save time and produce better looking code In this video we are going to teach you how to use the Black application to easily help make the formatting in your python code more consistent and readable. You can concentrate on writing your code, and re-format when you are finished. This will save you time, and will ensure the formatting style in yo...
Gemini AI Setup Free API Account
Переглядів 2834 місяці тому
Gemini AI Setup Free API Account
Google Gemini AI Vision - OCR Text Extraction with Python
Переглядів 3,2 тис.4 місяці тому
Google Gemini AI Vision - OCR Text Extraction with Python
Intro to Azure Data Factory: Moving data with ADF - Tutorial for Beginners
Переглядів 2694 місяці тому
Intro to Azure Data Factory: Moving data with ADF - Tutorial for Beginners
OpenAI GPT Vision OCR API with Python: Extracting Information from Images
Переглядів 7 тис.5 місяців тому
OpenAI GPT Vision OCR API with Python: Extracting Information from Images
AWS Textract API for Images - AWS Textract OCR Tutorial: Text Extraction with Python
Переглядів 1,3 тис.7 місяців тому
AWS Textract API for Images - AWS Textract OCR Tutorial: Text Extraction with Python
Google Cloud Vision API for Images using Python: Google Vision API Tutorial
Переглядів 3,3 тис.8 місяців тому
Google Cloud Vision API for Images using Python: Google Vision API Tutorial
Google Cloud Vision API (Part 5): Label Detection Tutorial
Переглядів 5658 місяців тому
Google Cloud Vision API (Part 5): Label Detection Tutorial
Google Cloud Vision API (Part 4): Facial Detection Tutorial
Переглядів 4738 місяців тому
Google Cloud Vision API (Part 4): Facial Detection Tutorial
Google Cloud Vision API (Part 3): Landmark Detection Tutorial
Переглядів 4628 місяців тому
Google Cloud Vision API (Part 3): Landmark Detection Tutorial
Google Cloud Vision API (Part 2): Object Detection Tutorial
Переглядів 1,3 тис.9 місяців тому
Google Cloud Vision API (Part 2): Object Detection Tutorial
Google Cloud Vision API (Part 1): Google Vision API OCR Text Extraction Tutorial
Переглядів 6 тис.9 місяців тому
Google Cloud Vision API (Part 1): Google Vision API OCR Text Extraction Tutorial
Merge Pandas Dataframes: Merge Join and Concat Python Tutorial
Переглядів 1309 місяців тому
Merge Pandas Dataframes: Merge Join and Concat Python Tutorial
Pytesseract Image to Text OCR Python Package: Tutorial
Переглядів 5389 місяців тому
Pytesseract Image to Text OCR Python Package: Tutorial
Top 10 Python Pandas Functions: Expert Tips
Переглядів 309 місяців тому
Top 10 Python Pandas Functions: Expert Tips
Google Gemini AI Model: Tutorial
Переглядів 1199 місяців тому
Google Gemini AI Model: Tutorial

КОМЕНТАРІ

  • @themysteryman-e2j
    @themysteryman-e2j 2 дні тому

    whic is the best considering accuracy and cost open ai API,AWS , GCP, Azure ... or local installation of someting

  • @Jewish5783
    @Jewish5783 5 днів тому

    Can I use a google colab instead of jupyter Notebook?

    • @TechExpertTutorials
      @TechExpertTutorials 3 дні тому

      Hi, I haven't done this before, but you should be able to use a notebook on Google Colab instead of Jupyter notebook on a local pc. Try this: Create a service account in Google Cloud Vision API. Download the service account key file as a JSON file. download the json file, then upload the file to the colab environment Reference: cloud.google.com/vision/product-search/docs/auth

  • @TechExpertTutorials
    @TechExpertTutorials 7 днів тому

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 7 днів тому

    Are you using a desktop database such as MySQL, Oracle or SQLite? If you are curious to learn more about these and other databases, check out this playlist! ua-cam.com/video/aruS-sUK_eM/v-deo.html

  • @TechExpertTutorials
    @TechExpertTutorials 7 днів тому

    Are you using a desktop database such as MySQL, Oracle or SQLite? If you are curious to learn more about these and other databases, check out this playlist! ua-cam.com/video/aruS-sUK_eM/v-deo.html

  • @TechExpertTutorials
    @TechExpertTutorials 7 днів тому

    Are you using an online OCR application like Claude, OpenAI Vision or GeminiAI Vision? If you are curious to learn more about other applications, check out this playlist! ua-cam.com/video/hkKKfEqZvn4/v-deo.html

  • @TechExpertTutorials
    @TechExpertTutorials 7 днів тому

    Please like and subscribe

  • @Salehm-b5b
    @Salehm-b5b 11 днів тому

    I've seen an Id and this tool can read information from it, can this tool read MRZ a barcode for passports? how can I automate extracting information from any passport to an excel file? any suggestion?

    • @TechExpertTutorials
      @TechExpertTutorials 10 днів тому

      Hi, I haven't used Vision API for barcode reading. Even though it is a general model, it should do okay. For the highest accuracy, it is usually better to either retrain a general model or find a focused model that is already trained for your specific use. You will get better results on a model that is specific and not general. For automation, you would need to build an app that can take an image of the barcode, send it to the API, then post the results into the excel file.

  • @TechExpertTutorials
    @TechExpertTutorials 11 днів тому

    What database and version do you use most often? Are you mainly interested in on premise databases, or in online (cloud) databases? Learn more about these by checking out this playlist!! ua-cam.com/video/SjsjbWqkCPs/v-deo.html

  • @TechExpertTutorials
    @TechExpertTutorials 11 днів тому

    Are you interested in learning more about popular Python libraries? If so, check out this playlist!! ua-cam.com/video/4UYCwDoMGxw/v-deo.html

  • @TechExpertTutorials
    @TechExpertTutorials 11 днів тому

    Are you using an online OCR application like Claude, OpenAI Vision or GeminiAI Vision? If you are curious to learn more about other applications, check out this playlist! ua-cam.com/video/hkKKfEqZvn4/v-deo.html

  • @TechExpertTutorials
    @TechExpertTutorials 12 днів тому

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 13 днів тому

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 14 днів тому

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 26 днів тому

    Please Like and Subscribe!

  • @eduardomontero2901
    @eduardomontero2901 Місяць тому

    Great thank you so much for sharing

  • @TechExpertTutorials
    @TechExpertTutorials Місяць тому

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials Місяць тому

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials Місяць тому

    Please like and subscribe!

  • @stanleyewenike
    @stanleyewenike Місяць тому

    Spot on! Simple and straight to the point. Up-to-date as well! Thank you

  • @adhidwipa6027
    @adhidwipa6027 Місяць тому

    Exactly what I need to dissect video into image frames then utilize Tesseract to extract the string. Thank you for covering this I feel helped.

  • @ridhofebriansyah-f2h
    @ridhofebriansyah-f2h Місяць тому

    hi this is a good tutorial btw, i wanna know this is free or not. because when i wanna try to used it i should create a billing account if i wanna used cloud vision api key

  • @Adilnawazkhan7509
    @Adilnawazkhan7509 Місяць тому

    Is it free?

    • @TechExpertTutorials
      @TechExpertTutorials Місяць тому

      There used to be a free trial where they give you some credit. Once that credit was used up, you would need to pay to use. I don't see that option on their website any longer. Currently they have a prepayment method, in $5 increments.

  • @Adilnawazkhan7509
    @Adilnawazkhan7509 Місяць тому

    bRO TOO DIFFICULT

  • @geppetox748
    @geppetox748 2 місяці тому

    Thank you very much!

  • @TechExpertTutorials
    @TechExpertTutorials 2 місяці тому

    Please like and subscribe

  • @yordanpatronski1897
    @yordanpatronski1897 2 місяці тому

    how to set up the environment from 1:41 for conda and google cloud? And how to set up jupyter notebook on google cloud?

    • @TechExpertTutorials
      @TechExpertTutorials 2 місяці тому

      If you are using vscode as your editor, you can follow this video for general instructions on how to get these working together: ua-cam.com/video/lGRwEcCHNtA/v-deo.html google-cloud-vision is the main package for connecting python to google cloud

  • @EvitandTM
    @EvitandTM 2 місяці тому

    Thanks a lot sir🙏

  • @NingLi-b1b
    @NingLi-b1b 2 місяці тому

    How does the read method compare to the recognize_printed_text method? The documentation says the former is better for text heavy documents. Is that your experience?

  • @sanketjadhav_6537
    @sanketjadhav_6537 2 місяці тому

    can you also make a video of qr code detection

  • @sanketjadhav_6537
    @sanketjadhav_6537 2 місяці тому

    can i decode the barcode using google cloud vision api?and also can i mention in code that what i want to detect and decode using this api

    • @TechExpertTutorials
      @TechExpertTutorials 2 місяці тому

      You can, and Google Vision should work okay as a barcode reader. However, there are other tools that might be more useful and accurate as they were built specifically for this purpose. ML Kit and Android Google Mobile Vision Library are a few. I haven't used either of these.

  • @ukrainewarroom
    @ukrainewarroom 3 місяці тому

    Your LINQ select for the Blocktypes.WORD is redundant - you dont use them

  • @huynhvanthao8743
    @huynhvanthao8743 3 місяці тому

    Turn on IPv4 public will be charge by AWS

    • @TechExpertTutorials
      @TechExpertTutorials 3 місяці тому

      Thanks for pointing this out - AWS made some changes to IPv4 costs in February of this year (2024).

  • @joanjennifermartinez4928
    @joanjennifermartinez4928 3 місяці тому

    Great, video. For beginners, it would be great if you can comment on the difference or synergies between using boto3 and the amazon-textract-textractor package. Thanks!

    • @TechExpertTutorials
      @TechExpertTutorials 3 місяці тому

      Hi, textractor is a specialized package used only for connecting to the AWS Textract service, whereas boto3 is a general purpose library, it can be used for many different AWS API services. If you were just working with AWS Textract, the Textractor package would be easier to use.

  • @TechExpertTutorials
    @TechExpertTutorials 3 місяці тому

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 3 місяці тому

    Please like and subscribe!

  • @aldoseba
    @aldoseba 3 місяці тому

    Is there a way to create a doc with images and OCR from something like a scanned book?

    • @TechExpertTutorials
      @TechExpertTutorials 3 місяці тому

      creating a text document from a scanned book would be possible, but the accuracy may not be 100%. You would need to edit and correct the mistakes in the output after the OCR is finished. Creating the images would be more difficult.

    • @aldoseba
      @aldoseba 3 місяці тому

      @@TechExpertTutorials that's fine, but I'm looking a way to do it in one step, ocr and image recognition to a doc file, then, rearrange and correct it.

  • @Furyki
    @Furyki 3 місяці тому

    hi @TechExpertTutorials , can u also create finger print detection using google api, thanksss

    • @TechExpertTutorials
      @TechExpertTutorials 3 місяці тому

      Hi, Google does not have an API designed for fingerprint recognition. You can check out the WebAuthn API, although I have never used it.

  • @omarjab
    @omarjab 3 місяці тому

    thank you, it works!

  • @abdulfathah4126
    @abdulfathah4126 3 місяці тому

    Thank you. ❤

  • @michaelvansintjan8536
    @michaelvansintjan8536 3 місяці тому

    Excelent video, thanks! Is there a way upload multiple images before asking questions about the text in them?

    • @TechExpertTutorials
      @TechExpertTutorials 3 місяці тому

      Thanks! To handle multiple images effectively, you could use the Azure OpenAI GPT4 service and include the BYOD "add your data" option, which can include extracting text from files/images. Then you can ask any questions about any of the files/images. The process would look through the data on all of the files and find the most relevant information. FYI, I plan to have a video out soon that will cover how to set this up.

    • @omarjab
      @omarjab 3 місяці тому

      yes, you can, i did it this way: content = [{"type": "text", "text": prompt}] for filename in os.listdir(images_folder_path): if filename.lower().endswith(('.png', '.jpg', '.jpeg', '.gif', '.bmp')): filepath = os.path.join(images_folder_path, filename) content.append({"type": "image_url", "image_url": {"url": f"data:image/png;base64,{encode_image(filepath)}"}}) response = client.chat.completions.create( model='gpt-4o', messages=[{"role": "user", "content": content}], max_tokens=500, )

    • @omarjab
      @omarjab 3 місяці тому

      i don't know if that's what you really need but i hope it works for you

  • @crisostomoibarra1760
    @crisostomoibarra1760 3 місяці тому

    Can you teach us how to use document ai for php? Tysm, i also want to learn how to get the extracted text to fill a form, is that possible?

    • @TechExpertTutorials
      @TechExpertTutorials 3 місяці тому

      You should be able to take the extracted text from Gemini AI and add that information to a web or text-based form. I don't know if there are any 3rd party tools that would simplify this, but it could be done.

  • @TechExpertTutorials
    @TechExpertTutorials 4 місяці тому

    Thanks for watching our video! Please like and subscribe!

  • @hajsandeepa4332
    @hajsandeepa4332 4 місяці тому

    do i need a billing account for this ?

    • @TechExpertTutorials
      @TechExpertTutorials 4 місяці тому

      I was able to use this with a free Google Cloud account previously. Google gives you $300 in free credits to use for testing and evaluation. Here are some more details: cloud.google.com/vision/docs/drag-and-drop

    • @hajsandeepa4332
      @hajsandeepa4332 4 місяці тому

      ​@@TechExpertTutorials thanx 🤗

  • @TechExpertTutorials
    @TechExpertTutorials 4 місяці тому

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 4 місяці тому

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 4 місяці тому

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 4 місяці тому

    Please like and subscribe