- Видео 49
- Просмотров 41 696
Tech Expert Tutorials
США
Добавлен 18 янв 2024
Interested in learning more about Data Science, Data Engineering, AI or Cloud Computing? Want to build a career in one of these fields?
If you are looking for short and concise videos that explain these topics quickly then this is the channel for you.
About us:
We have over 20 years of experience in Cloud Technology, Data Engineering, Data Science, and Software Engineering. We have built hundreds of successful solutions for our customers, always striving to exceed expectations. Now we are creating videos that share our knowledge that we have gained, helping you to quickly understand the basic concepts of multiple topics, to help you get started on your tech or cloud journey in the shortest time possible.
If you want to join me in a journey to become a better data or cloud developer, hit the subscribe button now.
If you are looking for short and concise videos that explain these topics quickly then this is the channel for you.
About us:
We have over 20 years of experience in Cloud Technology, Data Engineering, Data Science, and Software Engineering. We have built hundreds of successful solutions for our customers, always striving to exceed expectations. Now we are creating videos that share our knowledge that we have gained, helping you to quickly understand the basic concepts of multiple topics, to help you get started on your tech or cloud journey in the shortest time possible.
If you want to join me in a journey to become a better data or cloud developer, hit the subscribe button now.
How to Upgrade MySQL Database: Avoid Downtime/Best Practices
In this comprehensive MySQL tutorial, we'll guide you through the complete MySQL installation upgrade process on Windows. Learn how to use mysql workbench effectively while performing the upgrade, ensuring your mysql instance remains stable throughout the process. We'll demonstrate proper database management system practices and show you how to verify your mysql connector configurations after the upgrade. 💻
Reference links:
▶️ .msi install files: dev.mysql.com/downloads/installer/
▶️ .zip install files: downloads.mysql.com/archives/community
Related Videos:
▶️ Install MySQL on Your Desktop (zip version): future video
▶️ Install Oracle on Your Desktop: ruclips.net/video/irmy4eZ60SY/видео.html
▶️ ...
Reference links:
▶️ .msi install files: dev.mysql.com/downloads/installer/
▶️ .zip install files: downloads.mysql.com/archives/community
Related Videos:
▶️ Install MySQL on Your Desktop (zip version): future video
▶️ Install Oracle on Your Desktop: ruclips.net/video/irmy4eZ60SY/видео.html
▶️ ...
Просмотров: 6
Видео
Don't Lose Your Data! Upgrade MySQL to a Newer Version Successfully
Просмотров 45 часов назад
In this comprehensive MySQL tutorial, we'll guide you through the complete MySQL installation upgrade process on Windows. Learn how to use mysql workbench effectively while performing the upgrade, ensuring your mysql instance remains stable throughout the process. We'll demonstrate proper database management system practices and show you how to verify your mysql connector configurations after t...
How to Install Postgres 17 and pgAdmin in Windows
Просмотров 234 часа назад
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 SQL Server Database on Azure: Free Tier
Просмотров 324 часа назад
Azure SQL Server Database Tutorial 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-offer?view=azuresql Related Video...
How to Install and Upgrade MySQL Server 5.7 and Workbench on Windows
Просмотров 357Месяц назад
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...
How to Create an AWS RDS Postgres Database: Tutorial
Просмотров 68Месяц назад
RDS POSTGRES Database on AWS: Learn how to create a Postgres database on AWS with Tech Expert Tutorials! In this tutorial, we'll guide you through the process of setting up your own database in AWS Free Tier using Postgres. We'll cover everything from creating databases and tables to inserting and querying data. Stay tuned until the end to learn how to clean up and delete your Postgres database...
Install and Setup SQL Server 2022 and SSMS on Windows
Просмотров 164Месяц назад
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 cover several topics with everything you will need to know in order to get started with SQL Server. Topics included or discussed: SQL Server overview and uses (when to use this vs other databases) Use: R...
Azure OpenAI with OCR Vision: Use GPT-4 Turbo with Vision on Your Data
Просмотров 6492 месяца назад
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
Просмотров 8602 месяца назад
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 - Tutorial
Просмотров 6113 месяца назад
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
Просмотров 963 месяца назад
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
Просмотров 2463 месяца назад
Description: Gemini AI OCR Python API In this video we are going to teach you how to setup a free API account for the Gemini AI model. You can use this to send API calls to Gemini without any cost to you. This should be used for investigating the functionality and for testing purposes only. Related Videos: ▶️ Python, Conda and VSCode Video: ruclips.net/video/lGRwEcCHNtA/видео.html ▶️ Azure OCR ...
Google Gemini AI Vision - OCR Text Extraction with Python
Просмотров 2 тыс.3 месяца назад
Description: Gemini AI OCR Python API In this video we are going to teach you how to setup and extract text and other information from images, using the Google Gemini AI API service. Later, we will show you the accuracy of the output, so please stick around. Gemini AI has the ability to extract text from images and interpret the contents of the image. This model can take in images and answer qu...
Intro to Azure Data Factory: Moving data with ADF - Tutorial for Beginners
Просмотров 2073 месяца назад
Azure Data Factory ADF is a vital service for data engineering activities in Azure. It is a powerful and flexible Platform as a service with hundreds of connectors and integration functions. It is the central location for ETL in Azure. In this video, we will show you everything you need to know to use Microsoft Azure Data Factory. First, we will create a new Data Factory service with some commo...
OpenAI GPT Vision OCR API with Python: Extracting Information from Images
Просмотров 5 тыс.4 месяца назад
OpenAI GPT4 Vision OCR API Python In this video we are going to teach you how to setup and extract information from images, using the OpenAI Vision API service. Later, we will show you the accuracy of the output, so please stick around. OpenAI’s vision capabilities allow models like GPT-4o, GPT-4o mini, and GPT-4 Turbo to understand images. These models can take in images and answer questions a...
AWS Textract API for Images - AWS OCR Tutorial: Text Extraction with Python
Просмотров 1 тыс.6 месяцев назад
AWS Textract API for Images - AWS OCR Tutorial: Text Extraction with Python
Google Cloud Vision API for Images using Python: Complete Tutorial
Просмотров 2,7 тыс.6 месяцев назад
Google Cloud Vision API for Images using Python: Complete Tutorial
Google Cloud Vision API (Part 5): Label Detection Tutorial
Просмотров 4357 месяцев назад
Google Cloud Vision API (Part 5): Label Detection Tutorial
Google Cloud Vision API (Part 4): Facial Detection Tutorial
Просмотров 3517 месяцев назад
Google Cloud Vision API (Part 4): Facial Detection Tutorial
Google Cloud Vision API (Part 3): Landmark Detection Tutorial
Просмотров 3517 месяцев назад
Google Cloud Vision API (Part 3): Landmark Detection Tutorial
Google Cloud Vision API (Part 2): Object Detection Tutorial
Просмотров 9917 месяцев назад
Google Cloud Vision API (Part 2): Object Detection Tutorial
Google Cloud Vision API (Part 1): OCR Text Extraction Tutorial
Просмотров 4 тыс.7 месяцев назад
Google Cloud Vision API (Part 1): OCR Text Extraction Tutorial
How to Merge Pandas Dataframes: Merge Join and Concat Python Tutorial
Просмотров 1178 месяцев назад
How to Merge Pandas Dataframes: Merge Join and Concat Python Tutorial
Pytesseract Image to Text OCR Python Package: Tutorial
Просмотров 4848 месяцев назад
Pytesseract Image to Text OCR Python Package: Tutorial
Top 10 Python Pandas Functions: Expert Tips
Просмотров 238 месяцев назад
Top 10 Python Pandas Functions: Expert Tips
Easy Python Web Scraping with BeautifulSoup and Requests
Просмотров 398 месяцев назад
Easy Python Web Scraping with BeautifulSoup and Requests
Learn Interactive Dashboard with Dash and Plotly in under 5 minutes - Quick Tutorial
Просмотров 768 месяцев назад
Learn Interactive Dashboard with Dash and Plotly in under 5 minutes - Quick Tutorial
Python Diagrams Module - Make Awesome Architecture and Workflow Diagrams in Python
Просмотров 2008 месяцев назад
Python Diagrams Module - Make Awesome Architecture and Workflow Diagrams in Python
Create Your Own AWS VPC with Private and Public Subnets in Minutes - Using Console or Python Script
Просмотров 1109 месяцев назад
Create Your Own AWS VPC with Private and Public Subnets in Minutes - Using Console or Python Script
Please like and subscribe!
Please like and subscribe!
Please like and subscribe!
Please like and subscribe!
Spot on! Simple and straight to the point. Up-to-date as well! Thank you
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.
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
Is it free?
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.
bRO TOO DIFFICULT
Thank you very much!
Please like and subscribe
how to set up the environment from 1:41 for conda and google cloud? And how to set up jupyter notebook on google cloud?
If you are using vscode as your editor, you can follow this video for general instructions on how to get these working together: ruclips.net/video/lGRwEcCHNtA/видео.html google-cloud-vision is the main package for connecting python to google cloud
Thanks a lot sir🙏
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?
can you also make a video of qr code detection
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
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.
Your LINQ select for the Blocktypes.WORD is redundant - you dont use them
Please like and subscribe!
Turn on IPv4 public will be charge by AWS
Thanks for pointing this out - AWS made some changes to IPv4 costs in February of this year (2024).
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!
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.
Please like and subscribe!
Please like and subscribe!
Is there a way to create a doc with images and OCR from something like a scanned book?
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.
@@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.
hi @TechExpertTutorials , can u also create finger print detection using google api, thanksss
Hi, Google does not have an API designed for fingerprint recognition. You can check out the WebAuthn API, although I have never used it.
thank you, it works!
Thank you. ❤
Excelent video, thanks! Is there a way upload multiple images before asking questions about the text in them?
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.
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, )
i don't know if that's what you really need but i hope it works for you
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?
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.
Thanks for watching our video! Please like and subscribe!
do i need a billing account for this ?
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
@@TechExpertTutorials thanx 🤗
Please like and subscribe
Please like and subscribe
Please like and subscribe
Please like and subscribe
Which model is it using for extracting the text from images?
This is using the Google Gemini large language model version 1.5 to extract the text. This multimodal model includes multiple functions in one model. Find more details here: ai.google.dev/gemini-api/docs/text-generation?lang=python
@@TechExpertTutorials I was trying to do same task using open source models. The google ocr engine tesseract is terrible for such tasks, so I was trying to achieve it using the object detection models and then passing the bboxes to the ocr, but it's performance is not up to the mark. Any suggestion how to proceed with open source models?
@@BhrantoPathik I have found that open-source models are currently not as accurate as the paid models from OpenAI and Google Gemini. This could change in the future as larger and more robust models are built and made available in open-source. I also tested pytesseract, see this video for details: ruclips.net/video/UBpFPBVlINw/видео.html
Looks up to date, much appreciated!
thanks for making this video, with a clear explanation of this topic!
It doesn't have a free trial, I follow video's instruction, but the response is 403 This API method requires billing to be enabled
You need billing enabled so if you go above 1,000 calls/units it can bill you accordingly
Hey guys, I have challenging use case. In my country lot of retail stores publish pdfs/images with bunch of products containing, new price old price and name of product alongside image. Is there any way I can import images/pdfs and then it returns array of items from that page with mentioned properties. Loved your video and keep it coming 🎉
Thanks for the video! Good results.
good video!
thanks!
great video! clear explanation of AWS Textract. Thanks for posting this
thank you!
Great video, nicely done! I have subscribed and liked the video. Where can I find the video that covers the configuration of the chatbot as you mentioned? Additionally, if I create a chatbot on an existing website, how can I ensure that only logged-in users can access and use it?
Hi, thanks for watching and subscribing. I am still working on the next video for this topic. Also, to ensure that only logged in users can access this would require setting up a login form and a database on the website, to store the credentials. Microsoft Azure does provide additional ways to secure access, such as firewalls, gateways, key vaults, etc.
I feel difficult to install anaconda
Hey, great video! Which approach do you think is better for extracting specific documents/images patterns (say an ID from a country) in another language (maybe even handwritten) when a user uploads the file and for returing the data to him: Tesseract, Google Cloud Vision OCR, Azure or AWS Textract? Many thanks!
Thanks! I would suggest Azure, it has the best accuracy, and can even be improved upon if you include an OpenAI ChatGPT component.
thanks a lot. what could be the accuracy for Arabic language?
Not sure what is the accuracy for other languages, I have only used the English version. Here is a list of other languages that are available for this API: cloud.google.com/vision/docs/languages There is a paper comparing different languages, including Arabic, and it mentions the accuracy for Arabic is lower than English (93% vs 98%): www.researchgate.net/publication/356446235_OCR_with_Tesseract_Amazon_Textract_and_Google_Document_AI_a_benchmarking_experiment
Hi, amazing video, is it work with QR COdes?
Hi, thanks! AWS Textract does not currently read and decode QR Codes. You might be able to do that using a different AWS Service. There is an open-source library named ZBar that can decode QR codes and Bar codes.
The github repo is no more available
Thanks for letting me know. The repo has been moved. Here is the new location: github.com/TechExpertTutorials/AzureAIVision this is also updated in the description
@@TechExpertTutorials
Please click the like button, and subscribe to our channel. Thanks!
Please click the like button and subscribe to our channel. Thank you!