Tomek in Tech
Tomek in Tech
  • 55
  • 71 071
10 Most COMMON SQL Interview Questions and Answers for Beginners | ACE Your SQL Interview
In this video I show you 10 most common SQL interview questions for beginners and best answers for them. This video is applicable to many different DBMS like Oracle SQL or PostgreSQL.
Video about indexes ua-cam.com/video/ndOqBZxwV1M/v-deo.html
Video about join algorithms ua-cam.com/video/ZXnD3Mzy_TM/v-deo.html
#sqlqueryinterviewquestionsandanswers
#sqlinterview
#sql
Переглядів: 145

Відео

Create a Machine Learning Web App from Scratch - Python Streamlit Step-by-Step Tutorial
Переглядів 2112 місяці тому
In this video I show you how to create a Python Streamlit Machine Learning AI Model Explorer WebApp website in under 1 hour step-by-step from scratch, no previous knowledge required. We will deploy our Web Application to Streamlit Cloud so that you can post a link to it in your CV. This is a great addition to your Data Science, Machine Learning and Data Engineering CV. Deploy Streamlit App Step...
Configure HTTPS For Your Linux Server - React Websockets Docker NGINX Let's Encrypt Linux
Переглядів 2073 місяці тому
In this video I show you how to enable HTTPS (SSL) for your server for React, Websockets with NGINX and Certbot image by Let's Encrypt. Everything is deployed with Docker and Docker Compose. We also schedule a renewal using Cron. It is all done using Ubuntu Linux. It also contains NodeJs ExpressAPI as a backend and Postgres database. Video with server setup ua-cam.com/video/GyR5Q46s7Jc/v-deo.ht...
Custom Domain Setup: The Ultimate Step-By-Step Guide
Переглядів 563 місяці тому
In this comprehensive guide, Iwill walk you through the essential steps for custom domain setup, ensuring you have all the tools and knowledge needed to successfully manage your domain.
Configure a Linux Virtual Machine (VM) - Basic Setup Step-By-Step
Переглядів 2273 місяці тому
In this video I'll show you what are the first steps you should do after setting up a Linux Virtual Machine (VM). The commands 1. Set the hostname a. Hostnamectl set-hostname (hostname) b. Nano /etc/hosts c. Add (ip_address) and (hostname) 2. Create new user a. Adduser (username) i. Add user to sudo group b. Adduser (username) sudo 3. Relogin a. Exit b. Ssh (username)@(ip_address) 4. Set-up ssh...
How To Become a Software Engineer From Nothing - Start Earning Money In Months
Переглядів 723 місяці тому
In this video I explain what is in my opinion the best way to become a software engineer starting from zero. Simple project tutorials: To Do App ua-cam.com/video/gIbX5oEzZk0/v-deo.html Chat App ua-cam.com/video/c4_Sh8GzBks/v-deo.html Complex Backend project ua-cam.com/video/rjaEcVMFYj8/v-deo.html
Deploy Python Web App For Free! - Streamlit deployment guide step-by-step
Переглядів 2873 місяці тому
In this video I'll show you how to deploy a Python Streamlit Web app completely for free. Code for this video github.com/TomekQ13/streamlit-computer-vision Git clone (url) this repository to follow along! Replace (url) with the same link I'm copying in the video for Streamlit. Video where we created the Computer Vision App ua-cam.com/video/ra2OXS_AyjM/v-deo.html 00:00 Intro 00:40 Github setup 0...
3 Project To Include In Your Data Science CV
Переглядів 1344 місяці тому
Data Science Interviews can be intimidating due to a wide range of topics you can be asked about. There is no single way to ensure your success, however, having good quality projects certainly improves your chances. Learn what projects to make and include your CV in this video!
Everything You Need To Know About Database Partitions In 20mins
Переглядів 5094 місяці тому
In this video I'll tell you everything you need to know about database partitions and database partitioning process. These exist in major DBMS like Oracle partitions, PostgreSQL partitions, mySQL, MS SQL and DB2. The video explains how to create database partitions, how to manage database partitions and how to delete and drop database partitions. Table partitions are key to good database optimi...
Complete Step-by-step Guide To Database Indexes
Переглядів 1 тис.4 місяці тому
In this video I'll tell you everything you need to know about database indexes to be able to comfortably work with them as a developer. Index basics video ua-cam.com/video/lgAGGdttCOg/v-deo.html Join algorithms video ua-cam.com/video/ZXnD3Mzy_TM/v-deo.html SQL script to create the data model raw.githubusercontent.com/TomekQ13/NaturalLanguageToSQLVideo/main/database.sql?token=GHSAT0AAAAAACVVTGAT...
Deploy a Python App with Docker on Azure Cloud - Container Apps
Переглядів 1 тис.4 місяці тому
In this video I'll show you how to deploy a Python WebApp with Docker to Azure Cloud Container Apps Service. Github with the App github.com/TomekQ13/StreamlitAIVisionVideo
Create AI Computer Vision App in Python with Azure Cloud and Streamlit
Переглядів 1765 місяців тому
00:00 Intro 00:50 Setup 05:20 Azure Cloud Service 07:09 Azure SDK In this video I show you how to create an AI Computer Vision App in less than 30 mins. This is great to practice your cloud and AI skills and a good base to start of a great project for your resume. How to create a free Azure Cloud account ua-cam.com/video/rZHqynCOZsA/v-deo.html
GenAI App - Natural Language to SQL - Azure Open AI & Python Streamlit
Переглядів 3665 місяців тому
00:00 Environment setup 05:05 Database setup 12:41 Azure Open AI setup 18:24 Connection to Azure Open AI using the SDK 50:14 Logging In this video I'll show you how to create a GenAI based App in less than 1 hour that allows you to ask questions in natural language and get an answer from a database based on an SQL query generated by GenAI model. The app is based on Azure Open AI services. How t...
Azure Cloud - Create a free Azure Cloud account
Переглядів 1135 місяців тому
In this video you learn how to create a free Azure Cloud account. Keep in mind that depending on what you do you can still incurr some costs but if you stick to the basics and only learning purpose you will be able to use it for free. Starting page azure.microsoft.com/en-us/free
Isolation Levels in a DBMS - Step-By-Step Guide - Advanced SQL
Переглядів 1,9 тис.2 роки тому
In this video we will discuss isolation levels in a database management system. This is the basic concept that allows multiple users to access and modify data in the same database, schema or table and still keep a consistent view of it. Transaction video ua-cam.com/video/29NgA2QsTgs/v-deo.html ISO/ANSI SQL 92 Standard en.wikipedia.org/wiki/Isolation_(database_systems) PostgreSQL docs www.postgr...
Learn To Use Explain Plans in 20 minutes and Understand Your Queries - Advanced SQL
Переглядів 15 тис.2 роки тому
Learn To Use Explain Plans in 20 minutes and Understand Your Queries - Advanced SQL
Database Join Algorithms Explained Step-By-Step - Advanced SQL
Переглядів 2,5 тис.2 роки тому
Database Join Algorithms Explained Step-By-Step - Advanced SQL
Swagger for NodeJs Express REST API - Document your API like a professional
Переглядів 9 тис.2 роки тому
Swagger for NodeJs Express REST API - Document your API like a professional
SQL For Data Analysts And Data Scientists - Episode 12 - Window functions
Переглядів 1422 роки тому
SQL For Data Analysts And Data Scientists - Episode 12 - Window functions
Step-by-step guide to database indexes - Advanced SQL
Переглядів 1,4 тис.2 роки тому
Step-by-step guide to database indexes - Advanced SQL
Custom Error Handling in REST Express API with Sending Emails
Переглядів 1,4 тис.2 роки тому
Custom Error Handling in REST Express API with Sending Emails
3 Tips to improve SQL query performance - SQL for Data Analysts and Data Scientists Episode 11
Переглядів 1802 роки тому
3 Tips to improve SQL query performance - SQL for Data Analysts and Data Scientists Episode 11
Logging in Express and NodeJs - Winston library introduction
Переглядів 30 тис.2 роки тому
Logging in Express and NodeJs - Winston library introduction
Do not use console.log - Logging for an Express REST API with Winston
Переглядів 2 тис.2 роки тому
Do not use console.log - Logging for an Express REST API with Winston
Build a REST API step by step - Create Read Update Delete with Express, PostgreSQL and Docker
Переглядів 1,7 тис.2 роки тому
Build a REST API step by step - Create Read Update Delete with Express, PostgreSQL and Docker
SQL For Data Analysts And Data Scientists - Episode 10 - Database transaction and DML
Переглядів 922 роки тому
SQL For Data Analysts And Data Scientists - Episode 10 - Database transaction and DML
SQL For Data Analysts And Data Scientists - Episode 9 - Functions
Переглядів 702 роки тому
SQL For Data Analysts And Data Scientists - Episode 9 - Functions
SQL For Data Analysts And Data Scientists - Episode 8 - Views and Materialized Views
Переглядів 392 роки тому
SQL For Data Analysts And Data Scientists - Episode 8 - Views and Materialized Views
SQL For Data Analysts And Data Scientists - Episode 7 - DDL - Create and modify tables and columns
Переглядів 352 роки тому
SQL For Data Analysts And Data Scientists - Episode 7 - DDL - Create and modify tables and columns
SQL For Data Analysts And Data Scientists - Episode 6 - Case When
Переглядів 382 роки тому
SQL For Data Analysts And Data Scientists - Episode 6 - Case When

