Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SQL For Databases : A Beginner's Quick Introduction to your Wishlist.

Add to Wishlist

SQL For Databases : A Beginner's Quick Introduction

Learn how to use SQL to write queries to Create,Read,Update and delete data from a database.
4.4 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,532 students enrolled
Last updated 10/2015
$10 $90 89% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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

Who is the target audience?
  • Anyone who wants to learn
  • Students
  • IT Professionals
  • Developer
  • System Analysts
  • Business Analysts
  • Internet Marketers
  • Project Managers
  • App Developers
  • Web Developers
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn to use SQL to execute queries against a database
Learn to use SQL to retrieve data from a database
Learn to use SQL to insert records in a database
Learn to use SQL to update records in a database
Learn to use SQL to delete records from a database
Learn to use SQL to create new table in a database
Learn to download and install oracle database
Learn to connect to oracle database using TOAD
View Curriculum
  • Internet Connection
Curriculum For This Course
Expand All 24 Lectures Collapse All 24 Lectures 02:19:45
Structured Query Language
24 Lectures 02:19:45

Required Software

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

20 questions
About the Instructor
4.2 Average rating
849 Reviews
22,886 Students
57 Courses
Learning made simple

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.

Report Abuse