Embark on a comprehensive Oracle SQL tutorial designed for beginners, covering essential topics from basic concepts to advanced database management techniques. Learn to create tables, set up Oracle, understand the relational model, and master various SQL elements including operators, functions, clauses, and joins. Explore nested queries, SQL commands, and database objects while gaining practical skills in data manipulation, retrieval, and storage. By the end of this 3.5-hour tutorial, develop a solid foundation in SQL programming and its application in managing relational databases effectively.
Overview
Syllabus
Agenda.
Introduction.
Creation of Table.
Oracle Setup and Installation.
Relational Model.
Miscellaneous topics.
Operators as keywords.
Functions.
Clauses.
Nested Query.
Joins.
SQL Commands.
Database Objects.
Summary.
Taught by
Great Learning
