READY TO GET HANDS ON WITH SQL?
“My objective is to add SQL familiarity and hands-on experience to your array of skills. This should serve as a spark to turn familiarity into proficiency and proficiency into expertise! There is tremendous value in having SQL proficiency in the Salesforce ecosystem. All technical skills require time, dedication, practice, and experimentation. I hope to provide a foundation for SQL based on concepts you already know and understand well as a Salesforce professional. I will also provide you with resources and experts that I have learned from, so you can continue your journey forward.”
What's Included
- Learn SQL concepts and code
- Learn Data Query Language (DQL)
- Leverage Snowflake to import data
- Database tradeoffs
- Best practices, considerations, and limitations
- Instructor led videos to support your learning style
- Step by step tutorials with examples
- 65+ exercises to cement your learning and test your knowledge
- Additional recommended resources
- Course access for 12 months
- Course certificate
$49.99PURCHASE
Take A look Inside
This course will focus on Data Query Language, DQL for short. The aim of introducing SQL is to focus on query and analysis use cases for selecting data from your database. This is a great starting point and gives you coverage and common ground when collaborating with analytics and data teams.
We will leverage Snowflake to import data, but will not get into SQL commands for creating and administering a database. A general understanding of Data Query Language will open the door for you to explore other areas like Data Definition, Data Manipulation, and administrative functions like Data Control, and Transaction Control. I will explain various commands at a high level to give you a good foundation.
The SQL concepts and code you will learn in this course are universal. It will translate to most databases including, but not limited to, Microsoft SQL server, MySQL, POSTRESQL, and others. I will also reference Salesforce SOQL from time to time.
Course Content
Course Instructor
Ryan brings over 20 years of experience as a Salesforce customer. Throughout these two decades, Ryan has donned various hats in analytics, working as a hands-on practitioner, consultant, entrepreneur, author, and community leader. After 15 years in enterprise software, Ryan shifted gears from being a vendor to a customer. As the VP of Data Analytics for a mid-sized financial services company, he implemented and executed his analytics strategy playbook over a span of 4 years.
With thousands of hours dedicated to building a successful analytics competency center using Salesforce, Snowflake, and Azure, Ryan has channeled his expertise, tools, and recent AI advancements into his latest endeavor, DataTools Pro.
Frequently Asked Questions
Salesforce Ben is the #1 community resource for Salesforce content and is trusted around the world. We are known for delivering concise, easy to understand training material, brought to you by a team with 20+ years’ combined Salesforce experience.
Any professional wishing to add SQL to their skills.
Benefits:
- Employees with SQL skills earn an average of 10% more than those without, according to PayScale.com.
- The job market for SQL skills is projected to grow 10% between 2020 and 2030, much faster than the average for all occupations. (Source: Bureau of Labor Statistics)
- 72% of hiring managers in the United States consider SQL skills to be “very important” or “essential” when hiring for data-related roles. (Source: Indeed 2023 Hiring Report)
My objective is to add SQL “familiarity” and some hands-on experience to your array of skills. This should serve as a spark to turn familiarity into proficiency and proficiency into expertise! There is tremendous value in having SQL proficiency in the Salesforce ecosystem. All technical skills require time, dedication, practice, and experimentation. I hope to provide a foundation for SQL based on concepts you already know and understand well as a Salesforce professional. I will also provide you with resources and experts that I have learned from, so you can continue your journey forward.
This course will focus on Data Query Language, DQL for short. The aim of introducing SQL is to focus on query and analysis use cases for selecting data from your database. This is a great starting point and gives you coverage and common ground when collaborating with analytics and data teams.
We will leverage Snowflake to import data, but will not get into SQL commands for creating and administering a database. A general understanding of Data Query Language will open the door for you to explore other areas like Data Definition, Data Manipulation, and administrative functions like Data Control, and Transaction Control. I will explain various commands at a high level to give you a good foundation.
The SQL concepts and code you will learn in this course are universal. It will translate to most databases including, but not limited to, Microsoft SQL server, MySQL, POSTRESQL, and others. I will also reference Salesforce SOQL from time to time.
We’ve gathered all the information you need in one place and arranged them in a logical order.
We also make sure we cover the best practices and considerations you need to be aware of, to ensure code that won’t cause technical debt.
Salesforce is an ever-changing technology with 3 releases per year and you must be confident that the resources you use are accurate and up to date. We update our course after each release, so you know you’ll always have the right information at your fingertips.
Your purchase includes access to the Introduction to Salesforce SOQL Course for 12 months.
We update the course shortly after each new release to reflect any changes, enhancements or new features. These updates are included in the cost of your purchase.
At Salesforce Ben we strive to keep our content up to date in line with the latest Salesforce release. We update each course and practice exam shortly after each new release. These updates are included in the cost of your purchase.
We offer a 30-day money-back guarantee, provided that no more than 25% of the course has been completed. If 25% or more has been completed, or the refund request is outside the initial 30-day period, we are unable to offer a refund.
$49.99PURCHASE