Discover and read the best of Twitter Threads about #SQL

Most recents (21)

SQL INTERVIEW QUESTION CHEATSHEET.

SQL is the most popular database Query Language and many popular websites use it. So, here's a collection of the most asked SQL interview questions.

Please RT for reach and bookmark for easy recall.

🧵A Thread 🧵

#100DaysOfCode
1. What is Database?

A database is an organized collection of data, stored and retrieved digitally from a remote or local computer system. Databases can be vast and complex, and such databases are developed using fixed design and modeling approaches.

#100DaysOfCode
2. What is DBMS?

DBMS stands for Database Management System. DBMS is a system software responsible for the creation, retrieval, updating, and management of the database.

#100DaysOfCode
Read 24 tweets
How can I start a career in #risk management in the financial services industry?
@GARP_Risk @PRMIA @RIMSorg @actuarynews @SOActuaries @CQFInstitute @CFAinstitute
I believe they are many degrees that can be a good value for money, provided you know where you would like to work in the long run.
In the developing world markets, employers still don't appreciate highly technical education in risk, actuarial sciences, financial engineering, quantitative economics, machine learning, etc.

For them, an #MBA is a be-all and an end-all troubleshooter.
Read 22 tweets
Modern #data platforms are emerging as the answer to the holy grail: creating a truly data-driven organization. With this, “how” we use data has changed.

Many vendors today brand themselves as the be-all and end-all... but this isn’t true. 🙅
It’s impossible to work today with a single modern data platform from one vendor! A modern #data platform is a collection of tools and processes. 🧰

In this thread, I’ll break down what a modern data platform means in practice today. 2/n
Today, data platforms have basic building blocks that look something like this. 👇 3/n

towardsdatascience.com/the-building-b…
Read 9 tweets
SQL INTERVIEW QUESTION CHEATSHEET.

SQL is the most popular database and many popular websites use SQL. So, here is a collection of the most asked #SQL interview questions to help you prepare.

Please RT for reach and bookmark for easy recall.
🧵A Thread 🧵

#100DaysOfCode
1. What is Database?

A database is an organized collection of data, stored and retrieved digitally from a remote or local computer system. Databases can be vast and complex, and such databases are developed using fixed design and modeling approaches.
#100DaysOfCode
2. What is DBMS?
DBMS stands for Database Management System. DBMS is a system software responsible for the creation, retrieval, updating and management of the database.

#100DaysOfCode
Read 24 tweets
SQL INTERVIEW QUESTION CHEATSHEET

SQL(stands for Structured Query Language)is the popular query language to manage databases. So, here is a collection of the most asked SQL interview questions to help you prepare

Please Like & Retweet

🧵A Thread 🧵

#100DaysOfCode
#SQL #Coding
What is Database?

A database is an organized collection of data, stored and retrieved digitally from a remote or local computer system. Databases can be vast and complex, and such databases are developed using fixed design and modeling approaches.

#100DaysOfCode #SQL #Coding
What is DBMS?

DBMS stands for Database Management System. DBMS is a system software responsible for the creation, retrieval, updating, and management of the database.

#100DaysOfCode #SQL #Coding
Read 24 tweets
#PYTHON SENIOR DEV, USA Client
* USD Salary, 100% Remote job, fluent English.
* Participa TODO LATAM

