-
-
- Sciences, Mathematics
and Biotechnology - Biology
- Chemistry and Physics
- Clinical Laboratory Science
- Health Advising
- Life Science Business and Biotechnology
- Mathematics and Statistics
- Online Sciences Courses
- See the full list
- Technology and
Information Management - Writing, Editing and
Technical Communication
- Transfer Credit
- Online Learning
- Events
- Career Services
- Custom Programs
- Sciences, Mathematics
-
-
-
- Academic Services
- Course and Program Information
- Student Aid
-
-
-
Berkeley Global
Get in-depth training of the core Structured Query Language (SQL), focusing on Data Query Language (DQL) and Data Manipulation Language (DML). You learn the concepts of SQL, including writing complex SQL statements, and gain a basic understanding of database operations. Learn more by e-mailing the instructor at mkremer@berkeley.edu or by visiting the instructor's website.
Prerequisites:
Recommended
- Ability to program in at least one high-level programming language such as Python, Java, Ruby, JavaScript, C or C++. Need to fulfill this prereq? Take a course in:
- Introduction to Computers and Programming COMPSCI X444.4
- Programming Python COMPSCI X434
- First Course in Java EL ENG X429.9
- JavaScript and jQuery: An Introduction COMPSCI X452.1
- Introduction to C Language Programming EL ENG X24
Course Outline
Expand or collapse section
Course Objectives
- Understand basic SQL language concepts and structure.
- Construct SQL SELECT statements.
- Understand SQL data types and functions.
- Perform complex filtering, aggregate queries and multiple table joins.
- Use SQL subqueries and complex DML queries.
- Create advanced SQL queries and use SQL for data analysis and mining.
What You Learn
- SQL SELECT
- Data types
- Functions
- Filtering
- Intersections, difference and union of sets
- Multiple table joins
- INNER, OUTER, NONEQUI and SELF joins
- Aggregate functions
- Subqueries
- SQLDML
- Insert, update, delete
- Hierarchical SQL
- Regular expressions
- Data analysis and data mining
- OLAP SQL
How You Learn
- Reading assignments
- Quizzes
- Homework assignments
- Final project
Is This Course Right for You?
If you want to gain a mastery of SQL in order to query and update databases, as well as perform data analysis, you should enroll.
Loading...
Sections
Spring enrollment opens on October 16!