Oracle Database 12c
Format
Self-paced
Price
£199
About the course
Develop practical SQL querying and database manipulation skills through a series of self-paced, hands-on labs focused on Oracle Database 12c.
The course introduces learners to key Oracle Database features and the fundamentals of retrieving, filtering, sorting, and presenting data using SQL statements.
Learners will explore single-row functions, conversion functions, conditional expressions, and aggregate functions to customise query output and summarise data.
Additional labs cover retrieving information from multiple tables using joins, working with subqueries, and managing table data through Data Manipulation Language (DML) statements.
The course also introduces Data Definition Language (DDL) for creating and modifying database structures.
The labs connect SQL concepts with practical database tasks, helping learners retrieve relevant information, combine related data, perform calculations, summarise results, and manage database records and structures.
Activities reinforce query accuracy, data organisation, and the effective use of SQL to interact with relational databases.
By completing the labs, learners will develop foundational skills in Oracle Database 12c, SQL querying, data filtering and sorting, functions, aggregation, joins, subqueries, DML operations, and DDL commands.
The course provides a practical foundation for further study in Oracle database development, SQL programming, reporting, and database administration.
The course introduces learners to key Oracle Database features and the fundamentals of retrieving, filtering, sorting, and presenting data using SQL statements.
Learners will explore single-row functions, conversion functions, conditional expressions, and aggregate functions to customise query output and summarise data.
Additional labs cover retrieving information from multiple tables using joins, working with subqueries, and managing table data through Data Manipulation Language (DML) statements.
The course also introduces Data Definition Language (DDL) for creating and modifying database structures.
The labs connect SQL concepts with practical database tasks, helping learners retrieve relevant information, combine related data, perform calculations, summarise results, and manage database records and structures.
Activities reinforce query accuracy, data organisation, and the effective use of SQL to interact with relational databases.
By completing the labs, learners will develop foundational skills in Oracle Database 12c, SQL querying, data filtering and sorting, functions, aggregation, joins, subqueries, DML operations, and DDL commands.
The course provides a practical foundation for further study in Oracle database development, SQL programming, reporting, and database administration.
Course Lessons
