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 (24 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,525 students enrolled
$19
$90
79% off
Take This Course
  • Lectures 24
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course Description

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

What are the requirements?

  • Internet Connection

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Structured Query Language
Introduction
Preview
06:42
Database Concepts
Preview
03:50
Required Software
02:11
Oracle 11g Express Database Download
04:58
Oracle 11g Database Installation
04:47
Unlocking Oracle Database Sample HR Schema Account
05:09
Toad For Oracle Download
03:36
Toad For Oracle Installation
04:08
Connecting Toad To Oracle Database
05:21
Toad For Oracle Quick Tour
05:41
Suggested Guidelines For Writing SQL Querries
04:09
Using SQL Create Command To Create a Database Table
10:37
Creating a Sequence
04:56
Creating SQL Views
11:02
Adding Data into a Database using SQL INSERT
07:24
The Importance of the WHERE Clause
05:48
Changing existing Database Data By Using SQL UPDATE
06:04
Removing Database Records Using SQL DELETE
04:19
Retrieving Data Using SQL SELECT Statement
10:18
Sorting Data with ORDER BY
08:44
Restricting and Sorting Data from a Database
05:43
Using SQL COUNT Function
05:55
Using SQL DISTINCT Keyword
05:05
Viewing a Table Structure with SQL Describe
03:18
SQL QUIZ
20 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bluelime Learning Solutions, 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.

Ready to start learning?
Take This Course