Oracle SQL Developer - Full Course

Подписаться 20 тыс.

Просмотров 289 тыс.

50% 1

Learn the features that can help you work with your Oracle database better and faster
Oracle Tutorial | Oracle SQL Tutorial For Beginners ☞ morioh.com/p/cdd5588d4e8e
Oracle Foundations Associate Certification (PASS THE EXAM!) ☞ morioh.com/p/2e7316a54d06
MySQL Database - Full Course from Zero to Hero
☞ morioh.com/p/752aa713e91d
Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default.
If you are one of them, this course will help you get out of that group and start using Oracle SQL Developer more smartly.
Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you.
Learn the features that can help you work with your Oracle database better and faster:
Install and configure Oracle SQL Developer to run in your desired language and only with the features you need.
Create database connections and execute commands and scripts.
Display your results in a way that makes your work easier.
Use code templates and snippets to accelerate your work.
Export data in different formats and using different methods.
Some other useful and interesting things.
All Oracle SQL Developer features are free. Take advantage of them:
This course was created because there appears to be a pattern among Oracle SQL courses, regardless of the platform where they are taught: “If you are able to install it and connect to a database, you are good to go".
What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster in SQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs.
The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job.
Content and Overview:
The course includes more than 20 lectures, each one starting by showing you why you need it or how it can be helpful to you, and then proceeding to demonstrate how to enable it and/or use it.
There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about.
The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released.
Learn these tips and apply them to your work, and you will not only be well prepared to learn SQL or work with it smartly, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.
#oracel #sql #database
Video source via:

Опубликовано:

16 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 91

@awakened514 2 года назад

@48:40 Useful Shortcuts 1. Hotkey for SQL History is F8 or View>SQL History From here you can move previous queries into your worksheet or remove them. 2. ctrl+space hotkey to fill in queries as you type them for table or column names. 3. ctrl+g hotkey to jump to a specific line in your worksheet 4. shift+f4 on object name in worksheet to give a floating window with even more information than the DESCRIBE command. Using this hotkey on a stored procedure or function will give you its code in a new tab. 5. shift+f5 hotkey for moving to the next tab to your left. shift+alt+f5 hotkey for moving to the next tab to your right 6. ctrl+tab+tab (hold ctrl and press tab twice while continuously holding ctrl) will take you to your last tab. If you continue to hold ctrl after you have pressed tab twice you will get a list of all of your tabs so you can toggle through them with tab.

@awakened514 2 года назад

@53:12 Useful Shortcuts 2 ctrl+shift+' hotkey for toggling between UPPER, LOWER, and INITCAP on highlighted text in worksheet ctrl + / hotkey for commenting in or out your line or highlighted lines of code in worksheet alt + pagedown and alt+pageup hotkeys for moving between worksheet and results grid (very helpful for when copying and pasting results while running queries)

@awakened514 2 года назад

@55:52 Using HTML If you concatenate html tags into your select list so that they surround an expression, the output will actually provide an html output. Alternatively, you can just use the opening tags and leave out the closing tags in your concatenation and you will get the same result. This includes img tags with a src. An example: SELECT ''||table_name name, FROM cat; An interesting use case is that you can place html code into the 'Display Null Value as' bar located at Tools>Preferences then click Database and then click Advanced. This can allow you to display an html image for example when a NULL is present in your data.

@awakened514 2 года назад

@16:54 Using the Linegutter You can see your line and column at the bottom right of your SQL Developer window. Right click in your worksheet to the left of the dotted lines to turn on line gutter (toggle line numbers) Instead of trying to highlight a query with your mouse on the query text, start your click and drag at the line number in which your query begins and drag to highlight. If you go to Tools

@awakened514 2 года назад

@29:32 Exporting Data Simply highlighting the data and then using ctrl+c and pasting somewhere with ctrl+v does not give you the column header. Instead, if you use ctrl+shift+c, you will also copy the column headers. You can also right click on any selection of data and then click 'Export" and this will bring up the export wizard. You can then export as your data as insert, html, or pdf. HTML and INSERT are two examples that can be particularly useful in some use cases. Also, you can insert a /* csv */, /* html */, /* insert */ and other comments immediately before your column list in the SELECT list and then run a script in order to output in the format of your comment's keyword. You can use any keyword from the export wizard except pdf and excel. If you use a spool command followed by a file path immediately before a SELECT statement as per the paragraph immediately above this one, you can export this as a file on a machine. Finally, you can export a table by right-clicking it in the connections window and clicking export.

@awakened514 2 года назад

@1:02:51 Displaying Gauges Here is a hard-coded example (you can also do this dynamically since there is string involved): SELECT column_name1, 'SQL:GAUGE:::::', column_name2; In the above example, the min is the minimum value you want your gauge (a bar graph) to display and max is the maximum value. Low and High Threshold control where the bar graph will be colored to represent ranges of values in the low and high range and, if you leave an interval between the low and high threshold, there will be a third area colored in between the low and high threshold. values_the_gauge_needs is the expression you will use to feed the gauge values to display. For example: SELECT last_name, 'SQL:GAUGE:1:25000:2500:15000:' || salary, column_name2;

