๐ป Catch Taiob Ali (@SqlWorldWide) at #PosetteConf Livestream 3๏ธโฃ talking about 15 essential standards for compliance and security for Azure Database for #PostgreSQL. ๐ ๐
posetteconf.com
#postgresql #databases #azure
ALT A person wearing headphones and a blue jacket, seated in a room with light blue walls. Behind them are shelves with books and items, and two closed white doors. A desk with a computer monitor and keyboard is on the left, and another desk with various items is on the right. The top of the image displays the text 'POSETTE: An Event for Postgres 2025' in white on a purple background.
2
105
๐ Do you manage, secure, or audit instances of Azure Database for #PostgreSQL?
If so, (@SqlWorldWide) Taiob Aliโs talk at #PosetteConf is a safe bet! ๐ฏ
Learn more about Taiob and his talk at: posetteconf.com/speakers/taiโฆ
#postgres #databases #azure
1
2
127
21 Apr 2025
๐ Discover how to turn your #Data into smart decisions using #Azure #AI #Python!
Live session with @SqlWorldWide Taiob Ali, MVP & Data Expert.
๐๏ธ Apr 24, 12 PM EDT
๐๏ธ Moderated by Ronen Ariely @pitoach
Register ๐ meetup.com/cloud-data-drivenโฆ
#DataScience
3
36
Here is the @welshazure November 2024 VIrtual Meet Up recording with @SqlWorldWide and @jakewalsh90
jonnychipz.com/2024/11/20/weโฆ
#vwan #sql #migration #cloud #azure #networking
2
4
345
First up tonight we have the amazing @SqlWorldWide discussing SQL migrations to Azure
2
3
331
17 Nov 2024
I donโt post that much here, some things last week:
3x2x8k to the office by bike
2x12k for a company dinner by bike
2 hours with children in a swimming pool (I was sooo tired!)
7k running
Happy that I am healthy enough to do this :)
2
4
141
12 Nov 2024
The sky was so beautiful and the music was so good that the 7 minute run turned into a 31 minute run. Happy Tuesday everyone!
2
6
155
7 Nov 2024
4
116
6 Nov 2024
Makes me sad I missed it this year :(
Great job everyone!!
3
79
6 Nov 2024
Pattern matching is such an important part of data analytics and it is very easy to use in SQL.
๐๐ฒ๐'๐ ๐๐ป๐ฑ๐ฒ๐ฟ๐๐๐ฎ๐ป๐ฑ ๐ต๐ผ๐ ๐๐ผ๐ ๐ฐ๐ฎ๐ป ๐ฝ๐ฒ๐ฟ๐ณ๐ผ๐ฟ๐บ ๐ฝ๐ฎ๐๐๐ฒ๐ฟ๐ป ๐บ๐ฎ๐๐ฐ๐ต๐ถ๐ป๐ด ๐ถ๐ป ๐ฆ๐ค๐ ๐ฎ๐ ๐ฎ ๐ฑ๐ฎ๐๐ฎ ๐ฎ๐ป๐ฎ๐น๐๐๐:
You can use the 'LIKE' keyword in SQL for pattern matching.
Also, you have wildcards in SQL that can be used in combination with the 'LIKE' keyword.
๐๐ฒ๐'๐ ๐๐ฒ๐ฒ ๐๐ต๐ฒ ๐๐ถ๐น๐ฑ๐ฐ๐ฎ๐ฟ๐ฑ๐ ๐ฎ๐ป๐ฑ ๐๐ต๐ฒ๐ป ๐ ๐๐ถ๐น๐น ๐ฝ๐ฟ๐ผ๐๐ถ๐ฑ๐ฒ ๐๐ผ๐ ๐๐ผ๐บ๐ฒ ๐ฒ๐
๐ฎ๐บ๐ฝ๐น๐ฒ๐ ๐ฎ๐ ๐๐ฒ๐น๐น:
'%' - It is used to represent n number of characters after/before or between desired text.
๐๐
๐ฎ๐บ๐ฝ๐น๐ฒ:
โข ๐ช๐๐๐ฅ๐ ๐ฐ๐ผ๐น๐๐บ๐ป_๐ป๐ฎ๐บ๐ฒ ๐๐๐๐ '๐ฆ%' (finds values that start with S with n number of characters.)
โข ๐ช๐๐๐ฅ๐ ๐ฐ๐ผ๐น๐๐บ๐ป_๐ป๐ฎ๐บ๐ฒ ๐๐๐๐ '%๐' (finds values that end with 's' with n number of characters.)
โข ๐ช๐๐๐ฅ๐ ๐ฐ๐ผ๐น๐๐บ๐ป_๐ป๐ฎ๐บ๐ฒ ๐๐๐๐ '%๐%'ย (finds values that have 's' in between with n number of characters.)
'_' -> It represents a single character.
๐๐
๐ฎ๐บ๐ฝ๐น๐ฒ:
โข ๐ช๐๐๐ฅ๐ ๐ฐ๐ผ๐น๐๐บ๐ป_๐ป๐ฎ๐บ๐ฒ ๐๐๐๐ '๐ฆ_' (find values that have only 2 characters starting with 'S')
So, this is how you can perform pattern matching in SQL as a data analyst.
Enjoy. Follow for more!
#DataAnalysis #SQLPatternMatching #SQLTips #DataAnalyst #PatternMatching #DataScience #DataAnalystLife #SQLSkills #DataCleaning #DatabaseManagement #DataAnalytics #DataJobsUSA #SQLUSA #AnalyticsCareersUSA #DataAnalystUK #SQLUK #AnalyticsUK #DataAnalystEurope #SQLEurope #AnalyticsEurope #GlobalDataJobs #SQLWorldwide #DataScienceGlobal #AnalyticsCareersGlobal
2
20