Home
Search results “Session current sql oracle”
How to Monitor Session in SQL Developer | Oracle SQL Developer Tips and Tricks
 
04:10
How to Monitor Session in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners, Oracle Database Tutorial for Beginners, Oracle SQL Developer Tips and Tricks, Oracle Tutorial for Beginners, Oracle Tutorial How to Monitor Session in SQL Developer, How to Monitor Session Using SQL Developer, How to Monitor Session in Oracle SQL Developer, How to Monitor Session Using Oracle SQL Developer, how to check number of connections in oracle, how to check active sessions in oracle, oracle sql developer real time sql monitoring, how to check active session in oracle 11g, sql developer monitor sessions table or view does not exist oracle monitor sql statements how to check query performance in oracle sql developer
Views: 447 Oracle PL/SQL World
Trace session details with USER process and SERVER process ID
 
13:43
Oracle database user session tracing.
Views: 7240 OrSkl Academy
UTL_FILE Package in Oracle PL/SQL | Oracle SQL Tutorial | Mr.Murali
 
41:39
UTL_FILE Package in Oracle PL/SQL | Oracle SQL Tutorial | Mr.Murali PL/SQL Tutorial for beginners ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 7402 Naresh i Technologies
Oracle Tutorial || Oracle|Adv Sql | Partitioned Table Part - 1 by basha
 
33:26
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo.......
Oracle to SQL server 5 Steps Migration
 
01:02:38
Migration is a process. We have in-depth methodologies, resources, offers and tools to help you move from Oracle to SQL Server quickly and painlessly. Learn 5 steps to migrate from Oracle to Microsoft SQL Join this session to learn about the 5 steps in migration: •Assess your current data systems •Develop a Migration Plan •Deploy to the new system •Validate everything is working properly •Cutover from your old system azure database dba
Views: 2380 Technocraft
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 24751 Jeff Smith
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 278188 Chandra Shekhar Reddy
Oracle Tutorial || Oracle|Adv Sql | WITH Clause by basha
 
42:43
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle 12c PL/SQL Security New Features - Session 5 of 8 - The New Inherit Privileges Privilege
 
06:47
Learn the Oracle Database 12c Inherit Privileges Privilege. Demonstration and Examples. There's a whole new privilege. The inherit privileges privilege. We indeed inherit any privileges privileged. That's just in privileged of course. Any privileges - system privileges, any privileges is an object privilege or new type objects. We can now assign privileges, grant privileges on users. It limits the owner's inheritance of privileges from the invoker. Oracle Corporation is presumably reasonably happy with the way definer's rights code works and definer's rights code as I demonstrated can be highly dangerous. That hasn't really changed in the current release except is will see with the ability to grant roles to code because in invoker's rights we've got huge differences and that's the inheriting of privileges privilege. If you don't have the inheritance enabled, any attempt to execute invoker's rights code will fail because the definer will not be in able to inherit the rights of the invoker. So I'm going to go straight in to do it and then go through the rest of the slides so we can see the sort of issue. Let me lose 11g and go to 12c. What I shall do is create my low privileged user or drop user dev. I don't think he exists. He doesn't. So I'll create my low privileged user. Grant create session, create procedure, select any table to dev identified by dev. It's the same mechanism I use. The same command I use in 11g. I'm creating a developer with a bare minimum that he needs to do his job, which is writing code that lets people query the database. Then log on as him, comm dev/dev and create my procedure. I'll create a version of the code, create or replace procedure list_emp, author ID current user. Invoker's rights code. Remember, this gives my low privilege user dev the ability to insert something horrible in his code which shall then be executed with the invoker's rights. We create the procedure. Now connect / as sysdba - I'll be the highest possible person there is - set server output on and run the code. Execute dev.list_emp looking for the CLARKS. I can't do it. Even as user sys, I can't run that because of the lack of this new privilege. I can correct the situation. I can grant inherit privileges on user sys - which of course one would never normally do - to dev. So I'm now giving my low privilege user the ability to inherit the privileges of user sys when we are running invoker's rights code. And having done that, the code now succeeds. That's the general principle. Without this inherit any privileges code all that doesn't have any privileges privilege, all your invoker's rights code is now blocked. It simply won't run until you grant that privilege to your trusted user. So without inheritance the invoker's rights code will fail. This privilege is in fact granted by default in 12.1 when a user is created. I believe this is purely for backward compatibility. So you don't have to worry about all your codes ceasing to function the moment you have to upgrade but there's no guarantee that this situation will remain as we go through 12.2, 12.3. Also in upgrade I haven't had the time to test comprehensively every possible method of upgrade but certainly this simple test I've done so far, the privilege does appear to be being granted and we can see it. If we look at who's been granted this privilege so far Select grantee, table_name, privilege from dba_tab_privs where privilege like inherit and we see that straight out of the box inherit privileges on a number of users have been granted to public. They have been granted to public. So if I create a brand new user, I grant connect to jw identified by jw, we will see that in the current release - there he is - inherit has beeen granted to public. In the current release by default, your code will continue to function and Oracle often does this with their [05:46 inaudible] with powerful new features. By default, it's configured so there's no change and in the next release it all changes. That's happened to a quite a few releases, quite a few new features, and it wouldn't surprise me if by the time we get to say 12.2 and certainly by the time we get to 13 this behavior changes. So plan for it and look at that privilege and see who it's been granted to and secure your systems. What you need to do is revoke all the inherit privileges grants that's there by default and then grant inherit any privileges very, very sparingly only to a very few trusted users and that should tighten up the danger of definer's inheriting invoker's rights. So a few trusted schemas, create the code in those schemas only and control this very tightly indeed.
Views: 1577 SkillBuilders
Oracle SQL First Session
 
