Discover and read the best of Twitter Threads about #SQL

Most recents (24)

Our decoded data makes it easy for anyone to run #Ethereum queries. In this guide we show you how to use the #EthereumDataWarehouse to run simple #data queries about mints and secondary market transactions for an #NFT

tokenflow.live/blog/user-guide
Using just basic #SQL we show you how to see the mints for an #NFT over time using @thekissprecise as an example: Image
And we also look at how to aggregate secondary market transactions across @opensea and @LooksRare marketplaces: Image
Read 3 tweets
1⃣ Today, I'll continue with Chapter II. This chapter focuses on data types and creating / populating data.

Since I was aware of the data types, I try to summarize the chapter. For who are new to #SQL should read in detail.

For statistics related treads, see @levikul09.
2⃣ #MySQL Datatypes
1. Character data:
☑️ Fixed-length : right-pinned with spaces
☑️ Variable length : not padded, space consumption varies
i.e : char(20) - fixed ; varchar(20) variable length examples.
3⃣ Character Sets are used for different languages with different letters
Returns a table with different char sets. If maxlen bigger than 1, the chars in that language are bigger than 1 bytes. Image
Read 10 tweets
Most useful websites/blogs/Youtube Channels for learning SQL and Oracle Database.🧵👇

#SQL #Oracle #Database @connor_mc_d @SQLMaria @ChrisRSaxon
1. devgym.oracle.com/pls/apex/f?p=1…::

This is my favourite. It contains tutorials on SQL, PLSQL, a lot of quizzes and practice material from beginner to advance levels.
2. blogs.oracle.com

This is the encyclopedia of Oracle.

blogs.oracle.com/connect/catego…
and
blogs.oracle.com/connect/catego…

These are a series of articles written by Melanie Caffrey covering A to Z of SQL and Oracle database
Read 7 tweets
💻¿Dónde y cómo subir tu NIVEL de programación?

🚀 Te enseño como y lo mejor de forma GRATUITA

Super Hilo 👇🧵
Primero debes tener en cuenta
¿Qué quieres mejorar y por qué? 💻

Aqui te dejo lo necesario sea cual sea tu respuesta 👇
📌Estas empezando con HTML y CSS y quieres retos básicos de maquetado para practicar?

Frontedmentor es la mejor opción por su variedad de challenges y de distinta dificultad 👨‍💻

frontendmentor.io/challenges
Read 14 tweets
Google has released Imagen: a text-to-image diffusion model with an unprecedented degree of photorealism and a deep level of language understanding

#Python3 #MachineLearning #DataScience #100DaysOfCode #DataScience #DataAnalytics #100DaysOfMLCode #DataScientist #Statistics Image
Imagen builds on the power of large transformer language models in understanding text and hinges on the strength of diffusion models in high-fidelity image generation.

#Python3 #MachineLearning #DataScience #100DaysOfCode #DataScience #DataAnalytics #100DaysOfMLCode
This generator is scarily accurate with super-resolution! "A photo of a raccoon wearing an astronaut helmet, looking out of the window at night."

#Python3 #MachineLearning #DataScience #100DaysOfCode #DataScience #DataAnalytics #100DaysOfMLCode #DataScientist #Statistics Image
Read 4 tweets
#SQL from #R is insane. Here’s why. 1/6

Image Credit: @yutannihilat_en

#rstats
2/6 Thanks to Hiroaki Yutani for putting this amazing example together.

This small example demonstrates how you can learn R and automatically use SQL.
3/6 Under the hood, the dbplyr library converts R’s tidyverse syntax to SQL

So we don’t need to memorize the SQL translation.
Read 6 tweets
Without effective testing, there's no way to know if your database has been migrated correctly. There are many things you need to verify.

🧵1/10

#databases #databasemigration #dataengineering #sql #googlecloud
1. Was the database schema migrated correctly?
2. Has all the data been migrated?
3. How about user logins?
4. Can all of the users still connect and can users only access the data they're permitted to access?

🧵2/10

#databases #databasemigration #dataengineering #sql
There are basically three categories of testing that needs to be considered; structural, functional and non-functional.

🧵3/10

#databases #databasemigration #dataengineering #sql #googlecloud
Read 11 tweets
#DataScientist in a software dev team and #pythonprogramming code for production pipelines? You should think carefully about scalability and integration. One of the things to consider is datatypes, here are some helpful tips 🧵
#Python is a dynamically typed language, but that doesn't mean you shouldn't care about types. Know you dtypes, from "str" to "bool" to "int8" to "float64", and understand their memory footprint and restrictions. Especially when working with larger objects, choose wisely.
Loose the strings. 9/10 times strings can be replaced by categoricals (Pandas) or even better by Enums (docs.python.org/3/library/enum…). This can reduce memory footprint of large dataframes with >30%, and improves performance.
Read 8 tweets
What is PostgreSQL?

PostgreSQL (aka Postgres) is one of the most popular relational database-backed by more than 30 years of open source development.

(1/10)
#Database #dbms #SQL #PostgreSQL
For history lovers, Postgres was started in 1986. The initial name Postgres was later changed to PostgreSQL to reflect the clear support for SQL in 1996.

