Practical SQL with Oracle Database 18c
What you'll learn
- Install Oracle 18c Database Server
- Unlock sample hr schema
- Install Oracle SQL Developer
- Connect to Oracle using SQL Developer
- Basic Database Concepts
Course content
- Preview01:19
- Preview03:38
- Preview07:59
- 03:23What s SQLPlus
- 05:29Unlock Sample Schema
- 05:49Install Oracle Developer
- 04:27Connect to Oracle Database
- 08:57Database concepts
Requirements
- Oracle 18c Database ( The course covers the installation)
- SQL Developer ( The course covers the installation)
Description
SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write queries for Oracle databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.
SQL Skills will greatly improve your job prospects either as a contractor
or full time employment. It is a useful skill that is always in demand .
Oracle is one of the top database management systems used in the world by companies of various sizes in a variety of sectors.
There is so much data in the world today and the volume is growing each day. SQL is the language used to interrogate and interact with various types of databases.
This is a practical hands on video based course designed for beginners to learn practical SQL skills that can be used across multiple databases.
You will Learn how to :
Download and install Oracle Database
Install SQL Developer
Connect to Oracle Database
How to create a database table
How to use count aggregate function
Updating exiting records in database
How to add new records into database
How to delete records from database
How to generate reports based on certain conditions.
Who this course is for:
- Beginners to SQL with Oracle Databases
Instructor
![Bluelime Learning Solutions](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 17,289 Reviews
- 405,780 Students
- 221 Courses
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.