Home
Search results “Oracle integer data types” for the 2014
9.6 How to use Wrapper classes in Java | Integer, Float, Double | Free Java Course | Toturial
 
05:02
Wrapper classes are used to convert any data type into an object. The primitive data types are not objects; they do not belong to any class; they are defined in the language itself. Sometimes, it is required to convert data types into objects in Java language. Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 69761 Telusko
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 164877 Manish Sharma
11.Data Types: float and double
 
06:40
Data Types: float and double in java In this video the data types float and double are explained with ways to declare them and their limitation are explained. Thank you for watching. Please like the video and subscribe to the channel. Facebook: facebook.com/webdevmentors Twitter:twitter.com/webdevmentors Google+:https://plus.google.com/u/0/b/113758214343280360750/113758214343280360750 by Vasandkumar Google+: https://plus.google.com/u/vasandkumar Facebook: https://www.facebook.com/kvasandkumar Twitter: https://www.twitter.com/vasandkumar
Views: 4342 WebDevMentors
SQL Complete Tutorial - ADD or SUBSTRACT or MULTIPLY between two columns - Chapter 6
 
03:47
In this video, I have explained how to add_subtract_multiply the two columns from the particular table. Comment - Follow - Like : https://www.facebook.com/TechyVickyBlog https://www.twitter.com/techyvicky https://www.pinterest.com/techyvicky/techy-vicky-blog https://plus.google.com/109896475845510580320/
Views: 28332 Vicky's Blog
Java Beginner Programming Tutorial - 6 - Data Types and more
 
10:20
Click Here To Subscribe! ► http://bit.ly/JoinMyFun In this tutorial, is about the different data types. Which includes primitive data types(byte, short, int, long, float, double, boolean and char), variable declaration, integer data type and floating data types. Get your JDK here: http://www.oracle.com/technetwork/java/javase/downloads/index.html Get eclipse here: https://www.eclipse.org/downloads/ ------------------------------------------------------------------------------------------------- Beside making tutorials, I also enjoy live stremaing on Twitch.tv Wanna see more? Head over to http://www.twitch.tv/lincxx Also follow me on Twitter https://twitter.com/MrJeremyLincoln
Views: 416 JeremyLincoln34
CONCATENATION OPERATOR, TO_CHAR CURRENCY, MONEY SYMBOL in oracle SQL
 
04:56
How to use concatenation operator, to_char, currency symbol, display money
Oracle Forms Training : using Sequence to generate automated data.
 
12:41
Oracle Training in Bangladesh Oracle Developer and Database Training in Bangladesh Oracle Training at Dev Net IT Oracle forms Training for details http://www.devnet-it.com
Views: 5271 devnetbd devnetit
#16. Intro to Oracle PL/SQL ( Type - table of cursors ) مقدمة لاوراكل
 
02:50
تعريف نوع خاص لحفظ بيانات من نوع كورسر​ Get the Source Code: https://gist.github.com/Ismail-AlJubbah/27a7b0cc1c2e81ad0626 Help us caption & translate this video! http://amara.org/v/Fr7d/
Views: 147 Jubba Smail
CA Exercise 1 - Java Tutorials Arrays Strings Scanner Integer
 
12:39
For more: http://redstagdigital.com/ Next Video: http://youtu.be/vivNoObXuH4 Java API Arrays: http://docs.oracle.com/javase/tutorial/java/nutsandbolts/arrays.html ____________________________________________________ Objective Write a Java program called PrintNumberInLetters that prompts the user to enter a whole number between 1 and 10 inclusive. Print out the number in word format. If a user enters a number less than 1 or greater than 10, inform the user that the number is invalid. For example, if a user enters 2, the output displayed on screen is “Two”. Java Strings Java Arrays Java Tutorials Java For Beginners Java Integers Java Statements
Views: 4965 Red Stag Digital
103 Oracle 11g Tutorials    Using Number Functions
 
06:12
Introduction to Oracle 11g Tuts
Views: 97 saratutus
How to create Primary Key in sql  using oracle 10g
 
02:21
This video gives information about how to create primary key to table in oracle 10 g
Views: 1142 AvilTwo Beginer
SQL Data Types: Don't Convert To String when Sorting/Displaying Values
 
05:54
Preserve data types; allowing the user interface to format as needed. This will allow sorting to properly be done..
Views: 123 David Rodecker
JDBC Demo - Connect to Oracle Database
 
03:30
JDBC Demo - Connect to Oracle Database. JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 2788 Ram N
#15. Intro to Oracle PL/SQL ( Type - table of numbers ) مقدمة لاوراكل
 
06:16
تعريف نوع خاص لحفظ بيانات من ارقام Get the Source Code: https://gist.github.com/Ismail-AlJubbah/ba2c2f17d6a84ef64a2d Help us caption & translate this video! http://amara.org/v/Fr7e/
Views: 131 Jubba Smail
106 Oracle 11g Tutorials    Miscellaneous Functions
 
06:56
Introduction to Oracle 11g Tuts
Views: 92 saratutus
Oracle APEX 4.2.4 Tutorial (05 of 22) - Create a table using Object Browser and define a constraint
 
04:57
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI See how to use Object Browser in APEX's SQL Workshop to create a table. How to add a constraint to field in a table is also shown. In this example a uniqueness constraints is added to a field.
Views: 19251 Jennifer Kreie
How to create Sequence in sql using Oracle 10g
 
01:18
This vIdeo gives Information aboutHow to create Sequence in sql using Oracle 10g
Views: 285 AvilTwo Beginer
SQL Tutorial - 40: The TRIM() Function
 
02:32
In this tutorial we'll see how we can remove leading and trailing spaces from strings using the TRIM() function.
Views: 24050 The Bad Tutorials
How To Import a dataset in to oracl database and add identity column
 
07:04
How To Import a data set (Excel Sheet .csv file) in to Oracle database and add identity column. Requirements: 1. Oracle Database Express Edition 11g Release 2 or higher 2. Oracle SQL Developer 3. A data set
Views: 787 IT Prop
PL/SQL : Methods of Declaring a Variable
 
09:36
In this tutorial, you'll learn how to declare a variable in PL/SQL
Views: 5286 radhikaravikumar
Java Programming Tutorials #2 - Variables
 
08:14
Hey guys whatsup! In this java tutorials video some important stuff about java variables will be explained! Thanks for watching! More Information On Variables: https://docs.oracle.com/javase/tutorial/java/nutsandbolts/datatypes.html
Views: 8 DudesOfRandom
Oracle SQL Developer - How to create an ERD and generate the SQL Script
 
07:44
A simple way to generate SQL statements
Views: 7923 Thomas Stuetz
Removing Decimals with the INT and TRUNC Functions
 
03:51
Check out my Blog: http://exceltraining101.blogspot.com When you want to remove decimal numbers and not be bothered with rounding there are two functions that can do that: INT and TRUNC. This video gives you a quick example on how it's done. Feel free to provide a comment or share it with a friend! --------------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 7935 Doug H
IST297D - Java Data Types with Doceri
 
05:18
Integer and Double
Views: 93 Peggy Fisher
PL SQL 2   Databases and transactional applications
 
