| 001 1_basic_select, describe, projection.mp4 | 20.3 MB | ||
| 001 Introduction to sql functions.mp4 | 20.4 MB | ||
| 001 Introduction.mp4 | 19.2 MB | ||
| 001 Multiple Row subqueries.mp4 | 30.5 MB | ||
| 001 Trunc and Round functions.mp4 | 18.1 MB | ||
| 001 Where Clause.mp4 | 16 MB | ||
| 001 intro current_date and sysdate.mp4 | 21.2 MB | ||
| 001 introduction to subqueries.mp4 | 50.8 MB | ||
| 001 introduction.mp4 | 20.3 MB | ||
| 001 max, min, avg, sum group functions.mp4 | 39.4 MB | ||
| 001 natural join clause.mp4 | 46.2 MB | ||
| 001 nvl, nvl2, nullif, coalesce functions.mp4 | 59.6 MB | ||
| 002 2_arithmetics, null, column alias, concatenation and distinct.mp4 | 53 MB | ||
| 002 Definitions.mp4 | 44.5 MB | ||
| 002 IN and LIKE operators.mp4 | 37.3 MB | ||
| 002 Multiple column subqueries.mp4 | 28.1 MB | ||
| 002 UNION operator.mp4 | 38.1 MB | ||
| 002 arithmetic with dates.mp4 | 23.4 MB | ||
| 002 character single row functions.mp4 | 20.5 MB | ||
| 002 count function.mp4 | 13.8 MB | ||
| 002 decode and case functions.mp4 | 41.4 MB | ||
| 002 mod, abs, ceil, floor, cos, power, sqrt.mp4 | 10.5 MB | ||
| 002 single row subqueries labs.mp4 | 28.6 MB | ||
| 002 to_char, to_date, to_number functions.mp4 | 88.1 MB | ||
| 002 using clause.mp4 | 58.5 MB | ||
| 003 CONCAT and SUBSTR.mp4 | 35.6 MB | ||
| 003 NULL and LOGICAL operators.mp4 | 55.3 MB | ||
| 003 UNION ALL operator.mp4 | 31.1 MB | ||
| 003 What is structured query language_.mp4 | 27.4 MB | ||
| 003 group by and having clause.mp4 | 76.8 MB | ||
| 003 having clause.mp4 | 35.7 MB | ||
| 003 months_between, add_months, next_day, last_day functions.mp4 | 41.9 MB | ||
| 003 on clause.mp4 | 29.1 MB | ||
| 004 INTERSECT-MINUS operator.mp4 | 51.1 MB | ||
| 004 Recap.mp4 | 87.1 MB | ||
| 004 SQL development environment.mp4 | 4.1 MB | ||
| 004 TRIM single row functions.mp4 | 21.4 MB | ||
| 004 n-way join clause.mp4 | 23.3 MB | ||
| 004 round and trunc with dates.mp4 | 22.3 MB | ||
| 005 REPLACE single row functions.mp4 | 13 MB | ||
| 005 hr-schema.mp4 | 44.9 MB | ||
| 005 self and non-equijoins clause.mp4 | 53.5 MB | ||
| 006 INSTR single row function.mp4 | 21.3 MB | ||
| 006 outer joins.mp4 | 35.9 MB | ||
| 007 LPAD, RPAD AND LENGTH single row functions.mp4 | 17.6 MB | ||
| 007 cross join.mp4 | 19.3 MB | ||
| 008 Dual table.mp4 | 10.1 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 50 total files | |||
21c Oracle SQL Hands on Training
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 48 lectures (5h 6m) | Size: 1.35 GB
A complete guide to Oracle exam 1Z0-071 with extreme hands on videos and labs
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.
Data analytics spans every aspect of business, from research and development to marketing, accounting, and beyond. And data analytics would be impossible without the efficient querying of the massive databases holding the data.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.1 GB | freecoursewb | 4 years | 0 | 0 | |
| 3.3 GB | freecoursewb | 4 years | 0 | 0 | |
| 2.6 GB | freecoursewb | 4 years | 2 | 0 |
All Comments