01:21:24
Structured Query Language(SQL) as we all know is the database language by the use of which we can perform certain operations on the existing database and also we can use this language to create a database. SQL uses certain commands like Create, Drop, Insert etc. to carry out the required tasks. These SQL commands are mainly categorized into four categories as discussed below: 1. DDL(Data Definition Language) : DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in database. Examples of DDL commands:  CREATE – is used to create the database or its objects (like table, index, function, views, store procedure and triggers).  DROP – is used to delete objects from the database.  ALTER-is used to alter the structure of the database.  TRUNCATE–is used to remove all records from a table, including all spaces allocated for the records are removed.  COMMENT –is used to add comments to the data dictionary.  RENAME –is used to rename an object existing in the database. 2. DML(Data Manipulation Language) : The SQL commands that deals with the manipulation of data present in database belong to DML or Data Manipulation Language and this includes most of the SQL statements. Examples of DML:  SELECT – is used to retrieve data from the a database.  INSERT – is used to insert data into a table.  UPDATE – is used to update existing data within a table.  DELETE – is used to delete records from a database table. 3. DCL(Data Control Language) : DCL includes commands such as GRANT and REVOKE which mainly deals with the rights, permissions and other controls of the database system. Examples of DCL commands:  GRANT-gives user’s access privileges to database.  REVOKE-withdraw user’s access privileges given by using the GRANT command. 4. TCL(transaction Control Language) : TCL commands deals with the transaction within the database. Examples of TCL commands:  COMMIT– commits a Transaction.  ROLLBACK– rollbacks a transaction in case of any error occurs.  SAVEPOINT–sets a savepoint within a transaction.  SET TRANSACTION–specify characteristics for the transaction.
Views: 63 Little Legend
Optimizing SQL Performance
 
51:42
Held on July 12 2018 In July's session we mainly looked at performance. Highlights include: 1:30 How does the database process subqueries? 5:20 Performance: comparing insert ... select to create tmp table, insert select from tmp; DDL in PL/SQL; dynamic SQL problems 12:45 18c private temporary tables; tables specific to a session; DDL you can rollback across! 21:00 Improving update performance: things to watch for; insert vs. update; "join-update" - create a view instead; create table as select "update" 34:05 Analytic function performance: first_value non-determinism; min keep vs first_value; computing function in a subquery; indexes for analytic functions AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 475 Oracle Developers
How to use Toad for Oracle's SQL Tracker tool
 
05:16
How to use Toad for Oracle's SQL Tracker tool. Diagnose why not all tables show up in the Schema Browser or the Editor i.e. no tables appear or some tables are missing.
Oracle PL/SQL Tutorials | Oracle FOR LOOP REVERSE | Mr.Vaman Deshmukh
 
