Local, instructor-led live SQL (Structured Query Language) training courses demonstrate through hands-on practice the necessary skills to extract and analyse data from any database and create reports, and how to build advanced queries and add, update and delete data, tables, views and indexes.
SQL training is available as "onsite live training" or "remote live training". Onsite live SQL training can be carried out locally on customer premises in Hong Kong or in NobleProg corporate training centers in Hong Kong. Remote live training is carried out by way of an interactive, remote desktop.
NobleProg -- Your Local Training Provider
Testimonials
useful knowledge
Ewa Napieralska - Amazon Development Center Poland Sp. z o.o.
Course: PostgreSQL Administration and Development
The fact that we had a chance to hear about the difference between many databases types.
Marta Melloch - Amazon Development Center Poland Sp. z o.o.
Course: PostgreSQL Administration and Development
Training from the basics, which I needed. I hope that now it will be easier for me to write the queries and understand more advanced ones. Maybe sometimes too slow, but on the other hand it was large group so I guess it is hard to adjust the training pace for everybody as the knowledge was different (some of the people were more advanced).
Amazon Development Center Poland Sp. z o.o.
Course: PostgreSQL Administration and Development
Excercises were good, trainer was helpful. I also assume that trainer adapted a little to our knowledge after first day.
Capgemini Polska sp. z o.o.
Course: Teradata Fundamentals
Trainer's enthusiasm and energy
Capgemini Polska sp. z o.o.
Course: Teradata Fundamentals
Tips to improve performance
Capgemini Polska sp. z o.o.
Course: Teradata Fundamentals
Phil was incredibly knowledgeable, worked at our pace and took the time to talk us through multiple ways of doing different queries. He consistently took the time throughout the sessions to check both myself and my colleague were on board with what was being discussed, no question was too big/too small. This was my first time taking a training course remotely and I'm completely sold on it - Phil is a credit to you.
Chris Teasdale - Openreach
Course: SQL Fundamentals
Pace of the training and detail of content was perfect for a virtual session
Chris Hopton - Openreach
Course: SQL Fundamentals
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course: SQL in MySQL
Relevance to BigQuery.
Spark44
Course: SQL in SQL Server
We use BigQuery and the trainer decided we would use BigQuery instead to run all of the codes which was really really useful
Spark44
Course: SQL in SQL Server
The exercise
Federal Demographic Council
Course: Oracle SQL for beginners
the exercises
Amna AlAli - Federal Demographic Council
Course: Oracle SQL for beginners
The explanation are very clear and the exercises help understand better
Federal Demographic Council
Course: Oracle SQL for beginners
Clear
Mariam Karmostaji - Federal Demographic Council
Course: Oracle SQL for beginners
the good energy of the trainer, he explained everything clearly and precisely
MicroStrategy Poland Sp. z o.o.
Course: Teradata Fundamentals
Materials (code, presentation) were good
MicroStrategy Poland Sp. z o.o.
Course: Teradata Fundamentals
Nice training, full of interesting topics. After each topic helpful examples were provided.
Pawel Wojcikowski - MicroStrategy Poland Sp. z o.o.
Course: Teradata Fundamentals
I like the comprehensive approach to the subject taught. The course was well-structured, the topics were prepared and presented in a good order, helping us understand step-by-step logic how particular aspects of Teradata work. Especially I like that a lot of impact was put on the topic of indices. Pablo is a very likeable person and a good teacher. The time spent on this training was definitely spent well.
MicroStrategy Poland Sp. z o.o.
Course: Teradata Fundamentals
interaction
Maastricht University | UMIO
Course: Teradata Fundamentals
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
Course: Teradata Fundamentals
exercises & subquery
Maastricht University | UMIO
Course: Teradata Fundamentals
I liked the depth of the training. I was able to understand most of it and definitely learned from this training
Maastricht University | UMIO
Course: Teradata Fundamentals
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
Course: Teradata Fundamentals
x
Maastricht University | UMIO
Course: Teradata Fundamentals
New learned skills
Maastricht University | UMIO
Course: Teradata Fundamentals
The enthusiasm of the trainer
Maastricht University | UMIO
Course: Teradata Fundamentals
Explaining the step to take when trying to answer a question via the SQL
Maastricht University | UMIO
Course: Teradata Fundamentals
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course: Transact SQL Basic
wide aspect of Teradata knolwedge - starting basic architecture monitoring finishing
MicroStrategy Poland Sp. z o.o.
Course: Teradata Fundamentals
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Course: Transact SQL Basic
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
Course: Transact SQL Basic
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course: Oracle SQL Language
Patience, reordering, knowledge
Santander Bank Polska S.A.
Course: SQL Fundamentals
Machine Translated
Lots of exercises
Michał Świerkowski - Santander Bank Polska S.A.
Course: SQL Fundamentals
Machine Translated
Practice
Santander Bank Polska S.A.
Course: SQL Fundamentals
Machine Translated
Individual approach to listeners
Santander Bank Polska S.A.
Course: SQL Advanced
Machine Translated
A lot of exercises and vivid examples, few PDFs
Santander Bank Polska S.A.
Course: SQL Advanced
Machine Translated
practical
Swiss International Air Lines Ltd.
Course: SQL Advanced level for Analysts
Machine Translated
Mr. Bless has a very friendly, pleasant personality and with his experience and enthusiasm always motivates the participants and encourages them to do some tricky exercises! He has always made sure that all participants understand the content and has answered any questions. Good exercises help you to use the theory part quickly in practice. In general, the organization and tailoring of the training to the requirements of Nobleprog participants was very professional. Many Thanks!
Timo Koch - Swiss International Air Lines Ltd.
Course: SQL Advanced level for Analysts
Machine Translated
A lot of exercises, examples, recalling and discussing cases of practical applications of the issue
UBS Business Solutions Poland Sp. z o.o.
Course: SQL in Microsoft Access
Machine Translated
The training was conducted thoroughly from basic to very advanced ones. Friendly trainer, happy to answer questions.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
Course: SQL in Microsoft Access
Machine Translated
the knowledge gained from the training can be used in the job for which he was asked, the code written in VBA certainly no one will remember, so sending this message in the email is useful
UBS Business Solutions Poland Sp. z o.o.
Course: SQL in Microsoft Access
Machine Translated
Świetny trener. Wszystko na najwyższym poziomie. Ze względu na trenera szkolenie najlepsze ze wszystkich odbytych przeze mnie w ciągu ostatnich 20 lat. Także bardzo dobrze przygotowane materiały do szkolenia.
Giełda Papierów Wartościowych w Warszawie S.A.
Course: PostgreSQL Administration and Development
SQL Course Outlines in Hong Kong
- Construct queries to extract and filter data from an SQL Server database
- Create summarised results
- Change, derive and format data to suit the required output
- Change data and maintain database components and definitions
This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.
All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.
Format of the course
25% lectures, 75% labs
- Use queries to return complex result sets
- Manage database objects to aid query performance
- Tune queries to perform more efficiently
This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
This course introduces the delegates to Teradata.
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between T-SQL and other dialects
- practical skills for writing queries
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
- What is a relational database?
- What is the structure and SQL commands?
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with Microsoft Access dialect of SQL.
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
- How to work with SQL Server and SQL Server Management Studio.
- Meaning of Databases, SQL and RDBMS etc.
- How to create tables, use DDL, DML and DAL.
- Which are the various RDBMS Packages in the market and how they compare with each other.
- An Introduction to NoSQL and how they are organizations are changing into hybrid databases.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
- Beginner or intermediate database developers
- Beginner or intermediate database administrators
- Programmers
Format of the course
- Heavy emphasis on hands-on practice.
- Most of the concepts are learned through samples, exercises, and hands-on development.
This training is addressed for people starting to work with the SQL language in Oracle database
The course answer for questions:
- How to build a query?
- What possibilities have SQL?
- What is a relational database?
- What is the structure and SQL commands
This course is designed for people who want to use the advanced features of SQL in Oracle
The course answers the questions
- How to build advanced queries?
- How to create advanced reports?
How to build a query?
What possibilities have SQL?
What is a relational database?
What is the structure and SQL commands
.png "european central bank (ecb)")
.jpg "european southern observatory (eso)")
.jpg "procter & gamble (p&g)")
.jpg "european molecular biology laboratory (embl)")
