October 25, 2024 at 10:59 pm
I am a new student to learn Sql syntax. Is there any skills I need to master first?
October 26, 2024 at 11:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 28, 2024 at 2:26 pm
Yes, Oracle is extremely difficult to learn. Their syntax is overall an odd mix of SQL style and earlier language styles.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
October 28, 2024 at 4:48 pm
Oracle isn't the easiest database to learn sql on but they do have an online course Oracle Database 19c: SQL Fundamentals https://learn.oracle.com/ols/home/sql-and-plsql-fundamentals/88387
November 1, 2024 at 8:59 am
I would say that Oracle is no harder to learn than any dialect of any language. In other words you should learn enough on day one to say hello, but not enough to ask what the weather is likely to be tomorrow.
Just keep learning and keep doing. Remember always you are learning a dialect of a language (in this case SQL) and other systems such as SQL Server and PostgreSql have different dialects. Different dialects mean most things that look the same will do the same, but some will do something different. And each dialect has its own unique words, some of which do thing you already know using a different word and some do things new to you.
As to which dialect is best, the answer is 'it depends'. If you are in an organisation using Oracle then knowing or being willing to pick up Oracle pl/SQL is critical. In a SQL Server shop then using the SQL Server dialect becomes what is needed. Also, running in-house or in the cloud or a mixture of these brings its own subtleties in what is best to do.
If you go further than using SQL, and go into Server management or architecture then again learning how to make your beast work the best is more important than knowing how to make some other beast work well.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply