Tech Expert Tutorials
Tech Expert Tutorials
  • Видео 49
  • Просмотров 41 696
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
▶️ ...
Просмотров: 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
Google Gemini AI Model: Tutorial
Просмотров 1138 месяцев назад
Google Gemini AI Model: Tutorial
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

Комментарии

  • @TechExpertTutorials
    @TechExpertTutorials 5 часов назад

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 5 часов назад

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 2 дня назад

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 2 дня назад

    Please like and subscribe!

  • @stanleyewenike
    @stanleyewenike 3 дня назад

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

  • @adhidwipa6027
    @adhidwipa6027 7 дней назад

    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 11 дней назад

    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

  • @historyofislam7509
    @historyofislam7509 12 дней назад

    Is it free?

    • @TechExpertTutorials
      @TechExpertTutorials 12 дней назад

      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.

  • @historyofislam7509
    @historyofislam7509 12 дней назад

    bRO TOO DIFFICULT

  • @geppetox748
    @geppetox748 Месяц назад

    Thank you very much!

  • @TechExpertTutorials
    @TechExpertTutorials Месяц назад

    Please like and subscribe

  • @yordanpatronski1897
    @yordanpatronski1897 Месяц назад

    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 Месяц назад

      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

  • @EvitandTM
    @EvitandTM Месяц назад

    Thanks a lot sir🙏

  • @NingLi-b1b
    @NingLi-b1b Месяц назад

    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 Месяц назад

    can you also make a video of qr code detection

  • @sanketjadhav_6537
    @sanketjadhav_6537 Месяц назад

    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 Месяц назад

      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 Месяц назад

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

  • @TechExpertTutorials
    @TechExpertTutorials Месяц назад

    Please like and subscribe!

  • @huynhvanthao8743
    @huynhvanthao8743 Месяц назад

    Turn on IPv4 public will be charge by AWS

    • @TechExpertTutorials
      @TechExpertTutorials Месяц назад

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

  • @joanjennifermartinez4928
    @joanjennifermartinez4928 Месяц назад

    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 Месяц назад

      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 Месяц назад

    Please like and subscribe!

  • @TechExpertTutorials
    @TechExpertTutorials 2 месяца назад

    Please like and subscribe!

  • @aldoseba
    @aldoseba 2 месяца назад

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

    • @TechExpertTutorials
      @TechExpertTutorials 2 месяца назад

      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 Месяц назад

      @@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 2 месяца назад

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

    • @TechExpertTutorials
      @TechExpertTutorials 2 месяца назад

      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 2 месяца назад

    thank you, it works!

  • @abdulfathah4126
    @abdulfathah4126 2 месяца назад

    Thank you. ❤

  • @michaelvansintjan8536
    @michaelvansintjan8536 2 месяца назад

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

    • @TechExpertTutorials
      @TechExpertTutorials 2 месяца назад

      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 2 месяца назад

      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 2 месяца назад

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

  • @crisostomoibarra1760
    @crisostomoibarra1760 2 месяца назад

    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 2 месяца назад

      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 2 месяца назад

    Thanks for watching our video! Please like and subscribe!

  • @hajsandeepa4332
    @hajsandeepa4332 2 месяца назад

    do i need a billing account for this ?

    • @TechExpertTutorials
      @TechExpertTutorials 2 месяца назад

      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 2 месяца назад

      ​@@TechExpertTutorials thanx 🤗

  • @TechExpertTutorials
    @TechExpertTutorials 3 месяца назад

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 3 месяца назад

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 3 месяца назад

    Please like and subscribe

  • @TechExpertTutorials
    @TechExpertTutorials 3 месяца назад

    Please like and subscribe

  • @BhrantoPathik
    @BhrantoPathik 3 месяца назад

    Which model is it using for extracting the text from images?

    • @TechExpertTutorials
      @TechExpertTutorials 3 месяца назад

      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

    • @BhrantoPathik
      @BhrantoPathik 3 месяца назад

      @@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?

    • @TechExpertTutorials
      @TechExpertTutorials 3 месяца назад

      @@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

  • @David-h5m9v
    @David-h5m9v 3 месяца назад

    Looks up to date, much appreciated!

  • @allaboutdatatech
    @allaboutdatatech 3 месяца назад

    thanks for making this video, with a clear explanation of this topic!

  • @ucduyvo4552
    @ucduyvo4552 4 месяца назад

    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

    • @matthewkapfer6345
      @matthewkapfer6345 Месяц назад

      You need billing enabled so if you go above 1,000 calls/units it can bill you accordingly

  • @mahirkadic2683
    @mahirkadic2683 4 месяца назад

    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 🎉

  • @Data-guy-x8w
    @Data-guy-x8w 4 месяца назад

    Thanks for the video! Good results.

  • @DFS-r5s
    @DFS-r5s 4 месяца назад

    good video!

  • @iowa_hawk
    @iowa_hawk 4 месяца назад

    great video! clear explanation of AWS Textract. Thanks for posting this

  • @AI_Joyful_Discoveries
    @AI_Joyful_Discoveries 4 месяца назад

    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?

    • @TechExpertTutorials
      @TechExpertTutorials 4 месяца назад

      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.

  • @maryamarshad871
    @maryamarshad871 5 месяцев назад

    I feel difficult to install anaconda

  • @joaoarthurbandeira
    @joaoarthurbandeira 5 месяцев назад

    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!

    • @TechExpertTutorials
      @TechExpertTutorials 5 месяцев назад

      Thanks! I would suggest Azure, it has the best accuracy, and can even be improved upon if you include an OpenAI ChatGPT component.

  • @khadijarefouh
    @khadijarefouh 5 месяцев назад

    thanks a lot. what could be the accuracy for Arabic language?

    • @TechExpertTutorials
      @TechExpertTutorials 5 месяцев назад

      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

  • @joseantoniocarreraescobar5856
    @joseantoniocarreraescobar5856 6 месяцев назад

    Hi, amazing video, is it work with QR COdes?

    • @TechExpertTutorials
      @TechExpertTutorials 6 месяцев назад

      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.

  • @SameedBaig-vv5jn
    @SameedBaig-vv5jn 6 месяцев назад

    The github repo is no more available

    • @TechExpertTutorials
      @TechExpertTutorials 6 месяцев назад

      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

    • @catherinemontiel5083
      @catherinemontiel5083 4 месяца назад

      @@TechExpertTutorials

  • @TechExpertTutorials
    @TechExpertTutorials 7 месяцев назад

    Please click the like button, and subscribe to our channel. Thanks!

  • @TechExpertTutorials
    @TechExpertTutorials 7 месяцев назад

    Please click the like button and subscribe to our channel. Thank you!