06:27
https://drive.google.com/file/d/0BxYoN5rLDBaRMUJuMWs0c1ZrbVU/edit?usp=sharing Course Objectives Variable declaration (again) operators Conversions of data types Nested blocks and variable scope Control Structures Example 1 DECLARE hours_worked INTEGER := 40; employee_count INTEGER := 0; pi CONSTANT REAL := 3.14159; radius REAL := 1; area REAL := (pi * radius**2); BEGIN NULL; END; --------------------------------- Exampl 2 SET SERVEROUTPUT ON DECLARE counter INTEGER; -- initial value is NULL by default BEGIN counter := counter + 1; -- NULL + 1 is still NULL IF counter IS NULL THEN DBMS_OUTPUT.PUT_LINE('counter is NULL'); END IF; END; --------------------------------- Example 3 DECLARE acct_id INTEGER(4) NOT NULL := 9999; a NATURALN := 9999; b POSITIVEN := 9999; c SIMPLE_INTEGER := 9999; BEGIN NULL; END; --------------------------------- Example 4 DECLARE null_string VARCHAR2(80) := TO_CHAR(''); address VARCHAR2(80); zip_code VARCHAR2(80) := SUBSTR(address,25,0); name VARCHAR2(80); valid BOOLEAN := (name != ''); BEGIN DBMS_OUTPUT.PUT_LINE('null_string is'||null_string); IF valid is null THEN DBMS_OUTPUT.PUT_LINE('name is NULL, not ""'); END IF; END; --------------------------------- Example 5 SET SERVEROUTPUT ON DECLARE name VARCHAR(25) NOT NULL := 'Smith'; surname name%TYPE := 'Jones'; BEGIN DBMS_OUTPUT.PUT_LINE('name=' || name); DBMS_OUTPUT.PUT_LINE('surname=' || surname); END; ---------------------------------- Example 6 BEGIN DBMS_OUTPUT.PUT_LINE ('Today is '||'&sv_day'); DBMS_OUTPUT.PUT_LINE ('Tomorrow will be '||'&sv_day'); END; Example 7 ---------------------------------- BEGIN DBMS_OUTPUT.PUT_LINE ('Today is '||'&&sv_day'); DBMS_OUTPUT.PUT_LINE ('The same day is '||'&sv_day'); END; ----------------------------------- Example 8 DECLARE a INTEGER := 2**2*3**2; BEGIN DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a)); END; ---------------------------------- Example 9 SET SERVEROUTPUT ON -- outer_block DECLARE v_test NUMBER := 123; BEGIN DBMS_OUTPUT.PUT_LINE('Outer Block, v_test: '||v_test); -- inner_block DECLARE v_test NUMBER := 456; BEGIN DBMS_OUTPUT.PUT_LINE('Inner Block, v_test: '||v_test); DBMS_OUTPUT.PUT_LINE('In inner Block, ?outer_block.v_test is: '|| outer_block.v_test); END inner_block; ---------------------------------- Example 10 DECLARE v_num NUMBER := &sv_user_num; BEGIN IF MOD(v_num,2) = 0 THEN DBMS_OUTPUT.PUT_LINE (v_num|| ' is even number'); ELSE DBMS_OUTPUT.PUT_LINE (v_num||' is odd number'); END IF; DBMS_OUTPUT.PUT_LINE ('Done'); END; ---------------------------------- Example 11 SET SERVEROUTPUT ON DECLARE x NUMBER := 5; y NUMBER := NULL; BEGIN IF x != y THEN DBMS_OUTPUT.PUT_LINE('x != y'); ELSIF x = y THEN DBMS_OUTPUT.PUT_LINE('x = y'); ELSE DBMS_OUTPUT.PUT_LINE('impossible to define if = or not'); END IF; END; ---------------------------------- Example 12 SET SERVEROUTPUT ON DECLARE a NUMBER := NULL; b NUMBER := NULL; BEGIN IF a = b THEN DBMS_OUTPUT.PUT_LINE('a = b'); ELSIF a != b THEN DBMS_OUTPUT.PUT_LINE('a != b'); ELSE DBMS_OUTPUT.PUT_LINE('umm, it is not known'); END IF; END; ---------------------------------- Example 13 DECLARE x INTEGER := 2; y INTEGER := 5; high INTEGER; BEGIN IF (x mayor y) THEN high := x; ELSE high := y; END IF; IF NOT (x menor y) THEN high := y; ELSE high := x; END IF; DBMS_OUTPUT.PUT_LINE('high is: '||to_char(high)); END; ---------------------------------- Example 14 DECLARE grade CHAR(1); -- NULL by default appraisal VARCHAR2(20); BEGIN appraisal := CASE grade WHEN NULL THEN 'No grade assigned' WHEN 'A' THEN 'Excellent' WHEN 'B' THEN 'Very Good' WHEN 'C' THEN 'Good' WHEN 'D' THEN 'Fair' WHEN 'F' THEN 'Poor' ELSE 'No such grade' END; DBMS_OUTPUT.PUT_LINE ('Grade '||grade||' is '||appraisal); END; ---------------------------------- Example 15 DECLARE grade CHAR(1); -- NULL by default appraisal VARCHAR2(20); BEGIN appraisal := CASE WHEN grade IS NULL THEN 'No grade assigned' WHEN grade = 'A' THEN 'Excellent' WHEN grade = 'B' THEN 'Very Good' WHEN grade = 'C' THEN 'Good' WHEN grade = 'D' THEN 'Fair' WHEN grade = 'F' THEN 'Poor' ELSE 'No such grade' END; DBMS_OUTPUT.PUT_LINE ('Grade ' || grade || ' is ' || appraisal); END;
Views: 199 Fdo Luis
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: 4804 Chris Forsberg
How to use Concatenation operator in SQL in Hindi
 
