Learn 130 SQL Statements in 20 Minutes
Vložit
- čas přidán 30. 07. 2019
- A whistle-stop tour of 130 SQL statements you can run in your database!
Want the scripts to play along yourself?
Find them on Live SQL livesql.oracle.com/apex/lives...
Looking for free tutorials on SQL?
Take Databases for Developers: Foundations devgym.oracle.com/pls/apex/dg...
Need help with SQL?
Ask us over on AskTOM: asktom.oracle.com
Twitter: / chrisrsaxon
Daily SQL Twitter tips: / sqldaily
All Things SQL blog: blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: devgym.oracle.com/
============================
The Magic of SQL with Chris Saxon
Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement. - Věda a technologie
this is such an excellent all-in-one SQL tutorial ... I bet anyone knows 80% of syntax can declare as a SQL master ... thank you!!!
Thanks, and yes. If you know 80% of what's in this video you're got strong SQL skills :)
Wooow.. It's like quick recall of every sql statements. Really appreciating your effort Chris .🥰
You're welcome! Glad you like it :)
And there's still a bunch more I didn't cover; maybe I'll have to do a follow-up ;)
Great Effort from Chris
Thanks!
Was really awesome. Thanks !!
You're welcome :)
Very usefull 20 minutes :) Thx
Good work.
What an awesome video!
Glad you enjoyed it!
Hey, Thank you for your videos, very helpful! Have you created any full courses?
Thanks David,
Yes, I've created a beginner's SQL tutorial:
devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html
And an intermediate follow-on:
devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html
I'm working on SQL performance tutorial; this will be ready "soon" ;)
@@TheMagicofSQL Thank you I will give them a try! I am currently working towards my second try at 1Z0-071. I am looking for ways to study the details and getting hands-on practice simultaneously! I find it so hard to remember each detail, any advice for this?
sir pls help me with the following
Complete the following query to return the total weight for each shape stored in the bricks table:
select shape, /* TODO */ shape_weight
from bricks
/* TODO */;
That looks like it's from one of the tutorials on my free SQL course!
If so, please submit questions about this on Oracle Dev Gym using the Feedback option (drop down in the top right) or discussion on the quiz itself
devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html