SQL Intermediate to Advanced Training Course
This instructor-led, live training (online or onsite) is aimed at intermediate to advanced level users who wish to use learn more about SQL.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Extended Use Of Summary Functions
- Group_Concat
- Rollup
- Grouping Function
Window Functions
- Summarising
- Ranking
- Lead & Lag
- Percentiles
Extended Use Of Sub-Queries
- Common Table Expression
- Columns
Recursive Common Table Expressions
- Hierarchical Queries
- Reporting Grids
Stored Procedures
- Use of parameters
- Use of IF statements
- Use of Loops & Cursors
Execution Plan
Indexes
Requirements
SQL Fundamentals knowledge and experience.
Need help picking the right course?
azerbaijan@nobleprog.com
SQL Intermediate to Advanced Training Course - Enquiry
SQL Intermediate to Advanced - Consultancy Enquiry
Testimonials (2)
everything was fine
Titus
Course - SQL Intermediate to Advanced
I learned a lot of new information and made myself a path to follow,
Flavius
Course - SQL Intermediate to Advanced
Related Courses
SQL Advanced
14 HoursThis instructor-led, live training in Azerbaijan (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.
By the end of this training, participants will be able to:
- Perform advanced querying techniques using unions, subqueries, and complex joins.
- Add, update, and delete data, tables, views, and indexes with precision.
- Ensure data integrity through transactions and manipulate database structures.
- Create and manage databases efficiently for robust data storage and retrieval.
AI for SQL: Leveraging Large Language Models for Intelligent Querying and Optimization
21 HoursThis instructor-led, live training in Azerbaijan equips data engineers with the skills to integrate LLMs into SQL environments. Participants will build natural language pipelines, implement AI-driven optimization, and design secure enterprise workflows for automated data analysis.
SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
14 HoursOracle Database 19c Performance Management and Tuning
28 HoursThis instructor-led, live training in Azerbaijan (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to optimize the performance of Oracle Database 19c.
By the end of this training, participants will be able to:
- Understand Oracle Database 19c performance tuning concepts.
- Use performance management tools effectively.
- Optimize database performance through tuning techniques.
- Troubleshoot and resolve performance issues.
Oracle SQL - advanced
14 HoursBy the end of this training, participants will be able to:
The training is dedicated to people with the profile of user, programmer or administrator who already have some knowledge of working with Oracle database and want to deepen and systematize it. It is a complement to the ORA_S1 training course.
By the end of this training, participants will be able to:
- The training will provide participants with the skills to efficiently store and process data using SQL, introducing knowledge of optimization, analysis and various methods of data extraction. At the same time, it will provide knowledge of the database architecture and its advanced capabilities to create effective applications.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SQL Advanced level for Analysts
21 HoursSQL Basics
14 HoursSQL: Basics to Intermediate
35 HoursThis instructor-led, live training in Azerbaijan (online or onsite) is aimed at beginner-level to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL to manage databases effectively.
By the end of this training, participants will be able to:
- Understand and use fundamental SQL commands and queries.
- Create and manipulate tables and databases.
- Use SQL to sort, filter, and summarize data.
- Implement more complex operations like joins, subqueries, and set operations.
- Apply intermediate techniques such as indexes, views, stored procedures, and triggers.
SQL For Data Science and Data Analysis
14 HoursSQL Fundamentals to Advanced Querying
10 HoursSQL Fundamentals
14 HoursSQL Intermediate
14 HoursSQL language in MSSQL
14 HoursSQL Advanced in MySQL
7 HoursData Analysis with SQL, Python, and Tableau
14 HoursThis instructor-led, live training in Azerbaijan (online or onsite) is aimed at data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualization.
By the end of this training, participants will be able to:
- Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
- Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
- Get a refresher on the fundamentals of Python and SQL.
- Perform data pre-processing techniques in Python.
- Learn how to connect Python and SQL for data analysis.
- Create insightful data visualizations and charts with Tableau.