Discover and read the best of Twitter Threads about #databases

Most recents (18)

12 Best #SQL Online Course Certificate Programs for #DataScience in 2023 — compiled by @tut_ml
————
#Databases #BigData #DataScientists
mltut.com/best-sql-onlin…
7 Best Advanced #SQL Courses & Training Online You Must Know in 2023 — compiled by @tut_ml
————
#BigData #DataScience #DataScientists #Coding #Database #Analytics
mltut.com/best-advanced-…
Read 3 tweets
12 Best FREE #SQL Courses and Certifications Online in 2023 — compiled by @tut_ml
—————
#Databases #DataScience #BigData #Analytics #DataScientists #100DaysOfCode
mltut.com/best-free-sql-…
#SQL Notes for Professionals: books.goalkicker.com/SQLBook/
[free 166-page PDF download]
———
#Database #DataScience #DataAnalytics #DataScientists #DataProfiling
Read 4 tweets
🧵

1/ Get rid of complex, traditional backend servers while building your #websites.

According to @HTTPArchive, now more than 1% of ALL websites are based on the Jamstack architectural approach

👇

(image by C. Fayock)

#webapp #coding #developer #innovation
2/ Whether you are an experienced or a novice web developer, your main, urgent goal is to avoid:

🐢Slow loading times

🔒Security vulnerabilities

📈Scaling issues

😵Headaches

#webdev
3/ The Jamstack is a way of building web applications that utilizes modern tools and technologies based on #JavaScript, #APIs, and Markdown (J.A.M. stack), in order to decouple the #frontend from the #backend
Read 14 tweets
🧵#Bioinformatics and its impact on #healthcare, a THREAD🧵🧵:
#Bioinformatics is the application of #computational techniques to the analysis of #biological data, such as #DNA sequences and #protein #structures.
In #healthcare, #bioinformatics is used to gain insights into the #genetic basis of diseases, and to develop new #diagnostic tests and #treatments.
Read 11 tweets
NEXT Inventory and Comparison of ICU datasets by Christopher SAUER

"Why talk on differences in ICU databases?"
Ans: becuase data is "CORE"
@ESICM #ml #ai #databases #datascience #LIVES2022
@ESICM Merit of publicly available ICU databases
- no randomzined evidence exists for most clinical situations
-data and pt level insights incredibly useful.
-local epidemiology and treatment difers
-real world data sets help deliver optimal treatment policies.
#DataScience #LIVES2022
@ESICM 1st publicly available dataset MIMIC-3 in 2016,
Beth Israel Deaconess Medical Centre, Boston,MA
>70,000 icu stays, 2008 to 2019
now also includes chest x-rays, emergency room data
- large, community developed Github repo.
#DataScience
Read 16 tweets
1\6
Lobster Daily #504 – Daily Recap – 14 August:
3\6
2.1. Exploit in the @AcalaNetwork due to an issue in the $iBTC/ $aUSD pool
Link:
Link:
Link to discussion 👇
t.me/lobsters_chat/…
Link to discussion👇
t.me/lobsters_chat/…
Read 7 tweets
What's the logical order of SQL query operations? SQL Query Execution Order (Visualized). #SQL #Databases
1. FROM & JOIN: The DB looks at the tables we specified in FROM and in the JOINs, and then merges this data - this merged data is our starting "working set".
2. WHERE: Perhaps we don't want the whole merged working set - perhaps we want to filter this data, so this means we end up with a subset of our working set - we've retained some rows and discarded other rows.
Read 9 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
#Global #PartyPanopticon:

#PRC "gov't, which has built an extensive digital infrastructure & security apparatus to ctrl dissent on its own platforms, is going to even greater lengths to extend its internet dragnet to unmask & silence those who criticize"

nytimes.com/2021/12/31/bus…
...the #PRC "on @Twitter, @Facebook & other international #SocialMedia.

These new investigations, targeting sites blocked inside #China, are relying on sophisticated technological methods to expand the reach of #Chinese authorities & the list of targets"

nytimes.com/2021/12/31/bus…
"To hunt people, [#PRC] security forces use advanced investigation #software, #PublicRecords & #databases to find all their #PersonalInformation & international #SocialMedia presence.

The operations sometimes target those living beyond #China’s borders."

nytimes.com/2021/12/31/bus…
Read 12 tweets
On this I can agree with @Dominic2306, and go further.

#SW1 #IT and #IG has been in a parlous state for well over a DECADE, and more.

A year and a slew of inquiries after the @HMRC #ChildBenefit #DataBreach in 2007, we #FOIed every Government Department about the #databases...
..of #PersonalData they held. (Initially just the ones containing over 1 million records.)

I'll have to dig up the responses, but I clearly remember only 4 or 5 (out of 24) even had an #InformationAssetRegister, i.e. just a basic list of all the #databases for which they were...
...'#responsible'.

The responses from @cabinetofficeuk & @10DowningStreet were even more appalling; they admitted allowing officials to routinely make copies of #population-scale data "for policy reasons" with no #oversight, no #audit, no defined #IG processes, and no idea of...
Read 13 tweets
A thread on how I managed to encrypt and store a video using #Flutter

Scroll for links, code snippets, and my general thought process...
Recording and saving videos locally isn't too difficult.

Dependencies:
- camera
- path_provider

#flutter #android #s21 #video #coding

Below is the code for getting a file reference:

Created with @carbon_app   /// One call to get a file reference, set temp = false to
Encryption on the other hand is a foreign language to me. From my research, I learned that each user needs an #AsymmetricKeyPair that can be used to #encrypt and #decrypt data.

To generate these, I used the rsa_encrypt package.

pub.dev/packages/rsa_e…
Read 19 tweets
What are the most common types of #NoSQL #databases?

* Document databases store data in documents similar to JSON objects. Each document contains pairs of fields and values. The values can be a variety of types including strings, numbers, booleans, arrays, or objects 1/n
* Key-value databases are a type of database where each item contains keys and values. A value can typically only be retrieved by referencing its key, so learning how to query for a specific key-value pair is typically simple 2/n
* Wide-column stores store data in tables, rows, and dynamic columns, wide-column stores are commonly used for storing IoT data and user profile data. Cassandra and HBase are two of the popular wide-column stores 3/n
Read 5 tweets
Important to keep in mind that #AI is made by humans. Our flaws and biases get encoded and amplified. We need the right diversity of people at the table to design and implement #ArtificialIntelliegence and #ML. #humancentereddesign for all of humanity. #design
Who determines definitions, labels of #data cut offs? Too often we get all nerdy on which variables & factors in the model. But are we even using the right data? #tech #technology types might consider reading Maya Angelou & Toni Morrison and others to think outside the box
#AI
Example: many people are interested in #SDoH #socialdeterminantsofhealth & #data for it.
Who has existing large #databases?
Banks
Banks are traditionally risk averse, block/exclude those who are labeled high risk
So can their data improve health equity?

reuters.com/article/us-usa…
Read 5 tweets
Exploring variation in the use of feedback from national clinical #audits: a realist investigation @HSRatBMC by @tasha_alvarado  
bmchealthservres.biomedcentral.com/articles/10.11…
National Clinical Audits (NCAs) are a well-established quality improvement strategy used in #healthcare settings.@CardiacAudit @HQIP #NHS #MINAP #PICANET @BCIS_uk
Significant resources, including clinicians’ time, are invested in participating in NCAs, yet there is variation in the extent to which the resulting feedback stimulates quality improvement.
Read 20 tweets
There are a lot of types of databases out there. Which one you use depends on what you need it for. Here are a few examples 👇🧵

#100DaysOfCode #CodeNewbies #databases
▶️ RELATIONAL DATABASE

This is the most popular database out there. It depends on tables which have relationships between them (thus "relational"). Popular examples include:

👉@MySQL
👉 @PostgreSQL
👉 @SQLServer
▶️ NOSQL DATABASE

The opposite of a relational database. It doesn't rely on tables and relationships, which is why it's called No-SQL. It is instead (usually) reliant on documents. Popular examples include:

👉 @MongoDB
👉 @couchbase
👉 @dynamodb by @awscloud
Read 6 tweets
Let’s talk #safetyculture

@TheIHI

It’s a framework for a harm reduction towards all: patients & families as well as all staff

Important:
growth mindset
instead of
fixed mindset

to have needed uncomfortable conversations

#MedTwitter #AcademicTwitter #MedEd #NurseTwitter
This framework has been applied to reducing harm, mostly through medication error (though intended to achieve population health)

Then was expanded to patient experience

Also, cost of care

More recently we have added clinician wellbeing

=quadruple aim

ihi.org/communities/bl…
What has not been clearly stated in any of these #safety framework is disparities, structural inequity, or racism

The acute care side of the hospital - money maker - thinks of this as type of safety & #quality

but not #populationhealth

#Implicitbias elicits 🙄😡😴 response
Read 13 tweets
🥳 We are celebrating 1 year of @ECHO_ERCproject 🤩

Started on 1st of March 2019, the project lead by Alberto Palloni has as the main objective to reformulate and generalize standard theories of human #health and #mortality.
💶: @ERC_Research 🇪🇺
🗓️: 5 years
#epidemiology #ERC
@ERC_Research @sebadaza @lauracilek @mathiasvoigt2 @Demografia_CSIC @CCHS_CSIC @Europeos_CSIC @REA_research @dordanovich During year 1, Alberto Palloni has:
-moved from @UWSoc 🇺🇸 ✈️ to @CSIC 🇪🇸
-set his own team of researchers and collaborators, specialised in #sociology, #demography, #geography, #epidemiology and #epigenetics👩🏽‍💻🧑🏻‍💼👨🏾‍💻👩‍🔬
-identified suitable health #databases & #longitudinal studies
@ERC_Research @sebadaza @lauracilek @mathiasvoigt2 @Demografia_CSIC @CCHS_CSIC @Europeos_CSIC @REA_research @dordanovich @UWSoc @CSIC @IEGD_CSIC Meet Alberto's team at @CCHS_CSIC!
-Diego Ramiro: Director of @IEGD_CSIC @Demografia_CSIC
-Sebastián Daza: Demographer and Social Data Scientist @sebadaza
-Mathias Voigt: Demographer @mathiasvoigt2
-Dariya Ordanovich: Geographer, GIS Specialist and Data Scientist @dordanovich
Read 9 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!