In the modern business landscape, information represents the most valuable resource for organizations, with the majority of this critical data housed within digital relational database systems.
The overwhelming majority of database management platforms currently deployed across industries rely on SQL as their primary language for data manipulation and retrieval operations.
As a globally recognized standard, SQL empowers users to execute sophisticated data analysis and aggregation operations through an intuitive command structure that maximizes efficiency.
For professionals pursuing careers in data analytics, software development, or any field requiring database interaction capabilities, SQL proficiency serves as a fundamental prerequisite.
This comprehensive course will guide you through essential database management principles while providing hands-on experience with SQL implementation. Beginning with fundamental data retrieval techniques from single tables, you'll progress to advanced multi-table operations that enable comprehensive data analysis—all practiced using our cloud-based SQL simulation environment throughout your learning journey.
What's included
1 reading7 assignments5 plugins
Show info about module content
1 reading•Total 2 minutes
Download course slides•2 minutes
7 assignments•Total 50 minutes
Module Exam •30 minutes
Database Basics•2 minutes
relational databases•2 minutes
Relationships between tables in relational databases•2 minutes
Database Management Systems (DBMS)•2 minutes
SQL language•2 minutes
Test exam week 1•10 minutes
5 plugins•Total 44 minutes
Database Basics•10 minutes
relational databases•10 minutes
Relationships between tables in relational databases•10 minutes
Database Management Systems (DBMS)•6 minutes
SQL language•8 minutes
Week 2: Introduction to SQL
Module 2•5 hours to complete
Module details
What's included
7 readings9 assignments7 plugins
Show info about module content
7 readings•Total 100 minutes
Generalities exercise•5 minutes
Select command•10 minutes
Limit, Distinct(), Count() exercises•10 minutes
Data types exercises•10 minutes
Create, Drop, Alter exercises•30 minutes
Insert, Update, Delete exercises•20 minutes
Indexes, Views, and Stored Procedures exercises•15 minutes
9 assignments•Total 104 minutes
Module Exam•60 minutes
Generalities exercise•2 minutes
Select command exercises•2 minutes
Limit, Distinct(), Count() exercises•2 minutes
Data types exercises•2 minutes
Create, Drop, Alter exercises•2 minutes
Insert, Update, Delete exercises•2 minutes
Indexes, Views, and Stored Procedures exercises•2 minutes
Test exam week 2•30 minutes
7 plugins•Total 74 minutes
Generalities•12 minutes
Select command•10 minutes
Limit, Distinct(), Count()•7 minutes
Data types•15 minutes
Create, Drop, Alter•12 minutes
Insert, Update, Delete•8 minutes
Indexes, Views, and Stored Procedures•10 minutes
Week 3: Improving SQL queries
Module 3•6 hours to complete
Module details
What's included
7 readings9 assignments7 plugins
Show info about module content
7 readings•Total 130 minutes
Select with string patterns, ranges, and sets exercises•30 minutes
Order result sets with ORDER BY exercises•10 minutes
Grouping result sets with GROUP BY exercises•15 minutes
SELECT CASE exercises•15 minutes
Aggregate and per-row functions exercises•20 minutes
Integrated date and time exercises•30 minutes
Subqueries and nested SELECTs exercises•10 minutes
9 assignments•Total 179 minutes
Module exam•120 minutes
Select with string patterns, ranges, and sets exercises•2 minutes
Order result sets with ORDER BY exercises•2 minutes
Grouping result sets with GROUP BY exercises•2 minutes
SELECT CASE exercises•2 minutes
Aggregate and per-row functions exercises•2 minutes
Integrated date and time functions exercises•2 minutes
Subqueries and nested SELECTs exercises•2 minutes
Test exam week 3•45 minutes
7 plugins•Total 56 minutes
Select with string patterns, ranges, and sets•8 minutes
Order result sets with ORDER BY•5 minutes
Grouping result sets with GROUP BY•5 minutes
SELECT CASE•5 minutes
Aggregate and per-row functions•10 minutes
Integrated date and time functions•15 minutes
Subqueries and nested SELECTs•8 minutes
Week 4: Queries that consolidate data from several tables
Module 4•5 hours to complete
Module details
What's included
3 readings5 assignments3 plugins
Show info about module content
3 readings•Total 50 minutes
Implicit JOIN and JOIN types exercises•10 minutes
INNER, LEFT, RIGHT and OUTER JOIN exercises•20 minutes
SELECT UNION exercises•20 minutes
5 assignments•Total 186 minutes
Module exam•120 minutes
Implicit JOIN and JOIN types exercises•2 minutes
INNER, LEFT, RIGHT and OUTER JOIN exercises•2 minutes
The Universitat Politècnica de València (UPV) operates as a public higher education institution, delivering contemporary, adaptable degree programs designed to fulfill current societal demands. It also provides official postgraduate qualifications, all subject to stringent educational quality assurance protocols.
Currently, the UPV's thriving academic community encompasses over 28,000 students, nearly 2,500 teaching and research professionals, and 1,500 administrative and service personnel. Its operations span three distinct campuses, located in València, Alcoi, and Gandia.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.