About This Course:
Welcome to the course, The Complete Oracle SQL Course For Beginners.
This course introduces SQL, which is an acronym for 'Structured Query Language', to its students. This is based on Oracle's SQL implementation for Oracle Databases. The lessons are based on Oracle 12c Database and SQL Developer Tools running in Windows 10.
This course may help you in taking a step towards..
About the Name of this Course:
When I started out to create this course, I wanted to create a Beginner Level Oracle SQL course. So I named it as 'SQL Development for Beginners'.
However as I progressed, I decided to make it much more comprehensive and cover most of the topics in the curriculum of Oracle SQL exam 1Z0-071. And so I renamed it to, 'Oracle SQL: Oracle Database 12c SQL Certified Associate'.
So, this course starts with Beginner Level lessons and progresses into next levels.
SQL is used to interact with Database Systems. As per ANSI (American National Standards Institute), SQL is the standard language for Relational Database Management Systems.
SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.
About Oracle Database:
Oracle Database is one of the prominent Database Systems in the RDBMS (Relational Database Management Systems) segment. Some of the other prominent Database Systems are
How to download Oracle 12c software from Oracle's Website and install it in you Windows PC or a Windows Laptop.
Questions about Oracle Installation
This lecture explains about how to connect to a Oracle Database using SQL Developer. Oracle SQL Developer is a tool provided for Oracle, to interact with Oracle Databases. Oracle SQL Developer tool can be used to develop programs for Oracle Database.
The lecture explains about Client Server Architecture. Client Server architecture is a two system architecture where one system serves as a Server or a provider while the other acts as the client or consumer.
This lecture explains about connecting to an Oracle Database.
Hands-on lab: Connect as SYSDBA
LAB - Hands on with connecting as SYSDBA
This hands-on lecture explains about Stopping an Oracle Database.
LAB - Hands on with Stopping an Oracle Database
Explains about starting an Oracle Database.
Hands on with Starting an Oracle Database
This lecture explains about a Table.
This lecture explains about Data Types
The lecture explains the basics of a SELECT statement
Explains about DESCRIBE command which is used to get the Column level information of a Table.
LAB work on DESCRIBE Command
This lecture explains about how to find the total row count of a Table.
LAB for SELECT COUNT syntax
Explains about DBA_TABLESPACES
SELECT and understand the data from DBA_TABLESPACES
Around 20 years of IT and Database Support experience.
* Expert in Systems Administration, Database Administration, Systems Integration, IT Operations Mgmt, Business Management, IT Consulting and Business Development.
* Hobbies include Social Networking, Music Composition, Reading and Writing.
Specialties:IT Support, Client Support, Client Management, Database Support. Infrastructure Management, Project Management, Business Development, IT Solutions Management, Team Management and Customer Care.