(2/10)
PostgreSQL supports a number of features, data types, ability to write functions in different languages, a robust RBAC and support for JSON data storage for NoSQL like ability.

(3/10)
Read 10 tweets
Is Infrastructure as SQL (IaSQL) a thing? 🤔

🧵1

#dataengineering #sql #IaSQL #cloud
𝗛𝗼𝘄 𝗜𝗮𝗦𝗤𝗟 𝘄𝗼𝗿𝗸𝘀

IaSQL is an open-source SaaS that models cloud infrastructure as data by maintaining a 2-way connection between a AWS account and a hosted PostgreSQL database. ☁

🧵2
𝗪𝗵𝘆 𝗜𝗮𝗦𝗤𝗟?

👉 𝘐𝘮𝘱𝘰𝘳𝘵 𝘦𝘹𝘪𝘴𝘵𝘪𝘯𝘨 𝘤𝘭𝘰𝘶𝘥 𝘪𝘯𝘧𝘳𝘢𝘴𝘵𝘳𝘶𝘤𝘵𝘶𝘳𝘦

Connect an AWS account to a hosted IaSQL DB to automatically backfill the database with your existing cloud resources. No need to redefine or reconcile existing infrastructure.

🧵3
Read 6 tweets
I realized today one of the reasons I appreciate working for a system integrator. Last time this year I was training in #Scala and #Spark. Then, I was placed in a project using #python, #pandas, #pyspark and #sql. That ended 12/31/21 and I had a short break before joining...
a pilot project working with #terraform, #aws, #boto3 with #python, #informatica, #autosys and #shellScripting. Not to mention the increasing frequency of situations that are like "Here is some technology setup that you have never seen before, here is some rudimentary docs,...
Figure it out in 1 or 2 sprints, provide deliverable artifacts and documentation on the preexisting system AND the new artifacts. Thx, k. Bai!" Oh, and teammates you joined with, they all have a shit-ton of stuff, so don't expect replies to your msgs.

Cue: 1. panic, then...
Read 6 tweets
#NoCode #buildinpublic

Many people think that free #OpenSource software is only for #Linux.

But I use a lot of #FOSS software on my @Microsoft #Windows desktop that I'd be lost without!

These are some of my faves!

25+ FOSS Tools to Improve Your Windows Experience 🧵 👇
7-Zip (@7zip)

Great archiver supporting

Packing/unpacking:
7z
XZ
BZIP2
GZIP
TAR
ZIP
WIM

Unpacking only:
AR
ARJ
CAB
CHM
CPIO
CramFS
DMG
EXT
FAT
GPT
HFS
IHEX
ISO
LZH
LZMA
MBR
MSI
NSIS
NTFS
QCOW2
RAR
RPM
SquashFS
UDF
UEFI
VDI
VHD
VHDX
VMDK
WIM
XAR
Z

7-zip.org
Audacity (@getaudacity)

If you need to perform some audio editing, Audacity is a huge help. I often use it when fixing audio for a video or converting a recording for use in a phone system menu.

Tons of features & useful tools!

audacityteam.org
Read 28 tweets
Continuing the #learningpath series.
Next skill in #DataScience industry is SQL (One of the most In-Demand Skills )
⭐There are 1,000,000+ jobs available in USA with requirement of SQL as a skill

Step by step learning SQL for data scientists

A thread🧵
#data #datascience #sql Image
1. SQL Basics
⭐ Creating Tables
⭐ Inserting values
⭐ Adding a New column in the existing Table
⭐ Deleting a Column from a Table
⭐ Deleting the Table
2. SQL start with Commands
⭐ Learn basic SQL commands: SELECT, FROM and WHERE
⭐ Learn logical operators in SQL
⭐ Learn commands: IN , AND, OR, NOT, LIKE, NULL, ISNULL, BETWEEN
Read 11 tweets
One of the biggest misconceptions about #Hibernate is that it causes performance problems. But that’s not the case. Many successful projects use it to implement a highly scalable persistence layer.
Here are 8 recommendations for a fast persistence layer
1. Activate statistics to find problems as early as possible

Set the property 𝘩𝘪𝘣𝘦𝘳𝘯𝘢𝘵𝘦.𝘨𝘦𝘯𝘦𝘳𝘢𝘵𝘦_𝘴𝘵𝘢𝘵𝘪𝘴𝘵𝘪𝘤𝘴 to 𝘵𝘳𝘶𝘦 to activate #Hibernate's statistics and get a summary of all performed operations
2. Improve slow queries

You will find slow queries. They are not a Hibernate issue. They occur with every framework, even plain #SQL over JDBC. That’s why your database provides tools to analyze SQL statements.
Optimize your query and execute it as a native statement.
Read 10 tweets
such a good blog post from @nocentino ...
~~
Understanding #SQL Server IO Size
2021 December 10
nocentino.com/posts/2021-12-…
i'll nitpick two details, though :-)
the 512k upper bound for disk IO size isn't properly a #sqlserver limit, although it *is* the limit on most systems. it's the upper bound of the disk adapter.
some disk adapters - most fibre channel HBAs and some others, too - allow configuration of the maximum disk transfer size, and can be set higher than 512kb.
Read 23 tweets
10 SQL Concepts every developer should learn
1. JOIN
2. GROUP BY
3. Window Function
4. Correlated subquery
5. Indexing
6. WHERE vs HAVING
7. UNION
8. Table Alias
9. Temp table
10. Functions

