- Onboard For Tech Teams
- Reduce initial time to productivity.
- Increase employee tenure.
- Plug-and-play into HR onboarding and career pathing programs.
- Customize for ad-hoc and cohort-based hiring approaches.
- Upskill For Tech Teams
- Upgrade and round out developer skills.
- Tailor to tech stack and specific project.
- Help teams, business units, centers of excellence and corporate tech universities.
- Reskill For Tech Teams
- Offer bootcamps to give employees a running start.
- Create immersive and cadenced learning journeys with guaranteed results.
- Supplement limited in-house L&D resources with all-inclusive programs to meet specific business goals.
- Design For Tech Teams
- Uplevel your existing tech learning framework.
- Extend HR efforts to provide growth opportunities within the organization.
- Prepare your team for an upcoming tech transformation.
Get your team started on a custom learning journey today!
Our Boulder, CO-based learning experts are ready to help!
Course Summary
The Advanced SQL training course is designed to teach students how Structured Query Language (SQL) works under the covers.
The course begins with a lesson on how to write elegant, high-performance queries and how to troubleshoot and solve complex challenges with ease. The course then dives into establishing some often-overlooked theoretical aspects of SQL, while laying layer after layer of deep foundational understanding and emphasizing practical applied implications. The curse will then cover the most efficient ways to use SQL efficiently and elegantly using things like set operators, window functions, common table expressions, lateral joins and more.
- Productivity Objectives:
- Troubleshoot, optimize and solve complex SQL challenges.
- Evaluate common pitfalls.
- Demonstrate high-performing solutions minimizing bugs and resources, improving consistency, productivity, and performance.
Request Information
Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.
If you are not completely satisfied with your training class, we'll give you your money back.
about our training
-
Real-World Content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
-
Expert Practitioners
Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
-
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
-
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
What You'll Learn
In the Advanced SQL training course, you'll learn:
- Understanding query logical and physical processing
- Advanced JOIN processing
- Cartesian products
- Qualified joins
- Reserving tables
- ANSI 89 vs. ANSI 92 joins
- Lateral derived tables
- Filtering and dealing with missing data complexities
- The case for NULL and I-values vs. A-values
- Ternary logic and predicates
- Advanced logical operators
- Understanding grouping and group filters
- The need for grouping data
- Aggregate functions and the logical limitations of grouped sets
- DISTINCT vs. grouped queries
- The do’s and don’ts of group filters
- Introduction to ordered set functions
- Efficient paging and ordering
- The role of presentation ordering in multi-tier applications
- Understanding the LIMITs of FETCH and OFFSET
- Advanced JOIN processing
- Advanced querying constructs
- Changing to a ‘set oriented’ thinking
- Sets vs. bags, rows vs. records, fields vs. columns
- The ‘all-at-one’ principal
- RBAR (Row by Agonizing Row) processing
- Advanced subqueries and query compositions
- Correlation predicates
- Expression subqueries and derived tables
- Value list subqueries
- The benefits of EXISTS processing
- Unleashing the power of set operators
- Advanced use of UNION, EXCEPT, and INTERSECT
- Changing to a ‘set oriented’ thinking
- Recursions, window functions, and imperative processing
- The use cases for recursive and iterative constructs in SQL
- Recursive common table expressions
- The use case for imperative constructs
- Using window functions to the max
- Understanding window function processing
- Framing and filtering windows
- Aggregate, ranking, analytic and offset window functions
- Imperative processing in SQL
- Using vs. abusing cursors
- Loops
- Temporary objects
- The use cases for recursive and iterative constructs in SQL
Real-world content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners
Industry experts that bring their battle scars into the classroom.
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
Elite Instructor Program
We recently launched our internal Elite Instructor Program. The community driven instructor program is designed to support instructors in transforming students’ lives by consistently showing a world-class level of engagement, ability, and teaching prowess. Reach out today to learn more about our instructors.
Customized Technical Learning Solutions to Help Attract and Retain Talented Developers
Let DI help you design solutions to onboard, upskill or reskill your software development organization. Fully customized. 100% guaranteed.
DevelopIntelligence leads technical and software development learning programs for Fortune 500 companies. We provide learning solutions for hundreds of thousands of engineers for over 250 global brands.
“I appreciated the instructor’s technique of writing live code examples rather than using fixed slide decks to present the material.”
VMwareAbout Us
LET’S DISCUSS
DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.
Resources
Thank you for everyone who joined us this past year to hear about our proven methods of attracting and retaining tech talent.
- Boulder, Colorado Headquarters: 980 W. Dillon Road, Louisville, CO 80027
© 2013 - 2022 DevelopIntelligence LLC - Privacy Policy