Presentations About Resources

Salesforce, Python, SQL, & other ways to put your data where you need it -- a bilingual blog in English & French

Bienvenue! Welcome!

My goal is to help you work faster.

I must speak and teach until I hear 10 people say, "That thing you taught me? I used it! And it saved me time!"

(Ahem ... although maybe blogging slower than I'd hoped. Ugh, coders' repetitive stress injury.)

So check out the tutorials. Play with code. Tell me about your triumphs.

Dedupe Salesforce NPSP Emails with Python

23 Nov 2018 🔖 salesforce python questions tutorials intermediate 💬 EN

Salesforce #AwesomeAdmin Matthew (@matthewsalibi) asked how he could use Python to deduplicate Salesforce NPSP email addresses across several fields. Today I’ll provide you a script you can copy, paste, and try on your own data. And for the geeks, I’ll break it down and explain how every line works.

Continue Reading

Python for Salesforce Real-Life Challenge: NPSP Email Deduping

12 Nov 2018 🔖 salesforce python questions 💬 EN

Salesforce #AwesomeAdmin, reader, and “Office Hours” attendee Matthew (@matthewsalibi) got Python up and running on his computer, and is ready to dive into looking for duplicates in his Salesforce “Contacts” table. But he’s on the Nonprofit Starter Pack (NPSP), and a given email address might be in any of several fields. Today we’ll lay out his question … stay tuned for the answer!

Continue Reading

Every SQL Join You'll Ever Need

08 Nov 2018 🔖 databases sql 💬 EN

All right … maybe not every join. But this cheat sheet helped me score 104% on my Database 101 midterm exam, so it must be worth something.

Continue Reading

Why & How Should I Learn PL/SQL? (…T-SQL…PL/pgSQL…)

01 Nov 2018 🔖 databases sql triggers 💬 EN ( FR )

What if you need to perform more complex loops or conditions in your code than the SQL programming language allows? That’s why most major brands of database also understand commands written in a “procedural” programming language. Oracle calls theirs “PL/SQL,” Microsoft SQL Server calls theirs “T-SQL,” PostgreSQL calls theirs “PL/pgSQL,” etc. Let’s explore whether you need to learn one of these languages.

Continue Reading

Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

01 Nov 2018 🔖 bases de données sql triggers 💬 FR ( EN )

Quoi faire si le langage de programmation SQL ne vous permet autant de contrôle de la logique conditionnelle et des boucles qu’il vous faut ? Pour cette raison, la plupart des grandes marques de bases de données comprennent également des commandes écrites dans un langage de programmation “procédural”. Chez Oracle, la langue s’appelle PL/SQL. Microsoft SQL Server : T-SQL. PostgreSQL : PL/pgSQL. Etc. Lisez cet article pour découvrir s’il vous faut apprendre l’un de ces langages.

Lire plus