05:15
In this video we are continue with SQL chapter 1, And get knowledge about oracle 10g sql part.
Views: 1701 OCP Technology
OCAJP 7 Certification | Operators and Control Structure
 
59:24
• Java operators We will examine various types of Java operators such as Arithmetic, Assignment, Relational, Logical, Short-hand Assignment etc. required for OCA SE7. We will also discuss the use of parenthesis to override operator precedence. • Logical Expression We will begin with a discussion of logical expressions as they are central to making decisions. Logical expressions are expressions that return a Boolean value. • The if statement We will examine how the logical expressions can be used with the if statement and the conditional operator. There are numerous variations on how the if statement can be structured and we will look at their advantages and disadvantages. • The switch statement Prior to Java 7, switch statements were based on integer or enumeration values. In Java 7, we can now use String values. The use of Strings and their potential pitfalls are examined. • Control structure issues The last section addresses general control structure issues along with the impact of floating point numbers when making decisions, comparing objects, testing equality between Strings and other objects using == and equals () and a discussion of useful ways of organizing code. This is a 1 Hour Session. The Trainer will teach you the assigned topic and provide you insights about OCAJP 7 Exam. After this session you will be clear about basic concepts in OCAJP 7 and get an understanding about Whizlabs Training Offerings Attend the session and learn the Tips and Tricks of the exam. For more information please visit www.whizlabs.com
Views: 7825 Whizlabs
SQL Tutorial - 36: Useful Numeric Functions Part-1
 
05:14
In this tutorial we'll learn to use the following functions-: 1. CEIL() 2. FLOOR() 3. EXP() 4. LOG() 5. LOG10() 6. POW() 7. GREATEST() 8. LEAST()
Views: 22792 The Bad Tutorials
50 Oracle 11g Tutorials    Primary & Foreign Key Indexing
 
03:53
Introduction to Oracle 11g Tuts
Views: 2338 saratutus
SQL Tutorial - 37: Useful Numeric Functions Part-2
 
04:29
In this tutorial we'll learn to use the following functions-: 1. RADIANS() 2. SQRT() 3. TRUNCATE() 4. RAND()
Views: 18977 The Bad Tutorials
Polymorphism in Java Tutorial
 
08:32
For code click here.. http://www.telusko.com/code.htm?cname=Polymorphism Polymorphism In programming languages and type theory, polymorphism (from Greek πολύς, polys, "many, much" and μορφή, morphē, "form, shape") is the provision of a single interface to entities of different types. Object Oriented Programming A polymorphic type is a type whose operations can also be applied to values of some other type, or types. Method (Function) Overriding, Late Binding, dynamic Binding, Runtime Polymorphism Method (Function) Overloading, Early Binding, Static Binding, Compile Time Polymorphish Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 51872 Telusko
CA Exercise 2 - Java Tutorials For Loop Sum Average Exceptions Error
 
12:25
For more: http://redstagdigital.com/ Java API For Loop: http://docs.oracle.com/javase/tutorial/java/nutsandbolts/for.html Java API System.exit(0); : http://docs.oracle.com/javase/7/docs/api/java/lang/System.html Java API Primitive Data Types: http://docs.oracle.com/javase/tutorial/java/nutsandbolts/datatypes.html Objective Write a Java program called SumAndAverage to prompt a user to enter a whole number (called n) between 1 and 100 inclusive. Compute the sum of the sequence from 1 to n and display the result. Also compute the average of the sequence from 1 to n and display the result. If a user enters a number less than 1 or greater than 100, inform the user the number is invalid. You are expected to use a FOR loop to compute the sum from 1 to n.
Views: 2054 Red Stag Digital
ETL Testing Training Tutorial Part 2 - ETL Testing Introduction Overview - BigClasses
 
21:34
For ETL Testing online training course details visit:- http://bigclasses.com/online-etl-testing-training.html, call: +91 800 811 4040 ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System and Transform the data into Data warehouse. At the Time of Transformation, Data will first transforms to the Staging Table. Based on Business rules the data is mapped into target table, this process manually mapped and configured using ETL Tool ETL will not transforms the Duplicate data The speed of Data Transformation process will be based on the Source and Target Data ware House. We need to consider the OLAP (Online Analytic Processing) Structure as Data warehouse Model Source data consists of XML,Flat file. We need to set the validation at time of data transformation like 'Avoid the 'NULL' values in the table, validate the data type as using Tiny int instead of integer .etc Based on the user requirement, ETL process starts. For regular Updates on ETL Testing Online Training please like our page:- Facebook:- https://www.facebook.com/bigclasses/ Twitter:- https://twitter.com/bigclasses LinkedIn:- https://www.linkedin.com/company/bigclasses Google+: https://plus.google.com/+Bigclassesonlinetraining ETL Testing Course Page:- http://bigclasses.com/online-etl-testing-training.html Contact us: - India +91 800 811 4040 USA +1 732 325 1626 Email us at: - [email protected]
Views: 2904 Bigclasses
ETL Testing  Training Tutorial - ETL Testing  Free Demo - BigClasses
 
39:31
For ETL Testing online training course details visit:- http://bigclasses.com/online-etl-testing-training.html, call: +91 800 811 4040 ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System and Transform the data into Data warehouse. At the Time of Transformation, Data will first transforms to the Staging Table. Based on Business rules the data is mapped into target table, this process manually mapped and configured using ETL Tool ETL will not transforms the Duplicate data The speed of Data Transformation process will be based on the Source and Target Data ware House. We need to consider the OLAP (Online Analytic Processing) Structure as Data warehouse Model Source data consists of XML,Flat file. We need to set the validation at time of data transformation like 'Avoid the 'NULL' values in the table, validate the data type as using Tiny int instead of integer .etc Based on the user requirement, ETL process starts. For regular Updates on ETL Testing Online Training please like our page:- Facebook:- https://www.facebook.com/bigclasses/ Twitter:- https://twitter.com/bigclasses LinkedIn:- https://www.linkedin.com/company/bigclasses Google+: https://plus.google.com/+Bigclassesonlinetraining ETL Testing Course Page:- http://bigclasses.com/online-etl-testing-training.html Contact us: - India +91 800 811 4040 USA +1 732 325 1626 Email us at: - [email protected]
Views: 4631 Bigclasses
14.229 Fractured Mirrors, (Redundant) Column Grouping, Vertical Partitioning, Bell Numbers
 
10:54
What is the relationship of fractured mirrors to row and column layouts? Why would this make sense? This is good for which type of queries again? What are the drawbacks? What is column grouping and its relationship to vertical partitioning? Which type of queries would benefit from this? How would we introduce data redundancy to column grouping? How many vertical partitionings are there? What has this to do with The Data Redundancy Pattern? Video for my inverted classroom "Database Systems". The complete list of videos and additional material is (will be) available at http://datenbankenlernen.de Computer Science, Saarland University: Bachelor (in German): http://www.cs.uni-saarland.de/index.php?id=52&L=1 Master (in English): http://www.cs.uni-saarland.de/index.php?id=132&L=1 Ph.D./Grad School: http://gradschool.cs.uni-saarland.de/ Credits and Copyrights: CC: mate2code http://commons.wikimedia.org/wiki/File:Noncrossing_partitions_5.svg http://creativecommons.org/licenses/by/3.0/deed.en
CRM 2013 Floating Point Number and Decimal Numbers
 
02:29
In Dynamics CRM 2013 what is the difference between a Floating Point Number and Decimal Number?
Views: 586 Customer Dynamics
SQL Server tutorial 43: Using conversion functions.
 
07:49
How to convert data using CAST. How to convert data using CONVERT. How to convert data using new SQL Server 2012 functions. For more info, or a copy of any of the scripts used in any of my tutorials, please email me at [email protected]
Views: 1236 Johnny Deluca
MSSQL - How to, Step by Step Change Data Capture (CDC) Tutorial
 
10:46
Download example from my Google Drive - https://goo.gl/3HYQcH REFERENCES http://technet.microsoft.com/en-us/library/cc645937.aspx http://technet.microsoft.com/en-us/library/dd266396(v=sql.100).aspx Change data capture cannot function properly when the Database Engine service or the SQL Server Agent service is running under the NETWORK SERVICE account. This can result in error 22832. 0) CDC Can not be enabled when Transactional Replication is on, must turn off, enable CDC then reapply Transactional Replication 1) Source is the SQL Server Transaction Log 2) Log file serves as the Input to the Capture Process 3) Commands a. EXEC sp_changedbowner 'dbo' or 'sa' b. EXEC sys.sp_cdc_enable_db / EXEC sys.sp_cdc_disable_db c. EXEC sys.sp_cdc_enable_table / d. EXEC sys.sp_cdc_help_change_data_capture -- view the cdc tables e. SELECT name, is_cdc_enabled FROM sys.databases 4) To SELECT a table you must use the cdc schema such as cdc.SCHEMANAME_TABLENAME_CT iand its suffixed with CT 5) Columns a. _$start_lsn -- commit log sequence number (LSN) within the same Transaction b. _$end_lsn - c. _$seqval -- order changes within a transaction d. _$operation -- 1=delete, 2=insert,3=updatebefore,4=updateafter e. _$update_mask -- for insert,delete all bits are set, for update bits set correspond to columns changed 6) Note CDC creates SQL Agent Jobs to move log entries to the CDC tables, there is a latency 7) There is a moving window of data kept, I believe the default is 3 days. 8) At most 2 capture instances per table USE AdventureWorks2008R2 GO EXEC sp_changedbowner 'sa' EXEC sys.sp_cdc_help_change_data_capture EXEC sys.sp_cdc_enable_db EXEC sys.sp_cdc_disable_db SELECT * FROM cdc.change_tables SELECT * FROM cdc.Address_CT SELECT * FROM cdc.Person_Address_CT ORDER BY __$start_lsn DESC EXEC sys.sp_cdc_disable_table @source_schema = N'Person' , @source_name = N'Address' , @capture_instance = N'Address' EXEC sys.sp_cdc_enable_table @source_schema = N'Person' , @source_name = N'Address' , @role_name = NULL -- , @capture_instance = N'Address' , @capture_instance = NULL , @supports_net_changes = 1 , @captured_column_list = N'AddressID, AddressLine1, City' , @filegroup_name = N'PRIMARY'; GO INSERT INTO AdventureWorks2008R2.Person.Address (AddressLine1,AddressLine2,City,StateProvinceID,PostalCode,SpatialLocation,rowguid,ModifiedDate) VALUES ('188 Football Avenue', 'Suite 188', 'Seattle', 10, '80230', NULL, NEWID(), GETDATE()); SELECT TOP 1 * FROM Person.Address ORDER BY AddressID DESC UPDATE Person.Address SET AddressLine1 = '199 Football Ave' WHERE AddressID = 32524 DELETE FROM Person.Address WHERE AddressID = 32524 GO
Views: 36336 CodeCowboyOrg
Part 18   Load xml data into sql server table using sqlbulkcopy
 
