-
-
- Transfer Credit
- Online Learning
- Events
- Career Services
- Custom Programs
-
-
-
- Academic Services
- Course and Program Information
- Student Aid
-
-
-
Berkeley Global
Learn to analyze and mine data with the Structured Query Language (SQL). Building on the fundamentals of SQL, advance into data analysis and data mining with real applications. Use spreadsheets to further analyze, manipulate and present your data exploration and data mining findings in tabular and graphical formats. This course is ideal if you want to analyze data with SQL queries and use statistical methods to test the results.
Prerequisites:
Fundamental knowledge/experience of SQL or the following course:
- Introduction to SQL COMPSCI X451.1
Course Outline
Expand or collapse section
What You Learn
- SQL queries
- SELECT commands, UNION, INTERSECT and EXCEPT
- Nested queries
- Aggregate operators
- Null values
- Advanced SQL features
- Data analysis using dataflows
- SQL queries and subqueries
- Data exploration
- Charting with Excel String values
- Data mining models in SQL
- Directed data mining
- Statistical concepts
- Chi-square
How You Learn
- Lectures
- Group discussions
- Review of homework problems
- Assigned textbook chapters
- Homework assignments
Is This Course Right for You?
If you want to explore, analyze and mine data with SQL queries, as well as use statistical testing of data analysis results, this course is ideal. It is geared to heavy data users, scientists, data modelers, business intelligence professionals, business analysis professionals, dashboard designers, DBAs, quantitative/computational financial engineers and system administrators.
Learner Outcomes
On successful completion, you will be able to:
-
Construct SQL queries for data exploration, analysis, mining and statistical testing of results
-
Develop advanced queries and calculations using SQL, as well as further analyze and present these results using Excel
-
Perform data analysis using SQL and test the statistical significance of the resulting measurements using different statistical methods
-
Practice statistical methods such as null hypothesis, confidence intervals, normal distribution, calculation of probabilities from sample data, difference of proportion
Loading...
Sections
Fall 2024 enrollment opens on June 17!