02:53
** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #OracleFORLOOPREVERSE -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ ------------------------------------------------------------------------------------------------------ #sqltrainingvideos #oraclevideos #oracletraining #oracletutorials #trending #sqltutorials
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 119272 Sam Dhanasekaran
Learn Oracle SQL : The Hierarchical Query Clause
 
11:19
http://bit.ly/oracle-sql-course | Get the complete course today. Learn Oracle SQL : The Hierarchical Query Clause: In this video, I show you how to use the Hierarchical Query Clause in Oracle SQL to build a basic hierarchical query. This is an excerpt of the course "The Ultimate Oracle SQL Course" which you can get at a heavily discounted price here: http://bit.ly/oracle-sql-course ================ You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Views: 7702 Oracle SQL
Query Tuning 101 How to Run Autotrace in SQL Developer
 
02:21
This video shows how to run autotrace reports using Oracle SQL Developer to analyze query performance. It also discusses the privileges you need to enable database users to run autotrace. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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.
Views: 18892 The Magic of SQL
Back up a single Oracle table with SQL Developer
 
05:09
Backing up a table by making a copy of it gives you the ability to quickly revert extensive changes or compare data after the fact. You can use a backup table as a work table when you need to insert a modified copy of a subset of the data. For more information and JDE Webinars, visit http://www.getgsi.com.
Views: 15309 GSI, Inc.
How To Troubleshoot a Slow Running Query in SQL Server (Extended Events & Wait Stats) by Amit Bansal
 
17:48
In this video, you will understand how to track waits stats for a given query/session using Extended Events. Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Suggest us topics that you wish to learn through our videos: http://www.dataplatformgeeks.com/dpg-suggest-topics/ Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ -http://www.twitter.com/SQLMaestros -https://www.facebook.com/SQLMaestros -Email us: [email protected] Have technical questions? Join the largest SQL/Data group on FaceBook – https://www.facebook.com/groups/thesqlgeeks/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development -http://www.dataplatformgeeks.com/
Views: 47906 SQLMaestros
Oracle SQL Performance Tuning  1
 
06:49
Oracle SQL Performance Tuning and tips Cost Based Optimizer (CBO) Rule Based Optimizer (RBO) SQL Explain Plan Oracle Explain Plan
Views: 13461 TechLake
Custom date time format in Oracle SQL Developer?
 
01:03
From Oracle SQL Developer's menu go to Tools -- Preferences. From the Preferences dialog, select Database -- NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS or for 24-Hour, DD-MON-YY HH24:MI:SS Or just for an active session use below instead. alter SESSION set NLS_DATE_FORMAT = 'required_date_format' i.e. alter SESSION set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS' into the Date Format field. Save and close the dialog.
Views: 711 Maruti AIR Tech
How to find blocking queries in sql server
 
07:35
sql server find blocking processes sql server list blocking processes dbcc opentran example sql server kill spid sql server kill connections sql server kill query sql server kill transaction In this video we will discuss, how to find blocking queries in sql server. Blocking occurs if there are open transactions. Let us understand this with an example. Execute the following 2 sql statements Begin Tran Update TableA set Name='Mark Transaction 1' where Id = 1 Now from a different window, execute any of the following commands. Notice that all the queries are blocked. Select Count(*) from TableA Delete from TableA where Id = 1 Truncate table TableA Drop table TableA This is because there is an open transaction. Once the open transaction completes, you will be able to execute the above queries. So the obvious next question is - How to identify all the active transactions. One way to do this is by using DBCC OpenTran. DBCC OpenTran will display only the oldest active transaction. It is not going to show you all the open transactions. DBCC OpenTran The following link has the SQL script that you can use to identify all the active transactions. http://www.sqlskills.com/blogs/paul/script-open-transactions-with-text-and-plans The beauty about this script is that it has a lot more useful information about the open transactions Session Id Login Name Database Name Transaction Begin Time The actual query that is executed You can now use this information and ask the respective developer to either commit or rollback the transactions that they have left open unintentionally. For some reason if the person who initiated the transaction is not available, you also have the option to KILL the associated process. However, this may have unintended consequences, so use it with extremen caution. There are 2 ways to kill the process are described below Killing the process using SQL Server Activity Monitor : 1. Right Click on the Server Name in Object explorer and select "Activity Monitor" 2. In the "Activity Monitor" window expand Processes section 3. Right click on the associated "Session ID" and select "Kill Process" from the context menu Killing the process using SQL command : KILL Process_ID What happens when you kill a session All the work that the transaction has done will be rolled back. The database must be put back in the state it was in, before the transaction started. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/how-to-find-blocking-queries-in-sql_3.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/how-to-find-blocking-queries-in-sql_3.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 51656 kudvenkat
Definer’s Rights and Invoker’s Rights in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar
 
12:59
Definer’s Rights and Invoker’s Rights in PL/SQL by Mr. Vijay Kumar "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" For Registration : https://goo.gl/r6kJbB Visit Our Websites: http://nareshit.in/ http://nareshit.com/ Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] Our Online Training Features: 1. Training with Real-Time Experts 2. Industry Specific Scenario’s 3. Flexible Timings 4. Soft Copy of Material 5. Share Video's of each and every session. For Registration : https://goo.gl/r6kJbB For more updates on courses and tips follow us on: Facebook: https://www.facebook.com/NareshIT Twitter: https://twitter.com/nareshitech Google+: https://plus.google.com/NareshIT For Registration : https://goo.gl/r6kJbB Call: India- 8179191999, USA- 404-232-9879 Email: [email protected]
Views: 2771 Naresh i Technologies
Session 2 - How to handle PL/SQL API changes
 
06:40
ADF Talk about regeneration of existing ApplicationModules based on PL/SQL Package.
Views: 1835 ADFTalk
Why is my Oracle Database Slow? The SQL Developer Performance Dashboard
 
11:00
Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!
Views: 1405 Jeff Smith
Oracle || PL/SQL Exceptions  Part - 1 by dinesh
 
42:24
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Javascript and CSS for PL/SQL Developers with Jorge Rimblas
 
57:26
Join Jorge Rimblas as he presents one of Kscope17's best overall sessions: Javascript and CSS for PL/SQL Developers. If you have been working with the Oracle Database for a while, but still feel lost when working with JavaScript and CSS in your APEX applications, then this session is for you. Working with HTML, JavaScript, and CSS doesn't have to be hard. Learn about CSS selectors, what is the DOM and working with it. This session will provide you some tools to work better with web technologies. http://rimblas.com/ https://www.insum.ca/
Views: 1430 Insum
Oracle SQL Monitoring - Performance Analysis
 
01:30:41
SQL Monitoring is the best new feature of Oracle 11g for performance analysts, developers and support teams. Finally there is a tool that provides the most accurate, useful and interesting information when a SQL statement is running for longer than expected in a clear format with no minimal advance configuration requirements: What execution plan is really being used? What row source cardinality calculations are incorrect? What steps in the plan are taking the most time and consuming most resources? In this presentation, Doug Burns will demonstrate the various ways of accessing SQL Monitoring functionality and use example reports to show how the information can be used to analyse both currently running and completed statements. It will also describe and offer solutions to some of the minor quirks you might encounter. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 5154 Redgate Videos
PARTITION BY in Oracle SQL  | Oracle SQL Tutorials | By Mr.Murali
 
31:56
PARTITION BY in Oracle SQL | Oracle SQL Tutorials | By Mr.Murali ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 4954 Naresh i Technologies
VTS: SQL Tuning Without Trying - Arup Nanda
 
59:24
This VTS session features learn about the SQL Tuning Advisor feature in Oracle Database, and how to use it effectively and interpret the results for superior performance in the context of the real world presented by a real-life DBA. Presented by Oracle Ace Director Arup Nanda.
Views: 8228 Database Community
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 43319 Manish Sharma
Stored Procedures in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar
 
18:54
Stored Procedures:- A Stored Procedure is also a Named PL/SQL block the accepts some input in the form of parameters and performs some task and many or many not returns a value Procedures are created to perform one or more dml operations over database.
Views: 50199 Naresh i Technologies
SQL: Lag
 
04:40
In this tutorial, you'll learn how to make use of lag function in oracle sql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 2180 radhikaravikumar
10 Query Tuning Techniques Every SQL Programmer Should Know
 
01:34:44
Presenters: Kevin Kline Aaron Bertrand
Views: 250783 PASStv
Oracle tutorial : Pseudo columns in Oracle PL SQL (pseudo column)
 
07:56
Oracle tutorial : Pseudo columns in Oracle PL SQL ( pseudocolumn ) oracle tutorial for beginners rownum in oracle This video will show you what is Pseudo columns in Oracle PL SQL. Pseudo columns are likes ROWNUM, ROENUM, ROWID, NEXTVAL,SYSDTAE , USER etc. pseudocolumn examples Oracle tutorial : Pseudo columns in oracle Oracle supports several special-purpose data elements that are not actually contained in a table, but are available for use in SQL statements. Here is a partial list of pseudo-columns in Oracle a)CURRVAL : When using Oracle SEQUENCE values, the pseudo-column CURRVAL returns the current value of the sequence. for example: schema.sequence_name.CURRVAL b)NEXTVAL :When using Oracle SEQUENCE values, the pseudo-column NEXTVAL returns the next value of the sequence and causes the sequence to increment by one. for example: schema.sequence_name.NEXTVAL c)ROWNUM:ROWNUM returns a number indicating the order in which a row was selected from a table. d)ROWID: ROWID returns the rowid (binary address) of a row in a database table. e)USER :This pseudo-column will always contain the Oracle username under which you are connected to the database. f)SYSDATE:This pseudo-column will contain the current date and time. This column is a standard Oracle DATE datatype. The value represents the current time on the server not the client. For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 1464 Tech Query Pond
Oracle Performance Tuning - Monitoring using Oracle Enterprise Manager
 
12:41
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 30593 itversity
Add Primary Key to Existing Table using SQL - Oracle Express Edition Tutorial
 
01:06
Learn to add Primary Key to Existing Table in Oracle Express Edition using SQL Command ALTER. Syntax: ----------------------------------------------------------------- ALTER TABLE TABLENAME ADD PRIMARY KEY(COLUMNNAME); ----------------------------------------------------------------- This video shows how to add the primary key constraint to an already created table without data in SQL.
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 84945 jbleistein11
How to find Oracle Service Name by sql command
 
01:40
If you have an Oracle database on your network which is able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID. you need to connect another application, however it uses the Service Name instead of the SID. it is the way for to you to determine the SERVICE_NAME of the database when you am connected in SQL Developer via the SID thanking you... just share this video to your friends...
Views: 16579 w3h
SQL 12c  Tutorial 19 : SQL  IDENTITY Column for generating Sequence Values by default
 
08:21
SQL 12c Tutorial 19 : SQL IDENTITY Column for generating Sequence Values by default SQL 12c Tutorial for beginners Oracle SQL 12c Tutorial for beginners SQL 12c New Features Identity columns
Views: 896 TechLake
oracle sql performance analyzer
 
12:50
compares the performance of the statements in a tuning set before and after a database change.
How to Install Oracle SQL Developer
 
04:22
oracle plane, oracle p, oracle query, oracle quality, oracle queue, oracle queen, oracle query optimization, oracle quoting, oracle query processing, oracle query tutorial, oracle query execution plan, oracle quality cloud, oracle rac, oracle reading, oracle r12, oracle rman, oracle review, oracle report, oracle remix, oracle retail, oracle racing, oracle rdc, r oracle connection, strong r oracle, oracle r enterprise, oracle r 12, install oracle r enterprise, oracle sql developer, oracle sql developer tutorial, oracle software, oracle sales cloud, oracle soa, oracle song, oracle sql tutorial for beginners, oracle solaris, oracle stock, oracle s, oracle s&op, oracle tutorial, oracle turret, oracle trailer, oracle training, oracle touch, oracle team usa, oracle tender, oracle timmy, oracle taleo, oracle tutorial for beginners bangla, timmy t oracle, at&t oracle cloud, oracle university, oracle upk, oracle utilities, oracle ucm, oracle usa, oracle upgrade, oracle uninstall, oracle union, oracle unpivot, oracle unboxing, oracle vm, oracle virtualbox, oracle vm server, oracle virtual machine, oracle videos, oracal vinyl, oracle visual builder cloud service, oracle vs sap, oracle view, oracle voice, gta v oracle, gta v oracle xs, final fantasy v oracle, google v oracle, v$session in oracle, oracle v$sql_monitor, oracle v, adidas oracle v, oracle weblogic, oracle workflow, oracle wms, oracle wallet, oracle watch party, oracle warehouse builder, oracle weblogic server, oracle webcenter content, oracle warehouse management, oracle world, oracle xe, oracle xs, oracle xe tutorial, oracle xml publisher, oracle xml db, oracle xpert, oracle xe linux, oracle x86, oracle xstore, oracle xmlquery, xoracle, xoracle not working, xoracle csgo, xoracle csgo hack, xoracle 2018, xoracle hack, xoracle download, xoracle discord, xoracle csgo hack mac, xoracle failed to inject, oracle yoyo, oracle yt, oracle your tomorrow today, oracle yoyo tricks, oracle yacht, oracle yard management, oracle youtube tutorial, oracle youtube videos, i oracle academy oracle internship oracle index hint oracle identity manager oracle instr function oracle isle of dogs oracle industry connect oracle investor relations oracle interview questions oracle instant client oracle insert h&m oracle reading address h samuel oracle h&m oracle reading opening times h samuel oracle reading oracle h file oracle h&d policy oracle h-1b oracle h&m oracle.h oracle project oracle halo lights oracle hr oracle hints oracle headquarters address oracle hospitality oracle hcm cloud oracle hq oracle headlights oracle hyperion oracle headquarters oracle g download oracle gv$session oracle g eazy oracle g-log oracle g cloud oracle g stands for oracle 10 g oracle 11g oracle g vs c g oracle sql developer oracle global temporary table oracle grc oracle gdpr oracle guide pathfinder oracle google lawsuit oracle grant oracle google oracle knowledge advanced oracle keywords oracle king cobra oracle kohls oracle keep oracle kc oracle kubernetes oracle key vault oracle kill session oracle j.rsa oracle j initiator 1.1.8.2 oracle j process oracle q expression oracle q delimiter oracle q processes oracle q escape oracle q quote syntax oracle q notation oracle q operator q' oracle quote q oracle quote operator oracle query optimization oracle quiz oracle quarterly results oracle queue oracle q4 earnings oracle quote oracle query date format oracle questions oracle query date oracle query oracle p-code oracle p card oracle p-card reconciliation oracle p-card functionality oracle p-track oracle p&l oracle p file oracle p/e oracle p-card process flow oracle parallel hint oracle pl sql oracle payroll oracle price list oracle pivot oracle products oracle partner network oracle primavera oracle pathfinder oracle peoplesoft oracle o_direct oracle o store opower oracle oracle o'reilly oracle o'reilly pdf o oracle sql developer decodein oracle o oracle ludzkim głosem pdf o oracle ludzkim o oracle ludzkim głosem oracle obiee oracle odbc driver oracle of mul daya oracle oci oracle owner oracle of bacon oracle of ages oracle of omaha oracle of seasons oracle n replace oracle n-tier architecture oracle n r oracle n string oracle nchar oracle n function oracle n before string oracle n prefix n oracle sql oracle s base oracle s&op oracle s invalid identifier $s oracle apex oracle synonym oracle stadium oracle substr oracle sql developer download oracle software oracle stock price oracle sql r oracle example
Views: 171 T3SO Tutorials
A lap around SQL Operations Studio, a new cross-platform SQL Server tool | T255
 
11:06
Watch this session to learn about the new SQL Server developer and ops tool, SQL Operations Studio. Ops Studio is a lightweight, free multi-OS tool on Windows, macOS, and Linux. It supports SQL Server, Azure SQL Database, and Azure SQL Data Warehouse running anywhere.
Ask Tom Office Hours: PL/SQL Error Management
 
01:01:44
In our March 2018 session, we explored error management, from raising to handling exceptions. We took a look at SAVE EXCEPTION with FORALL, LOG ERRORS, when it makes sense to "swallow up" an exception - though preferably not with WHEN OTHERS THEN NULL. AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 341 Oracle Developers
1.Introduction to basic SQL*Plus and SQL commands in oracle 9i
 
20:41
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases currently in use are based on the relational database model.RDBMSs have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and much more since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have been challenged by object databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases. Object-relational database management system (ORDBMS) ============================================ An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases (OODBMS). In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying. Object-relational database management systems grew out of research that occurred in the early 1990s. That research extended existing relational database concepts by adding object concepts. The researchers aimed to retain a declarative query-language based on predicate calculus as a central component of the architecture. Probably the most notable research project, Postgres (UC Berkeley), spawned two products tracing their lineage to that research: Illustra and PostgreSQL. Many of the ideas of early object-relational database efforts have largely become incorporated into SQL:1999 via structured types. In fact, any product that adheres to the object-oriented aspects of SQL:1999 could be described as an object-relational database management product. For example, IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success. SQL(Structures Query Language) ======================== SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.The acronym SEQUEL was later changed to SQL because "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company. SQL*Plus ======= SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database. If you are familiar with other databases, sqlplus is equivalent to: "sql" in Ingres, "isql" in Sybase and SQL Server, "sqlcmd" in Microsoft SQL Server, "db2" in IBM DB2, "psql" in PostgreSQL, and "mysql" in MySQL.
Views: 46481 DASARI TUTS
Oracle APEX Architecture and Listener Options - Session 2 of 7 - Tutorial Agenda
 
02:35
This free tutorial explains APEX architecture, i.e. how the HTTP request/response cycle works, how an APEX application works (prerequesite knowledge), then introduces the options for an HTTP listening service: the embedded PL/SQL gateway, the Apache mod_plsql module, and the APEX listener deployed to either a Glassfish or a WebLogic container. We summarize with benefits and recommendations for the various listener options. John: Thank you very much for the introduction, Dave. Now what we want to talk about today in this short lecture is options for Listener architectures for APEX applications. I'm going to run through some basics here in this as well and just to set the background to make sure we're all on the same page that the manual as it were. Because I found over the years that web listening architecture tends to be something that slips between domains at many IT shops. Setting up listeners should not be done by a database administrator team nor should it be part of the development domain. No one really seems to know and in some environment, it's the head lead developers who manage the web listeners in other environments as the DBA who manages all system administration even manage the web listeners. It's always split. There's a role split between the two domains of development and administration in most circumstances. Some of what I'm going to go through may seem a bit trivial to developers, some of it may seem a bit trivial to administrators, but please bear with me on that. That's just the way it is because the product does set between those two domains. I'll begin by looking at what is the HTTP request-response cycle? We have to have a basic understanding and make sure we're all on the same level with that so we can then see how HTTP is used to get to APEX applications. I'll run through what an APEX application is. It's nothing magical. It's just PL/SQL, the setup wizard for developing PL/SQL applications and I'll run through how to design the PL/SQL web application from basics and then we'll move on to APEX itself. Having understood how the APEX application works, we can then look at the options for the listening architecture, the way users actually connect to your APEX applications, the way developers connect to APEX applications. The three significant options for that, the embedded gateway using a module and Oracle supplied module for an Apache Web Listener or the APEX Listener which is a custom written servlet or in effect to servlet written specifically to handle APEX listening requests.
Views: 4250 SkillBuilders
Introduction to Spark SQL and DataFrames | Session 27 | Big Data Hadoop Spark | CloudxLab
 
