Loading...
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.
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.