CV a tuamigaflowers@gmail.com
Asunto: Senior PythonDev (#años experiencia) + EnglishLevel + Ciudad

Porfa, LK & RT #engineers #software #jobs #backenddeveloper #django #flask
SOBRE EL CLIENTE: Es de Houston Texas y una de las más grandes en EEUU. Ellos tienen un equipo de devs y diseñadores enfocados en experiencia de usuario en su stack. Buscan hacer crecer team y requieren un equipo de 4 SENIOR #PYTHON #DEVELOPERS
SOBRE EL STACK #TECH para #PYTHON Senior. (USD Salary, remote 100%):
Diseño de #APIs / asyncio en Python / #Flask y #django / #SQL (+ en Oracle) / #Swagger y #OpenAPI (plus) / git / Conocer la estructura de #microservices
Read 3 tweets
🧵 M E G A T H R E A D

Check out all of my amazing threads that cover various topics like #JavaScript, #React, my favourite podcasts and many more...

👇#100DaysOfCode #CodeNewbie
Thread #1: This is the place where you can find most of the amazing resources, tutorials, code snippets, tips and tricks about #JavaScript. Happy Coding Days 😎

👇#100DaysOfCode #CodeNewbie #React
Thread #2: This is the place where you can learn most of the thing about #React. Find out some of the best resources, tutorials, code snippets, tips and tricks to enhance your React skills.

👇#100DaysOfCode #CodeNewbie #JavaScript #ReactHooks
Read 21 tweets
SQL INTERVIEW QUESTION CHEATSHEET.

SQL is the most popular database and many popular websites use SQL. So, here is a collection of the most asked #SQL interview questions to help you prepare.

Please RT for reach and bookmark for easy recall.

🧵A Thread 🧵

#100DaysOfCode
1. What is Database?

A database is an organized collection of data, stored and retrieved digitally from a remote or local computer system. Databases can be vast and complex, and such databases are developed using fixed design and modeling approaches.

#100DaysOfCode
2. What is DBMS?

DBMS stands for Database Management System. DBMS is a system software responsible for the creation, retrieval, updating, and management of the database.

#100DaysOfCode
Read 25 tweets
Yesterday I had to work on a backfill script to update 24 Million records of payments. Yes, you read right, 24 million. The script ran for 3 hours and wasn´t even at half.

We found several ways to improve its performance today.
Summary below 👇

#SQL #Database
The first thing was to be able to check performance to make sure we were improving it. So, a sample size of 20k records updates instead of 24 million.

Original query took around 36 seconds. We ended up making this take only 6 seconds, and I think we can´t improve it more now.
1_ Removed an unnecessary join table. We were updating based on a list of descriptions values joined instead of using direct codes. Easier to read by humans, slower for computers. We are at 32 seconds now.
Read 7 tweets
I am always nervous before each and every podcast interview.

Not because I am afraid of working/ learning in public but because want to be respectful of my guest's time and create content that will give the podcast audience value.

Here are the 10 most popular podcast episodes!
In this episode, @geomenke gives a fantastic introduction to #QGIS

mapscaping.com/blogs/the-maps…
Read 12 tweets
SQL INTERVIEW QUESTION CHEATSHEET.

SQL is the most popular database and many popular websites use SQL. So, here is a collection of the most asked #SQL interview questions to help you prepare.

Please RT for reach and bookmark for easy recall.

🧵A Thread 🧵

#100DaysOfCode
1. What is Database?

A database is an organized collection of data, stored and retrieved digitally from a remote or local computer system. Databases can be vast and complex, and such databases are developed using fixed design and modeling approaches.

#100DaysOfCode #developers
2. What is DBMS?

DBMS stands for Database Management System. DBMS is a system software responsible for the creation, retrieval, updating and management of the database.

#100DaysOfCode #developers
Read 26 tweets
A thread: How I prepared for a #tech role in #FAANG
1. Technical preparation of #python and #SQL
2. Behavioral and cultural screen with @Latesha_Byrd
3. Deep dive on department domain and current tools and techniques
Technical preparation included practicing @LeetCode and @CodeSignalCom for #SQL and #python. I started to time myself and also spoke out loud what I was doing and why to get familiar with #whiteboarding etiquette. I also had my friends mock interview me.
I also utilized @TeamBatcode for more #python practice with primitive #datastructures and #Algorithms. It was consistent practice while talking out loud. I probably worked through about 50-60 problems.
Read 11 tweets
Habe mir den Datenbank-Code der Corona-Warn-App angeschaut. An den paar Zeilen kann man beispielhaft zeigen, was bei vielen Datenbank-Projekten nicht ganz optimal läuft. Ein Thread über Datenbank-Sicherheit, #SQL, die Corona-App und #PostgreSQL. #CoronaWarnApp #cwa 1/x
Kurzzusammenfassung: Die Datenbank-Berechtigungen sind viel zu weitgehend, ein erfolgreicher Angreifer könnte auf alle Daten zugreifen, löschen usw. Außerdem werden Datum und Zeit als Zahl gespeichert, unschön, denn es gibt einen TIMESTAMP-Datentyp! Und was ist mit der ID? 2/x
Bei den Berechtigungen könnte man einwenden: ein Angreifer darf nicht so weit kommen; aber das passiert leider immer wieder, und man kann sich mit einfachen Methoden schützen. Sieht auf den ersten Blick kompliziert aus, ist aber ganz simpel. Kommentare Willkommen! Also los: 3/x
Read 31 tweets
Segue o #fio de um #historiador sobre o curso Programação Web @metropoledigi @ufrnbr. Ideia dada por @brennovich no dia da #MarchaVirtualpelaCiencia @SBPCnet. Conversas com Brenno, @freireopaulo, @Guimme_ e outros sobre #programacao #Tecnologia #web #Historia #ensino #ti
04/05/2020: Começo da matéria Lógica de #Programação. De cara me lembrei dos livros de #HarukiMurakami que se passam nos anos 1980. Vários personagens aparecem japoneses aprendendo sobre #input e #output nos recém lançados editores de texto e computadores pessoais. #literatura
04/05/2020 Me lembrou conversa com @iberemoreno sobre editores de textos que funcionam com lógica de #programação. Aqueles em que ao invés de tentar reproduzir na tela o que você vê no papel, partem para a o que você "quis dizer" é que vai para o resultado final. 1/3
Read 71 tweets
Woooo! Another milestone reached!

Thanks all for joining me 😃

To celebrate, I'll post an (Oracle) #SQL tip for each retweet this gets (up to some limit)

Go!
NULL is neither equal to nor not equal to anything

So

select * from ... where anything = NULL

ALWAYS returns no rows
This can lead to other unexpected outcomes where NULLs are possible

For example:

WHERE c1 NOT IN ( ... )

Returns no rows if any values in the list are NULL

To avoid this, usually you want NOT EXISTS instead of NOT NULL
Read 38 tweets
Transitioning into #DataScience: A (long) thread—
Transitioning into a new field can be cumbersome, especially #datascience which usually requires some level of #math #statistics #machinelearning #programming. But fret not!
This thread will go over the fundamentals of what you should know to become a #datascientist. First thing first, there are hundreds of tools for visualization (Power BI, Tableau, Dash), cloud computing (GCP, AWS, Azure) and SQL variants (Postgres, MSSQL, MySQL).
Don’t get caught up trying to learn all of these tools/platforms/software! You will be onboarded to these technologies and they differ highly from company to company and sometimes even department to department. But, you should be familiar with what they do at a high level!
Read 20 tweets
Vamos a usar este tweet para publicar #Dorks de todo tipo, empecemos con este:

inurl:wp-config.php intext:DB_PASSWORD -stackoverflow -wpbeginner -foro -forum -topic -blog -about -docs -articles

#CyberSecurity #dork #BugBounty
intext:"pass" ! "usuario" | "user" | "contraseña" filetype:sql -github
Este es muy bueno, nos permite hacer uploads, ha sido probado con imágenes .jpeg

intitle:"FCKeditor - Uploaders Tests"
Read 63 tweets
TIL there's lots of ways of #seeding #fakedata into a #SQL #database. You can either

A. Seed it with purely random data all the way
B. Seed it with realistic data
C. Seed it initially with random data, but tie that data into other tables realistically
When you seed a database, you start off with enum (that's like a dictionary that doesn't change in size). If you look at a database schema, it's the tables that are only connected one time.

Then you focus on tables that have only have 1 foreign key tied, tied to an enum
Example with a basic HR database schema. Start seeding the outlier tables first, starting with the bottom-left most and bottom-right most tables, followed by bottom-middle.
Read 11 tweets
Bir yazılım geliştiricinin bilmesi gerekenlerle ilgili 15 maddelik flood geliyor.. Mümkün olduğunca fazla keywordü bir araya toplamaya çalıştım.
Hadi Başlıyoruz!

#Developer #Software #Java #code #kod #yazılım #development #computer #bilgisayar #tool #PC #IT #web #tech #data
1-Temel veri yapıları (linkedList, map, tree vb) ve temel algoritmalar (sıralama, arama vb)

Sıfırdan kodlama ihtiyacınız büyük ihtimalle hiç olmayacak. Ancak ihtiyaç anında doğru yerde doğrusunu seçebilmek için o veri yapısının veya algoritmanın nasıl çalıştığını bilmeniz şart
2- Network Temelleri

OSI Modelini ve 7 katmanı; temel protokolleri(#TCP-IP, TCP-UDP, #HTTP, #FTP), güvenlik protokollerini(#HTTPS, #SFTP, #SSL), monitoring protokolleri(#SNMP, ICMP) bilmekte fayda var. Ayrıca ağ ekipmanlarının görevlerini tanımak ve 7Layer yerlerini bilmek lazım
Read 16 tweets
I’ve had a lovely few days of doing NOTHING work related! I hope you have had some relaxation too.

BUT I do want to tell you about the “full stack” requirements of this AWESOME job that you should apply for to work with me & @AutisticaUK at @turinginst!

turing.ac.uk/work-turing/re…
Here are some screen grabs from the job ad that talk about what you need.... the essential requirements.
I was nervous writing this ad. It’s asking for A LOT to have someone join an academic project for a salary of between £34,000 and £40,000 if they can do ALL the #FullStack development! There are lots of jobs that would pay you a lot more!!
Read 9 tweets
Não deu pra ir no #codabr18? Foi, mas queria mesmo era se clonar pra ver as muitas atividades simultâneas? A gente reuniu quase 40 apresentações e recursos didáticos usados nas mesas, bootcamps e workshops! Conhecimento bom é conhecimento aberto! #ddj escoladedados.org/2018/11/21/apr…
Vamos revisitar aos poucos as apresentações do #CodaBr18 :

Na abertura, o @albertocairo abordou a democratização da visualização de dados, falando de sua busca para que esta prática se torne uma linguagem universal 🌐

drive.google.com/file/d/1PrDaDB…
@viegasf falou de suas pesquisas sobre inteligência artificial, #dataviz e inovação no Google. Aqui, você confere a oficina que ela deu sobre Interpretação e Fairness em Machine Learning

bit.ly/mlfairness-coda
Read 37 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!