- 55
- 71 071
Tomek in Tech
Приєднався 10 тра 2014
I share my passion for coding with you creating tutorials for different areas of the profession
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
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
Hi, would you consider to show how to setup the continuous deployment in azure container app with github action? thanks =)
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.
The issue has been resolved
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..
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.
can you explain to us when we put a unique constraint on a column what happened under the hood? thank.
cross join, self-join are also types of join
Thank you! the link in the repo is not working
Thanks! Should work now
Thank you!! I don't think the link to the repo is working.
Thanks! Should work now
good thanks
Indian Jio 4G SNI Host give me 😢
Don't know it but the concepts are surely the same so the A records and DNS
"If you by some miracle do not have a github account" Really? 😂😂😂
How to deploy
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.
@@tomekintech5748 I have tried with free tier but not working, basic paid monthly version is working fine👍
It craps ! All you do is demotaving people to get some views
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 ?
Are you getting any errors in the log? Try referencing the code here github.com/TomekQ13/StreamlitAIVisionVideo/blob/main/app/app.py
@@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.
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?
You are right. The example is a bit off!
What to do for a student not having any bank card.? And edu mail also
Unfortunately I do not know a good option in such case
thanks man, saved my job today
thanks a lot !!!!!! it helped me a lot
Hi! Is it possible concatenate some custom log messages in the end of main log for each route?
❤❤
Gracias por todos estos Amazing vídeos
You say "basically" too much. Love
Good explanation
Useful
Mar 14 7:09
good explanation.👏
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?
I'll stick with the good old "console.log" function. Interesting, but just too much crap to log.
these are necessary for when the application is deployed
@@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.
@@ahndeux Yeah, of course, this is more useful when using Kibana or other logging UI
Thanks buddy for such nice explanation ❤
Perfect video for indexes
It was very useful for me. Thanks for your job.
Thanks, you are difinetely good as a teacher.
Great video
Excellent be stuck on that for ages.
Thank you very much i can't explain how much you have helped me😊 @ 21:58
Thanks man this was the best video I found on UA-cam for production level logging, keep up the good work!
be regular
valeu mano, Obrigado pela ajuda
a.get(...).keySeq is not a function at Ct.render i am getting this error
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
Quite useful, straightforward forward and very practical video for logging, Thanks
why not use the Prisma ORM?
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.
Great Info. Thank you....... but in the future slow it down just a notch....... had me dizzy towards the end.
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?
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.
Great explanation, thank you
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
you really left vscode editor font size at 12 to record a video in broad 2022? Are you being serious?
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.
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
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.
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
Thanks!
@@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