Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - Complete guide to understanding Oracle SQL - Hands on course

Size
1.6 GB
Seeders
1
Leechers
0
Files
49
Category
Added
at 8:41pm GMT+1
Infohash
06151017856c7084110e5c5e3c2717ea61761fa5
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] Complete guide to understanding Oracle SQL: Hands on course



If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com







MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz

Language: English | Size: 1.64 GB | Duration: 5h 8m



The ultimate, complete with examples and hands on Labs SQL training plus guide to Oracle exam 1z0-071.



What you'll learn

What is SQL and its importance in databases

Access Oracle database and its development environment

Write efficient SQL queries to produce accurate reports

Understand the different types of SQL statements and how to use them.

Use of SQL Functions

Working with Subqueries

Working with Joins

Using set operators



Requirements

No prior SQL experience required, this is a comprehensive hands on training with easy to follow examples.

Description

These days, almost everyone has to work with data in some form or another. Usually it's through spreadsheets or databases, but if you can learn a little SQL, you can become so much more powerful in your job.



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

File list
  • Udemy - Complete guide to understanding Oracle SQL - Hands on course
  • ~Get Your Files Here !/01 - Introduction/001 Introduction.mp4 31.2 MB
  • ~Get Your Files Here !/01 - Introduction/002 Definitions.mp4 44.5 MB
  • ~Get Your Files Here !/01 - Introduction/003 What is structured query language.mp4 27.4 MB
  • ~Get Your Files Here !/01 - Introduction/004 SQL development environment.mp4 4.1 MB
  • ~Get Your Files Here !/01 - Introduction/005 hr-schema.mp4 44.9 MB
  • ~Get Your Files Here !/02 - Projection/001 1_basic_select, describe, projection.mp4 20.3 MB
  • ~Get Your Files Here !/02 - Projection/002 2_arithmetics, null, column alias, concatenation and distinct.mp4 53 MB
  • ~Get Your Files Here !/03 - Selection/001 Where Clause.mp4 48.1 MB
  • ~Get Your Files Here !/03 - Selection/002 IN and LIKE operators.mp4 37.3 MB
  • ~Get Your Files Here !/03 - Selection/003 NULL and LOGICAL operators.mp4 55.3 MB
  • ~Get Your Files Here !/03 - Selection/004 Recap.mp4 87.1 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/001 Introduction to sql functions.mp4 20.4 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/002 character single row functions.mp4 20.5 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/003 CONCAT and SUBSTR.mp4 35.6 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/004 TRIM single row functions.mp4 21.4 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/005 REPLACE single row functions.mp4 13 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/006 INSTR single row function.mp4 21.3 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/007 LPAD, RPAD AND LENGTH single row functions.mp4 17.6 MB
  • ~Get Your Files Here !/04 - SQL Single row Functions/008 Dual table.mp4 10.1 MB
  • ~Get Your Files Here !/05 - number single row functions/001 Trunc and Round functions.mp4 18.1 MB
  • ~Get Your Files Here !/05 - number single row functions/002 mod, abs, ceil, floor, cos, power, sqrt.mp4 10.5 MB
  • ~Get Your Files Here !/06 - Date single row functions/001 intro current_date and sysdate.mp4 21.2 MB
  • ~Get Your Files Here !/06 - Date single row functions/002 arithmetic with dates.mp4 23.4 MB
  • ~Get Your Files Here !/06 - Date single row functions/003 months_between, add_months, next_day, last_day functions.mp4 41.9 MB
  • ~Get Your Files Here !/06 - Date single row functions/004 round and trunc with dates.mp4 22.3 MB
  • ~Get Your Files Here !/07 - Conversion single row functions/001 introduction.mp4 35.7 MB
  • ~Get Your Files Here !/07 - Conversion single row functions/002 to_char, to_date, to_number functions.mp4 88.1 MB
  • ~Get Your Files Here !/08 - General single row functions/001 nvl, nvl2, nullif, coalesce functions.mp4 59.6 MB
  • ~Get Your Files Here !/08 - General single row functions/002 decode and case functions.mp4 41.4 MB
  • ~Get Your Files Here !/09 - Multiple Row functions/001 max, min, avg, sum group functions.mp4 39.4 MB
  • ~Get Your Files Here !/09 - Multiple Row functions/002 count function.mp4 13.8 MB
  • ~Get Your Files Here !/09 - Multiple Row functions/003 group by and having clause.mp4 76.8 MB
  • ~Get Your Files Here !/10 - Working with Joins/001 natural join clause.mp4 46.2 MB
  • ~Get Your Files Here !/10 - Working with Joins/002 using clause.mp4 58.5 MB
  • ~Get Your Files Here !/10 - Working with Joins/003 on clause.mp4 29.1 MB
  • ~Get Your Files Here !/10 - Working with Joins/004 n-way join clause.mp4 23.3 MB
  • ~Get Your Files Here !/10 - Working with Joins/005 self and non-equijoins clause.mp4 53.5 MB
  • ~Get Your Files Here !/10 - Working with Joins/006 outer joins.mp4 35.9 MB
  • ~Get Your Files Here !/10 - Working with Joins/007 cross join.mp4 19.3 MB
  • ~Get Your Files Here !/11 - Subqueries/001 introduction to subqueries.mp4 50.8 MB
  • ~Get Your Files Here !/11 - Subqueries/002 single row subqueries labs.mp4 28.6 MB
  • ~Get Your Files Here !/11 - Subqueries/003 having clause.mp4 35.7 MB
  • ~Get Your Files Here !/12 - Multiple Row subquery/001 Multiple Row subqueries.mp4 30.5 MB
  • ~Get Your Files Here !/12 - Multiple Row subquery/002 Multiple column subqueries.mp4 28.1 MB
  • ~Get Your Files Here !/13 - Set Operators/001 introduction.mp4 20.3 MB
  • ~Get Your Files Here !/13 - Set Operators/002 UNION operator.mp4 38.1 MB
  • ~Get Your Files Here !/13 - Set Operators/003 UNION ALL operator.mp4 31.1 MB
  • ~Get Your Files Here !/13 - Set Operators/004 INTERSECT-MINUS operator.mp4 51.1 MB
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents