Kris Wenzel @sqlkris
Your search for SQL training is over, I'm here to help. Stick around, I'll tweet to you great introductory tips to search databases using SQL. essentialsql.com/start-today New Hudson, MI Joined December 2013-
Tweets8K
-
Followers3K
-
Following40
-
Likes691
Learn three ways to concatenate text in SQL. And why CONCAT_WS is superior over + and CONCAT for handling NULL.
What is a Relational Database Conceptual Model? youtu.be/vsak_iYU-V4 via @YouTube
There are several alternatives to bulk insert to use when inserting multiple rows into SQL Server. Let's review there here.
Rounding up to the nearest integer is easier that you think in SQL. Learn how to use a common built-in function to do so.
Learn to calculate a moving median in SQL. We'll use window functions and derived tables to make this happen.
Surprisingly there isn't a SQL MEDIAN() function. In this article I'll show you how you can calculate a Median using SQL Server.
Avoid SQL divide by zero errors using CASE WHEN or NULLIF functions to substitute zero for another value in our expression.
If you would like to subtract 30 days for a date in SQL you can easily do so using either SQL Server, PostgreSQL, or MySQL.
There are several way to find the week number in SQL. Let's though the standard ways to do so using PostgreSQL, MySQL, and SQL Server.
Use the REPLACE function to replace all occurrences of a substring with another. Use REPLACE with MySQL, PostgreSQL, and SQL Server.
Design a database is four steps. Follow along as I build the PizzaDB sample database. Learn my practical approach to designing databases.
The SQL CREATE TABLE statement is used to create a database table in SQLServer. Use it to add columns, datatypes and constraints.
Use GETDATE() to in conjunction with CAST to return today's date. GETDATE() returns data and time, so cast is necessary just get the date.
How to calculate 30 days into the Future using SQL SERVER. Also learn how to use it to calculate a date in the past.
An impossible join uses STRING_SPLIT() to break up column values into individual words which you can then join to another table.
Learn five ways to know when a column contains in SQL another value. We'll explore STRING_SPLIT, CHARINDEX, and other popular methods.
There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations group, and developers.
A SQL trigger ensure actions, such as updating an audit file, are completed regardless of which program update a database table.
Use SQL HAVING to filter summary results from a GROUP BY. It specifies the search condition for the group or aggregate.
Gianluca Sartori @spaghettidba
3K Followers 1K Following Data Platform MVP. Formula 1 DBA. Founder at @quantumdatis Retired account, please find me with same handle where the sky is blue
Benni De Jagere @BenniDeJagere
2K Followers 1K Following Senior Program Manager Fabric CAT, Microsoft Employee - Volunteer of things @dataMindsBe - Data Enthusiast - Consumer of Coffee - Karateka - Fulltime weirdo
SQL.ProductManager.Or... @thatjeffsmith
20K Followers 2K Following 🌟 SQL ⭕ Oracle 📊 Databases 🏋️♂️ Weights, poorly 🥃 Bourbon 🕸️ REST API 🙊 Product Manager 🤡 Annoying people online Words are mine.
patrick leblanc @patrickdba
9K Followers 2K Following
Tusarrin @TusarrinCpHy
30 Followers 965 Following
vijaykma @vkmandala9
50 Followers 3K Following
Todd Macklin @todd_macklin
27 Followers 482 Following
FML @f_mlds
0 Followers 305 Following here to .party() !!! #DataScience #MachineLearning #DataAnalyst
AS BD-AIML-CPS Archit... @BD_AIML_EngrArc
204 Followers 2K Following Change and modernize the world with Data engineering & science innovative solutions
Teshore @TeshoreA4J
47 Followers 4K Following
OpheliaHodge @WZ7ZmpK8VoXi4Y
68 Followers 7K Following
Xavifearless @Xavifearless
11 Followers 120 Following
Akinde Solomon Eriolu... @SolomonAki39907
2 Followers 101 Following
fossette @fossette17845
45 Followers 4K Following
MerissaHefter @HefterMeri41639
37 Followers 1K Following
Yogesh More @hereisyogi7
8 Followers 176 Following
Shiva✍️🚶 @Shiva_Tweets__
104 Followers 1K Following Miracles can happen at any Time📍||🌴🌳🌿🍀🌹🥀🥰🌄🌧️✍️ #Devara #NTR🔜
Rudhramoorthy @XRudhramoorthy
2 Followers 86 Following
Erick Carmo @welricsson
236 Followers 2K Following Analista de dados • desenvolvedor T-SQL • automatizo processos em ETL • entusiasta de Python para ciência de dados
Xtopher @andresic09
177 Followers 1K Following
mohazmakafash @mohazmakafash
129 Followers 574 Following “life is too short to write bad 《code》.” #Github:mohazmakafash instagram: mohaze_bellon LinkedIn: https://t.co/4DS4hwCGZq
Clumio @ClumioInc
581 Followers 292 Following Clumio is redefining data protection. @ us to protect your data from sloppy code, cyber attacks, fat-fingers, or whatever else you decided to throw at it today
teoespero 💚 @teoespero
216 Followers 739 Following 🇵🇭 grad student in Geospatial Information Technologies at @deltastateuniversity 🇺🇸 #networkengineering #cybersecurity #toycollector #diecastcars #gis
Shuai Chen (Charlie) @ShuaiChen2
3 Followers 95 Following 💼Business Intelligence Consultant 🎓RMIT University Alumnus 🎓Ohio University Alumnus
yellareddy @yellakatkuri
30 Followers 775 Following Learning Machine Learning, Data Science and web development
Darren Ryan @itsnotCRMnomore
207 Followers 698 Following It’s not CRM anymore. It’s so much more. Power Platform enthusiast. working with Microsoft CRM since 2011.
Sathish Kanna @mdsathishkanna
135 Followers 721 Following Software Developer, Website Designer, 🐵🐔🐶🐷 Animal welfare
Jeff Thomas @jctaudiodesigns
150 Followers 319 Following
GITΛЯI DΣ ИΣSH�... @gdmnesh
756 Followers 3K Following I endorse @OkiyaOmtatah | Data Scientist | @Chelseafc | Economist | IG. gitzdnesh | INTJ | Alumni @bkfuniversity '21
franklin work @franklinwork
981 Followers 5K Following
Pierre Gadea @pierre_gadea
381 Followers 2K Following .NET Developer, C#, JS, K8s, previously @usairforce. Love dogs, learning and coding. Interested in all things Azure.
HandicapperTech @HandicapperTech
28 Followers 117 Following I help sports handicappers build data-driven websites and applications to boost their chances of winning, raise revenue, and expand their business
ERP-BI_Solutions @ERPBISolutions1
5 Followers 120 Following
Toy3 @aldentoy19
159 Followers 718 Following
Louisianish 🦐🦪�... @Louisianish
2K Followers 3K Following Louisiana heritage language slacktivist qui parle franxais d'Lafourche et kouri-vini. 🌱 Développeur web. 💻 Attempting to raise des 👶🏼 bilingues.
Chuck Jacobson - Data @JacobsonData
87 Followers 292 Following Data Manager for Movement Disorders @FixelInstitute | SQL Server, Power BI, R, Neuro-stuff | Jesus Loves You | Personal account @chuckiej
David Bermudez @davidbermudezs
22 Followers 154 Following
Jose Molina Escobar @polylmevc
62 Followers 292 Following Lic. Matemática Aplicada. Director División de Desarrollo DATAZUCAR
Abuzar Kamal @AbuzarKamal
185 Followers 2K Following Database Architect at Tesco. #Oracle, #postgreSQL, #Exadata, #goldengate, #Couchbase, #Azure, #AWS solutions architect associate
Nizam @Nizammon
13 Followers 272 Following S/W Developer . # N.e.v.e.r S.e.t.t.l.e . . ! 🇦🇪 أفضل الصراحه حتى لو فيها كسر لكن لا تكذبون
Nadeem Hashmi @Nadeem_Hashmi
113 Followers 338 Following
Elizabeth Warren @ewarren
5.5M Followers 544 Following U.S. Senator, former teacher. Wife, mom (Amelia, Alex, Bailey, CFPB), grandmother, and Okie. She/her. Official campaign account.
Joe Biden @JoeBiden
38.1M Followers 46 Following Husband to @DrBiden, proud father, grandfather, and great grandfather.
Jill Biden Archived @FLOTUS46Archive
4.2M Followers 5 Following This is an archive of a Biden administration account, maintained by the National Archives and Records Administration.
The White House 46 Ar... @WhiteHouse46
8.6M Followers 6 Following This is an archive of a Biden administration account, maintained by the National Archives and Records Administration.
Nancy Pelosi @SpeakerPelosi
7.9M Followers 490 Following Representative for CA-11, fighting for the people of San Francisco. 52nd Speaker of the House. Wife, mother, grandmother, dark chocolate connoisseur.
Adam Schiff @SenAdamSchiff
3.4M Followers 897 Following Husband. Father. U.S. Senator for California. Fighting for an economy that works for everyone and for our democracy.
Michelle Obama @MichelleObama
21.5M Followers 18 Following Girl from the South Side and former First Lady. Wife, mother, dog lover. Always hugger-in-chief.
Reverend Raphael Warn... @ReverendWarnock
1.2M Followers 887 Following Pastor. Advocate. Savannah born & raised. @Morehouse alum. Senator from Georgia. | Join us @TeamWarnock
Vice President Kamala... @VP46Archive
14.6M Followers 6 Following This is an archive of a Biden administration account, maintained by the National Archives and Records Administration.
Kamala Harris @KamalaHarris
20.8M Followers 702 Following Always fighting for the people. Wife, Momala, Auntie. She/her. 107 Days available now.
Daniel Dale @ddale8
990K Followers 2K Following
(((Tendar))) @Tendar
419K Followers 855 Following Tyrants are my enemies | Si vis pacem para bellum |🇩🇪🇪🇺| Das Böse triumphiert allein dadurch, dass gute Menschen nichts unternehmen |Military & History
MMS @mmsholdings
2K Followers 2K Following MMS is a leading, global clinical research organization (CRO) focused on regulatory submission support for the #pharma, #biotech and medical device industries.
Andriy Yermak @AndriyYermak
270K Followers 457 Following Керівник Офісу Президента України / Head of the Office of the President of Ukraine
Exxegroup @exxegroup
3K Followers 958 Following $AXXA Public Company, Ticker Symbol: AXXA 💻 | #Fintech 🏢 | #RealEstate, #Agriculture 📈 | #PrivateEquity, #VentureCapital
Karla H Carpenter @KarlaHCarpenter
354 Followers 726 Following Opinions expressed are my own. Follows may or may not indicate alignment.
CSea Perkins @CSea
3K Followers 4K Following ☀️Face inevitable fact that digital currencies / crypto is here to stay; I teach☀️Respect and nurture our environment through conscious and repetitive actions☀️
NotATweeter16 @NotATweeter16
8K Followers 9K Following I follow back—indiscriminately, automatically, & with alacrity. Therefore, I don't necessarily share the stances of everyone I'm following.
Walz Wins @walz_wins
124K Followers 1K Following
Jonathan Sunassee @Jsunassee
45 Followers 195 Following
Aditya Bhushan Chatur... @Aditya3550
274 Followers 1 Following Technology Specialist(Coforgetech), Mo:9560277537 E:[email protected]
The Lincoln Project @ProjectLincoln
2.8M Followers 1K Following "You cannot escape the responsibility of tomorrow by evading it today.” – Abraham Lincoln 🏴☠️ | Home of #TheBreakdown and LP Podcast
Kirzy @HenrryPires
112 Followers 135 Following Programador nos tempos livres (segunda a sexta), apaixonado por SQLServer e co-fundador da comunidade NetPonto
Mary Clavier @MEC018
13 Followers 3 Following
SHEIKHMYDHEEN @M_Sheikmydheen
147 Followers 834 Following Senior Program Manager-Microsoft Dynamics D365| Commerce and Retail | PowerApps | Chief Architect -Solutions & Advisory| Technology & Management consulting |
Governor Gretchen Whi... @GovWhitmer
519K Followers 506 Following 49th Governor of Michigan. Proud mom. You can reach my office for support at 517-335-7858 or visit https://t.co/n9DUTcUNjo
SatKat @xspeedcruiser
76 Followers 791 Following
Hooman Tajbakhsh @hoomantajbakhsh
18 Followers 56 Following
Jermy Hoffman 💙�... @jermyh
121 Followers 360 Following
Sarah Polston-Smith (... @kappaslk
37 Followers 159 Following
sydney schwartz @sschwartz939
6 Followers 538 Following
Swarn Singh @Biaspind
12 Followers 81 Following
yotwitt @mayo1210
249 Followers 528 Following lifetime learner | lifetime explorer | curious | obsessed | extraordinary |
David Allan @Dallan76
30 Followers 70 Following
Michel Salloum @msalloum
38 Followers 222 Following
Tom Randall @tsrandall
29K Followers 3K Following Covering the future of transportation+energy. Opinions are, too often, my own.
Elizabeth Warren @SenWarren
6.6M Followers 495 Following U.S. Senator, Massachusetts. She/her/hers. Official Senate account.Trends for United States
93,3 B posts
247 B posts
8.867 posts
20,5 B posts
26,4 B posts
53,1 B posts
15,3 B posts
11,3 B posts
12,9 B posts
19,3 B posts
544 B posts
29,7 B posts
114 B posts
7.561 posts
128 B posts
69,4 B posts
3.572 posts
5.118 posts
38,8 B posts
8.684 posts
You might like
Steve Stedman
@SqlEmt
11K Followers
Kevin Kline
@kekline
11K Followers
Wayne Sheffield
@DBAWayne
2K Followers
Arcane Code
@arcanecode
3K Followers
Tim Radney
@tradney
3K Followers
Database Health
@DatabaseHealth
2K Followers
Niko Neugebauer
@NikoNeugebauer
3K Followers
SQL Shack
@SQLShack
4K Followers
AndyLeonard
@AndyLeonard
6K Followers
way0utwest 🎙️ (H...
@way0utwest
8K Followers
Jessica Moss-Bonistal...
@jessicammoss
4K Followers