The Complete Oracle SQL course for Data Analysts -A-Z of SQL – Free Udemy Courses

Oracle database is one of the world’s top and most widely used relational database management systems.

This more advanced beginners course will teach you how to retrieve data from an oracle database.

We will start by downloading and installing oracle database 21c express which is free to use.

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986 and the International Organization for Standardization (ISO) in 1987

What Can SQL do?

1. SQL can execute queries against a database
2. SQL can retrieve data from a database
3. SQL can insert records into a database
4. SQL can update records in a database
5. SQL can delete records from a database
6. SQL can create new databases
7. SQL can create new tables in a database
8. SQL can create stored procedures in a database
9. SQL can create views in a database
10. SQL can set permissions on tables, procedures, and views
11. SQL is a Standard – BUT…

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to comply with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) similarly.

Note: Most SQL database programs also have their proprietary extensions in addition to the SQL standard!