4 out of 5
4
84 reviews on Udemy

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.
Instructor:
Bluelime Learning Solutions
2,732 students enrolled
English [Auto]
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

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

Structured Query Language

1
Introduction
2
Database Concepts
3
Required Software
4
Oracle 11g Express Database Download
5
Oracle 11g Database Installation
6
Unlocking Oracle Database Sample HR Schema Account
7
Toad For Oracle Download
8
Toad For Oracle Installation
9
Connecting Toad To Oracle Database
10
Toad For Oracle Quick Tour
11
Suggested Guidelines For Writing SQL Querries
12
Using SQL Create Command To Create a Database Table
13
Creating a Sequence
14
Creating SQL Views
15
Adding Data into a Database using SQL INSERT
16
The Importance of the WHERE Clause
17
Changing existing Database Data By Using SQL UPDATE
18
Removing Database Records Using SQL DELETE
19
Retrieving Data Using SQL SELECT Statement
20
Sorting Data with ORDER BY
21
Restricting and Sorting Data from a Database
22
Using SQL COUNT Function
23
Using SQL DISTINCT Keyword
24
Viewing a Table Structure with SQL Describe
25
SQL QUIZ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4
4 out of 5
84 Ratings

Detailed Rating

Stars 5
41
Stars 4
29
Stars 3
10
Stars 2
0
Stars 1
4
b8947e4aca401e47831c02fcf629e407
Course available for 2 days
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW