Home
Search results “Oracle type guid”
UniqueIdentifier, Guid, Newid, NewSequentialid in SQL Server
 
09:27
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Uniqueidentifiers are also referred to as GUIDs. (Globally Unique IDentifier). That is, the API call that returns a GUID is guaranteed to always return a unique value across space and time. Its related to MAC address based On network card and the system time. The uniqueidentifier data type in SQL Server is stored natively as a 16-byte binary value. We can get a Guid from NewID() or NewSequentialID() NEWID() - randomly generates a guaranteed unique value based on the identification number of the server's network card plus a unique number from the CPU clock. We can use this in Insert, Select Statement. NEWSEQUENTIALID() - generates these values in sequential order as opposed to randomly. We can use this in Create Statement default value and We can’t use in Insert, Select Statement The major advantage of using GUIDs is that they are unique across all space and time. This comes in handy if you're consolidating records from multiple SQL Servers into one table, as in a data warehousing situation. GUIDs are also used heavily by SQL Server replication to keep track of rows when they're spread out among multiple SQL Servers The main disadvantage to using GUIDs as key values is that they are BIG. At 16 bytes a pop, they are one of the largest datatypes in SQL Server. Indexes built on GUIDs are going to be larger and slower than indexes built on IDENTITY columns, which are usually ints (4 bytes)
Views: 1491 IT Port
Working with Orchestrated Integrations in Oracle Integration Cloud Service
 
04:38
When should you use an Orchestration integration? How do you create an Orchestration integration? This video shows you how. Learn more about Orchestration: https://docs.oracle.com/cloud/latest/intcs_gs/ICSUG/GUID-F66ABE41-0A69-4A73-BC3D-0CE36FA78C4D.htm#ICSUG-GUID-36A90FF0-F0D4-4F81-9028-41971C7D100B ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
How to generate UUIDs as primary keys with Hibernate
 
05:59
Most developers prefer numerical primary keys because they are efficient to use and easy to generate. But that doesn’t mean that a primary key has to be a number. UUIDs, for example, have gained some popularity over the recent years If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Join the free Member Library: https://goo.gl/dtyIIC Read the accompanying post: https://www.thoughts-on-java.org/generate-uuids-primary-keys-hibernate/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 3566 Thoughts On Java
Hierarchical Queries: Databases for Developers #16
 
09:38
Often data contains a parent-child relationship between rows in the same table. For example, company org charts and family trees. You can use the power of SQL to traverse these hierarchical relationships. There are two ways to do this in Oracle Database: - Connect By - Recursive With Watch this video to learn about data trees and find out how these work! Further reading: Hierarchical queries in the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Hierarchical-Queries.html#GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E Recursive subquery factoring in 11.2: https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2 Take the course! https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ 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: 4098 The Magic of SQL
Convert datatypes without downtime!
 
03:06
Made a mistake in your database design? Do you need to change the datatype of a column without inflicting lengthy downtime for your users? It's easier than you think. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week
Views: 260 Connor McDonald
Oracl lesson 13 (Canvas Tab type )
 
03:16
canvas tab type in oracle form
Views: 1410 Haitham Salim
Partition Tables
 
11:26
Discussion of partition tables, including DOS and GPT tables, partition type codes, and alignment.
Views: 731 Mike Murphy
Omnichannel Services - Use UUID Keys to Your Data
 
03:46
Today I'm going to talk to you about why it's important to use universally unique identifiers (UUID) as keys to your data, and I will show you some of the problems that they can solve. In the distributed computing world of mobile devices and an internet of things it becomes almost impossible to have one source for key generation, so each device need to be able to create their own keys, while still making sure that those keys are unique. The answer is to use UUIDs, which is a standard by the Open Software Foundation, and there's an industry wide support for them (http://en.wikipedia.org/wiki/Universally_unique_identifier). For example, PHP, Java, .NET, Oracle, and MySQL all have ways to generate them, and SQL Server and ProgresSQL even has native UUID data types. Let talk about the benefits of using UUIDs, and I will start by pointing out some of the problems they can solve. When doing our data models, we have been taught to normalize our databases so that we find primary keys as one of the columns or a combination of columns. If not found, we usually add a generated id, such as an automatically incremented integer. One problem with using a multi-column key is that the queries become more complex as each column needs to be included in each join, and more complex means a lower performance and also larger indices. Another problem is that it's harder for the consumer of the data to know which columns are included in the key. With auto-generated keys, we get a simpler join, but a problem is that each consumer need to ask the generator for a valid key, and another problem is that there will be "holes" in the sequence when rows are deleted. Yet another problem is that any data type used has a fixed limit (even if huge), so it will eventually run out. Also, it becomes tricky for a client to find out which id was generated during an insert. With UUIDs, we get the same benefit of the simpler join as we got with the auto-generated keys, but now each user of the data can generate new keys and rows, without access to any central key generator -- it can even happen while disconnected. So any device or thing can generate a key and the maximum 3.4 x 10^38 combinations both ensure that each key is unique and that there's no practical limit of keys. But even UUIDs have drawbacks, and the most obvious is that they are hard to remember. Therefore, it's a good practice to provide ways of accessing data using attributes that are easier to remember. For example, provide a service that can get an order by providing an order number in addition to getting it using the primary key, the UUID. So make sure that you use UUIDs as keys to your data to allow distributed key generation, simplified joins, and get better performance. Follow me on Twitter https://twitter.com/chrisforsberg Visit my site http://cforsberg.com
Views: 5336 Chris Forsberg
CTE in sql server   Part 49
 
12:57
In this video we will learn about creating and referencing CTE's in SQL server. We will also learn how to create multiple CTE's using a single WITH clause. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/common-table-expressions-part-49.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-49-cte.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: 191285 kudvenkat
ALUCARD BEST BUILD AND EXPLANATION | ALUCARD BEST GUIDE | MOBILE LEGENDS
 
12:35
alucard best build alucard guide thanks for watching and have a great day everyone tags mobile legends mobile legend mobile legends bang bang mobile legend bang bang mobile legends troll build ml troll build mobile legends troll build mobile legends wtf ml wtf mobile legends alucard alucard best build alucard best item alucard tips and tricks alucard guide and tutorial ml alucard ml alucard best build ml alucard best item ml alucard tips and tricks ml alucard guide and tutorial best build for alucard best item for alucard tips and tricks alucard guide and tutorial alucard mobile legends no mercy play alucard best play alucard best build alucard mobile legends
Views: 1396351 MOBILE LEGENDS TV
Linux SUID(Set User Identifier) BIT [Hindi]
 
13:20
In this tutorial you will learn about Set User Identifier bit that is Setuid Bit in Linux Operating System. We do this with the help of chmod command in Linux. The Suid bit is an advanced feature of file security system in Linux. The octal value of suid is equals to 4. The purpose of setting this type of permission is to secure the file and this is good for security but this can be dangerous. By setting suid bit leads the programs to run with the credentials of their user owner.
Views: 380 Ethical Harsh
DDL Triggers in sql server
 
12:31
ddl trigger example ddl trigger example in sql server ddl triggers can be used to In this video we will discuss DDL Triggers in sql server. In SQL Server there are 4 types of triggers 1. DML Triggers - Data Manipulation Language. Discussed in Parts 43 to 47 of SQL Server Tutorial. 2. DDL Triggers - Data Definition Language 3. CLR triggers - Common Language Runtime 4. Logon triggers What are DDL triggers DDL triggers fire in response to DDL events - CREATE, ALTER, and DROP (Table, Function, Index, Stored Procedure etc...). For the list of all DDL events please visit https://msdn.microsoft.com/en-us/library/bb522542.aspx Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. Example - sp_rename system stored procedure What is the use of DDL triggers If you want to execute some code in response to a specific DDL event To prevent certain changes to your database schema Audit the changes that the users are making to the database structure Syntax for creating DDL trigger CREATE TRIGGER [Trigger_Name] ON [Scope (Server|Database)] FOR [EventType1, EventType2, EventType3, ...], AS BEGIN -- Trigger Body END DDL triggers scope : DDL triggers can be created in a specific database or at the server level. The following trigger will fire in response to CREATE_TABLE DDL event. Use SampleDB Go CREATE TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE AS BEGIN Print 'New table created' END To check if the trigger has been created 1. In the Object Explorer window, expand the SampleDB database by clicking on the plus symbol. 2. Expand Programmability folder 3. Expand Database Triggers folder Please note : If you can't find the trigger that you just created, make sure to refresh the Database Triggers folder. When you execute the following code to create the table, the trigger will automatically fire and will print the message - New table created Create Table Test (Id int) The above trigger will be fired only for one DDL event CREATE_TABLE. If you want this trigger to be fired for multiple events, for example when you alter or drop a table, then separate the events using a comma as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Print 'A table has just been created, modified or deleted' END Now if you create, alter or drop a table, the trigger will fire automatically and you will get the message - A table has just been created, modified or deleted. The 2 DDL triggers above execute some code in response to DDL events (CREATE_TABLE, ALTER_TABLE, DROP_TABLE). Now let us look at an example of how to prevent users from creating, altering or dropping tables. To do this modify the trigger as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Rollback Print 'You cannot create, alter or drop a table' END To be able to create, alter or drop a table, you either have to disable or delete the trigger. To disable trigger 1. Right click on the trigger in object explorer and select "Disable" from the context menu 2. You can also disable the trigger using the following T-SQL command DISABLE TRIGGER trMyFirstTrigger ON DATABASE To enable trigger 1. Right click on the trigger in object explorer and select "Enable" from the context menu 2. You can also enable the trigger using the following T-SQL command ENABLE TRIGGER trMyFirstTrigger ON DATABASE To drop trigger 1. Right click on the trigger in object explorer and select "Delete" from the context menu 2. You can also drop the trigger using the following T-SQL command DROP TRIGGER trMyFirstTrigger ON DATABASE Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. The following trigger will be fired when ever you rename a database object using sp_rename system stored procedure. CREATE TRIGGER trRenameTable ON DATABASE FOR RENAME AS BEGIN Print 'You just renamed something' END The following code changes the name of the TestTable to NewTestTable. When this code is executed, it will fire the trigger trRenameTable sp_rename 'TestTable', 'NewTestTable' The following code changes the name of the Id column in NewTestTable to NewId. When this code is executed, it will fire the trigger trRenameTable sp_rename 'NewTestTable.Id' , 'NewId', 'column' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server_9.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: 62550 kudvenkat
Difference between sequence and identity in SQL Server
 
05:29
sql server identity vs sequence In this video we will discuss the difference between SEQUENCE and IDENTITY in SQL Server This is continuation to Part 134. Please watch Part 134 from SQL Server tutorial before proceeding. Sequence object is similar to the Identity property, in the sense that it generates sequence of numeric values in an ascending order just like the identity property. However there are several differences between the 2 which we will discuss in this video. Identity property is a table column property meaning it is tied to the table, where as the sequence is a user-defined database object and is not tied to any specific table meaning it's value can be shared by multiple tables. Example : Identity property tied to the Id column of the Employees table. CREATE TABLE Employees ( Id INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(50), Gender NVARCHAR(10) ) Example : Sequence object not tied to any specific table CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 This means the above sequence object can be used with any table. Example : Sharing sequence object value with multiple tables. Step 1 : Create Customers and Users tables CREATE TABLE Customers ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO CREATE TABLE Users ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO Step 2 : Insert 2 rows into Customers table and 3 rows into Users table. Notice the same sequence object is generating the ID values for both the tables. INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Tom', 'Male') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Pam', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'David', 'Male') GO Step 3 : Query the tables SELECT * FROM Customers SELECT * FROM Users GO Output : Notice the same sequence object has generated the values for ID columns in both the tables To generate the next identity value, a row has to be inserted into the table, where as with sequence object there is no need to insert a row into the table to generate the next sequence value. You can use NEXT VALUE FOR clause to generate the next sequence value. Example : Generating Identity value by inserting a row into the table INSERT INTO Employees VALUES ('Todd', 'Male') Example : Generating the next sequence value using NEXT VALUE FOR clause. SELECT NEXT VALUE FOR [dbo].[SequenceObject] Maximum value for the identity property cannot be specified. The maximum value will be the maximum value of the correspoding column data type. With the sequence object you can use the MAXVALUE option to specify the maximum value. If the MAXVALUE option is not specified for the sequence object, then the maximum value will be the maximum value of it's data type. Example : Specifying maximum value for the sequence object using the MAXVALUE option CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MAXVALUE 5 CYCLE option of the Sequence object can be used to specify whether the sequence should restart automatically when the max value (for incrementing sequence object) or min value (for decrementing sequence object) is reached, where as with the Identity property we don't have any such option to automatically restart the identity values. Example : Specifying the CYCLE option of the Sequence object, so the sequence will restart automatically when the max value is exceeded CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 5 CYCLE Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and_27.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: 35291 kudvenkat
Data types in SQL Server  - Part 5 Tamil
 
09:12
Subscribe to IT PORT : https://www.youtube.com/c/itport28 SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3 SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4 SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX In SQL Server, each column, local variable, expression, and parameter has a related data type. A data type is an attribute that specifies the type of data that the object can hold: integer data, character data, monetary data, date and time data, binary strings, and so on. There are 7 Data type Categories available: a) Exact numerics b) Approximate numerics c) Date and time d) Character Strings e) Unicode Character Strings f) Binary Strings g) Other data types Explained in Tamil
Views: 711 IT Port
Monitoring  Oracle Java Cloud Service -  SaaS Extension
 
04:54
(This video is describes how to use JCS-SaaS Extension Control, the Java console for JCS-SaaS Extension, to monitor activity running on that application. For additional information, see "Using Oracle Java Cloud Service - SaaS Extension Control" at https://docs.oracle.com/cloud/latest/javacs_gs/CSJSU/GUID-DB8FC210-671F-470C-94A9-C472814C8E66.htm#CSJSU7074 NOTE: To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
Table valued parameters in SQL Server
 
06:46
table valued parameters example send table variable to stored procedure pass table variable as parameter to stored procedure pass table variable to sql stored procedure In this video we will discuss table valued parameters in SQL Server. Table Valued Parameter is a new feature introduced in SQL SERVER 2008. Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure from T-SQL code or from an application. Prior to SQL SERVER 2008, it is not possible to pass a table variable as a parameter to a stored procedure. Let us understand how to pass multiple rows to a stored procedure using Table Valued Parameter with an example. We want to insert multiple rows into the following Employees table. SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10) ) Go Step 1 : Create User-defined Table Type CREATE TYPE EmpTableType AS TABLE ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) Go Step 2 : Use the User-defined Table Type as a parameter in the stored procedure. Table valued parameters must be passed as read-only to stored procedures, functions etc. This means you cannot perform DML operations like INSERT, UPDATE or DELETE on a table-valued parameter in the body of a function, stored procedure etc. CREATE PROCEDURE spInsertEmployees @EmpTableType EmpTableType READONLY AS BEGIN INSERT INTO Employees SELECT * FROM @EmpTableType END Step 3 : Declare a table variable, insert the data and then pass the table variable as a parameter to the stored procedure. DECLARE @EmployeeTableType EmpTableType INSERT INTO @EmployeeTableType VALUES (1, 'Mark', 'Male') INSERT INTO @EmployeeTableType VALUES (2, 'Mary', 'Female') INSERT INTO @EmployeeTableType VALUES (3, 'John', 'Male') INSERT INTO @EmployeeTableType VALUES (4, 'Sara', 'Female') INSERT INTO @EmployeeTableType VALUES (5, 'Rob', 'Male') EXECUTE spInsertEmployees @EmployeeTableType That's it. Now select the data from Employees table and notice that all the rows of the table variable are inserted into the Employees table. In our next video, we will discuss how to pass table as a parameter to the stored procedure from an ADO.NET application Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server_17.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: 66605 kudvenkat
URANUS ITEM BUILD, SKILL GUIDE, TALENT EMBLEM, BATTLE SPELL - MOBILE LEGENDS URANUS
 
08:23
Hey guys! What's up? Now this video is all about the tank hero Uranus. #BACKGROUND# Uranus is the Celestial Palace's ancient city defense. His goal to guard the Celestial Palace and get rid of its intruders. #SKILL# Uranus passive skill is called Radiance. It grants him immense HP regen that can stack up to 20 times. It can be triggered when Uranus receives damage. This skill is what makes Uranus a one of a kind tank. Next is his first skill which is named Ionic Edge. When hit by Ionic Edge, enemies will get slowed and their attack power is reduced. Its damage is affected by the current stack of Radiance. Next is his second skill Transcendent Ward. It grants him a shield and movement speed. Magic damage is dealt to enemies nearby, once the shield is used or the duration is up. This skill also gives Uranus immunity from slow effects. Consecration is Uranus' ultimate skill. Uranus disables the target for a short period then pulls himself and the target together. Using this skill gives Uranus six stacks of Radiance. #ITEM BUILD# First item is the Tranquility Boots. This adds 10% more HP regen from his passive skill. Without Tranquility Boots, HP regen is 70. After buying Tranquility Boots it becomes 77. The mana regeneration from Tranquility Boots is a big help for Uranus. Next item is the Oracle. It works almost like his passive which gives him HP when hit by enemies. This item boosts Uranus' sustainability even further. Third item guys is the Demon's Advent. Demon's Advent's unique passive works in harmony with his 1st skill, Ionic Edge. It lessens the enemy's attack power when Uranus is hit. Ionic Edge's attack power reduction stacks with Demon's Advent unique passive. Fourth item guys is the Thunder Belt. It gives extra mana regeneration so that Uranus can spam his first skill. Its unique passive will help in slowing enemies when near Uranus. Also, the low cooldown of his skills makes him a good Thunder Belt user. Fifth item is Cursed Helmet. Since his skills are short ranged, he needs to be close to enemies to be effective. Because Cursed Helmet's passive requires close distance, it is a good match for his gameplay. Last item is either Dominance Ice or Immortality. Use Dominance Ice if the main carry of the opponent's team is a physical user. Dominance Ice helps in slowing the movement speed and attack speed of enemies nearby. Use Immortality if the enemy carry is a magic user. You can sell it after you reincarnate for another magic defense item like Athena's Shield. #BATTLE SPELL# Now for the battlespell guys, Petrify is the recommended battlespell for Uranus. since it gives him an extra crowd control skill. #TALENT# For the talent, it is a choice between Tenacity and Attack & Defense. Attack & Defense for extra damage while Tenacity for durability while low in HP. #COUNTER# To counter Uranus' regen, the enemy has to use either Deadly Blade or Necklace of Durance. Karrie is another counter for Uranus because of her passive skill. #PROS# Uranus' regen is his defining skill. Being able to survive without the need to recall saves time which means more gold for Uranus. Use a couple of mana regeneration item and Uranus is good to go. #CONS# The drawback with Uranus is that he doesn't have any long range skills like Akai or Johnson. He needs to be near the enemies for his skills to hit. Another con is his crowd control skill since it's only limited to one target. #TIPS# Uranus is a one of a kind tank with great regeneration skills. His goal is to take damage for his team while his teammates prepare for the kill. Using mana regeneration items is recommended since his skills have low cooldown. To maximize Uranus, he needs to be in front of the clash. He needs to hit mutiple enemies with Ionic Edge to lower their attack power. Angela and Uranus is great pair because their skills works well in disabling and slowing enemies. Zhask's spawn and Uranus' ultimate is another great combo. Holding the enemy while Zhask's spawn kills the target with two to three hits. Now, after playing Uranus several times I can rate him in the top 5 of the tanks right now. Despite the short range skills, he can still survive pretty well in clashes. I received the Man of Steel achievement from using Uranus. Play Uranus according to his strengths and you'll see why this tank is one of a kind. So, that's it guys. Thank you for watching!
Views: 149370 Elgin - Mobile Legends
PART-2 (Oracle Functions) Oracle PL SQL Training - Fast Track Series
 
26:20
Topic 2: Functions in PL SQL. In oracle there are two types of functions available. 1. Oracle Supplied Function (Built in Functions) Scaler Functions a) String Functions Length, instr, substr, rtrim, ltrim, lower, upper, concat, replace sqlplus sanket/patel SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 14 11:38:56 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL# SQL# select length('sanket') from dual; LENGTH('SANKET') ---------------- 6 SQL# select instr('sanket','n') from dual; INSTR('SANKET','N') ------------------- 3 SQL# select substr('sanket',1,3) from dual; SUB --- san SQL# select ltrim(' sanket ') from dual; LTRIM('S -------- sanket SQL# select rtrim(' sanket ') from dual; RTRIM('S -------- sanket SQL# select trim(' sanket ') from dual; TRIM(' ------ sanket SQL# select lower('SanKet') from dual; LOWER( ------ sanket SQL# select upper('SanKet') from dual; UPPER( ------ SANKET SQL# select concat('sanket','patel') from dual; CONCAT('SAN ----------- sanketpatel SQL# SQL# select replace('patel','e','i') from dual; REPLA ----- patil SQL# b) Date Functions Sysdate, add_months, extract, last_day, next_day, months_between c) Numeric Functions Trunc, ceil, round d) Oracle Type Cast or Conversion Functions To_char, to_date, to_number e) Null functions Nvl, Nvl2 Aggregate Functions Count,min,max,sum 2. User Defined Functions (PL SQL) CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Characteristics of Functions • Function must returns some value • Function can be called from select statement • Function support all three types of parameters available in oracle like IN, OUT and IN OUT parameters. Types of Parameters: IN Parameter: We can’t overwrite value of such kind of parameters. It is used to pass reference values to program and utilized it within the programs or sub-programs or other standalone programs. OUT Parameter: We can overwrite value of such kind of parameters. It is not useful to pass reference values to program and utilized it within the programs or sub-programs or other standalone programs but output value must need to be hold by calling program. IN OUT Parameter: We can overwrite value as well as pass reference value to program or sub-programs or other standalone programs but output value must need to be hold by calling program. EXAMPLES: --FUNCTION WITH OUT PARAMETER CREATE OR REPLACE FUNCTION GET_DATE_HH24TIME RETURN VARCHAR2 IS HH24DATE_TIME VARCHAR2(20); BEGIN HH24DATE_TIME := TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS'); RETURN HH24DATE_TIME; END; / --FUNCTION WITH PARAMETER CREATE OR REPLACE FUNCTION GET_P_DATE_HH24TIME (P_HH24DATE_TIME IN DATE) RETURN VARCHAR2 IS HH24DATE_TIME VARCHAR2(20); BEGIN HH24DATE_TIME := TO_CHAR(P_HH24DATE_TIME,'DD/MM/YYYY HH24:MI:SS'); RETURN HH24DATE_TIME; END; / SELECT GET_P_DATE_HH24TIME(SYSDATE) FROM DUAL; Drop Functions: We can drop function from the database. DROP FUNCTION GET_P_DATE_HH24TIME; SQL# SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'FUNCTION'; OBJECT_NAME --------------------------------------------------------------------------GET_DATE_HH24TIME GET_P_DATE_HH24TIME DROP FUNCTION GET_DATE_HH24TIME;
Views: 4725 Sanket Patel
Sequence object in SQL Server 2012
 
12:22
create sequence in sql server In this video we will discuss sequence object in SQL Server. Sequence object Introduced in SQL Server 2012 Generates sequence of numeric values in an ascending or descending order Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012_26.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 Creating the Incrementing Sequence : The following code create a Sequence object that starts with 1 and increments by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 Generating the Next Sequence Value : Now we have a sequence object created. To generate the sequence value use NEXT VALUE FOR clause SELECT NEXT VALUE FOR [dbo].[SequenceObject] Output : 1 Every time you execute the above query the sequence value will be incremented by 1. I executed the above query 5 times, so the current sequence value is 5. Retrieving the current sequence value : If you want to see what the current Sequence value before generating the next, use sys.sequences SELECT * FROM sys.sequences WHERE name = 'SequenceObject' Alter the Sequence object to reset the sequence value : ALTER SEQUENCE [SequenceObject] RESTART WITH 1 Select the next sequence value to make sure the value starts from 1 SELECT NEXT VALUE FOR [dbo].[SequenceObject] Using sequence value in an INSERT query : CREATE TABLE Employees ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) -- Generate and insert Sequence values INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') -- Select the data from the table SELECT * FROM Employees Creating the decrementing Sequence : The following code create a Sequence object that starts with 100 and decrements by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 100 INCREMENT BY -1 Specifying MIN and MAX values for the sequence : Use the MINVALUE and MAXVALUE arguments to specify the MIN and MAX values respectively. Step 1 : Create the Sequence object CREATE SEQUENCE [dbo].[SequenceObject] START WITH 100 INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 Step 2 : Retrieve the next sequence value. The sequence value starts at 100. Every time we call NEXT VALUE, the value will be incremented by 10. SELECT NEXT VALUE FOR [dbo].[SequenceObject] If you call NEXT VALUE, when the value reaches 150 (MAXVALUE), you will get the following error The sequence object 'SequenceObject' has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated. Recycling Sequence values : When the sequence object has reached it's maximum value, and if you want to restart from the minimum value, set CYCLE option ALTER SEQUENCE [dbo].[SequenceObject] INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 CYCLE At this point, whe the sequence object has reached it's maximum value, and if you ask for the NEXT VALUE, sequence object starts from the minimum value again which in this case is 100. To improve performance, the Sequence object values can be cached using the CACHE option. When the values are cached they are read from the memory instead of from the disk, which improves the performance. When the cache option is specified you can also specify the size of th cache , that is the number of values to cache. The following example, creates the sequence object with 10 values cached. When the 11th value is requested, the next 10 values will be cached again. CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 CACHE 10 Using SQL Server Graphical User Interface (GUI) to create the sequence object : 1. Expand the database folder 2. Expand Programmability folder 3. Right click on Sequences folder 4. Select New Sequence Next video : Difference between SEQUENCE and IDENTITY in SQL Server
Views: 36528 kudvenkat
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►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 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. 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: 1440507 Manish Sharma
LOB's, BLOB's, CLOB's and raster data types in ArcGIS
 
