Structured Query Language (SQL) using SAS
Master SQL in SAS to create reports and query data. Learn to query, summarize, join tables, create views, and access DBMS data in this hands-on course.
Master SQL in SAS to create reports and query data. Learn to query, summarize, join tables, create views, and access DBMS data in this hands-on course.
This course cannot be purchased separately - to access the complete learning experience, graded assignments, and earn certificates, you'll need to enroll in the full SAS Advanced Programmer Professional Certificate program. You can audit this specific course for free to explore the content, which includes access to course materials and lectures. This allows you to learn at your own pace without any financial commitment.
4.9
(276 ratings)
16,308 already enrolled
Instructors:
English
Қазақша, Deutsch, हिन्दी, 19 more
Powered by
What you'll learn
Query and subset data effectively using SQL in SAS
Summarize and present data through reports and visualizations
Combine tables using various join techniques and set operators
Create and modify tables and views for data management
Create data-driven macro variables to develop dynamic programs
Access database management systems with SAS/ACCESS technology
Skills you'll gain
This course includes:
26 Hours PreRecorded video
60 assignments
Access on Mobile, Desktop, Tablet
FullTime access
Shareable certificate
Closed caption
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 9 modules in this course
This comprehensive course teaches learners how to use Structured Query Language (SQL) within SAS programs to create reports and effectively query data. Starting with SQL fundamentals, the course progresses through essential concepts including filtering data with WHERE clauses, sorting with ORDER BY, and enhancing reports with calculated columns and conditional logic. Students learn to summarize and group data, create and modify tables, and use DICTIONARY tables for metadata access. Advanced topics cover joining tables using various join types, writing subqueries, employing set operators, and creating data-driven macro variables. The course concludes with practical instruction on accessing third-party database management systems using SAS/ACCESS technology, preparing learners for real-world data analysis challenges.
Course Overview and Data Setup
Module 1 · 50 Minutes to complete
Essentials
Module 2 · 1 Hours to complete
PROC SQL Fundamentals
Module 3 · 6 Hours to complete
SQL Joins
Module 4 · 4 Hours to complete
Subqueries
Module 5 · 4 Hours to complete
Set Operators
Module 6 · 2 Hours to complete
Using and Creating Macro Variables in SQL
Module 7 · 2 Hours to complete
Accessing DBMS Data with SAS/ACCESS
Module 8 · 1 Hours to complete
Case Study (Honors) and Certification Practice Exam
Module 9 · 2 Hours to complete
Fee Structure
Instructor
Senior Technical Training Consultant at SAS, Expert in Data Analytics Education
Peter Styliadis is a Senior Technical Training Consultant at SAS, where he specializes in developing and delivering comprehensive training programs focused on data analytics and visualization. With a strong foundation in programming languages such as SQL, Python, and SAS, Peter has designed and implemented courses that empower users to effectively process and analyze large datasets. His expertise includes leading curriculum development for key courses like SAS SQL Essentials and Data Visualization Using SAS ODS Graphics. In addition to his instructional roles, he actively mentors fellow instructors and collaborates with internal teams to address customer inquiries, leveraging his extensive knowledge of SAS software. Peter's commitment to education is further demonstrated through his involvement in online learning platforms, where he teaches courses that enhance analytical skills for professionals across various industries. Through his innovative training approaches, he plays a vital role in equipping individuals with the tools necessary to harness the power of data for informed decision-making.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
4.9 course rating
276 ratings
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.