강좌 실습을 통해 실제 SQL (Structured Query Language) 교육 과정을 통해 모든 데이터베이스의 데이터를 추출 및 분석하고 보고서를 작성하는 데 필요한 기술을 손으로 연습하여 고급 쿼리를 작성하고 데이터, 테이블, 뷰 및 인덱스를 추가, 업데이트 및 삭제하는 방법을 보여줍니다 SQL 교육은 "현장 실습"또는 "원격 실습"으로 제공됩니다 현장 실습은 고객 구내에서 현지에서 실시 할 수 있습니다 대한민국 또는 NobleProg 기업 교육 센터에서 대한민국 원격 라이브 교육은 대화 형 원격 데스크톱을 통해 수행됩니다 NobleProg 지역 교육 제공자.
Machine Translated
회원 평가
지식과 번역 Jan M
Jan Maksymowski
Course: Oracle 11g - Język SQL dla administratorów - warsztaty
Machine Translated
실질적인 준비, 세부 사항에 대한주의 Sebastian Łubik - Nordea B
Sebastian Łubik
Course: SQL Fundamentals
Machine Translated
트레이너의 매우 높은 능력 !!
Heino Eilers
Course: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
강사에 대한 완벽한 지식. Bogusław Stanek
Bogusław Stanek
Course: Oracle SQL - poziom średniozaawansowany
Machine Translated
각기 다른 수준의 난이도와 각 참가자에게 트레이너가 개별적으로 접근하는 많은 운동
Agnieszka Cybula
Course: Oracle SQL - poziom średniozaawansowany
Machine Translated
많은 수의 연습 문제 Wojciech Koz
Wojciech Kozioł
Course: Oracle SQL - poziom średniozaawansowany
Machine Translated
각 질문 / 문제 및 이해할 수있는 설명 / 번역 / 솔루션에 대한 개인 및 환자 접근
Grzegorz Krzeczek
Course: Oracle SQL dla początkujących
Machine Translated
질문을하거나, 필요에 맞게 페이스를 조정하거나, 참가자의 관점에서 가장 흥미롭고 필요한 / 어려운 요소에 집중할 수 있습니다.
Aleksandra Wójtowicz
Course: Oracle SQL dla początkujących
Machine Translated
의사 전달, 광범위한 주제 지식, 교육 프로그램 이외의 질문에 대한 개방성
Michał Woźny
Course: Oracle SQL dla początkujących
Machine Translated
교육 품질 및 문제 접근 방식 설명 Blazej Baron - UBS Bus
Blazej Baron
Course: Oracle SQL - poziom średniozaawansowany
Machine Translated
강사는 주제를 제시하고 많은 연습 문제를 지원합니다. 우리는 우리 스스로 지식을 적용 할 기회를 가졌습니다.
UBS Business Solutions Poland Sp. z o.o.
Course: Oracle SQL Intermediate
Machine Translated
훈련과 운동 중에 지식과 도움을 전하는 전문적이고 접근 가능한 방법.
Michal Bialek
Course: Język SQL w bazie danych MySQL
Machine Translated
운동 해결에 트레이너 개별 지원에 Access 합니다.
Tomasz Czornak
Course: Oracle SQL Intermediate
Machine Translated
실용적인 예제가 많이 있습니다. Paweł Miązek - Mindbox
Paweł Miązek
Course: Oracle 11g - Język SQL dla programistów - warsztaty
Machine Translated
훈련 중 좋은 분위기
clovis Nebouet
Course: Oracle 11g - SQL language for developers - Workshop
Machine Translated
실용적인 수업 Andrzej
Andrzej Kozak
Course: Oracle SQL dla początkujących
Machine Translated
드릴
Fabrice Limbourg
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
Machine Translated
강사가 갖고있는 철저한 실무 지식
Pieter Peirs
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
Machine Translated
주제에 대한 깊이있는 지식. 아니요. "그걸 조사하고 너에게 돌아 가야한다. 그냥 다 알았다."
David Marshall
Course: PostgreSQL Administration and Development
Machine Translated
삶의 예, 경험, 데이터베이스 작동 및 구성 옵션에 대한 깊은 지식.
Łukasz Picur
Course: PostgreSQL Administration
Machine Translated
트레이너, 그는 지식이 풍부하고 매력적이었으며 쉽게 배울 수있었습니다. 그는 학습에 많은 도움을주었습니다.
Shawn McAndrew
Course: SQL Fundamentals
Machine Translated
나는 사실을 좋아한다, 각 섹션 후에 우리는 excercises를 가지고 있었다. discused 주제를 기억하는 데 도움이됩니다.
Adam Bińczycki
Course: Oracle 11g - SQL language for developers - Workshop
Machine Translated
강사에 대한 지식 Paweł Dybo
Paweł Dybowski
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Machine Translated
트레이너에 대한 지식은 향상되었습니다. 개선 된 후에 트레이너를 다시 선택하게됩니다.
Michał Komarnicki
Course: ORACLE SQL Fundamentals
Machine Translated
나는 LOOOOOT을 배웠다
Kamil Szmid
Course: SQL Fundamentals
Machine Translated
이유를 모르더라도 SQL이 작동합니다.
Dominik Gardo
Course: SQL Fundamentals
Machine Translated
트레이너와 헌신에 대한 폭 넓은 지식, 주제에 관심을 가질 수있는 능력.
Michał Komarnicki
Course: Oracle 11g - Programowanie w PL/SQL - wprowadzenie
Machine Translated
훈련에 참여하는 사람들에게 트레이너의 개별 접근 Wojciech Gądzikiewicz - medhub sp. z o
Wojciech Gądzikiewicz
Course: SQL Fundamentals
Machine Translated
수행해야 할 과제 (과제), 트레이너의 전문적인 경험에서 나온 사례 Tomasz Niewiadomski - Intergraph Polska Sp. z o
Tomasz Niewiadomski
Course: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
데이터베이스 측에서 잘 알려진 메커니즘, 즉 메모리에서 처리되는 방식을 보여줍니다.
Marcin Czerwiec
Course: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
교육은 완벽하게 준비되었으므로 데이터베이스에 대한 개별 지침의 영향에 대한 자세한 설명과 함께 실시간 예제를 기반으로 실행 방법이 마음에 들었습니다.
Joanna Dymarczyk
Course: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
관심있는 지식, 관심사 및 요구에 자료를 적용하는 것; 소규모 그룹의 강사가 더 빨리 학습하는 데 도움이되었습니다. 지휘, 퀴즈, 대화의 좋은 방법
Łukasz Madej
Course: SQL in Microsoft Access
Machine Translated
SQL;)
MAGDALENA KOPCZYŃSKA
Course: Oracle SQL dla początkujących
Machine Translated
많은 운동 Łuka
Łukasz Dziewiński
Course: Oracle SQL dla początkujących
Machine Translated
대화식 학습 방법을 매우 좋아했습니다
Luigi Loiacono
Course: Data Analysis with Hive/HiveQL
Machine Translated
그것은 매우 실용적인 훈련이었다, 나는 handson 운동을 좋아했다
Proximus
Course: Data Analysis with Hive/HiveQL
Machine Translated
좋은 개요, 이론과 운동 사이의 좋은 균형
Proximus
Course: Data Analysis with Hive/HiveQL
Machine Translated
동적 인 상호 작용과 주제에 "손을 대", 가상 머신 덕분에, 매우 자극!
Philippe Job
Course: Data Analysis with Hive/HiveQL
Machine Translated
트레이너의 능력과 지식
Jonathan Puvilland
Course: Data Analysis with Hive/HiveQL
Machine Translated
주제에 대한 세부 사항, 지식 및 열정에 대한 관심
Bristol City Council
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Machine Translated
언제든지 질문을 할 수있는 능력과 비공식적 인 / 덜 구조화 된 스타일. 이것은 우리가 가장 흥미를 느낀 지식 분야를 추구 할 수있게 해주었습니다
Jim Lane
Course: Transact SQL Advanced
Machine Translated
수업의 템포, 사용자의 기대와 관련된 훈련의 내용에 대한 유연성
Karol
Course: SQL Fundamentals
Machine Translated
페이스, 완전히 다른 각도에서 이슈에 대한 설명. 서버 측에서 모든 것이 어떻게 작동하는지 설명하는 것 P4 Sp. z o.o.
P4 Sp. z o.o.
Course: SQL Fundamentals
Machine Translated
보상되는 이슈의 수 P4 Sp. z o.o
P4 Sp. z o.o.
Course: SQL Fundamentals
Machine Translated
참가자의 요구에 대한 적응, 토론 된 과제에 대한 아주 좋은 탐구, 질문에 대한 포괄적 인 대답
Marcin Gołdyn
Course: SQL Fundamentals
Machine Translated
실제 데이터베이스 작업. P4 Sp. z o.o.
P4 Sp. z o.o.
Course: SQL Fundamentals
Machine Translated
청취자의 요구에 적응하고보고하는 문제를 분석합니다. P4 Sp. z o.o.
P4 Sp. z o.o.
Course: SQL Fundamentals
Machine Translated
기능에 연습! WIktor
WIktor Paprzycki
Course: SQL Advanced level for Analysts
Machine Translated
번역의 방법 Małgor
Małgorzata Mieczkowska
Course: SQL Advanced level for Analysts
Machine Translated
연습 문제 Wikt
Wiktor Paprzycki
Course: SQL Advanced level for Analysts
Machine Translated
SQL코스 개요
코스 이름
Duration
Overview
코스 이름
Duration
Overview
14 시간
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
- 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.
- 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.
7 시간
Overview
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
14 시간
Overview
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.
14 시간
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
- 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.
- 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.
14 시간
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:
- 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 Microsoft Access dialect of SQL.
21 시간
Overview
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.
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.
14 시간
Overview
This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.
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.
28 시간
Overview
This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
14 시간
Overview
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:
- 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.
- 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.
7 시간
Overview
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:
- 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.
- 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.
14 시간
Overview
- How to build a query?
- What is a relational database?
- What is the structure and SQL commands?
- What is a relational database?
- What is the structure and SQL commands?
14 시간
Overview
Audience
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
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
14 시간
Overview
The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.
35 시간
Overview
This 5-day course demonstrates how to use Oracle SQL for database development and database management.
14 시간
Overview
This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:
- 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.
- 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.
7 시간
Overview
This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
14 시간
Overview
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
14 시간
Overview
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
21 시간
Overview
Audience
- 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.
- 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.
21 시간
Overview
Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism.
This course introduces the delegates to Teradata.
This course introduces the delegates to Teradata.
21 시간
Overview
The aim of this course is to provide a clear understanding of the use of SQL for different
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.
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.
7 시간
Overview
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
35 시간
Overview
In this instructor-led, live training in 대한민국 (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
14 시간
Overview
In this instructor-led, live training in 대한민국, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
14 시간
Overview
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
35 시간
Overview
This instructor-led, live training in 대한민국 (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
14 시간
Overview
The course is designed for persons with pre-information databases using SQL queries or queries.
14 시간
Overview
The course answers questions
- How to build a query?
- What opportunities have SQL?
- What is a relational database?
- What is the structure and SQL commands?
- How to build a query?
- What opportunities have SQL?
- What is a relational database?
- What is the structure and SQL commands?
14 시간
Overview
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
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.
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.
향후SQL 코스
28-10-2021 10:00
14 hours
04-11-2021 10:00
14 hours
11-11-2021 10:00
14 hours
22-11-2021 10:00
21 hours
29-11-2021 10:00
14 hours
Other countries
Consulting
주말SQL코스, 밤의SQL트레이닝, SQL부트 캠프, SQL 강사가 가르치는, 주말SQL교육, 밤의SQL과정, SQL코칭, SQL강사, SQL트레이너, SQL교육 과정, SQL클래스, SQL현장, SQL개인 강좌, SQL1 대 1 교육
.png "aeronautical radio, incorporated (arinc)"){kind=small}
_ireland.gif "environmental protection agency (epa) ireland")
.jpg "european southern observatory (eso)")
