Practical SQL Skills For Jobs | Businesses | Enterpreneurs

Learn SQL one of the most in demand IT skills requested by employers|SQL is useful to Businesses and Enterpreneurs
4.3 (8 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.
279 students enrolled
$19
$195
90% off
Take This Course
  • Lectures 80
  • Length 7.5 hours
  • Skill Level Intermediate 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 11/2015 English

Course Description

SQL is everywhere, and I'm not saying that because I want you to use it. It's just a fact. I bet you have some in your pocket right now. All Android Phones and iPhones.

SQL for several years and currently is the most in demand IT Skill requested by recruiters and employers. It is used anywhere there is a database present.

It runs banks, hospitals, universities, governments, small businesses, large ones, just about every computer and every person on the planet eventually touches something running SQL.

SQL is an incredibly successful and solid technology that has been around for years and will be here for a long time to come.

By learning SQL, you actually will learn important theoretical and practical concepts that apply to nearly every data storage system past and present .

SQL Skills will greatly improve your job prospects either as a contractor or full time employment. It is a useful skill that is always in demand due to its usefulness. It’s everywhere there is a database. The skills you learn on this course will be enough to confidently work as an SQL professional.

This is a practical hands on video based course with over 50 lectures and over 4 hours of content.

You will Learn how to :

· Manipulate Data from an oracle database table

· Modifying table contents

· Retrieve data with SELECT

· Remove rows with DELETE

· Protect data integrity with constraints

· Improve performance with indexes

· Add table rows with INSERT

· Change row content with UPDATE

· Sort the result with ORDER BY

· Create various types of Table Joins and get data from them

What are the requirements?

  • A Basic understanding of databases and exposure to information technology

What am I going to get from this course?

  • Learn how to create Database Tables
  • Learn how to create constraints on database Tables
  • Learn how to create Database Views
  • Learn how to modify Database Tables using SQL UPDATE Command
  • Learn how to retrieve data Database Tables
  • Learn how to join multiple tables and get data from them
  • Learn how to Apply conditions to filter retrieved rows
  • Learn how to Apply row and aggregate functions
  • Learn how to add new data into a table using the INSERT INTO SQL Command
  • Learn about Analytic functions
  • Learn how to implement sequences
  • Learn to delete records from a database
  • Learn to create reports using SQL

What is the target audience?

  • Students
  • Job Seekers
  • IT Professionals
  • Internet Marketers
  • Enterpreneurs
  • Businesses
  • New Web Developers
  • Business Analysts
  • Project Managers
  • System Analysts
  • Beginner Data Warehouse Administrator

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: Getting Started
Introduction
Preview
05:46
Database Concepts Part 1
Preview
04:31
Database Concepts Part 2
10:16
Java JDK T Download and Installation
05:24
Oracle SQL Developer Download
04:55
Oracle SQL Developer Installation
06:07
Launching Oracle SQL Developer
03:40
Oracle 11g Express Download
04:58
Oracle 11g Installation
04:47
Unclocking HR Schema and Accessing the Tables
05:09
Toad For Oracle Download
03:36
TOAD For Oracle Installation
04:08
Database Connection
05:21
Toad For Oracle Editor
05:41
Section 2: SQL SUB Languages
Introduction
03:05
DDL : Create Part 1
08:50
DDL: Create Part 2
08:03
DDL: Alter Truncate and Drop
08:38
DML: Insert
09:32
DML: Select
09:15
DML: Update and Delete
07:02
Aliases
07:47
Section 3: Getting Data From Multiple Tables Using Joins
Introduction
04:11
Equi Join
07:46
Non Equi Join
07:26
Cartesian Join
06:19
Outer Join
08:14
Self Join
09:53
Section 4: Aggregate Functions
Introduction To Aggregate Functions
01:38
AVG () Aggregate Functions
03:20
COUNT () Aggregate Function
04:40
MAX () Aggregate Function
03:13
MIN () Aggregate Function
02:48
SUM () Aggregate Function
07:17
Section 5: Analytic Functions
Introduction
06:43
Analytic Functions Syntax
04:07
Partition By Clause
08:04
Order By Clause
05:48
Windowing Clause
02:10
First and Last Functions
08:56
Row number Functions
09:26
Dense Rank Function
05:57
Lag Function
03:37
ListAgg Function
06:14
Lead Function
06:43
Rank Function
06:04
Section 6: SET Operators
Introduction
04:35
Union All SET Operator
02:53
uNION SET Operator
05:23
INTERSECT SET Operator
02:50
MINUS SET Operator
01:48
SET Operators Summary
03:31
Section 7: Reading Data
SQL Sub-Query
08:38
REMOVING DUPLICATES WITH SELECT DISTINCT
05:52
Restricting and Sorting Data
07:18
indexes
06:17
views
11:02
Synonyms
06:05
SQL NULL Value
07:51
Describe
03:18
Section 8: Oracle Database Single Row Functions
Introduction
00:59
Character Functions
07:50
Conversions
06:48
Date Functions
05:02
Numeric Functions
05:25
Section 9: SQL Clauses
SQL WHERE Clause
05:22
FROM Clause
02:51
Order By Clause
04:02
GROUP BY and HAVING Clause
07:35
LIKE Operator and WILD Card
09:18
Section 10: Logical Operators
Introduction
00:40
All Operator
04:01
Any Operator
04:01
NOT Operator
02:49
IS Null Operator
02:42
AND Operator
04:46
SQL IN Operator
04:48
OR Operator
04:12
Comparison Operators
07:43
Conclusion
02:11

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