Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Data is so vital and we interface with it in our daily lives.
Data is stored in databases which in turn stores the data in tables that contains rows and columns.
There are several database applications available to handle the storage and management of data examples include Oracle, Microsoft SQL and MySQL. We need a way to communicate with these database applications and the language used in doing that is SQL which stands for structured query language.
This course is a hands-on practical course that will build your confidence using SQL. All the queries used in this course are from a real world live production environment except that the table’s database and schema are different.
This course is video based and under 2 hours long with easy to follow real world query examples.
The example real world queries in this course includes:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Setting up Database Environment|
Download Oracle DatabasePreview
Installing Oracle DatabasePreview
Unlocking Hr Schema
Installing Java JDK8
Oracle SQL Developer Download
Installing Oracle SQL Developer
Launching Oracle SQL Developer
|Section 2: Using real world SQL Examples queries on an Oracle Database|
How to get the total count of employees in a company
How to update employee salaries in a company after a pay increase
How to produce a report of unique salaries in a company
How to produce a report of people with same job titles in a company
How to produce a report with a specified criteria
How to produce a salary report
How to produce a report of employees with no managers
Adding new record into a database
Creating a new Table
Deleting a record from a table
How to determine number of employees
How to produce a report of hire date
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.