SAS SQL 1: 기초
SQL1 : SQ1M6
데이터 질의, 검색, 테이블 생성, 갱신 및 삭제 등 SAS 프로그램 내에서 SQL 프로시저를 사용하여 데이터를 처리하는 방법을 학습합니다.
Learn How To
- Basic Queries
- Displaying Query Results
- Subqueries
- SQL Joins
- Set Operators
- Tables와 Views 생성
- 기타 SQL Procedure 기능
- Managing Tables
- Accessing Relational Databases
Who Should Attend
이 과정은 Structured Query Language(SQL)을 이용해서 데이터를 처리하고자 하는 SAS 사용자를 대상으로 합니다.
Prerequisites
이 과정의 선수 과정은 SAS Programming 1: 기초 입니다.
이 과정 참석 전에, 아래의 내용이 가능해야 합니다.
이 과정 참석 전에, 아래의 내용이 가능해야 합니다.
- SAS 프로그램 실행
- SAS 데이터셋 생성 및 엑세스
- 산술/비교/논리 연산자 사용
SAS Products Covered
Base SAS
Course Outline
소개
- Structured Query Language 소개
- 비즈니스 시나리오 소개
- SQL procedure 개요
- Columns/rows 선택
- Data 정렬 및 기타
- Data 요약
- 비상호관련 subqueries
- in-line view
- SQL joins 소개
- Complex SQL joins
- Set 연산자들 소개
- EXCEPT operator
- INTERSECT operator
- UNION operator
- OUTER UNION operator
- Proc SQL로 views 생성
- Proc SQL로 table 생성 (self-study)
- SQL procedure 옵션 설정
- Dictionary tables과 views
- Macro 언어와 PROC SQL 인터페이스
Live Class Schedule
Duration: 14 시간
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
06-07 JAN 2026
Live Web, US
9:00 AM-5:00 PM EST
English
2,000 USD
26-30 JAN 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
02-06 MAR 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
23-26 MAR 2026
Live Web, US
10:30 AM-3:00 PM EDT
Spanish
1,600 USD
09-10 APR 2026
Live Web, US
9:00 AM-5:00 PM EDT
English
2,000 USD
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.
This course helps prepare you to earn the following SAS Knowledge Badge:
This course helps prepare you to earn the following SAS Credentials:
SAS Certification Manager
SAS partners with Pearson VUE to provide you with the best possible certification experience.
Certification Resources
