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.
This course is a beginners introduction to SQL which stands for structured query language. It is the language used to communicate and manipulate databases.
In this course you will learn to C.R.U.D using SQL. C.R.U.D is an acronym for Create,Read,Update and Delete. These are the main functions that SQL can do on any database. There are other related tasks that SQL does or can do but the bulk of what it is used for is C.R.U.D.
The course is 100% video lectures structured in an orderly and easy to follow manner. It is advisable that you follow the course in the order of the lectures. The course is just under two hours long.
This course will give you the knowledge required to create ,read ,update and delete data from any database system using SQL. This is possible because SQL is a standard language and will perform C.R.U.D in the same way regardless of the type of database. This course will help you understand How to manipulate databases using SQL. Also you will learn how to retrieve only relevant data or information you need and order them in the way you want.
What you will Learn in this course includes :
How to write SELECT statements
How to create a table and a view
How to Update existing records in a database
How to Insert or add new records or data into a database.
How to delete a record from a database table
How to create a database report and export to excel
How to restrict and sort data returned by the SELECT query
How to use the WHERE Clause to filter data
How to use ORDER BY Clause to put retrieved data in order specified by table column
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Structured Query Language|
Oracle 11g Express Database Download
Oracle 11g Database Installation
Unlocking Oracle Database Sample HR Schema Account
Toad For Oracle Download
Toad For Oracle Installation
Connecting Toad To Oracle Database
Toad For Oracle Quick Tour
Suggested Guidelines For Writing SQL Querries
Using SQL Create Command To Create a Database Table
Creating a Sequence
Creating SQL Views
Adding Data into a Database using SQL INSERT
The Importance of the WHERE Clause
Changing existing Database Data By Using SQL UPDATE
Removing Database Records Using SQL DELETE
Retrieving Data Using SQL SELECT Statement
Sorting Data with ORDER BY
Restricting and Sorting Data from a Database
Using SQL COUNT Function
Using SQL DISTINCT Keyword
Viewing a Table Structure with SQL Describe
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.