03:06
Large objects (LOB's) can be stored inside modern databases. But how do you do it? Watch this video and learn.
Views: 2992 webekeit
entity framework code first primary key convention
 
12:14
In this video tutorial, I demonstrate about entity framework primary key conventions. for more tutorial please visit http://www.yogeshdotnet.com My Youtube gears: Headphone with Mic : http://amzn.to/2kUXHSq Best USB Micro phone : http://amzn.to/2gogjsR Another option(cheap) asUSB microphone : http://amzn.to/2yrOsME Microphone with mic under 500: http://amzn.to/2gogV1D Antivirus under 500 : http://amzn.to/2ieKPFV Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN What's app group for latest technologies and trends : https://chat.whatsapp.com/AtlkVqbxOrp1vyewFDOg4x Facebook Page Url : https://www.facebook.com/yogeshdotnetblogs/ Yogeshdotnet also provides online training on the front-end technologies(MEAN Stack, Web Designing - HTML5, JS, Jquery, Bootstrap, NodeJS, Express, Angular 6 with typescript etc. and backend technologies like(ASP.NET MVC, ASP.NET Web API, ASP.NET Core ,SQL Server , ORACLE ,REST and python), Data analysis(Big Data Hadoop development, PIG, Scala, Oozie) etc. For more details visit our website https://www.yogeshdotnet.com or call at 09887575540. Our training programs covered basics and advanced concept and real-time project scenarios. I designed various case studies and assignment which may help candidates to explore himself in learning technologies. I take alternate days classes and problem-solving classes also where we solve problems individually by desktop sharing. The student will get the all recorded sessions with lifetime access to all training sessions and study material. Our quality training programs are not more expensive. We provide training in Hindi & English language, depends on learner interest and comfort.
Views: 6146 Yogesh Sharma
Part 2   SQL query to get organization hierarchy
 
10:14
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 293524 kudvenkat
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.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 SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB 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 Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 34882 kudvenkat
Java tutorial for complete beginners with interesting examples - Easy-to-follow Java programming
 
01:02:34
#Java tutorial for beginners with easy-to-follow content. Buy the complete Java programming course (16 more Java tutorials) at Duckademy: https://www.duckademy.com/course/java-programming DOWNLOAD the source codes of the exercises from https://www.duckademy.com/course/java-programming DOWNLOAD the next Java programming tutorial (Video 2 - Control structures) from https://www.duckademy.com/course/java-programming Section 1 Java is one of the most popular programming languages nowadays. If you want to learn Java programming from the very basics than this step-by-step Java tutorial for beginners is for you. What we will do in this Java programming tutorial for beginners: 06:30 A quick introduction to Java programming for beginners 14:23 Installing NetBeans 18:07 Create our first Java project (Hello, World!) 21:46 Variables and types in Java 30:23 Input/Output and calculations 38:02 Conditions (if) 51:20 Review exercise This Java programming tutorial (Getting started with Java) is the first video of the Easy-to-follow Java programming course at Duckademy. http://www.duckademy.com/course/java-programming The goal of this Java programming course (12 hours, 17 tutorials) is to teach you step by step how to program in Java. From the very basics, through lots of exercises and examples, you will get to an advanced level where you can become an expert Java developer. The second Java programming tutorial (Java tutorial for beginners) following this Java tutorial for beginners (Video 2) is about control structures. You can download it for free from https://www.duckademy.com/course/java-programming During this Java programming tutorial for beginners we will use JDK NetBeans 8.1. You can download it from http://www.oracle.com/technetwork/articles/javase/jdk-netbeans-jsp-142931.html To see what our Easy-to-follow Java programming course for beginners is about watch the following short Java programming course summary: https://youtu.be/tSBpuvYQlk8 We hope you like our Java tutorial for beginners, and we hope you will profit a lot from it, and it will help your Java studies a great deal. It is worth learning Java programming, so do it from a great source in an easy and entertaining way. Check out our Easy-to-follow Java programming course at Duckademy: https://www.duckademy.com/course/java-programming ► SUBSCRIBE NOW FOR NEW JAVA PROGRAMMING TUTORIALS for beginners https://www.youtube.com/c/DuckademyITcourses?sub_confirmation=1 ► SUBSCRIBE TO OUR EMAIL LIST for more Java tutorial for beginners like this Java video: http://www.duckademy.com/course/java-programming#dialog-newsletter FOLLOW US and hear about new Java tutorials like this or other interesting Java videos: Facebook ► https://www.facebook.com/duckademy Twitter ► https://twitter.com/duckademy Linkedin ► https://www.linkedin.com/company/duckademy ---------------------------------------------------------------------------------------------------------- #JavaProgramming #JavaTutorial
Views: 603843 Duckademy IT courses
How to Install Debian 9 on VirtualBox
 
13:14
The VirtualBox Guest Additions version for Debian 9 is, as root: click link - http://www.codebind.com/linux-tutorials/install-virtualbox-guest-additions-debian-9-virtual-machine-vm/ To solve "username is not in the sudoers file. This incident will be reported." Please follow the steps below : go to home directory by running command "cd -" then type 'su -' it will ask you for password then type your login password you will be in root user. [[email protected] ~]$ su - Password: [[email protected] ~]# visudo then add username ALL=(ALL) ALL to sudoers save and exit In this Video I am going to show How to Install Debian 9 (GNU/Linux) "Stretch" GNOME Installation on Oracle VirtualBox. In addition I will show How do I install VirtualBox Guest Additions on Debian 9 so you can resize your Debian 9 guest and also Copy and paste between your debian guest and Windows 10 / Windows 8 / Linux host. Debian 9 is a 32- and 64-bit Linux distribution for desktop computers, based on either Ubuntu or Linux Mint. Debian Stretch. It's community based, which means that any Linux developers out there (-and there are many) can contribute to the codebase. Often, this means fixes are available quicker than distros maintained by companies (-such as Ubuntu and Fedora) - which generally only release updates twice a year. VirtualBox is a virtualization software which allows us to run a guest operating system while simultaneously running their host operating system. What is VirtualBox Guest Additions? VirtualBox Guest Additions is software package which can be installed inside the OS (Operating system) running inside of the virtual machine, at or the guest machine. -------------------Online Courses to learn---------------------------- Blockchain Course - http://bit.ly/2Mmzcv0 Big Data Hadoop Course - http://bit.ly/2MV97PL Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 25714 ProgrammingKnowledge
ASP.NET Tutorial 6- Create a Login website - Login page & Validating User and Password in database
 
22:58
asp.net login validation with database c# - Validating username and password in a database in asp.net Validating User Input in ASP.NET Web Pages Sites Asp.Net Examples: Simple login form example in asp.net How to create Login page/form and check username,password in database Simple login form example in asp.net Check Username How to implement form validation using ASP.Net 2.0 How to Validate User Login in asp.net using DataSet ASP.NET Form to Database with Form Validation ASP.NET Database Login ASP.NET FormDecorator Demo - Validation and Login Controls
Views: 470962 ProgrammingKnowledge
Sql Server user defined data types, rules, defaults and xml data type
 
01:31:45
Sql Server user defined data types, rules, defaults and xml data type
Views: 1641 FxAbs Tutorials
Exploring Document Formats in Oracle UPK Developer - UPK Tutorials
 
05:23
http://www.itconvergence.com/oracle-upk-user-productivity-kit - This UPK Video is about Exploring Document Formats in Oracle UPK Developer. This UPK video is part of User Productivity Kit (UPK) Video Tutorial Series from IT Convergence. Here is the transcript of this tutorial: Hello and welcome to the IT convergence's User Productivity Kit tutorial series. This is the demonstration of what options are available for the different document formats when publishing content using the Oracle UPK developer. The UPK developer allows the user to publish content through various document formats which are predefined documents that can appear in Microsoft Word .doc or .docx and Adobe Acrobat .pdf formats. There are several document output options available for publishing in the Publishing Wizard. In this tutorial we're going to walk you through different options available into which document formats they apply. In this demonstration the first document we're going to talk about is a system process document. Each document output uses the text from a specific mode under this option. You can specify the mode text to use. This is applicable for the format system process, job aid, training guide, instructor manual, test document, test case and presentation. Screenshots are included in the document based on the settings for the topic in the topic editor includes screenshots option allows you to over add those settings. This is applicable for the formats: system process, job aid, training guide, instructor manual and test document. Convert screenshots to color reduces the number of colors used in the screenshot as well as the size of the published topic and improves the playback speed. This is applicable for the formats: system process, job aid, training guide, instructor manual, test document test case and presentation. Alternative action and path appear in the document presentation outputs. The Include alternative option allows you to disable this option and makes the output simpler with only one set of steps. This is applicable for the formats: system process, job aid, training guide, instructor manual, test document, test case, and presentation. If you select to include images from packages option. Images will appear if they are attached to a frame or to the concept paint. This is applicable for the formats: system process, training guide, and instructor manual. If you select to include images in a web page option, images will appear if they're attached to the frame or to the concept paint. This is applicable for the formats: system process, training guide and instructor manual. If the include relative links option is disabled, relative links will be excluded from the printed outputs. This is applicable for the formats: system process, job aid, training guide, instructor manual, test document and presentation. Choose an output format you want to publish the output. This is applicable for the format system process, job aid, training guide, instructor manual and, test document. Select Microsoft file type applicable for your version. This is applicable for the formats: system process, job aid, training guide, instructor manual, test document, test case and presentation. The paper size is set based on the location settings in the Regional and Language Options for your operating system locale. By selecting a different paper size, you can overwrite this setting. This is applicable for the formats: system process, job aid, training guide, instructor manual and test document, the using coded fill folder and file names option publishes the content using the document GUID instead of the actual module section in topic names including shortened path names prevents the possibility of duplicated file names in the published output. This option makes it more difficult to identify the source based on the file name. This is applicable for the formats: system process, job aid, training guide, instructor manual, test document, test case and presentation. Next we're going to look at the training guide. Disabling the included assessment option excludes assessments. This is applicable for the formats: training guide and instructor manual. Disable the include questions option to exclude questions. This is applicable for the formats: training guide and instructor manual. Next let's look at the test case document. Each action appears in a separate row in the test procedure table when the group action by context ID option is selected the actions with the same context idea are grouped together into one test step. This is applicable for the test case format. Next let's look at the presentation format. The include action areas option allows you to include a marquee around the action area for each frame. This is applicable for the presentation format.
How to Install Java JDK on Windows 10 ( with JAVA_HOME )
 
08:56
In this video I am going to show you How to install Java JDK on Windows 10 ( with JAVA_HOME ). Java installer .msi file comes with JRE and JDK. Java JDK Installation for Microsoft Windows (64-bit). JDK stands for Java SE Development Kit. JRE stands for Java Runtime Environment. 1. Download Java Open your web browser Type URL: http://www.oracle.com/technetwork/java/javase/downloads/index.html to go to Oracle download page Click on button “ JDK download ” for Java SE update 4. This will lead you JDK download page http://www.oracle.com/technetwork/java/javase/downloads/jdk-7u4-downloads-1591156.html Accept oracle license agreement Find and click on the correct jdk download link right for your operating system to download Save the file to disk 2. Install Java Double click to run the download file Just follow the prompt in Installer window #Javatutorialforbeginners #Javatutorial #Javaprogramming #Javaprogrammingtutorial #Javabasicsforbeginners -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 1311185 ProgrammingKnowledge
Send datatable as parameter to stored procedure
 
09:27
how to pass datatable to stored procedure in c#.net pass datatable to stored procedure in sql server 2008 In this video we will discuss how to send datatable as parameter to stored procedure. This is continuation to Part 99. Please watch Part 99 from SQL Server tutorial before proceeding. In Part 99, we discussed creating a stored procedure that accepts a table as a parameter. In this video we will discuss how to pass a datatable from a web application to the SQL Server stored procedure. Here is what we want to do. 1. Design a webform to insert 5 employees at a time into the database table. 2. When "Insert Employees" button is clicked, retrieve the from data into a datatabe and then pass the datatable as a parameter to the stored procedure. 3. The stored procedure will then insert all the rows into the Employees table in the database. WebForm1.aspx.cs code using System; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace Demo { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {} private DataTable GetEmployeeData() { DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("Name"); dt.Columns.Add("Gender"); dt.Rows.Add(txtId1.Text, txtName1.Text, txtGender1.Text); dt.Rows.Add(txtId2.Text, txtName2.Text, txtGender2.Text); dt.Rows.Add(txtId3.Text, txtName3.Text, txtGender3.Text); dt.Rows.Add(txtId4.Text, txtName4.Text, txtGender4.Text); dt.Rows.Add(txtId5.Text, txtName5.Text, txtGender5.Text); return dt; } protected void btnInsert_Click(object sender, EventArgs e) { string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spInsertEmployees", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramTVP = new SqlParameter() { ParameterName = "@EmpTableType", Value = GetEmployeeData() }; cmd.Parameters.Add(paramTVP); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } protected void btnFillDummyData_Click(object sender, EventArgs e) { txtId1.Text = "1"; txtId2.Text = "2"; txtId3.Text = "3"; txtId4.Text = "4"; txtId5.Text = "5"; txtName1.Text = "John"; txtName2.Text = "Mike"; txtName3.Text = "Sara"; txtName4.Text = "Pam"; txtName5.Text = "Todd"; txtGender1.Text = "Male"; txtGender2.Text = "Male"; txtGender3.Text = "Female"; txtGender4.Text = "Female"; txtGender5.Text = "Male"; } } Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/send-datatable-as-parameter-to-stored.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/send-datatable-as-parameter-to-stored_18.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: 57841 kudvenkat
SQL Server Data Types and Functions
 
39:54
SQL Server Data Types and Functions
Views: 41 King
Dealing with Sql_variant in SSIS
 
07:42
Every now and then you come across something you don't want to deal with that you're forced to handle in your SSIS packages. Here I'll discuss techniques for handling the Sql_variant data type in your packages so your data loads properly.
Views: 150 MidnightDBA
SQL Tutorials -  5.Creating Table & Data Types
 
10:25
How to create a Table & Data Types in SQL
Views: 315 Vineela Madarapu
Virtual Box - How to set a new UUID to a Virtual Machine
 
02:47
How to set a new UUID on a VM in Oracle VM Virtual Box, this error can happen if circumstances surrounding the VDI file change such as name, location etc. This is done using the vboxmanage command line tool Steps: 1 - Right click "Command Prompt" and then click "Run as Administrator" 2 - Then use CD and DIR to browse to: C:\Program files\Oracle\Virtual Box 3 - Then type: vboxmanage internalcommands sethduuid "VDI filepath and filename" For example: vboxmanage internalcommands sethduuid "D:\vm\Windows7virtualmachine.vdi" Song name: DM Galaxy - Etiquette - Free Background Music Link to song: https://youtu.be/ZD_Urg9fOs0 Song created by: DM Galaxy: YouTube - http://goo.gl/5Tezt7 Facebook - https://www.facebook.com/DmGalaxy SoundCloud - https://soundcloud.com/dmgalaxy
Views: 4691 WitherTech
How Many Uuids Are There?
 
00:45
Postgresql documentation 9. How to generate uuids as primary keys with hibernate. Googleusercontent search. Uuid tossed about (universally unique identifier), there are so many guids that you can use them to number everything and not run online guid generatorjava practices generating ids. Proper rfc 4122 uuids as guids in wordpress bjrn johansen. Or if every human on earth generated 600,000,000 guids there would only be a 50. When identifiers are used solely within a database, their generation should be left starting with java 5, the uuid class provides simple means for generating uuids have many applications. 20 jul 2009 in other words, only after generating 1 billion uuids every second for the next 100 years, the probability of creating just one duplicate would be about 50. Uuids and linux everything you ever need to know [update uuid (java platform se 7 ) oracle help center. Rfc 4122 a universally unique identifier (uuid) urn namespaceuniversally identifiers (uuids) itu. Another is the data type uuid stores universally unique identifiers (uuid) as defined by rfc 4122, iso iec 9834 8 2005, and related standards. Object identifier components' 13 mar 2013 and about the question, how many uuids there are big chance is that you will generate a number already own, here version field holds value describes type of this uuid. Since the time and clock sequence total 74 bits, 2 (1. Uuid uuid4() collisions issue #80 ramsey uuid githubapple developer documentation. Some systems refer to 5 oct 2016 each component can generate a uuid and there will not be any conflicts. Uuids generally do not meet security requirements. Uuid? Stack overflow. Random uuid collisions software engineering stack exchange. An attractive feature of uuids when compared to alternatives is their relative small size, 128 bits, or 16 bytes. X10 22 or 18 sextillion) version 1 uuids can be generated per node id, at a maximum average rate of 163 billion second id i. As always, you don't have to do much get the default behaviour 27 aug 2015 at this moment i think there is an issue in ramsey uuid, but still maybe that explains why he was seeing so collisions with uuids created by nsuuid conform rfc 4122 version 4 and are because a uuid expressed simply as array of bytes, no 10 jun 2017 adoption guids widespread, many computing platforms providing support for generating them, parsing their 26 nov problem highlighted here not uuids, instead use from title, would thought something about Guid how unique uuid? Stack overflowhas ever been collision? Quora. Uuid? Stack overflow guid how unique is uuid? overflow stackoverflow questions 1155008 uuid url? Q webcache. Of osi registration authorities generation and of universally unique identifiers (uuids) their use as asn. Two different records had the same uuid yes, see this account of frequent uuid4 collisions we are generating about 1m a day, and getting pretty much allows anything from xkcd random generator very fact that there multiple approach
Views: 64 Lanora Hurn Tipz
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 111609 kudvenkat
What Is The Size Of The Partition Table?
 
00:45
A partition table is a maintained on disk by the operating this means that our first (and ony) begins at absolute sector 3fh, which also lba 63 (or 64th disk). I tried dba_tab_partitions but it does not provide the 28 sep 2015 guid partition table (gpt) is a new style of partitioning which part type primary entry defined over entire size disk or in when developers designed this master table, they left just enough room for description four partitions, hence (four 19 dec 2012 was developed on basis limitation maximum at 2. Googleusercontent search. As of july 2001, the microsoft implementation supports a hard disk up to 18 eb (512 kb lbas) question i need know data dictionary query find size each partition in partitioned table. It memorizes information about sizes and locations of partitions on hard disk. A partition is a fixed size subset of disk drive which treated as unit by the operating system. The number of rows in a table isn't generally great metric to use determine whether and how partition the thus, order interpret dos type table, one needs know hardware sector size. Wikipedia wiki partition_table url? Q webcache. Partition table? table recovery, repair partition wikipediawhat is ntfs tablehow to get size for partitioned sql what a good (# of rows) really minimal specification. What is partition table minitoolpartitioon size in a oracle dba forumsviewing the centos. This query doesn't give size of a partitioned table. Usually a sector has length of 512 bytes, and many partition table is maintained on disk by operating system describing the what's more, size single in mbr can only amount to 2tb 18 nov 2005 this then further split into 4 entries, with older systems maximum could you please give me hint how find pf table? I guess we need query views like dba_tab_partitions model ata st3160812as (scsi) dev sda 160gb (logical physical) 512b msdos number start end type file guid disks grow very large. Partition table? Partition table recovery, repair partition wikipediawhat is ntfs tablehow to get size for partitioned sql what a good (# of rows) really minimal specification. This is the first possible boot sector for any drive having 63 sectors per head trackpartition size in total (4 bytes) partition table located at (cylinder 0, 0 and 1, mbr) of each hard disk. Frequently asked questions about the guid partitioning table disk query oracle partition size burleson consultingthe master boot record (mbr) and what it does. Partition table? table recovery, repair partition. For disk sizes larger than 2 tb you need to use a different partition distribute by hashorganize dimensions. The partition information is started on offset 1beh of master boot sector. Partition table wikipedia en. Table partitioning functionality is available with the db2 version 9. Guid partition table thomas krenn wikitable partitioning ibm. Each partition entry is 16 bytes long the information about primary partitions and an extended each table long, making a maximum of four
Views: 16 Lanora Hurn Tipz
Different ways to replace NULL in sql server in arabic
 
07:34
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/different-ways-to-replace-null-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-15-different-ways-to-replace-null.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: 1012 kudvenkat.arabic
NULL Value in sql | Part 10 | SQL tutorial for beginners | Tech Talk Tricks
 
04:52
Welcome to our Tech Talk Tricks channel.The SQL NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. #TechTalkTricks #RanaSingh A field with a NULL value is a field with no value. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces. Syntax The basic syntax of NULL while creating a table. SQL: CREATE TABLE CUSTOMERS( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25), SALARY DECIMAL (18, 2), PRIMARY KEY (ID) ); Here, NOT NULL signifies that column should always accept an explicit value of the given data type. There are two columns where we did not use NOT NULL, which means these columns could be NULL. A field with a NULL value is the one that has been left blank during the record creation. null value definition sql is null or empty sql is not null or empty null value statistics importance of null values in relational database sql if null sql isnull function sql if not null ************************************************** Follow Tech Talk Trick on Facebook https://www.facebook.com/techtalktricks ************************************************** Follow tech talk trick on Twitter https://twitter.com/tecktalktrick ************************************************** Follow Tech Talk Tricks on Instagram https://www.instagram.com/techtalktricks ************************************************** Subscribe tech talk tricks on YouTube https://www.youtube.com/techtalktricks ***************************************************
Views: 1353 TechTalkTricks
DateTime functions in SQL Server in arabic
 
13:29
Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/09/datetime-functions-in-sql-server-part-25.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-25-datetime-functions-in-sql-server.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: 736 kudvenkat.arabic
NULL values in DBMS...how to insert null value in table in sql
 
02:07
how to insert null value in table in sql #sqltutorial#oracletutorial#databasetutorial
Views: 1784 Viral Fun Tube
Change SID in Windows Server 2016
 
06:09
Change SID in Windows Server 2016 1. Prepare - DC22 : Windows Server 2016 2. Step by step - DC22 : Change SID + Start - Windows PowerSell - whoami /all - Get SID , save into a file text named SID.txt + Go to run and type C:\Windows\System32\Sysprep\sysprep.exe - Restart + Compare SID before and after
Views: 14147 microsoft lab
70-461 – Querying Test SQL Exam Server 2012 Questions
 
00:55
For Microsoft 70-461 Test Questions and Answers Please Visit: https://www.PassEasily.com/70-461.htm Exam Section 1 - Create database objects Questions (Test Coverage 24%) Exam Section 2 - Work with data Questions (Test Coverage 27%) Exam Section 3 - Modify test data Questions (Test Coverage 24%) Exam Section 4 - Troubleshoot test and optimize Questions (Test Coverage 25%) (Exam Time) : 60 minutes (Number of Test Questions): 105 (70-461 Passing Score): 80% A. Create and alter tables using T-SQL syntax (simple statements) • Create tables without using the built in tools test; ALTER; DROP; ALTER COLUMN; CREATE. • Create and alter exam views (simple statements). • Create indexed views; create views without using the built in questions tools; CREATE, ALTER, DROP • Design views for the 70-461. • Ensure code exam non regression by keeping consistent test signature for procedure, views and function (interfaces); security questions implications. • Create and modify constraints (simple statements). • Create constraints on tables; define constraints; unique constraints; default constraints; primary and foreign key constraints. • Create and alter DML triggers for the 70-461. • Inserted and deleted tables test; nested triggers; types of triggers; update functions; handle multiple rows in a session exam; performance questions implications of triggers. B. Query data by using SELECT statements • Use the ranking function test to select top(X) rows for multiple categories in a single query; write and perform queries efficiently using the new (SQL 2005/8 - SDL) code items such as synonyms exam and joins (except, intersect); implement logic which uses dynamic SQL and system metadata; write efficient, technically complex SQL queries, including all types questions of joins versus the use of derived tables; determine what code may or may not execute based on the tables provided test; given a table with constraints, determine which statement set would load a table; use and understand different data test access technologies; case versus isnull versus coalesce. • Implement sub-queries for the 70-461. • Identify problematic exam elements in query plans; pivot and unpivot; apply operator; cte statement; with statement questions. • Implement data types questions. • Use appropriate data; understand the uses and limitations test of each data type; impact of GUID (newid, newsequentialid) on database performance, when to use what data type for columns exam. • Implement aggregate queries for the 70-461. • New analytic functions test; grouping sets; spatial aggregates; apply ranking functions • Query and manage XML data quesions. • Understand XML datatypes test and their schemas and interop w/, limitations and restrictions; implement XML schemas and handling exam of XML data; XML data: how to handle it in SQL Server and when and when not to use it, including XML namespaces exam; import and export XML; XML indexing C. Create and alter stored procedures (simple statements) • Write a stored procedure to meet a given set of test requirements ; branching logic; create stored procedures and other programmatic exam objects; techniques for developing stored procedures; different types of storeproc result; create stored procedure for data access questions layer; program stored procedures, triggers, functions with T-SQL Test. • Modify data by using INSERT, UPDATE and DELETE statements exam. • Given a set of code with default questions, constraints and triggers, determine the output of a set of DDL; know which SQL statements are best to solve common requirements test; use output statement. • Combine datasets for the 70-461. • Difference between exam UNION and UNION all; case versus isnull versus coalesce; modify data by using MERGE Test statements. • Work with functions for the 70-461. • Understand deterministic questions, non-deterministic test functions; scalar and table values; apply built-in scalar exam functions; create and alter user-defined functions (UDFs).
Views: 1811 PassEasily Microsoft
Introduce to Word 2013 Part 11
 
06:26
Hi, there. My name is Channel derm3nak, and in today's video I'm going to teach you something very important for if you're taking any type of test that has a writing component. Thank you...! This video tutorial will show you how to use Microsoft Word 2013 for beginners. Microsoft Word is a powerful word processing tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered.
Views: 65 Derm3 nak
MSSQL -  How to add new integer column to the table with default value
 
00:56
More info http://howtodomssqlcsharpexcelaccess.blogspot.ca/2017/11/mssql-how-to-add-new-integer-column-to.html
Views: 196 Vis Dotnet
How to Exercises Word 2013  01
 
10:31
Hi, there. My name is Channel derm3 nak, and in today's video I'm going to teach you something very important for if you're taking any type of test that has a writing component. Thank you...! This video tutorial will show you how to use Microsoft Word 2013 for beginners. Microsoft Word is a powerful word processing tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered.
Views: 72 Derm3 nak
Oracle Apps crm Training and Tutorials Available Online
 
06:25
www.Magnifictraining.com-oracle apps r12 scm fuctional online training. contact us: [email protected] or call us: +919052666559 oracle apps technologies like oracle discrete manufacturing, oracle apps purchasing training, oracle apps order management training,oracle apps r12 functional training. real time Oracle scm online training by industrail experts for details call:+919052666559 hands on training on oracle online TRAINING. Module 1:Introduction to Oracle CRM Service Fundamentals ● Understand iStore's shopping cart and ordering functionality and other key features ● Understand features of Oracle's sales applications ● Create leads and convert them into opportunities ● Create opportunities and convert them into quotes ● Describe Campaign Flows, schedules and target groups ● Under geographic territories and named territories, set up in Territory Manager ● Explain the Basic Sales Flow ● Set up common components, such as Notes, Tasks and Calendars ● Describe the Lead to Order Process ● Create Customers and Contacts using Oracle trading Community Architecture model ● Create Employees and Users, Import Resources, and assign roles and responsibilities to users ● Understand implementation steps required to set up sales products ● Describe integration points between Oracle Sales and Oracle Marketing applications ● Understand Global Address formatting ● Understand Oracle Sales related personalization features available in OA Framework ● Create proposals for leads, opportunities or quotes
Views: 16 sairam baba
How to delete a Registry entry (Error Deleting Key)
 
02:05
How to delete a "blocked" Windows registry key using "regedit.exe".
Views: 73163 furulevi