what would you add more into this list?

#SQL #Programming
And, if you need resource to learn these concepts well, I have shared some excellent SQL books here
java67.com/2016/09/sql-5-…
And, if you like courses, I have shared, both free and paid SQL courses for both beginners and intermediate devs
javarevisited.blogspot.com/2018/05/top-5-…
Read 9 tweets
#Serverless enthusiasts were lucky this month. November had lots of interesting meetup videos regarding the serverless framework. Check out the most watched videos below.

blog.meetupfeed.io/serverless-nov…
Get familiar with fan-out, queuing, decoupling and many many more! @julian_wood strives to help developers learn how they can use serverless technologies in order to transform the way they build and run applications.
@ServerlessParis

meetupfeed.io/talk/advanced-…
Wondering how you can create highly scalable, loosely coupled systems? Check out Event-driven architectures using Amazon’s EventBridge. Explore different options of testing with @serverlesssarah @ServerlessParis @theodo

meetupfeed.io/talk/integrati…
Read 6 tweets
Looking for the best #Career related videos in November? Look no further, we have already selected them for you!🥳

blog.meetupfeed.io/it-career-meet…

#programming #tech
🔥First up: Dive into matters with @HelenJoScott , who tells you all the things you need to know besides how to write code well. Find out how you can be an extraordinary #developer wanted by many headhunters.

meetupfeed.io/talk/tech-talk…

@WomenWhoCode
Jump into #accessibility and let @RobPreciousA11Y elaborate on the triggers that start accessibility work at a company. @Techyrey continues by making it easier for you to stand out.🔝
meetupfeed.io/talk/an-introd…

@manc_web
Read 7 tweets
1/10
Applications of computer programming languages

#programming #SSOT #Python #Java #javascript

THREAD
👇👇👇👇
2/10
#Python
Web and Internet Development,Scientific and Numeric applications, Desktop GUIs, Business applications. It is widely used in AI and Machine Learning space.
3/10
#Java
Mostly used for developing Android apps, web apps, and Big data
Read 12 tweets
Top 10 SQL Interview Questions for Programmers

A mini thread🧵

#SQL #Programming
10 Popular SQL Queries from Interviews
java67.com/2013/04/10-fre…
50+ SQL Server Questions for telephonic interviews
java67.com/2019/08/micros…
Read 18 tweets
#SQL vs. #Cypher for hierarchies

Recursive common-table expressions (SQL)

vs.

built-in path variables in #graph ImageImageImage
This only shows part of the picture; with recursive CTEs in #SQL I believe it is the case that:

- You can constrain max recursion, but not minimum without writing extra code

Contrast to cypher:

MATCH (e:Employee)-[:REPORTS_TO*3..5]->(:Employee)
recursive CTEs are a good example of "implementing a graph abstraction on top of something else". Namely the employee table represents a bunch of node instances; the managerID is a relationship, and the CTE implements a graph traversal.
Read 5 tweets
SQL dumps (database dumps) for #OSINT

Super short practical course.

Thread🧵🧵🧵

(12 tweets)

#sql #mysql #phpmyadmin
(1/12)

In @GoogleHacking (exploit-db.com/google-hacking…) there are 176 dorks for searching SQL dumps, which may contain any confidential information.

Simple ex (pic 2):

ivanov ext:sql site:github.com

This query search all sql-files, which contain "ivanov" in #Github
(2/12)

Sometimes in this way it's possible find databases with information about orders, customers or employees. Inattentively, site owners forget to close them from indexing in robot.txt.

Such SQL-dumps may contain names, surnames, dates of birth, addresses, phone numbers.
Read 14 tweets
#JSM2021 panel led by @minebocek on upskilling for a statistician -- how to learn??
@minebocek #JSM2021 @hglanz no shortage of stuff to learn. First identify what you don't know -- that comes from modern media (blogs, twitter, podcasts; groups, communities -- @RLadiesGlobal or local chapters; professional organizations -- @amstatnews ).
@minebocek @hglanz @RLadiesGlobal @AmstatNews #JSM2021 @hglanz What do the job postings require these days? (This is how the content for the @CalPoly stat/data science program was developed.)
Read 64 tweets
This morning I read the phrase "legacy Power BI" on the site of a "modern" tool, which uses SQL as a query language.

With all respect, marketing hype should understand when their words become counterproductive.

#powerbi #sql #mdx #dax #sequel #legacy #modern

1/19
I know hundreds of issues and limitations in Power BI, but when it comes to comparison, I can hardly understand why "moving data" should be considered "legacy".

2/19
How do you call any "caching" mechanism?
What is an "index" if not a copy of data?
Seriously, do you know business users who really care about how many copies of the data are around the world?

3/19
Read 20 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!