Oracle SQL Developer: Mastering its Features + Tips & Tricks

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

* List Price temporarily reduced from $74.99 to $19.99

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 customize SQL Developer in a way that works and feels best for you.

  • Take full advantage of the most useful features of the tool.

  • Create and share beautiful and interactive reports.

  • Take advantage of features that will make you more effective and efficient at work.

  • Learn a lot of tricks and enjoy being seen as an SQL Developer expert.


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 and the database community in general: “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, so that you can be more efficient and productive, and thus, stand out.


Content and Overview:

The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer.

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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.


Who this course is for:

  • Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition.
  • Aspiring application or database developers looking to work with Oracle databases.
  • Anyone taking or planning to take Oracle SQL or PL/SQL courses.
  • College/University students who need to learn and use SQL for Oracle to pass their database-related courses.

Expected Outcomes

  1. You will take advantage of many useful features that will make you more effective and efficient at work You will learn a lot of tricks and enjoy being seen as an SQL Developer expert You will learn how to create and share beautiful and interactive reports You will learn how to Install and customize SQL Developer in a way that works and feels best for you You will learn how to take full advantage of all the basic features of the tool Curated for the Udemy Business collection Requirements You will need a computer running Windows, Linux or Mac OS, in which you have the necessary privileges to install and run new programs Ideally you should have an Oracle database you can connect to, so that you can test all the tips and features demonstrated in the course, but it is not strictly necessary. Description * List Price temporarily reduced from $74.99 to $19.99 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 customize SQL Developer in a way that works and feels best for you. Take full advantage of the most useful features of the tool. Create and share beautiful and interactive reports. Take advantage of features that will make you more effective and efficient at work. Learn a lot of tricks and enjoy being seen as an SQL Developer expert. 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 and the database community in general: “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, so that you can be more efficient and productive, and thus, stand out. Content and Overview: The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer. 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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers. Who this course is for: Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition. Aspiring application or database developers looking to work with Oracle databases. Anyone taking or planning to take Oracle SQL or PL/SQL courses. College/University students who need to learn and use SQL for Oracle to pass their database-related courses. Show more Show less Course content 7 sections • 45 lectures • 3h 40m total length Expand all sections Introduction 2 lectures • 4min Course Structure and How to Take Advantage of it Preview 02:09 What this course IS and IS NOT 02:14 Program Installation 2 lectures • 5min Reminder: You need an Oracle Database Already Installed! Don’t have one? 00:22 Downloading and installing SQL Developer 04:22 Oracle SQL Developer Basics 5 lectures • 21min Introduction (SDB) 00:48 User Interface Basics Preview 03:25 Creating and Organizing Database Connections 06:23 Working with the Worksheet 04:58 Working with the Results’ Grid 05:20 Useful Customizations 7 lectures • 23min Introduction (UC) 00:40 Changing the Language 03:58 Disabling Features you Don't Need 02:31 Improving the way Data is Displayed 03:16 Advanced Code Formatting 07:13 Navigation Filtering 01:31 Customizing Fonts and Syntax Colors for Eye Comfort 03:49 Reports 8 lectures • 54min Introduction (R) 00:57 Predefined Reports Overview and Reports Basics 04:49 User-Defined Reports Basics 06:15 Master-Detail and Drill Down Reports 09:12 Gauge Reports 06:04 Chart Reports 11:09 Exporting and Sharing Reports Preview 07:24 A Final Reports' Trick 08:15 More Useful Features, Tips and Tricks 18 lectures • 1hr 35min Introduction (MUF) 00:36 Splitting Worksheets and Document Groups 05:55 Exporting data 07:07 Code Templates 03:43 Code Snippets 02:57 Taking Advantage of The Line Gutter 02:23 Performing Local Searches on Your Results 04:21 Testing Program Units Smartly 04:47 Debugging Program Units Smartly 13:15 Finding Database Objects 03:59 Getting Information about a Database Object 03:17 Oracle Folks Love Drag & Drop 04:38 Generating Relational Diagrams 04:37 Navigating Your Code 07:20 Performance Tuning Features 10:52 Displaying Gauges 03:25 Useful Tips and Shortcuts 1 06:21 Useful Tips and Shortcuts 2 05:36 Extras 3 lectures • 18min Using HTML in SQL and in preferences 05:23 Appendix 1: Installing Oracle Database Express Edition 18c On Windows 11:21 Bonus Lecture: Discounts for other courses 01:02 Instructor Carlos from Standout-Dev Academy Software Development Director & Chief Educator 4.6 Instructor Rating 6,179 Reviews 77,053 Students 2 Courses Carlos, founder of the Standout Dev Academy, is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for more than 20 years , and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for the last 18 years . His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time. He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites . In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy. If you are into software or database development, make sure to check out Standout Dev Academy's courses now . Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780faf71a625446',m:'dfbf4aec5f01fa1e2b7ff0efb21850561bba3174-1627840977-1800-AaeEBoNa6ikHeS5ycEgaklnGVkkDdwzKef8gS23+Uny9wIknsHHbZgPxAOaSmrgBvGfR8uxbIoZu32Kx2bmqDWnlnhFq6BWn/xw1vOSDZ3e5epWMnLFRHM4tzyG4aVEqVx+pLrxkaBKoymhR7K0+oqYE4Dl9ub5v/J72LWB1ns6S',s:[0x19467e7fcb,0x32ddc23cff],}})();
  2. You will learn a lot of tricks and enjoy being seen as an SQL Developer expert You will learn how to create and share beautiful and interactive reports You will learn how to Install and customize SQL Developer in a way that works and feels best for you You will learn how to take full advantage of all the basic features of the tool Curated for the Udemy Business collection Requirements You will need a computer running Windows, Linux or Mac OS, in which you have the necessary privileges to install and run new programs Ideally you should have an Oracle database you can connect to, so that you can test all the tips and features demonstrated in the course, but it is not strictly necessary. Description * List Price temporarily reduced from $74.99 to $19.99 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 customize SQL Developer in a way that works and feels best for you. Take full advantage of the most useful features of the tool. Create and share beautiful and interactive reports. Take advantage of features that will make you more effective and efficient at work. Learn a lot of tricks and enjoy being seen as an SQL Developer expert. 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 and the database community in general: “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, so that you can be more efficient and productive, and thus, stand out. Content and Overview: The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer. 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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers. Who this course is for: Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition. Aspiring application or database developers looking to work with Oracle databases. Anyone taking or planning to take Oracle SQL or PL/SQL courses. College/University students who need to learn and use SQL for Oracle to pass their database-related courses. Show more Show less Course content 7 sections • 45 lectures • 3h 40m total length Expand all sections Introduction 2 lectures • 4min Course Structure and How to Take Advantage of it Preview 02:09 What this course IS and IS NOT 02:14 Program Installation 2 lectures • 5min Reminder: You need an Oracle Database Already Installed! Don’t have one? 00:22 Downloading and installing SQL Developer 04:22 Oracle SQL Developer Basics 5 lectures • 21min Introduction (SDB) 00:48 User Interface Basics Preview 03:25 Creating and Organizing Database Connections 06:23 Working with the Worksheet 04:58 Working with the Results’ Grid 05:20 Useful Customizations 7 lectures • 23min Introduction (UC) 00:40 Changing the Language 03:58 Disabling Features you Don't Need 02:31 Improving the way Data is Displayed 03:16 Advanced Code Formatting 07:13 Navigation Filtering 01:31 Customizing Fonts and Syntax Colors for Eye Comfort 03:49 Reports 8 lectures • 54min Introduction (R) 00:57 Predefined Reports Overview and Reports Basics 04:49 User-Defined Reports Basics 06:15 Master-Detail and Drill Down Reports 09:12 Gauge Reports 06:04 Chart Reports 11:09 Exporting and Sharing Reports Preview 07:24 A Final Reports' Trick 08:15 More Useful Features, Tips and Tricks 18 lectures • 1hr 35min Introduction (MUF) 00:36 Splitting Worksheets and Document Groups 05:55 Exporting data 07:07 Code Templates 03:43 Code Snippets 02:57 Taking Advantage of The Line Gutter 02:23 Performing Local Searches on Your Results 04:21 Testing Program Units Smartly 04:47 Debugging Program Units Smartly 13:15 Finding Database Objects 03:59 Getting Information about a Database Object 03:17 Oracle Folks Love Drag & Drop 04:38 Generating Relational Diagrams 04:37 Navigating Your Code 07:20 Performance Tuning Features 10:52 Displaying Gauges 03:25 Useful Tips and Shortcuts 1 06:21 Useful Tips and Shortcuts 2 05:36 Extras 3 lectures • 18min Using HTML in SQL and in preferences 05:23 Appendix 1: Installing Oracle Database Express Edition 18c On Windows 11:21 Bonus Lecture: Discounts for other courses 01:02 Instructor Carlos from Standout-Dev Academy Software Development Director & Chief Educator 4.6 Instructor Rating 6,179 Reviews 77,053 Students 2 Courses Carlos, founder of the Standout Dev Academy, is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for more than 20 years , and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for the last 18 years . His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time. He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites . In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy. If you are into software or database development, make sure to check out Standout Dev Academy's courses now . Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780faf71a625446',m:'dfbf4aec5f01fa1e2b7ff0efb21850561bba3174-1627840977-1800-AaeEBoNa6ikHeS5ycEgaklnGVkkDdwzKef8gS23+Uny9wIknsHHbZgPxAOaSmrgBvGfR8uxbIoZu32Kx2bmqDWnlnhFq6BWn/xw1vOSDZ3e5epWMnLFRHM4tzyG4aVEqVx+pLrxkaBKoymhR7K0+oqYE4Dl9ub5v/J72LWB1ns6S',s:[0x19467e7fcb,0x32ddc23cff],}})();
  3. You will learn how to create and share beautiful and interactive reports You will learn how to Install and customize SQL Developer in a way that works and feels best for you You will learn how to take full advantage of all the basic features of the tool Curated for the Udemy Business collection Requirements You will need a computer running Windows, Linux or Mac OS, in which you have the necessary privileges to install and run new programs Ideally you should have an Oracle database you can connect to, so that you can test all the tips and features demonstrated in the course, but it is not strictly necessary. Description * List Price temporarily reduced from $74.99 to $19.99 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 customize SQL Developer in a way that works and feels best for you. Take full advantage of the most useful features of the tool. Create and share beautiful and interactive reports. Take advantage of features that will make you more effective and efficient at work. Learn a lot of tricks and enjoy being seen as an SQL Developer expert. 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 and the database community in general: “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, so that you can be more efficient and productive, and thus, stand out. Content and Overview: The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer. 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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers. Who this course is for: Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition. Aspiring application or database developers looking to work with Oracle databases. Anyone taking or planning to take Oracle SQL or PL/SQL courses. College/University students who need to learn and use SQL for Oracle to pass their database-related courses. Show more Show less Course content 7 sections • 45 lectures • 3h 40m total length Expand all sections Introduction 2 lectures • 4min Course Structure and How to Take Advantage of it Preview 02:09 What this course IS and IS NOT 02:14 Program Installation 2 lectures • 5min Reminder: You need an Oracle Database Already Installed! Don’t have one? 00:22 Downloading and installing SQL Developer 04:22 Oracle SQL Developer Basics 5 lectures • 21min Introduction (SDB) 00:48 User Interface Basics Preview 03:25 Creating and Organizing Database Connections 06:23 Working with the Worksheet 04:58 Working with the Results’ Grid 05:20 Useful Customizations 7 lectures • 23min Introduction (UC) 00:40 Changing the Language 03:58 Disabling Features you Don't Need 02:31 Improving the way Data is Displayed 03:16 Advanced Code Formatting 07:13 Navigation Filtering 01:31 Customizing Fonts and Syntax Colors for Eye Comfort 03:49 Reports 8 lectures • 54min Introduction (R) 00:57 Predefined Reports Overview and Reports Basics 04:49 User-Defined Reports Basics 06:15 Master-Detail and Drill Down Reports 09:12 Gauge Reports 06:04 Chart Reports 11:09 Exporting and Sharing Reports Preview 07:24 A Final Reports' Trick 08:15 More Useful Features, Tips and Tricks 18 lectures • 1hr 35min Introduction (MUF) 00:36 Splitting Worksheets and Document Groups 05:55 Exporting data 07:07 Code Templates 03:43 Code Snippets 02:57 Taking Advantage of The Line Gutter 02:23 Performing Local Searches on Your Results 04:21 Testing Program Units Smartly 04:47 Debugging Program Units Smartly 13:15 Finding Database Objects 03:59 Getting Information about a Database Object 03:17 Oracle Folks Love Drag & Drop 04:38 Generating Relational Diagrams 04:37 Navigating Your Code 07:20 Performance Tuning Features 10:52 Displaying Gauges 03:25 Useful Tips and Shortcuts 1 06:21 Useful Tips and Shortcuts 2 05:36 Extras 3 lectures • 18min Using HTML in SQL and in preferences 05:23 Appendix 1: Installing Oracle Database Express Edition 18c On Windows 11:21 Bonus Lecture: Discounts for other courses 01:02 Instructor Carlos from Standout-Dev Academy Software Development Director & Chief Educator 4.6 Instructor Rating 6,179 Reviews 77,053 Students 2 Courses Carlos, founder of the Standout Dev Academy, is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for more than 20 years , and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for the last 18 years . His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time. He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites . In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy. If you are into software or database development, make sure to check out Standout Dev Academy's courses now . Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780faf71a625446',m:'dfbf4aec5f01fa1e2b7ff0efb21850561bba3174-1627840977-1800-AaeEBoNa6ikHeS5ycEgaklnGVkkDdwzKef8gS23+Uny9wIknsHHbZgPxAOaSmrgBvGfR8uxbIoZu32Kx2bmqDWnlnhFq6BWn/xw1vOSDZ3e5epWMnLFRHM4tzyG4aVEqVx+pLrxkaBKoymhR7K0+oqYE4Dl9ub5v/J72LWB1ns6S',s:[0x19467e7fcb,0x32ddc23cff],}})();
  4. You will learn how to Install and customize SQL Developer in a way that works and feels best for you You will learn how to take full advantage of all the basic features of the tool Curated for the Udemy Business collection Requirements You will need a computer running Windows, Linux or Mac OS, in which you have the necessary privileges to install and run new programs Ideally you should have an Oracle database you can connect to, so that you can test all the tips and features demonstrated in the course, but it is not strictly necessary. Description * List Price temporarily reduced from $74.99 to $19.99 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 customize SQL Developer in a way that works and feels best for you. Take full advantage of the most useful features of the tool. Create and share beautiful and interactive reports. Take advantage of features that will make you more effective and efficient at work. Learn a lot of tricks and enjoy being seen as an SQL Developer expert. 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 and the database community in general: “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, so that you can be more efficient and productive, and thus, stand out. Content and Overview: The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer. 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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers. Who this course is for: Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition. Aspiring application or database developers looking to work with Oracle databases. Anyone taking or planning to take Oracle SQL or PL/SQL courses. College/University students who need to learn and use SQL for Oracle to pass their database-related courses. Show more Show less Course content 7 sections • 45 lectures • 3h 40m total length Expand all sections Introduction 2 lectures • 4min Course Structure and How to Take Advantage of it Preview 02:09 What this course IS and IS NOT 02:14 Program Installation 2 lectures • 5min Reminder: You need an Oracle Database Already Installed! Don’t have one? 00:22 Downloading and installing SQL Developer 04:22 Oracle SQL Developer Basics 5 lectures • 21min Introduction (SDB) 00:48 User Interface Basics Preview 03:25 Creating and Organizing Database Connections 06:23 Working with the Worksheet 04:58 Working with the Results’ Grid 05:20 Useful Customizations 7 lectures • 23min Introduction (UC) 00:40 Changing the Language 03:58 Disabling Features you Don't Need 02:31 Improving the way Data is Displayed 03:16 Advanced Code Formatting 07:13 Navigation Filtering 01:31 Customizing Fonts and Syntax Colors for Eye Comfort 03:49 Reports 8 lectures • 54min Introduction (R) 00:57 Predefined Reports Overview and Reports Basics 04:49 User-Defined Reports Basics 06:15 Master-Detail and Drill Down Reports 09:12 Gauge Reports 06:04 Chart Reports 11:09 Exporting and Sharing Reports Preview 07:24 A Final Reports' Trick 08:15 More Useful Features, Tips and Tricks 18 lectures • 1hr 35min Introduction (MUF) 00:36 Splitting Worksheets and Document Groups 05:55 Exporting data 07:07 Code Templates 03:43 Code Snippets 02:57 Taking Advantage of The Line Gutter 02:23 Performing Local Searches on Your Results 04:21 Testing Program Units Smartly 04:47 Debugging Program Units Smartly 13:15 Finding Database Objects 03:59 Getting Information about a Database Object 03:17 Oracle Folks Love Drag & Drop 04:38 Generating Relational Diagrams 04:37 Navigating Your Code 07:20 Performance Tuning Features 10:52 Displaying Gauges 03:25 Useful Tips and Shortcuts 1 06:21 Useful Tips and Shortcuts 2 05:36 Extras 3 lectures • 18min Using HTML in SQL and in preferences 05:23 Appendix 1: Installing Oracle Database Express Edition 18c On Windows 11:21 Bonus Lecture: Discounts for other courses 01:02 Instructor Carlos from Standout-Dev Academy Software Development Director & Chief Educator 4.6 Instructor Rating 6,179 Reviews 77,053 Students 2 Courses Carlos, founder of the Standout Dev Academy, is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for more than 20 years , and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for the last 18 years . His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time. He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites . In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy. If you are into software or database development, make sure to check out Standout Dev Academy's courses now . Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780faf71a625446',m:'dfbf4aec5f01fa1e2b7ff0efb21850561bba3174-1627840977-1800-AaeEBoNa6ikHeS5ycEgaklnGVkkDdwzKef8gS23+Uny9wIknsHHbZgPxAOaSmrgBvGfR8uxbIoZu32Kx2bmqDWnlnhFq6BWn/xw1vOSDZ3e5epWMnLFRHM4tzyG4aVEqVx+pLrxkaBKoymhR7K0+oqYE4Dl9ub5v/J72LWB1ns6S',s:[0x19467e7fcb,0x32ddc23cff],}})();
  5. You will learn how to take full advantage of all the basic features of the tool Curated for the Udemy Business collection Requirements You will need a computer running Windows, Linux or Mac OS, in which you have the necessary privileges to install and run new programs Ideally you should have an Oracle database you can connect to, so that you can test all the tips and features demonstrated in the course, but it is not strictly necessary. Description * List Price temporarily reduced from $74.99 to $19.99 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 customize SQL Developer in a way that works and feels best for you. Take full advantage of the most useful features of the tool. Create and share beautiful and interactive reports. Take advantage of features that will make you more effective and efficient at work. Learn a lot of tricks and enjoy being seen as an SQL Developer expert. 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 and the database community in general: “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, so that you can be more efficient and productive, and thus, stand out. Content and Overview: The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer. 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 work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers. Who this course is for: Application or database developers already working with Oracle databases who want to do their job in a smarter way and stand up from the competition. Aspiring application or database developers looking to work with Oracle databases. Anyone taking or planning to take Oracle SQL or PL/SQL courses. College/University students who need to learn and use SQL for Oracle to pass their database-related courses. Show more Show less Course content 7 sections • 45 lectures • 3h 40m total length Expand all sections Introduction 2 lectures • 4min Course Structure and How to Take Advantage of it Preview 02:09 What this course IS and IS NOT 02:14 Program Installation 2 lectures • 5min Reminder: You need an Oracle Database Already Installed! Don’t have one? 00:22 Downloading and installing SQL Developer 04:22 Oracle SQL Developer Basics 5 lectures • 21min Introduction (SDB) 00:48 User Interface Basics Preview 03:25 Creating and Organizing Database Connections 06:23 Working with the Worksheet 04:58 Working with the Results’ Grid 05:20 Useful Customizations 7 lectures • 23min Introduction (UC) 00:40 Changing the Language 03:58 Disabling Features you Don't Need 02:31 Improving the way Data is Displayed 03:16 Advanced Code Formatting 07:13 Navigation Filtering 01:31 Customizing Fonts and Syntax Colors for Eye Comfort 03:49 Reports 8 lectures • 54min Introduction (R) 00:57 Predefined Reports Overview and Reports Basics 04:49 User-Defined Reports Basics 06:15 Master-Detail and Drill Down Reports 09:12 Gauge Reports 06:04 Chart Reports 11:09 Exporting and Sharing Reports Preview 07:24 A Final Reports' Trick 08:15 More Useful Features, Tips and Tricks 18 lectures • 1hr 35min Introduction (MUF) 00:36 Splitting Worksheets and Document Groups 05:55 Exporting data 07:07 Code Templates 03:43 Code Snippets 02:57 Taking Advantage of The Line Gutter 02:23 Performing Local Searches on Your Results 04:21 Testing Program Units Smartly 04:47 Debugging Program Units Smartly 13:15 Finding Database Objects 03:59 Getting Information about a Database Object 03:17 Oracle Folks Love Drag & Drop 04:38 Generating Relational Diagrams 04:37 Navigating Your Code 07:20 Performance Tuning Features 10:52 Displaying Gauges 03:25 Useful Tips and Shortcuts 1 06:21 Useful Tips and Shortcuts 2 05:36 Extras 3 lectures • 18min Using HTML in SQL and in preferences 05:23 Appendix 1: Installing Oracle Database Express Edition 18c On Windows 11:21 Bonus Lecture: Discounts for other courses 01:02 Instructor Carlos from Standout-Dev Academy Software Development Director & Chief Educator 4.6 Instructor Rating 6,179 Reviews 77,053 Students 2 Courses Carlos, founder of the Standout Dev Academy, is an experienced systems engineer with a strong passion for software development and technology in general. He has been developing enterprise software for more than 20 years , and has worked with different database management systems, which has helped him develop a complete understanding and knowledge of the SQL language and its most popular vendor-specific implementations, being Oracle where his main experience is, as he has been working with Oracle databases on a daily basis for the last 18 years . His passion for software development and his entrepreneurial spirit also took him into the mobile world, where he has developed applications for several mobile platforms in his spare time. He's also a blogger and a regular contributor to the Oracle database community, and over the years has been known as an expert in different internet forums and IT knowledge exchange sites . In addition to software development, he loves teaching and sharing his knowledge and experience with others, which is the reason why he joined Udemy. If you are into software or database development, make sure to check out Standout Dev Academy's courses now . Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780faf71a625446',m:'dfbf4aec5f01fa1e2b7ff0efb21850561bba3174-1627840977-1800-AaeEBoNa6ikHeS5ycEgaklnGVkkDdwzKef8gS23+Uny9wIknsHHbZgPxAOaSmrgBvGfR8uxbIoZu32Kx2bmqDWnlnhFq6BWn/xw1vOSDZ3e5epWMnLFRHM4tzyG4aVEqVx+pLrxkaBKoymhR7K0+oqYE4Dl9ub5v/J72LWB1ns6S',s:[0x19467e7fcb,0x32ddc23cff],}})();