11:58
In this video we will discuss 1. What is the use of SqlBulkCopy class 2. Loading xml data into sql server table using sqlbulkcopy What is the use of SqlBulkCopy class SqlBulkCopy class is used to bulk copy data from different data sources to SQL Server database. This class is present in System.Data.SqlClient namespace. This class can be used to write data only to SQL Server tables. However, the data source is not limited to SQL Server, any data source can be used, as long as the data can be loaded to a DataTable instance or read with a IDataReader instance. From a performance standpoint, SqlBulkCopy makes it very easy and efficient to copy large amounts of data. Loading xml data into sql server table using sqlbulkcopy The following are the steps to achieve this using SqlBulkCopy class Step 1 : Create the database tables using the following sql script Create table Departments ( ID int primary key, Name nvarchar(50), Location nvarchar(50) ) GO Create table Employees ( ID int primary key, Name nvarchar(50), Gender nvarchar(50), DepartmentId int foreign key references Departments(Id) ) GO Step 2 : Create a new empty asp.net web application project. Name it Demo. Step 3 : Add a new xml file to the project. Name it Data.xml. Copy and paste the following XML. [?xml version="1.0" encoding="utf-8" ?] [Data] [Department Id="1"] [Name]IT[/Name] [Location]New York[/Location] [/Department] [Department Id="2"] [Name]HR[/Name] [Location]London[/Location] [/Department] [Department Id="3"] [Name]Payroll[/Name] [Location]Mumbai[/Location] [/Department] [Employee Id="1"] [Name]Mark[/Name] [Gender]Male[/Gender] [DepartmentId]1[/DepartmentId] [/Employee] [Employee Id="2"] [Name]John[/Name] [Gender]Male[/Gender] [DepartmentId]1[/DepartmentId] [/Employee] [Employee Id="3"] [Name]Mary[/Name] [Gender]Female[/Gender] [DepartmentId]2[/DepartmentId] [/Employee] [Employee Id="4"] [Name]Steve[/Name] [Gender]Male[/Gender] [DepartmentId]2[/DepartmentId] [/Employee] [Employee Id="5"] [Name]Ben[/Name] [Gender]Male[/Gender] [DepartmentId]3[/DepartmentId] [/Employee] [/Data] Step 4 : Include the database connection string in web.config file [connectionStrings] [add name="CS" connectionString="server=.;database=Sample;integrated security=true"/] [/connectionStrings] Step 5 : Add a new WebForm to the project. Drag and drop a button control on the webform. Double click the button control to generate the click event handler. Copy and paste the following code in the the click event handler method. string cs = ConfigurationManager.ConnectionStrings["CS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/Data.xml")); DataTable dtDept = ds.Tables["Department"]; DataTable dtEmp = ds.Tables["Employee"]; con.Open(); using (SqlBulkCopy sb = new SqlBulkCopy(con)) { sb.DestinationTableName = "Departments"; sb.ColumnMappings.Add("ID", "ID"); sb.ColumnMappings.Add("Name", "Name"); sb.ColumnMappings.Add("Location", "Location"); sb.WriteToServer(dtDept); } using (SqlBulkCopy sb = new SqlBulkCopy(con)) { sb.DestinationTableName = "Employees"; sb.ColumnMappings.Add("ID", "ID"); sb.ColumnMappings.Add("Name", "Name"); sb.ColumnMappings.Add("Gender", "Gender"); sb.ColumnMappings.Add("DepartmentId", "DepartmentId"); sb.WriteToServer(dtEmp); } } Note: Please make sure to include the following using declarations using System; using System.Configuration; using System.Data; using System.Data.SqlClient; Text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-18-load-xml-data-into-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2014/09/part-18-load-xml-data-into-sql-server_23.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.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: 60924 kudvenkat
Java Integer to String Conversion Methods
 
01:32
Java Integer to String Conversion Methods A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm Are you looking for a new Job ? InterviewDot.com - A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm JAVA/SPRING/SQL/JUNIT INTERVIEW QUESTION AND ANSWER Java Integer to String Conversion Methods
Views: 49 Interview Dot
part14 sql model empty string
 
01:01
empty string, model clause, dimension by, measures, data warehousing, oracle 10g
Part 7   SQL query to find rows that contain only numerical data
 
01:50
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/06/part-7-sql-query-to-find-rows-that_13.html Let me explain the scenario mentioned in one of the sql server interview. We have the following table. ID Value 1 123 2 ABC 3 DEF 4 901 5 JKL Write a SQL query to retrieve rows that contain only numerical data. SQL Script to create the TestTable Create Table TestTable ( ID int identity primary key, Value nvarchar(50) ) Insert into TestTable values ('123') Insert into TestTable values ('ABC') Insert into TestTable values ('DEF') Insert into TestTable values ('901') Insert into TestTable values ('JKL') This is very easy to achieve. If you have used ISNUMERIC() function in SQL Server, then you already know the answer. Here is the query SELECT Value FROM TestTable WHERE ISNUMERIC(Value) = 1 ISNUMERIC function returns 1 when the input expression evaluates to a valid numeric data type, otherwise it returns 0. For the list of all valid numeric data types in SQL Server please visit the following MSDN link. http://technet.microsoft.com/en-us/library/ms186272(v=sql.110).aspx
Views: 88731 kudvenkat
Java Tutorial - Introduction - data types and casting
 
09:49
Facebook page: https://www.facebook.com/pages/WebTunings/339234242822202 Google+ plus.google.com/+webtunings Code: https://github.com/webtunings/java/blob/master/dataTypes.java Recommended JavaScript Book: http://www.amazon.com/gp/product/0596805527/ref=as_li_qf_sp_asin_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0596805527&linkCode=as2&tag=webtuningscom-20 Code snippets: https://github.com/webtunings
Views: 205 WebTunings
Addition of two value
 
07:00
This is the simple program. you can add any two integer number. if you will watch the video. you will definately learn new thing.
Views: 61 Java Learner