What You'll Get
3+ hrs of self-paced training videos
23 high-value, learn-as-you-work lessons
Expert stories from the field & across industries
Research-backed curriculum designed to unlock your hidden talents
Immediately applicable Pro Tips & Tactics
Graphite Academy
SQL Tactics that Wow Clients & Win Raises
Master SQL strategies that transform an organization’s database into a treasure chest of intelligence. Render yourself irreplaceable by turning strategic questions into actionable answers.
Submit your email address to get the first lesson for free:
Thanks for Subscribing!
Self-paced E-learning course
7-day money back guarantee
Trusted by top companies
Set Yourself Apart
Why you should take this course
This course is a practical look at the most powerful SQL skills needed to translate business questions into powerful queries. Most organizations are still stuck looking at Excel spreadsheets - with SQL, they can generate millions in revenue and save even more in expenses.
To demonstrate your unique value, you have to be able to handle vast data sets and know your way around a company’s database, not to mention the administrators that manage it. In this course, you’ll learn to create and communicate data insights to everyone in an organization.
What You'll Learn
- How to develop powerful Executive-level reporting
- Relational database tricks and traps
- Turning strategic questions into actionable answers
- Database merges, migrations, and divestitures
- How to earn trust with every data stakeholder
- Much More! See Full Agenda
Optimized for You
Who is this program for?
consultants
- Help teams get the most out of their database
- Improve communication between executives and analysts
- Support your clients in making wiser decisions
employees
- Future-proof your company’s legacy database
- Understand your team’s data architecture
- Build dashboards and data flows that win raises
- Demonstrate dependable, promotable SQL know-how
Meet your Instructor
Joshua Gubitz
20 years advising multi-billion-dollar companies on how to harness the power of data
- Leads large-scale, complex, global data projects in finance, healthcare, and financial services
- Built the data analytics department for the biggest bank monitorship in history
- Known for leaving companies teaming with skilled and passionate data analysts
Our Difference
What sets this course apart
Expertise is no longer about what you know. It's about how you think. Most courses on SQL focus on the "how to". This course goes beyond that by unpacking the "how to think" using the tool, and how changing the way you think will take you to the next level in your career.
In this course, you will hear from experts who have used SQL to solve problems, earn trust, win contracts and promotions, and take their careers to new levels of credibility and compensation. You'll not only hear how they think when they sit down and open their laptops, but how they communicate, collaborate, and strategize to turn data into insight and insights into real value for their clients and their careers.
Course Curriculum
1. SQL powers and limitations
- 1.1. What is SQL
- 1.2. SQL’s strengths and when to use it
- 1.3. Understanding SQL’s weaknesses
- 1.4. The basics of data queries
- 1.5. Data joins and beyond
2. Working between fallible humans and precise machines
- 2.1. Examples of how SQL’s literalism can trip you up
- 2.2. Good data, bad data, no data - and what to do about it
- 2.3. Using wildcards to compensate for sloppy data input
- 2.4. Case Study: 43,000 Column Headers, and the 14-named man
3. Getting to know your data with SQL
- 3.1. Wrapping your mind around what’s happening in the data
- 3.2. The power of play: Better queries, fewer mistakes
- 3.3. Extrema power: The importance of null, max, min
- 3.4. Identifying data requirements
- 3.5. Translating data questions into SQL code requirements
- 3.6. Telling bigger stories by joining multiple datasets
- 3.7. Case Study: How to spot and handle fraud in your data
4. Generating insights and telling stories with data
- 4.1. Using data to tell stories: No more glazed eyes
- 4.2. Getting inside the boss’s head: What the boss wants to know
- 4.3. Case study: Shell companies, fake directors, and the apartment with 1,000 businesses
5. Improving a company’s data culture
- 5.1. Befriending your Database Admins
- 5.2. Injecting wisdom into an organization’s data practices
- 5.3. Starting with the basics and building up from there
- 5.4. Inspiring a passion for data on the team
- 5.5. Democratizing data analytics: SQL code snippets for everyone
- 5.6. Sharing is caring: How to use SQL libraries
Frequently Asked Questions
What will I learn in these courses?
- Graphite Academy courses are based on the premise that expertise these days is less about what you know, and more about how you think. We've designed these courses to help you unpack the mind of some of Graphite's top consultants, giving you the feeling of having the expert in the room with you as a source of knowledge and inspiration.
In these courses, you'll learn how experts use data tools to advance their careers and solve bigger problems. You'll hear how they learn about their clients underlying needs and desires, identify business assumptions and data sources needed to begin the analysis, and deliver finding with confidence, conviction, and compelling stories. We'll also include screenshares of the expert walking through the tools themselves to show you how the lessons apply in a practical sense on screen.
What is the format and structure of these courses?
- These courses are organized into 3 to 5 hours of video content structured in 5 to 10 minute segments. You'll have access to interviews with experts, stories from the field, and screenshares walking you through the tools in action.
You'll be able to watch the videos at your own pace anytime. We also include supplementary links and resources to help you dive into the tools and start practicing real-world applications of the technology on your own computer.
What sets these courses apart?
- We believe that expertise these days is less about what you know and more about how you think. So we have hired experts in online learning to tap into the minds of some of our top Graphite consultants, and show you how they think and use technology to solve bigger problems and advance their careers.
Other courses on the internet tend to focus on the technical features of the tool with lectures and long winded screencasts demoing the tool. Those courses tend to be tedious and outdated, and usually redundant since the "how to" resources are usually available online for free.
When are these courses offered?
- Once you purchase a published course you will have unlimited access to the course content. You can view it wherever, whenever you want.
We suggest taking the course once, and then going back to it in a few months to see what new lessons you learn from the experts as your own knowledge and experience with the tool evolves.
Do I need access to the tech tool to take this course?
- Most learners enjoy following along with the lessons on their own computers, which would require you to have your own access to the software featured in the course. Others use the courses to get an overview of the tool so they can have informed conversations about the tool with clients and decide when to invest in the tool as an addition to their professional repertoire.
Most of our courses, such as Tableau and SQL have free-to-use options you can use to teach yourself the tool and follow along with course content. Others, such as Excel, require a paid license to use.
What prior experience do I need to take this course?
- No prior experience with the tool is required. These courses are best for two levels of prior experience:
A. You've heard of the tool featured in the course and you'd like to learn how to start using it on the job
B. You've worked with the tool before and would like to level up your skills and accelerate your path to expertise
At minimum, you should have heard of the tool featured in the course and have a basic sense of how it's used by businesses.
Where can I learn the basics before I take these courses?
- No prior experience is with the tool is required. However, it is recommended that you have heard of the tool and have a basic understanding of how it's used in business.
If you'd like to familiarize yourself with the basics of the tool in order to decide whether it's the right time to take a Graphite Academy course, we recommend searching for "best YouTube channels for learning Thinkific" and watching a few free videos to get a basic understanding of the tool.
Upskill yourself today
Submit your email address to get the first lesson for free:
Thanks for Subscribing!
See More Graphite Academy courses