@SachinKumar-ct7tj 2 года назад

This is the best Oracle SQL tutorial 👍

@awakened514 2 года назад

@11:39 Disabling Unneeded Features Unneeded features affect application performance. Furthermore, it can affect security. Tools>Features Starting with Database, consider disabling the following: Data Miner Oracle OLAP APEX listener Admin. Change Management Database Cart RESTful Services Admin. Spatial Unit Test XML Schema Within Database Migrations, consider disabling the following: Everything (if you don't work with migrations) Within Version Control, consider disabling the following: Everything (but Data Modeler depends on Subversion so may not be able to disable it) Apply Changes Tools menu will be shorter

@girishdadi12 4 года назад

Simply Awesome, these are really helpful, thank you :)

@awakened514 2 года назад

@46:30 Navigation Filtering and Zebra Pattern Tools

@awakened514 2 года назад

@19:05 Formatting Code ctrl+f7 hotkey to auto format all of your code in your worksheet (or highlight specific query(-ies) first before using the hotkey to only format a select amount of code) You may not like the autoformat above so you can change the output of ctrl+F7 by doing the following: Tools>Preference: Click Database (or possibly Code Editor and, if so, then click 'Format' and then 'Advanced Format') Then click SQL Formatter and then Oracle Formatter.

@shobanbabu3692 3 года назад

Great, This is what i expected. Thanks 👌

@astrolite. Год назад

The energy you have is contageous! I was excited when you were

@prakashchakravarthyg 2 года назад

Excellent delivery of shortcuts

@awakened514 2 года назад

@8:53 Creating database connections Connection color important to consider 1521 is default port of the Oracle listener xe is default instance name of express edition test before save

@sriguduru1 2 года назад

Well explained! Thank you!

@josemicorrea4021 3 года назад

Awesome, amazing... Thank's a lot for share this!

@bellmorada Год назад

Thank you for all these tips! Awesome!

@SteveAMcPherson 2 года назад

This info was really helpful. Thanks!

@christianvegamontalvoSTREAM 3 года назад

AMAZING TUTORAL!!!

@dilludillsYT 4 года назад

Thank you. My respects to you Sir.

@vicolodo1 3 года назад

high recommend!!! Thank you!

@nitinkolte6657 5 лет назад

very useful info. Thanks!!!

@williamgarzon7031 5 лет назад

Useful information, thanks.

@xxllyyss 4 года назад

excellent tutorial.. why so less view? highly recommend!!!! thank you sir. God Job!!!!!

@mohd.golamhossain6536 Год назад

Sir, your presentation and selected topics for the video is really really great. Hats off. Thank you for the video.

@juno7893 3 года назад

Wow! 👏🏻👏🏻👏🏻 Great video sir.

@raghud541 2 года назад

Thank you so much, it was very useful.

@vigneshiyer5723 3 года назад

❤️❤️ Awesome explanation.

@alfredsfutterkiste7534 3 года назад

Awesome mate. just awesome.

@saidaouyous861 7 месяцев назад

what an amazing course thanks man 👏

@awakened514 2 года назад

@14:30 Executing Commands and Scripts ctrl+enter hotkey for 'run statement' A script is when you want to run two or more statements consecutively in one shot instead of individually. F5 hotkey for 'run script' You can reference an external script (one that is not present within your worksheet) by using: @[then path to the file present on your maching].sql

@pravinkumar-ug8bg 3 года назад

Thank you very much

@samreenshaikh6712 3 года назад

Great👍...thanks for sharing this information

@aydinbaysoz Год назад

Hello, I can not cennect to database. Where did you create username and passwrd? Thank you!

@venukuchipudi9861 4 года назад

Very good explanation

@fatemehghasemi8901 11 месяцев назад

Great video!

@markharsh1204 2 года назад

Excellent!

@murathp07 3 года назад

Wonderful set of tips and tricks, but I have a question about SQL Editor Code Templates in Version 19.2.1.247 of SQL developer. Even though I tried to do a ssfw and parameterized it, it is not working the same way as you have shown us in this video with older version. I am unable to jump between parameters via Tab and I need to use my mouse to actually point over each parameter and manually fill it... Do you know what might have changed with the newer version of the SQL developer...? Thanks.

@zeroxcrusher Год назад

You can also use F9 to execute statements instead of ctr + enter

@alexandredossantossilva166 4 месяца назад

Thanks by the tips!

@ayoubanbara2021 3 года назад

Thank you

@muneerhasan5822 Год назад

Thanks , it's very useful

@IndianYakker 3 года назад

Thanks a ton

@anwar6971 2 года назад

Good explanation

@danayoung4460 Год назад

Great lecture, thank you so much for your work! I have a question, when I use oracle sql at work, why tables showing filtered and not showing? How to make them appear?

@alexeymatveev9031 Год назад

great video thanks

@DWEthiopia 2 года назад

Why does everyone skip the part of creating the local database?

@cookiemonster1379 Год назад

This one worked for me: how to set up server: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GUpvXMHqe2U.html

@theslammer1999 Год назад

You tell

@awakened514 2 года назад

@42:00 Generating Relational Diagrams First of all, you can see the details of a table by finding it in the connections window and clicking on it. Alternatively, a hotkey for this is to hold down ctrl while clicking on the table's name within the worksheet window. Within this details window there are a number of tabs that are helpful. Clicking on the 'model' tab will provide a relational diagram of the given table and right clicking on one of the tables in this diagram will provide the option to 'show parent and child tables' which brings other tables that depend on that table into the diagram. Another way to make a relational diagram is to click ViewImport>Data Dictionary and then clicking the connection you want and the objects you want to include. Finally you can click File>Data Modeler>Print Diagram in order to create a file with your diagram for printing.

@zhengpeishannam2906 3 года назад

非常好！

@pavanghai 3 года назад

I like this video, thanks a ton for taking effort. Is it possible for new video using toad for oracle?

@jsp2518 2 года назад

I have been using this video each time I wanna setup SQL since 2019 lmao

@minpandey5188 3 года назад

cool. It is awesome.

@awakened514 2 года назад

@24:15 Displaying NULLs in a special way Tools>Preferences Then click 'Database' and then 'Advanced' Choose a color from the drop down 'Display Null Using Background Color'

@vicolodo1 3 года назад

hello, very good teacher....does exist an oracle sql course from same teacher?

@ahmed512 Год назад

Hello, i'm using a MacOS but never manage to make Oracle SQL Dev. tool working on it... i always get an error message when trying to add a DB. Like this: "The Network Adapter could not establish the connection"

@imranknight6659 Год назад

I keep getting error. The network adapter could not establish the connection.

@kingstonXavier-pn2gx 2 месяца назад

I had sql developer tool working like a charm for years. Recently I got a new laptop and got sql developer installed and now it became too slow and it takes almost 30 minutes to run a simple select query. Do you see any configuration change could fix this issue?

@coolcha 3 месяца назад

Are connections actually separate databases - i.e. if I make a table in one connection, it doesn't seem to show up in another connection?

@jagritisarkar2362 Год назад

How do I connect to an existing connection? I am failing to do so.

@bhoopathyp2339 2 года назад

I couldnt able to use spool and /*CSV*/* from Sql developer. Do i need to change any settings?

@alladivamshikrishna228 4 года назад

HI. CTRL+SPACE IS NOT WORKING WHEN WE ARE USING TEMPLATES.

@sahayavinodh Год назад

Is a way to write a script for Data Pump Export in Oracle SQL developer?

@sidnayak4395 Год назад

Hi, How did you find out the Username and Password to connect to local host?

@bentatlim 2 года назад

Hello, how can i just run a simple SQL Statement like " select getdate() "? The system show me a error "FROM is missing" . But Why

@user-lh6xe3zi1t 11 месяцев назад

How can I increase the buttons and the code line???

@joshuaperez8692 2 года назад

why when i press CTRL + SPACE. II still reamis ? my query goes wrong because that. regards,

@optimistic_guy313 2 года назад

Hello Sir, I can't connect to the database like you showed. What is the password you entered? I entered the password of my oracle acc. Still unable to connect t9 database. Any other way to connect to local database?

@imranashrafofficial. 3 месяца назад

Can anyone tell me which password should I use? I am beginner have no idea... I try but error came!

@beteewketeducation5099 2 года назад

how to fix ORA-01017 invalid username/password; logon denied problem

@onlinesaidasa9105 2 года назад

Namaste Oracle is offering free OCI database certifications till 28-Feb-2022

@mutharakeshvarma1811 9 месяцев назад

For creating "sys" connection what is the password

@francismwamba5759 Месяц назад

how can i solve this error ? Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=GjNCEiZvSz67JdYsugt2/Q==)

@anwar6971 2 года назад

Having problem with my databases using other databases fields

@pjmclenon 2 года назад

hello my username and password work on the cli but not on sql developer plz answer ok

@bhavyar2986 Год назад

Is PL/SQL alternate to Oracle SQL Developer?

@rajulgupta3614 Год назад

What is the password how we can get the password of any connection no one is showing the full method to create a connection

@sooieese 9 месяцев назад

11:36

@pavansharma7944 2 года назад

This is a my SQL course or oracle SQL 19 c

@ferreira926 9 месяцев назад

Thanks for the tips, its helps a lot! I commented because I can't gave you 2 likes....lol

@manishamurmu6328 2 года назад

Where can we get username and password.Do we have to put randomly any username and password or we have to create it from somewhere!Please sir help me out