Skip to main content

Oracle SQL

How do I start learning Oracle SQL?

Always prefer to start learning Oracle SQL with Oracle Database Express Edition (Oracle XE database) having installed on your laptop. XE database is limited to use minimum computed resources like 2GB RAM, 2 CPUS for foreground processes and 12GB for user data on disk and can be used it for free even in production. Lot of SQL and PLSQL can be learnt/practiced on XE database. 

How to install Oracle XE on local?

Here we are using Oracle Database 21c Express Edition.

  • Search for oracle XE database in google and download latest Oracle Express Edition database based on your operating system. In our practice we downloaded Oracle Database 21c Express Edition for Windows 64-bit operating system (OracleXE213_Win64.zip file is downloaded).
  • Unzip OracleXE213_Win64.zip file on local disk.
  • After unzip go into extracted folder and Run as Admin or double click on Setup.exe.
  • Click yes on popup shown to make changes on device. Then below screen will be appeared.
  • Click next and accept agreement and click next.
  • Choose the path for XE binaries installation and click next.
  • Enter and confirm password for SYS, SYSTEM & PDBADMIN schemas. Will be helpful for administering the database.
  • Click next and install.
  • Click Finish. XE is successfully installed.

How to interact with Oracle database?

In market many tools like Toad, PLSQL developer, SQL developer etc. are available to interact with Oracle database. 

Oracle SQL Developer is a free provided by Oracle, is an integrated development environment that simplifies the development or management of Oracle Database.

  • Download latest version for SQL Developer with JDK from Oracle website and extract on local disk.
  • Double click on sqldeveloper.exe and open SQL Developer.
  • Make a new connection on SQL developer. Right click on Oracle connections -> New connection. Enter details as shown below and create connections.

Note - Password will be same as mentioned during XE installation for SYS.

Once the connection is created open a new work sheet and create workspace.

alter session set container=xepdb1;

Create user SQLPRACTISE identified by XXXXX;
grant dba to SQLPRACTISE;

Comments

Post a Comment

Popular posts from this blog

Oracle Database SQL Certified Associate Certification (1Z0-071)

  Is the oracle database sql certification worthy ? Get geared up to build up some notably marketable programming skills. You can not hold in thoughts yourself a complete developer until you have knowledge of SQL(Structured Query Language). With more data available than ever is hot topic in technology and fact is that data is the biggest asset of the companies. All RDBMS databases require the knowledge of SQL to store and retrieve data. Salaries for junior SQL Developers are getting paid of $70,000 - $90,000 dollars per a year. Oracle Database SQL Certified Associate (1Z0-071) Exam Test - 1Z0-071 will be a 2 hours long exam and will have 78 multiple choice questions which needs correct answer should be chosen. Required score for 1Z0-071 is 63%. The 1Z0-071 tests scope of knowledge with the SQL programming language and requires ability of understanding of using SQL to achieve certain things in a database. How much does the Oracle Database SQL Certified Associate Exam Cost? Oracle D...
Post a Comment
Read more

Oracle Database SQL Certified Associate (1Z0-071) Exam Topics

Oracle Database SQL Certified Associate (1Z0-071)   Exam Topics  - Relational Database concepts Explaining the theoretical and physical aspects of a relational database Relating clauses in SQL Select Statement to Components of an ERD Explaining the relationship between a database and SQL Retrieving Data using the SQL SELECT Statement Using Column aliases Using The SQL SELECT statement Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Using Arithmetic expressions and NULL values in the SELECT statement Restricting and Sorting Data Applying Rules of precedence for operators in an expression Limiting Rows Returned in a SQL Statement Using Substitution Variables Using the DEFINE and VERIFY commands Sorting Data Using Single-Row Functions to Customize Output Manipulating strings with character functions in SQL SELECT and WHERE clauses Performing arithmetic with date data Manipulating numbers with the ROUND, TRUNC and ...
Post a Comment
Read more