02:55:27
( Big Data with Hadoop & Spark Training: http://bit.ly/2kwEbbX ) This CloudxLab Introduction to Spark SQL & DataFrames tutorial helps you to understand Spark SQL & DataFrames in detail. Below are the topics covered in this tutorial: 1) Introduction to DataFrames 2) Creating DataFrames from JSON 3) DataFrame Operations 4) Running SQL Queries Programmatically 5) Datasets 6) Inferring the Schema Using Reflection 7) Programmatically Specifying the Schema 8) Loading XML 9) What is RPC - Remote Process Call 10) Loading AVRO 11) Data Sources - Parquet Subscribe to our channel to get video updates. Hit the subscribe button above. Facebook: https://www.facebook.com/cloudxlab Twitter: https://twitter.com/cloudxlab LinkedIn: https://www.linkedin.com/company/cloudxlab Check our complete Hadoop & Spark playlist here: http://bit.ly/2IE6HGq - - - - - - - - - - - - - - How does it work? 1. This is a 60+ hour online instructor-led course 2. With the course, you get access to real-time distributed production cluster so that you can learn by doing hands-on 3. Cluster comes with all the tools preinstalled so that you can focus on learning than wasting time in setting up the cluster 4. Each topic consists of videos, assessments, questions and case studies to make sure you master the topic 5. The course is compatible with CCA175, HDP Certified Developer, HDP Certified Developer: Spark certifications 6. We have a 24×7 support and forum access to answer all your queries throughout your learning journey 7. At the end of the training, you will work on real-life projects on which we will provide you a grade and a verifiable certificate! 8. Optionally, Subscribe to 1:1 mentoring sessions and get guidance from industry leaders and professional - - - - - - - - - - - - - - About the Course CloudxLab's Big Data with Hadoop & Spark online training is designed to help you become a top Big Data developer. You will learn Hadoop and Spark to drive better business decisions and solve real-world problems. During this course, our expert will help you in 1. Introduction to Big Data 2. ZooKeeper 3. HDFS 4. YARN 5. MapReduce Basics 6. Write your own MapReduce programs 7. Analyzing and processing data with Pig and Hive 8. Schedule jobs using Oozie 9. NoSQL and HBase 10. Importing data with Sqoop and Flume 11. Implement best practices for Hadoop development 12. Introduction to Apache Spark 13. Introduction to Scala 14. Spark RDD and RDD operations 15. Writing and deploying Spark applications 16. Common patterns in Spark data processing 17. Data Formats - JSON, XML, AVRO, SequenceFile, Parquet, Protocol Buffers, RCFile 18. DataFrames and SparkSQL 19. Machine Learning with Spark using Spark MLlib 20. Introduction to GraphX 21. Work on real-life projects - - - - - - - - - - - - - - Who should go for this course? This course is for anyone who wants to become expert in Big Data with Hadoop and Spark and progress in the career. Ideally, this course will help professionals in the following groups 1. Analytics professionals 2. BI /ETL/DW professionals 3. Project managers 4. Testing professionals 5. Mainframe professionals 6. Software developers and architects 7. Recent graduates passionate about building a successful career in Big Data - - - - - - - - - - - - - - Why Learn Hadoop and Spark? As humans, we are immersed in data in our every-day lives. As per IBM, the data doubles every two years on this planet. The value that data holds can only be understood when we can start to identify patterns and trends in the data. Normal computing principles do not work when data becomes huge. There is massive growth in the big data space, and job opportunities are skyrocketing, making this the perfect time to launch your career in this space. In this specialization, you will learn Hadoop and Spark to drive better business decisions and solve real-world problems Please write back to us at [email protected] or call us at +1 (412) 568-3901 (US) or 080 - 4920 2224 (IN) for more information. Customer Review: Jose Manuel Ramirez Leon, Data Engineer, PwC - I signed up for CloudxLab's Big Data with Hadoop and Spark course. I went through all of the material, which includes very well narrated videos and very clear slides. I finally had to tackle a project in spark were I had to work hard to complete it and finally got my certificate. As I already said, they were very attentive and knowledgeable in their support throughout the whole course. I am going to use the site to prepare for the CCA175 exam now. I thoroughly recommend CloudxLab for anyone who needs to learn Spark, Hadoop, and the whole Big Data ecosystem
Views: 412 CloudxLab
Oracle APEX Tutorial 16 - Running a SQL Script in APEX
 
01:42
Hi! I’m Abdulrhman Uthman, a student of King Faisal University in Saudi Arabia. This series is intended for the practical class of Database Concepts students in our university, but anyone who wants to learn database, SQL or Structured Query Language and use Oracle’s APEX are welcome aboard. In this video we will upload the script file that we downloaded in the previous video. That file will automatically create and populate the tables that we will need for this series. I would like to acknowledge the following people for their support: Dr. Majed Alshamari, Dr. Mohammed Bonais, Dr. Abdullah Alaulaimie, Dr. Mohammed Al-Naeem, Mr. Ahmed Alshawayrid, Mr. Naif Bo-Hasan, Mr. Mohammed Tawfiq, my sister, Ms. Reem Uthman, and my brother, Anas Uthman for editing the video.
Views: 1065 Abdulrhman Uthman