SQL For Databases : A Beginner's Quick Introduction

SQL For Databases : A Beginner's Quick Introduction, available at $19.99, has an average rating of 4, with 30 lectures, 1 quizzes, based on 167 reviews, and has 10953 subscribers.

You will learn about 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 ideal for individuals who are Anyone who wants to learn or Students or IT Professionals or Developer or System Analysts or Business Analysts or Internet Marketers or Project Managers or App Developers or Web Developers It is particularly useful for Anyone who wants to learn or Students or IT Professionals or Developer or System Analysts or Business Analysts or Internet Marketers or Project Managers or App Developers or Web Developers.

Enroll now: SQL For Databases : A Beginner's Quick Introduction

Summary

Title: SQL For Databases : A Beginner's Quick Introduction

Price: $19.99

Average Rating: 4

Number of Lectures: 30

Number of Quizzes: 1

Number of Published Lectures: 30

Number of Published Quizzes: 1

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $79.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone who wants to learn
Students
IT Professionals
Developer
System Analysts
Business Analysts
Internet Marketers
Project Managers
App Developers
Web Developers

Target Audiences

Anyone who wants to learn
Students
IT Professionals
Developer
System Analysts
Business Analysts
Internet Marketers
Project Managers
App Developers
Web Developers

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

Course Curriculum

Chapter 1: Oracle 18c Setup

Lecture 1: Install Oracle 18c

Lecture 2: SQLPlus

Lecture 3: Unlock Sample Schema on Oracle 18c

Lecture 4: Install Oracle Developer

Lecture 5: Connect to Oracle with SQL Developer

Chapter 2: Structured Query Language

Lecture 1: Introduction

Lecture 2: Database Concepts

Lecture 3: Required Software

Lecture 4: Oracle 11g Express Database Download

Lecture 5: Oracle 11g Database Installation

Lecture 6: Unlocking Oracle Database Sample HR Schema Account

Lecture 7: Toad For Oracle Download

Lecture 8: Toad For Oracle Installation

Lecture 9: Connecting Toad To Oracle Database

Lecture 10: Toad For Oracle Quick Tour

Lecture 11: Suggested Guidelines For Writing SQL Querries

Lecture 12: Using SQL Create Command To Create a Database Table

Lecture 13: Creating a Sequence

Lecture 14: Creating SQL Views

Lecture 15: Adding Data into a Database using SQL INSERT

Lecture 16: The Importance of the WHERE Clause

Lecture 17: Changing existing Database Data By Using SQL UPDATE

Lecture 18: Removing Database Records Using SQL DELETE

Lecture 19: Retrieving Data Using SQL SELECT Statement

Lecture 20: Sorting Data with ORDER BY

Lecture 21: Restricting and Sorting Data from a Database

Lecture 22: Using SQL COUNT Function

Lecture 23: Using SQL DISTINCT Keyword

Lecture 24: Viewing a Table Structure with SQL Describe

Lecture 25: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 7 votes
2 stars: 3 votes
3 stars: 20 votes
4 stars: 64 votes
5 stars: 73 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu