Discover and read the best of Twitter Threads about #databases
Most recents (18)
#SQL Cheatsheet #infographic
———————
#Databases #DataScientists #DataScience #DataManagement #DataProfiling #DataLiteracy #DataQuality
———————
#Databases #DataScientists #DataScience #DataManagement #DataProfiling #DataLiteracy #DataQuality
12 Best #SQL Online Course Certificate Programs for #DataScience in 2023 — compiled by @tut_ml
————
#Databases #BigData #DataScientists
mltut.com/best-sql-onlin…
————
#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-…
————
#BigData #DataScience #DataScientists #Coding #Database #Analytics
mltut.com/best-advanced-…
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-…
—————
#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
[free 166-page PDF download]
———
#Database #DataScience #DataAnalytics #DataScientists #DataProfiling
🧵
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
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
🐢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
🧵#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.
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
"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
- 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
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
1\6
Lobster Daily #504 – Daily Recap – 14 August:
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/…
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/…
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.
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/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
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
🧵3/10
#databases #databasemigration #dataengineering #sql #googlecloud
Daily Bookmarks to GAVNet 03/26/2022 greeneracresvaluenetwork.wordpress.com/2022/03/26/dai…
Why America can't build quickly anymore
fullstackeconomics.com/why-america-ca…
#USInfrastructure, #ClimateChange, #responsiveness
fullstackeconomics.com/why-america-ca…
#USInfrastructure, #ClimateChange, #responsiveness
Vladimir Putin Has Fallen Into the Dictator Trap - The Atlantic
theatlantic.com/ideas/archive/…
#RussiaUkraine, #PowerDynamics, #InformationEcosystems, #DictatorTrap
theatlantic.com/ideas/archive/…
#RussiaUkraine, #PowerDynamics, #InformationEcosystems, #DictatorTrap
#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…
#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…
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…
The operations sometimes target those living beyond #China’s borders."
nytimes.com/2021/12/31/bus…
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...
#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...
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...
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...
A thread on how I managed to encrypt and store a video using #Flutter
Scroll for links, code snippets, and my general thought process...
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
Dependencies:
- camera
- path_provider
#flutter #android #s21 #video #coding
Below is the code for getting a file reference:
Created with @carbon_app
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…
To generate these, I used the rsa_encrypt package.
pub.dev/packages/rsa_e…
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
* 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
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
#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…
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…
Exploring variation in the use of feedback from national clinical #audits: a realist investigation @HSRatBMC by @tasha_alvarado
bmchealthservres.biomedcentral.com/articles/10.11…
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.
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
#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
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
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
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
@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…
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
The acute care side of the hospital - money maker - thinks of this as type of safety & #quality
but not #populationhealth
#Implicitbias elicits 🙄😡😴 response
🥳 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
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
-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
-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