КОМЕНТАРІ

  • @ChillFocus-j8y
    @ChillFocus-j8y 13 днів тому

    Hi, would you consider to show how to setup the continuous deployment in azure container app with github action? thanks =)

  • @ChillFocus-j8y
    @ChillFocus-j8y 15 днів тому

    I followed your instruction and replicated the same. However, after I upload the image in the browser and click the Analyse Image button, I got this error: "There was an error when analysing the image (InvalidRequest) The feature 'Caption' is not supported in this region. Code: InvalidRequest Message: The feature 'Caption' is not supported in this region." I tried to create a new azure computer vision with region in North Europe, I still get the same error. Did I miss anything? Thanks.

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

    Thank you for your great video brother. Hats off for your time and efforts. really appreciate. I simulate the load_dotenv() using 'python-dotenv' instead of 'pipenv' and it worked. Best wishes for all of your future endeavors..

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

    Thanks, this was very useful and applicable to my current task. I also learned something about Vs Code and how to use the Rest Client.

  • @Abdallah-r9w
    @Abdallah-r9w Місяць тому

    can you explain to us when we put a unique constraint on a column what happened under the hood? thank.

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

    cross join, self-join are also types of join

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

    Thank you! the link in the repo is not working

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

    Thank you!! I don't think the link to the repo is working.

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

    good thanks

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

    Indian Jio 4G SNI Host give me 😢

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

      Don't know it but the concepts are surely the same so the A records and DNS

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

    "If you by some miracle do not have a github account" Really? 😂😂😂

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

    How to deploy

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

      Here completely for free with Streamlit ua-cam.com/video/YAAy0Qvf9BU/v-deo.html Here for free with Azure but you need a credit/debit card ua-cam.com/video/2q_EA98kDGg/v-deo.html If you can I recommend the Azure option to get yourself into the Cloud environment.

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

      @@tomekintech5748 I have tried with free tier but not working, basic paid monthly version is working fine👍

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

    It craps ! All you do is demotaving people to get some views

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

    I tried to replicate the same but as soon as I click on Analyse Image button - it did nothing - Is there is anything I am missing ?

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

      Are you getting any errors in the log? Try referencing the code here github.com/TomekQ13/StreamlitAIVisionVideo/blob/main/app/app.py

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

      @@tomekintech5748 thanks for sharing. I'm not getting any error, its just doing nothing on click. Also can you share requirements.txt to make sure I'm good.

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

    10:00 How do I find that 7 though? 7 is larger than 3 so I go right, 7 is larger than 5 so I go right again and 7 is larger than 6 but there is no leaf node, therefore row is not found I think the adding is done the same way we search, so it would be added to right of node 6 and then rebalanced if needed And probably that rebalancing is what takes most time? So if you're lucky the insert is fast but in some cases it is a bit slower?

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

      You are right. The example is a bit off!

  • @MidhileshPattapu
    @MidhileshPattapu 5 місяців тому

    What to do for a student not having any bank card.? And edu mail also

    • @tomekintech5748
      @tomekintech5748 5 місяців тому

      Unfortunately I do not know a good option in such case

  • @Shasa.t
    @Shasa.t 6 місяців тому

    thanks man, saved my job today

  • @abirkolin4702
    @abirkolin4702 8 місяців тому

    thanks a lot !!!!!! it helped me a lot

  • @feugos
    @feugos 8 місяців тому

    Hi! Is it possible concatenate some custom log messages in the end of main log for each route?

  • @Rep-L4Y
    @Rep-L4Y 8 місяців тому

    ❤❤

  • @Rep-L4Y
    @Rep-L4Y 8 місяців тому

    Gracias por todos estos Amazing vídeos

  • @edvzig
    @edvzig 9 місяців тому

    You say "basically" too much. Love

  • @govindreddybusireddy7763
    @govindreddybusireddy7763 9 місяців тому

    Good explanation

  • @VanshShah-g5r
    @VanshShah-g5r 9 місяців тому

    Useful

  • @mohan1958
    @mohan1958 10 місяців тому

    Mar 14 7:09

  • @thiruardura
    @thiruardura 10 місяців тому

    good explanation.👏

  • @skyzane2735
    @skyzane2735 10 місяців тому

    is that rest extension secure and safe? I’m afraid that they might read the date we’ve been sending, or is it only used for testing?

  • @ahndeux
    @ahndeux Рік тому

    I'll stick with the good old "console.log" function. Interesting, but just too much crap to log.

    • @clementadjei4396
      @clementadjei4396 Рік тому

      these are necessary for when the application is deployed

    • @ahndeux
      @ahndeux Рік тому

      @@clementadjei4396 True, but for smaller projects, its not needed. Now you need another system to manage the log files. It's not even human readable without the ability to parse these log files.

    • @michaelcaxias
      @michaelcaxias 7 місяців тому

      @@ahndeux Yeah, of course, this is more useful when using Kibana or other logging UI

  • @ashlok2003
    @ashlok2003 Рік тому

    Thanks buddy for such nice explanation ❤

  • @sangithabodi
    @sangithabodi Рік тому

    Perfect video for indexes

  • @KelderPassos
    @KelderPassos Рік тому

    It was very useful for me. Thanks for your job.

  • @kyzym1
    @kyzym1 Рік тому

    Thanks, you are difinetely good as a teacher.

  • @amilasilva7
    @amilasilva7 Рік тому

    Great video

  • @BalvinderSingh-uh3my
    @BalvinderSingh-uh3my Рік тому

    Excellent be stuck on that for ages.

  • @mayurpatil2833
    @mayurpatil2833 Рік тому

    Thank you very much i can't explain how much you have helped me😊 @ 21:58

  • @alexandercarruth1954
    @alexandercarruth1954 Рік тому

    Thanks man this was the best video I found on UA-cam for production level logging, keep up the good work!

  • @arupde6320
    @arupde6320 Рік тому

    be regular

  • @ricardojoaoantonio4706
    @ricardojoaoantonio4706 Рік тому

    valeu mano, Obrigado pela ajuda

  • @KESHAVSHARMA-up7sk
    @KESHAVSHARMA-up7sk Рік тому

    a.get(...).keySeq is not a function at Ct.render i am getting this error

  • @fxstreamer238
    @fxstreamer238 Рік тому

    dude you wasted my time bu your home made MyFormat. you need to combine this=> format.errors({ stack: true }) instead of all that. no need for express-winston

  • @kataii
    @kataii Рік тому

    Quite useful, straightforward forward and very practical video for logging, Thanks

  • @soudaminipanda
    @soudaminipanda 2 роки тому

    why not use the Prisma ORM?

    • @tomekintech5748
      @tomekintech5748 2 роки тому

      Because the goal is to understand what is going on and what is needed for such api to work, introducing additional layer of abstraction on top does not help with that.

  • @sexyrican20m
    @sexyrican20m 2 роки тому

    Great Info. Thank you....... but in the future slow it down just a notch....... had me dizzy towards the end.

  • @Andrew-yr4dr
    @Andrew-yr4dr 2 роки тому

    Thank you, great video Is there some checklist or something, which can help to choose the proper isolation level for the concrete DB and business case? How is a decision made?

    • @tomekintech5748
      @tomekintech5748 2 роки тому

      Hi Andrew! Thanks for the comment. I'm not aware of such a list. Maybe that's an idea for the future. I'd usually stay with Read committed or Repeatable Reads unless you have a good case for a different one.

  • @antapedja
    @antapedja 2 роки тому

    Great explanation, thank you

  • @bigmegas
    @bigmegas 2 роки тому

    idk why, but at 1:29:15, i do not get any error, the only major different for my code is for volumes in app in docker-compose.test.yml i wrote ./ddl:/ddl (with colon) instead of what you wrote at 1:17:46 (without the colon > ./ddl/ddl), why is it different? is it supposed to be error at 1:29:15 edit : later on at 1:33:00, you fix that (./ddl:/ddl) , but still, in my previous comment, i do not get the initial error, so i dont know if i should make setup-db.js like you handle it

  • @vivienhounsounou1867
    @vivienhounsounou1867 2 роки тому

    you really left vscode editor font size at 12 to record a video in broad 2022? Are you being serious?

  • @hasanmougharbel8030
    @hasanmougharbel8030 2 роки тому

    Hey there, glad to meet again. I am working my way around sql language and still have one major enquiry. Is there a command to test an SQL query without executing it? I wish that i would play with my code and to return results without altering my physical data in the server. Thanks a lot for taking care of this.

    • @tomekintech5748
      @tomekintech5748 2 роки тому

      Yes, you can start a transaction, most likely by executing BEGIN; and then do a rollback. See here ua-cam.com/video/29NgA2QsTgs/v-deo.html

  • @retardoquasti7925
    @retardoquasti7925 2 роки тому

    I was here just to see the Error Handling process but noticed i have to refactor my whole mail sending process. Thanks for the additional work :) Great Video btw.

  • @retardoquasti7925
    @retardoquasti7925 2 роки тому

    00:00 - 2:25: Why to use Winston 2:25 - 7:30: Setup Winston 7:30 - 9:40: Format Outputs 9:40 - 13:30: Warning and Error Logging, Logging to File 13:30 - 18:00: Logging to MongoDB 18:00 - 22:50: Logging internal Application Errors 22:50 - 25:35: Custom format Outputs 25:35 - 30:36: Custom Log-Messages for different Levels 30:36 - 31:42: End Very good work :) Thanks

    • @tomekintech5748
      @tomekintech5748 2 роки тому

      Thanks!

    • @Krono159
      @Krono159 Рік тому

      @@tomekintech5748 how do i export to a file w/o using express? i'm trying to implement winston on a discord bot but i can't get it to work