Home
Search results “Oracle create table if exists”
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: 176327 Manish Sharma
Oracle SQL Tutorial 13 - How to Add Column Constraints (Attributes)
 
05:55
So far, we have this table declaration: CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR) first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) We can run this command see that it works. As we are learning though, we are going to want to be able to recreate our table with different settings and such, but if you try to run this command, it will complain that the table already exists. So we first need to delete this table before we start editing settings. When we get more experienced, we will learn about ways to edit the structure of a table that already exists. To fix this, we can get rid of the table using the DROP TABLE command: DROP TABLE users You can run this every time if you need to practice by adding a semicolon after it. This is how you can tell Oracle that you are putting in another command after it. This is known as a delimiter. When you run the script, it is going to run both commands. Now we can go through and reconsider our table structure. This is fine for starting out because we don't have any important data in our database, but once your database is in production you are not going to want to just drop tables. In the last video we discussed different constraints that you can apply to columns in a database table, but how do you actually apply these when you are creating a table? The first way you define constraints is to put them right after the column in your CREATE TABLE statement. CREATE TABLE users( username VARCHAR2(50 CHAR) NOT NULL ) When we define constraints this way, we usually say we are adding column attributes. If you have two constraints you want to add, you just put one after the other with spaces in between. There is no particular order that is required. CREATE TABLE users( username VARCHAR2(50 CHAR) NOT NULL UNIQUE ) In this situation we have already given the column the NOT NULL and UNIQUE attributes, so we should consider making this a primary key: CREATE TABLE users( username VARCHAR2(50 CHAR) PRIMARY KEY ) As you can see, adding column attributes is super easy. We can add a default like this: CREATE TABLE users( username VARCHAR2(50 CHAR) PRIMARY KEY, account_balance NUMBER DEFAULT 0 ) Note that now we need the comma after the first row. There are a few constraints we did not talk go through an example, specifically foreign keys and check constraints. We will be adding these constraints to our database in future videos. In the mean time, I have a thought for you… Many people prefer to name their column constraints. That way, we can refer to certain constraints by name. For example, we might have a primary key constraint that could be named users_pk. The way we are creating these constraints does not allow for this feature, so in the next video we are going to be discussing different ways to create constraints. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me on Patreon! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 20191 Caleb Curry
Oracle SQL Tutorial 15 - How to Add Primary Key Constraints
 
02:54
The goal of this video is to take the CREATE TABLE statement we have and walk through the different ways to create primary keys. This and foreign keys are the most common constraints, so we need to make sure that you have this one down. Once we have a more complex database design with multiple tables, we will learn the proper way to create foreign keys. For now, I am going to keep all of our constraints at the column level, unnamed. The only exception is the primary key, because that is what we are focusing on in this video. The first way to create the primary key is at the column level, unnamed. The primary key is very important because it what we use to distinguish rows from one another. Every table you create is going to need a primary key, and I suggest putting a lot of effort into making sure your keys are set up correctly and organized. --Delete the table if needed: DROP TABLE users; CREATE TABLE users( user_id NUMBER PRIMARY KEY, username VARCHAR2(50 CHAR) NOT NULL UNIQUE ) The next way is at the column level, but named: --Delete the table: DROP TABLE users; CREATE TABLE users( user_id NUMBER CONSTRAINT users_pk PRIMARY KEY, username VARCHAR2(50 CHAR)NOT NULL UNIQUE ) The general naming convention here is the table name followed by an underscore, followed by pk for primary key. Finally, the third way, which is at the table level, is the way we are going to create our primary key: --Delete the table: DROP TABLE users; CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) NOT NULL UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ) Now, once you've created these constraints, you can use Oracle SQL Developer to find these constraints. Open your databases in the connections tab and find the table in the Tables folder. Double click your table and travel to the Constraints tab. You can tell here that the UNIQUE constraint still exists in this table, but it has a pretty disgusting name. It kind of wants to make me puke. Referencing that constraint in the future with that wacky name would be a burden. Engrave these three options in your head so that you can use any of them whenever you need and can read other peoples' code. Thank you for sticking with the series thus far. In the next video, we will be…doing something. See you then! :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me on Patreon! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 14529 Caleb Curry
SQL create table in hindi | SQL tutorial in hindi | DBMS Lectures in hindi #72
 
04:24
Welcome to series of gate lectures by well academy SQL create table in hindi | SQL tutorial in hindi | DBMS Lectures in hindi #72 Here are some more GATE lectures by well academy relational algebra in dbms | relational algebra operations in dbms | DBMS lectures in hindi #58 : https://youtu.be/zbnyudmh4ys Select Operation in Relation Algebra | Selection in Relational Algebra | DBMS lectures in hindi #59 : https://youtu.be/NsIL7z4Ck4A Projection in Relational Algebra | relational algebra in dbms | DBMS Lectures in hindi #60 : https://youtu.be/5QVMyeDfih4 Gate 2012 Relaional Algebra | relational algebra in dbms gate | DBMS lectures in hindi #61 : https://youtu.be/SeGqtlzy5_k Rename operation in Relational Algebra | relational algebra in dbms | DBMS Lectures in hindi #62 : https://youtu.be/0bklGoIBcQ8 set operations in dbms | Set Operations in Relational Algebra in dbms | DBMS lectures in hindi #63 : https://youtu.be/cE8mZnWxyN4 Join Operation in DBMS | join operation in relational algebra | join operation in database DBMS #64 : https://youtu.be/Au-ab_Yq1rw Natural join operation in dbms | Natural join in relational algebra | Natural join in hindi | #65 : https://youtu.be/rBaSaPoUeqQ Division Operation | Division Operation in DBMS | Division Operation in dbms with example | DBMS #66 : https://youtu.be/705ljW1X5gM join in dbms | Types of Join in dbms | join operation in relational algebra | DBMS lectures #67 : https://www.youtube.com/watch?v=4DppvRx5a2Y GATE 2015 Relational Algebra | relational algebra in dbms with examples | DBMS Lectures in hindi #68 : https://youtu.be/gj0xiXmjVaw Relational Calculus | relational calculus database | relational calculus in hindi | DBMS #69 : https://youtu.be/1hG_qqckYj0 Tuple Relational Calculus | tuple relational calculus in dbms | tuple relational calculus in hindi : https://youtu.be/RzGg0fykY3I Tuple Relational Calculus | Bounded Variables and Free Variables | DBMS Lectures in Hindi #71 : https://youtu.be/Yjz10ysczUc Click here to subscribe well Academy https://www.youtube.com/wellacademy1 GATE Lectures by Well Academy Facebook Group https://www.facebook.com/groups/1392049960910003/ Thank you for watching share with your friends Follow on : Facebook page : https://www.facebook.com/wellacademy/ Instagram page : https://instagram.com/well_academy Twitter : https://twitter.com/well_academy sql create, sql create table, sql create table in hindi, sql create user, sql creating database, sql cross joins with examples, SQL tutorial in hindi, create new table sql, create table command in sql, create table in oracle sql developer, create table in sql 2012, create table in sql cmd, create table in sql command line, create table in sql in hindi, create table in sql plus, create table in sql server 2008, create table in sql server 2012, create table in sql server 2014, create table query in sql, create table sql server 2016, how to create sql table, how to create table sql developer, microsoft sql create table, ms sql create table, mysql create table, mysql create table and import data from csv, mysql create table command line windows, mysql create table example, mysql create table foreign key, mysql create table in workbench, mysql create table php, mysql create table primary key, mysql create table query, mysql create table tutorial, oracle sql create table, psql create table, psql create table command line, psql create table example, psql create table terminal, sql 2014 create table, sql create table, sql create table access, sql create table and columns, sql create table and insert data, sql create table associative entity, sql create table c#, sql create table command line, sql create table date yyyy-mm-dd, sql create table deutsch, sql create table example, sql create table foreign key, sql create table from a view, sql create table from csv, sql create table from excel, sql create table from scratch, sql create table from select, sql create table from select query, sql create table if not exists, sql create table in hindi, sql create table many to many relationship, sql create table no database selected, sql create table pk fk, sql create table primary key, sql create table primary key autoincrement, sql create table relationships, sql create table statement, sql create table stored procedure, sql create table student, sql create table time, sql create table time format, sql create table tutorial, sql create table with date in name, sql create table with primary key, sql create table with query, sql create table youtube, sql server create table, sql tutorial - 1 create table statement, sql workbench create table,
Views: 9663 Well Academy
How to use EXISTS / NOT EXISTS Logical Operator in SQL Server -  SQL Server / TSQL Tutorial Part 125
 
09:41
What is Exists / Not Exists Logical Operator in SQL Server Exists returns TRUE if a subquery contains any rows. EXISTS is used when we want to test for the existence of rows specified by a subquery. 1) EXISTS will return TRUE if subquery contains any rows. That is right, if our subquery will return any rows and we have used EXISTS, the outer query is going to return all rows. 2) Use EXISTS and Join with SubQuery Link to scripts used in SQL Server / TSQL Tutorial Video http://www.techbrothersit.com/2016/06/how-to-use-exists-logical-operator-in.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server 2016 DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 7288 TechBrothersIT
SQL Server 27 - How to Create FOREIGN KEY Constraints
 
04:25
In the previous video we set up an entire table. The problem with this table is that the species column is just plain text. The problem with this is that there is a higher probability of incorrect data and if we have tons of animals in here there will be a lot of redundant information. The solution to this is to change this species to a foreign key to another table. Remember that when you create a foreign key it is a child to a parent. The thing you need to know is that the parent has to exist before the child so the child has something to reference. So let's create the parent table. CREATE TABLE Species( ID INT PRIMARY KEY IDENTITY, Species VARCHAR(50) NOT NULL UNIQUE, FriendlyName VARCHAR(50) NOT NULL //NOT UNIQUE because multiple rows could be same category (Ex: Bunny) ); Now, the friendly name will likely have redundant data, so maybe later we can add a table for animal categories or something, but let's not overwhelm ourselves quite yet. Maybe in a few videos. Now that we have created that table, we can recreate the table that references it. The first thing to know when creating a foreign key is that the data type must match. Because the ID column in the species table is of type INT, we should make our Species column in the Animals table also of type INT. Secondly, to make this a foreign key we add REFERENCES Species(ID) to the Species column. DROP TABLE IF EXISTS Animals; CREATE TABLE Animals( ID INT PRIMARY KEY IDENTITY, Name VARCHAR(50) NOT NULL, Species INT NOT NULL REFERENCES Species(ID), ContactEmail VARCHAR(50) NOT NULL UNIQUE ); ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 5443 Caleb Curry
SQL script to insert into many to many table
 
14:52
Text Article http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many.html Slides http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many_6.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR 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 In this video we will discuss how to insert data into a table that has many-to-many relationship Create table Students ( Id int primary key identity, StudentName nvarchar(50) ) Go Create table Courses ( Id int primary key identity, CourseName nvarchar(50) ) Go Create table StudentCourses ( StudentId int not null foreign key references Students(Id), CourseId int not null foreign key references Courses(Id) ) Go Students - Id column is identity column Courses - Id column is identity column StudentCourses - StudentId and CourseId columns are foreign keys referencing Id column in Students and Courses tables As you can see, StudentCourses is a bridge table that has many to many relationship with Students and Courses tables. This means a given student can be enrolled into many courses and a given course can have many students enrolled. Below is the question asked in an interview for SQL Server Developer role. Write a SQL script to insert data into StudentCourses table. Here are the rules that your script should follow. 1. There will be 2 inputs for the script Student Name - The name of the student who wants to enroll into a course Course Name - The name of the course the student wants to enroll into 2. If the student is already in the Students table, then use that existing Student Id. If the student is not already in the Students table, then a row for that student must be inserted into the Students table, and use that new student id. 3. Along the same lines, if the course is already in the Courses table, then use that existing Course Id. If the course is not already in the Courses table, then a row for that course must be inserted into the Courses table, and use that new course id. 4. There should be no duplicate student course enrollments, i.e a given student must not be enrolled in the same course twice. For example, Tom must not be enrolled in C# course twice. Answer : To avoid duplicate student course enrollments create a composite primary key on StudentId and CourseId columns in StudentCourses table. With this composite primary key in place, if someone tries to enroll the same student in the same course again we get violation of primary key constraint error. Alter table StudentCourses Add Constraint PK_StudentCourses Primary Key Clustered (CourseId, StudentId) Here is the SQL script that inserts data into the 3 tables as expected Declare @StudentName nvarchar(50) = 'Sam' Declare @CourseName nvarchar(50) = 'SQL Server' Declare @StudentId int Declare @CourseId int -- If the student already exists, use the existing student ID Select @StudentId = Id from Students where StudentName = @StudentName -- If the course already exists, use the existing course ID Select @CourseId = Id from Courses where CourseName = @CourseName -- If the student does not exist in the Students table If (@StudentId is null) Begin -- Insert the student Insert into Students values(@StudentName) -- Get the Id of the student Select @StudentId = SCOPE_IDENTITY() End -- If the course does not exist in the Courses table If (@CourseId is null) Begin -- Insert the course Insert into Courses values(@CourseName) -- Get the Id of the course Select @CourseId = SCOPE_IDENTITY() End -- Insert StudentId & CourseId in StudentCourses table Insert into StudentCourses values(@StudentId, @CourseId) If required, we can very easily convert this into a stored procedure as shown below. Create procedure spInsertIntoStudentCourses @StudentName nvarchar(50), @CourseName nvarchar(50) as Begin Declare @StudentId int Declare @CourseId int Select @StudentId = Id from Students where StudentName = @StudentName Select @CourseId = Id from Courses where CourseName = @CourseName If (@StudentId is null) Begin Insert into Students values(@StudentName) Select @StudentId = SCOPE_IDENTITY() End If (@CourseId is null) Begin Insert into Courses values(@CourseName) Select @CourseId = SCOPE_IDENTITY() End Insert into StudentCourses values(@StudentId, @CourseId) End Use the following statement to execute the stored procedure Execute spInsertIntoStudentCourses 'Tom','C#'
Views: 81656 kudvenkat
The SQL EXISTS clause
 
08:52
How to use the EXISTS clause in SQL. For beginners.
Views: 22789 Database by Doug
HOW TO CHECKING IF TEMPORARY TABLE EXISTS IN TEMPORARY DATABASE IN SQL SERVER
 
10:42
HOW TO CHECKING IF TEMPORARY TABLE EXISTS IN TEMPORARY DATABASE IN SQL SERVER HD Video
Views: 685 Sourn Sarim
Oracle SQL Tutorial 16 - Parent Child Relationships
 
06:09
So far in this series we have discussed database design, creating tables, and constraints. We've brought up the concept of foreign keys, but we have not explained how to create them. That is the goal of this video and the upcoming videos. We want to study those foreign keys! Let's make them not so foreign. Let's learn the proper way to define a foreign key. As a reminder, a foreign key is a column that references a column of another table. The column it references must either be a primary key, or have the UNIQUE constraint. This means that every value inside of the column that is labeled as a foreign key, there must be that value in some row of the referenced column. As an example, imagine that we have the users table, and we have a table service_requests. We could have a column in the service_request that references a column in the users table. Usually this would be the primary key that is referenced, but there is nothing stopping you from referencing a unique column. Just for fun, let's go through an example using the username column. If we have a service_requests table, every single row within the table is going to be what some would consider an instance of a service_request. This means that the table columns are like the blueprint for what a service request looks like and then each row is an individual service request. If we have one of the columns labeled as a foreign key to the username of the users table, what does that mean practically? It means that for a single row, the value for that column must be a value that exists in the users table. We could have a service_request submitted by a user with the username of Yoloswagman. This means that there must be a row inside of the users table that has the value Yoloswagman for the username column. This brings up the concept of parent and child relationships. Yoloswagman in this situation is the parent, and his service request is the child. When we draw it out, it makes sense why a primary key must be UNIQUE. If we had two Yoloswagmans, the child would not know which column is the parent. The same applies if we were using IDs and we had So remember, always reference a primary key or a column with the UNIQUE constraint. Now, I have a question for you. Do foreign keys automatically have the UNIQUE constraint, just like primary keys? The answer is no. A parent row can have many child rows. It makes sense because the user could submit multiple service requests. Can we force the column to be unique? Absolutely. If that was the case, the user could only make one service request. Another question. Do foreign keys automatically have the NOT NULL constraint, just like primary keys? The answer is no. Essentially what this means is that a child could be created with no parent. Can we force the column to be NOT NULL? Absolutely. It is ok in some situations to allow the row to be null, but in this situation it makes no sense. It would be wise for us to add that constraint ourselves. So now that you understand some more differences between primary and foreign keys and parent child relationships, take all of these questions into consideration when you are creating foreign keys. In the next video, we are going to start a small project that is going to require multiple tables. We'll take a video to design our structure and then we'll get to creating those foreign keys in Oracle SQL Developer. Stick around and if you like these videos please be a serious supporter and subscribe to my channel. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 12259 Caleb Curry
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 6582 Manish Sharma
Learn What is Database Table? How to Create a Database Table using SQL?
 
03:42
Learn how to create the database table using SQL statement. The CREATE TABLE statement is used to create a database table. A valid database table name may contain only letters, numbers and underscore symbol. The database table names are case insensitive. That is table name 'students' (all small letters) is similar to the table name 'StuDenTs' (the letters S, D and T are capital). A single database must contain a unique table name, while in multiple databases, the same table name can exist in another database. The SQL statement to create new database table is, CREATE TABLE tablename ( columnname1 datatype, columnname2 datatype ); Select 'school' database, "USE school;" create a new table called 'students3' with only 2 columns, studentid and firstname. The SQL statement will be, CREATE TABLE students3 ( studentid SMALLINT(5), firstname VARCHAR(20) ); If we display all the tables, "SHOW TABLES;". We can see the new table named 'students3' is successfully created. We can display the information about table structure by using SQL statement, "DESCRIBE students3;" OR "EXPLAIN students3;" Check out the whole playlist of SQL Tutorials or Individual video from the following links, SQL Tutorial for Beginners. Introduction to SQL Basics https://www.youtube.com/playlist?list=PLhwzZMYRiUErXXX0Ryud2R7RjesCEdTqi 1.Learn What is SQL? Introduction to SQL https://www.youtube.com/watch?v=ox6zUOKascs 2.Learn How to Install MySQL Database Server on Windows Operating System https://www.youtube.com/watch?v=vtnoWaydkEU 3.Learn What is Database? How to Create and Show Databases using SQL https://www.youtube.com/watch?v=-yJgWq6K_U8 4.Learn How to Select and Use Existing Database using SQL https://www.youtube.com/watch?v=QMViQ38SPxc 5.Learn How to Delete or Remove Database using SQL https://www.youtube.com/watch?v=wjEOZKvfH4c 6.Learn What is Database Table? How to Create a Database Table using SQL? https://www.youtube.com/watch?v=8SvtNIfzC4o 7.Learn How to Modify or Update Database Table using SQL https://www.youtube.com/watch?v=1he5oZzG33o 8.Learn How to Delete or Remove Database Table using SQL https://www.youtube.com/watch?v=JD87WvBist0 9.Learn How to Add Data Rows in a Table using SQL https://www.youtube.com/watch?v=UB-bQxAQbWg 10.Learn How to Use INSERT INTO SELECT Statement in SQL https://www.youtube.com/watch?v=U4ApxHF4R1g 11.Learn How to Update Data Rows using Update Statement in SQL https://www.youtube.com/watch?v=lE1BmNbFJdo 12.Learn How to Delete Data Rows using Delete Statement in SQL https://www.youtube.com/watch?v=1ViqX1tFgYM Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
The SQL CREATE TABLE Statement
 
02:39
The SQL CREATE TABLE Statement The CREATE TABLE statement is used to create a table in a database. Tables are organized into rows and columns; and each table must have a name. SQL CREATE TABLE Syntax CREATE TABLE IF NOT EXISTS `contacts` ( `id` int(11) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `addres` text NOT NULL, `phone_number` int(11) NOT NULL, `birth_day` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Views: 118 alnoor biz
SQL Server Temp Tables - TSQL Command Line  with  IF EXISTS and  DROP TABLE
 
09:34
Discussion of Temp Tables and persistence and why IF EXISTS and DROP TABLE are not necessary. Temp Tables are created in the tempdb system database in SQL Server. They are persistent but not necessarily long lived. Temp tables hav many similarities to true tables, however they also have special properties that allow more flexibility respecting scope.
Views: 1823 Dave Merton
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH NULL / NOT IN / NOT EXISTS OR OUTER JOIN
 
08:36
This video demonstrates the oracle sql interview question where one need to use either not in, not exists or an outer join to get the desired result. For example if one is asked to fetch records from department table where department_id is not present in employee table
Views: 1965 Kishan Mashru
DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE
 
21:53
The audio and video now synced. Ever tried creating a table inside a PL SQL block, or a function or a procedure? If yes, then you would know that it would raise an error, as DDL statements are not allowed inside a PL/SQL Block. So the solution to such a case, where you want to generate tables, or sequences or want to execute any DDL statement on the fly, then use synamic sql. Dynamic SQL statment will allow you to create state statements on the fly and then you can execute them using the execute immediate statement. This video tutorial demonstrates on this topic of using synamic sql with execute immediate in a PL/SQL block.
Views: 4826 Kishan Mashru
Java- MySQL Connection (Create Table, Insert, Select)
 
09:55
This is a fast tutorial, intended for people who understand java, and the basics of SQL/MySQL who just want to see how to use my-sql-connector. How to create a MySQL Connection in java, then create a table, insert, and select, video 1 of 4. CODE: import java.sql.Connection; import java.sql.DriverManager; public static Connection getConnection() throws Exception{ try{ String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://24.196.52.166:3306/testdb"; String username = "username"; String password = "password"; Class.forName(driver); Connection conn = DriverManager.getConnection(url,username,password); System.out.println("Connected"); return conn; } catch(Exception e){System.out.println(e);} return null; } Download JDBC https://dev.mysql.com/downloads/connector/j/ --06/07/2107
Views: 272452 Steven Byrne
Creating a database, table, and inserting - SQLite3 with Python 3 part 1
 
10:59
Welcome to an SQLite mini-series! SQLite, as the name suggests, is a lite version of an SQL database. SQLite3 comes as a part of the Python 3 standard library. Databases offer, typically, a superior method of high-volume data input and output over a typical file such as a text file. SQLite is a "light" version that works based on SQL syntax. SQL is a programming language in itself, but is a very popular database language. Many websites use MySQL, for example. SQLite truly shines because it is extremely lightweight. Setting up an SQLite database is nearly instant, there is no server to set up, no users to define, and no permissions to concern yourself with. For this reason, it is often used as a developmental and protyping database, but it can and is used in production. The main issue with SQLite is that it winds up being much like any other flat-file, so high volume input/output, especially with simultaneous queries, can be problematic and slow. You may then ask, what really is the difference between a typical file and sqlite. First, SQLite will let you structure your data as a database, which can easily be queried, so you get that functionality both with adding new content and calling upon it later. Each table would likely need its own file if you were doing plain files, and SQLite is all in one. SQLite is also going to be buffering your data. A flat file will require a full load before you can start querying the full dataset, SQLite files don't work that way. Finally, edits do not require the entire file to be re-saved, it's just that part of the file. This improves performance significantly. Alright great, let's dive into some SQLite. https://pythonprogramming.net/sql-database-python-part-1-inserting-database/ Playlist: https://www.youtube.com/playlist?list=PLQVvvaa0QuDezJh0sC5CqXLKZTSKU1YNo https://pythonprogramming.net https://twitter.com/sentdex https://www.facebook.com/pythonprogramming.net/ https://plus.google.com/+sentdex
Views: 219157 sentdex
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 247769 The Bad Tutorials
Oracle SQL Tutorial 17 - Designing Our Foreign Keys
 
07:47
We are going to continue working with the users table that we've started with, but we are going to add a few tables. Imagine a system where you can create projects. And users can be added to these projects. So this could be some kind of productivity app or a project management solution, think of JIRA. We are going to start with three tables. The first table is going to be a users table that contains all of the information about each user's account. We are then going to have a table that is called projects. Each project will have data about the project and a foreign key that is the creator of the project. This is a situation where the database design depends a lot on the business rules and requirements of the application. Is it appropriate to have only one creator, or can it have multiple creators? We are going to design it with only one creator per project to increase simplicity. The third table is going to be used to record what users are part of certain projects. This situation is a many to many relationship because we've decided that one user can be a part of multiple projects and an individual project can have multiple members working on it. Because this is a many to many relationship, it calls for an intermediary table, project_users. First, we will draw out the user table. We will have a user_id, username, first_name, and last_name. Now, this is our parent table, because it has no foreign keys. Now, this is our parent table, because it has no foreign keys. Other tables are going to be referencing this table, so they would be the children. The project table will have a project_id, title, description, and creator. The column that needs to be a foreign key is the creator. Let's move on to the next table and we'll get back to the foreign key of the project table. The other table was project_users. Knowing that this is an intermediary table, immediately we know that the first two columns are going to be foreign keys to the each of the other tables. Now, let's ask the important questions about the foreign keys. Let's first start with the project table's user column. The first thing we need to ask is what column does it need to reference? Remember, the only options are the columns that are UNIQUE. Our candidates are user_id and username. For now, let's go with username as it makes things easier to work with. Once we go into learning about joins, we will talk about joining things by ID. Different people do it different ways, with the majority using only ID columns for primary and foreign keys, but it's important to be familiar with different ways of doing things. The important thing to remember is that keys should never change, so if we should only reference the username if a user's username will never change. Should the foreign key be labeled UNIQUE? If yes, it means that a user can only create one project. I vote no. Should the foreign key be labeled NOT NULL? If not, it means that a project can exist without a creator. I vote no. Moving on to the next table, I think I'll have the columns reference the project's id and user's id, so we can get some experience referencing surrogate keys. We can apply to these foreign keys the same questions we asked about the other foreign key, and I would encourage you to do so and really think about why. But I can tell you that we are not going to want them to be NOT NULL, but not UNIQUE. Now that we have a pretty decent database design, we can proceed with creating our database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 9890 Caleb Curry
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
 
04:12
3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-else Previous Tutorial ► IF THEN Statement https://youtu.be/IWvuFD6eD30 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 61488 Manish Sharma
How to Generate DDL Scripts(Create) from SSMS - SQL Server / T-SQL Tutorial Part 17
 
05:23
How to Generate DDL Scripts(Create) from SSMS - SQL Server / T-SQL Tutorial Scenario: We often need to get DDL( Data Definition Language) scripts for different objects such as tables, views and Stored Procedures etc. Is it possible to generate Create Table statement for a table in SSMS? If I need to generate Create statement for all the tables/view, Will SSMS let me do it? Solution: Generate Script for Single Object: SQL Server Management Studio ( SSMS) does provide the feature to script single or all objects. To generate DDL script for single object, You can right click on the object and then choose the statement you like to create. Let's say if we would like to generate create table statement for existing table, we will choose below options. How to Generate DDL Scripts for More than One Object: This is also easy. You need to Right click on the Database in which the objects exists. Then go to Tasks and hit Generate Scripts. In Next window, you will be able to choose the objects for which you would like to create script. The next window will ask you if you like to have the scripts open in new Query Window or you would like to save in a file. Sometime you have a lot of objects and those script might not fit in Query Window, you can always save to file and then use it when required. Once you hit Next, You will see the progress windows as shown below. Once done. You can hit Finish. Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 5879 TechBrothersIT
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 344075 Chitu Okoli
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon 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 liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 63904 Manish Sharma
Java & MySQL - Check if a value already exists
 
12:03
Easy tutorial on how to check if a value already exists in the database.
Views: 27241 Mozoran
Oracle Using In , Between and Not تعليم أوراكل
 
10:27
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How to use In , Between and Not. Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint insert into statement update statement delete statement select statement basic query where clause select where Like '%' Like '_' select where Like select where Between Between , Not Between select where In , Not In
Creating functions with PostgreSQL
 
01:08
How to create and run functions in PostgreSQL Code used in the video ---- We're going to create a database to store the electronic documentation -- For each document we need to know -- file name (name + extension) -- who has created the document with some contact data -- version (example: 3.1, 5.2, ...) -- summary info -- date of creation DROP TABLE IF EXISTS tbl_docs; DROP TYPE IF EXISTS tp_file; DROP TYPE IF EXISTS tp_version; DROP TYPE IF EXISTS tp_fileName; DROP TABLE IF EXISTS tbl_author; DROP TYPE IF EXISTS tp_author; -- First we create the type for author CREATE TYPE tp_author as ( ID char(10), name varchar(100), telf varchar(12), email varchar(255) ); -- Creating the table to store the authors collaborators CREATE TABLE tbl_author OF tp_author ( PRIMARY KEY (ID) ); -- Inserting some authors INSERT INTO tbl_author VALUES ( '0000000001', -- ID, 'Joan Pi', -- NAME '659...', -- TELEPHONE '[email protected]' -- EMAIL ); SELECT * FROM tbl_author; -- We need to create version type -- version (example: 3.1, 5.2, ...) -- major and minor CREATE TYPE tp_version AS ( major int, minor int ); -- Creating filename and file types -- file name (name + extension) CREATE TYPE tp_fileName AS ( name varchar(200), extension varchar(10) ); -- Info related to type file -- file name (name + extension) -- who has created the document with some contact data -- version (example: 3.1, 5.2, ...) -- summary info -- date of creation CREATE TYPE tp_file AS ( name tp_filename, description text, -- summary info idAuthor char(10), -- field related to authors table. We associated on table creation createdDate timestamp with time zone, -- date of creation version tp_version -- Version of the document ); -- Creating the table to store the document's info CREATE TABLE tbl_docs of tp_file ( PRIMARY KEY (name,version), CONSTRAINT FK_AUTHOR -- Associating idAuthor with ID field of tbl_author FOREIGN KEY (idAuthor) REFERENCES tbl_author(ID) ); -- INSERTING SOME DATA ON tbl_docs INSERT INTO tbl_docs VALUES ( ROW('Requirements','odt')::tp_filename, -- name,extension. specify ::tp_filename is optional 'Requirements ....', -- description '0000000001', -- author identification. Must exist in tbl_author '2018-07-03 12:25:00', -- creation date ROW(3,1) -- version . In this case cast (::tp_version) not specified ); SELECT * FROM tbl_docs; -- With PostgreSQL we can create functions to add functionality to our database. You can execute from an external -- program for example using Java language or from a PostgreSQL client. -- In this video we're going to use a previous database. We've included the code above. -- The purpose of our function is to get the filename as string. The filename is composed in two parts: -- the name and the extension. -- f(x)=name + '.' + extension CREATE OR REPLACE FUNCTION fn_filename(name tp_filename) RETURNS text AS $$ BEGIN RETURN (name).name || '.' || (name).extension; -- concat operator in PostgreSQL is || END $$ LANGUAGE plpgsql; -- Getting name and description from tbl_docs SELECT name, description from tbl_docs; -- name column returns data in a format object -- Using the function we get the filename as name.extension (Requirements.dot) SELECT fn_filename(name) AS filename, description FROM tbl_docs; #FpInfor #Dam #DamMp02 #DamMp02Uf4
Views: 111 Miquel Boada
Oracle Database11g tutorials 16: How to uninstall oracle 11g from windows 7 64 bit
 
08:49
How To Properly Uninstall oracle database 11g from windows 7 and 8 manually without formatting your Computer By Manish Sharma Rebellion Rider Blog Link http://bit.ly/uninstall-oracle-11g-from-win-7 Website: www.RebellionRider.com Manual Un-Installation of Oracle Database 11g. This video will show you proper process on uninstalling Oracle database 11g from windows 7 64 bit. How to uninstall oracle 11g on windows 7 / How to uninstall oracle 10g on windows 7 Read How to uninstall oracle 11g on windows http://www.rebellionrider.com/how-to-uninstall-oracle-database-11g-from-windows-7.html YouTube Video on How to create database http://bit.ly/create-database-using-DBCA 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
Views: 250765 Manish Sharma
Updating a Table with SSIS
 
06:19
Updating a Table with SSIS
Views: 102922 Rick Caminiti
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Open the sql plus in your system. Login as username : sys as sysdba and the password which is given at the time of installation. After connected to Oracle database you need to create the scott schema. Run this script: CREATE USER scott IDENTIFIED BY tiger; scott is the user tiger is the password. Grant all access to user scott,run this script: GRANT ALL PRIVILEGES TO scott; Download the Oracle default tables file: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing Extract the downloaded file in your system. Then Connect to Scott user as: CONNECT scott Password: tiger Then type this in your sql command prompt: @(extract file path)\oracle.sql; for example: @C:\Users\ABC\oracle\oracle.sql; Now you done all the steps completely and you can work with scott schema and all the default tables. Check This in your system to show all the tables in scott user: Select * from tab; After that you can see all the default table in scott user. Just run it to show the default data inside the tables. Select * from emp; If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your system. Like and subscribe this video: http://www.youtube.com/watch?v=vHcAs7k93AQ
Views: 17352 variabletips
SSIS Tutorial Part 60-Perform Upsert  (Update/Insert  SCD1) by Lookup Transformation in SSIS Package
 
23:07
SSIS Tutorial Scenario: Let's say we have to load a dimension table from text file. Our business Key is SSN. We need to insert new records depending upon values of SSN column, If any new then we need to insert this records. If SSN already existing in Table then we need to find out if any other column is changed from Source columns values. If that is true then we have to update those values. What we will learn in this video How to Read the data from Flat file in SSIS Package How to perform Lookup to Find out Existing or Non Existing Records in Destination Table From Source How to Insert new Records by using OLE DB Destination How to update existing Records by using OLE DB Command Transformation in SSIS Package Link to the blog post for this video with script if used http://sqlage.blogspot.com/2015/05/perform-upsert-updateinsert-scd1-by.html Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 33042 TechBrothersIT
Tutorial#68 SubQuery in Oracle SQL Database by rakesh malviya
 
08:15
Explaining what is SubQuery in Oracle SQL and How SubQuery internally work in Oracle SQL database a subquery is a query within a query(Parent and Child Query). You can create subqueries within your SQL statements. These subqueries can reside in the WHERE, FROM and SELECT clause ------------------------------------------------------------------------------ Assignment Link: Assignment Link will come Soon --------------------------------------------------------------------------------------- In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow Rakesh Malviya on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR
Views: 42 EqualConnect Coach
Mysql table name with space in mysql
 
01:10
Demo of Table :- CREATE TABLE IF NOT EXISTS `TABLE 8` ( `title` varchar(56) DEFAULT NULL, `platform` varchar(16) DEFAULT NULL, `score` decimal(2,1) DEFAULT NULL, `genre` varchar(17) DEFAULT NULL, `editors_choice` varchar(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `TABLE 8` -- INSERT INTO `TABLE 8` (`title`, `platform`, `score`, `genre`, `editors_choice`) VALUES ('LittleBigPlanet PS Vita', 'PlayStation Vita', 9.0, 'Platformer', 'Y'), ('LittleBigPlanet PS Vita -- Marvel Super Hero Edition', 'PlayStation Vita', 9.0, 'Platformer', 'Y'), ('Splice: Tree of Life', 'iPad', 8.5, 'Puzzle', 'N'), ('NHL 13', 'Xbox 360', 8.5, 'Sports', 'N'), ('NHL 13', 'PlayStation 3', 8.5, 'Sports', 'N'), ('Total War Battles: Shogun', 'Macintosh', 7.0, 'Strategy', 'N'), ('Double Dragon: Neon', 'Xbox 360', 3.0, 'Fighting', 'N'), ('Guild Wars 2', 'PC', 9.0, 'RPG', 'Y'); select Query :- select * from `TABLE 8`; -~-~~-~~~-~~-~- Please watch: "create data dictionary using code" https://www.youtube.com/watch?v=oUtfsjBFz_k -~-~~-~~~-~~-~-
Views: 68 kumawat ajay
7 - Checking before insert, Stop duplicate entries  - Java Swing Project
 
05:35
In this video we are going to write code to stop duplicate entries, it happen when we insert form data in database table directly, What we need to do is that we have to insert in database table before checking with sql query. Download Source Code : https://github.com/KamaleshSah/Bus-Managment-Application
Views: 7933 KAMLESHUTUBE
create and use function in sql. not exist in SQL PART 8
 
04:10
sql tutorial for beginners. not exists function in sql. part 8 create and use function in sql. not exists sql statement, how to write an sql statement of the records of a table where not exist in other table (child table) in sql statement. sql tutorial for beginners you can use this statement in sql view, sql stored procedure, sql function. ~~~~~~~~~~~~~ Subscriber will be notified when I will upload new tutorials in future. Many more new tutorials coming soon, so stay tuned! https://www.youtube.com/swiftlearn ~~~~~~~~~~~~~ You can also know all the programming techniques, and bug fixing, error solution in my channel Swift learn. The main topics of this channel are c#.net, asp.net, WCF, sql server, crystal report, RDLC report, HTML, CSS, javascript, Android etc. ~~~~~~~~~~~~~ Share this video with anyone if you think as useful. Please leave any suggestions for future tutorials in the comment section below. ~~~~~~~~~~~~~ Connect with me https://www.facebook.com/groups/swiftlearn/ All playlist c# tutorial for beginners Swift Learn https://www.youtube.com/playlist?list=PLINPYKVRUHyXoPn0-4NIdFn8RrQQDdAki c# linq to sql tutorial Swift Learn https://www.youtube.com/playlist?list=PLINPYKVRUHyVsic1g2CUn2pR5aKjNd3Nc asp.net tutorial for beginners full Swift Learn https://www.youtube.com/playlist?list=PLINPYKVRUHyUjmHrYfAq1l8pe5eXhkZqF crystal report c# in sql Swift Learn https://www.youtube.com/playlist?list=PLINPYKVRUHyWao6CC3Eu0srQxJjgkfLsm SQL Tutorial for beginners full Swift Learn https://www.youtube.com/playlist?list=PLINPYKVRUHyVOv6mx6xU7HEgGcfLk4Kmz
Views: 107 Swift Learn
Troubleshooting the FileMaker ODBC “Table Does Not Exist” Error
 
01:47
This video shows how to solve the "Table not found" error which can occur if there is not a TO on the Relationship Graph for the table when connecting via ODBC. FmPro Migrator Platinum Edition - $99 https://sites.fastspring.com/fmpromigrator/product/fmpromigratorplat_month_sub_fs1
Views: 1162 David Simpson
How to solve insufficient privileges in oracle and create a new user
 
03:09
This video is about how to solve the error insufficient privileges in oracle and how to create a new user in oracle......... You can use this method for sql developer. After opening sql developer go to command prompt and follow this instruction .... I hope this will help you for solving the insufficient privileges in oracle 10g...... -------------------------------------------------------------------------------- If face any problem then .. Contact/Follow on........ Email : [email protected] Google+ : https://plus.google.com/102074100342156490577 Twitter : https://twitter.com/Alamgir21409730 Facebook : https://www.facebook.com/computersoftwaresolution/ Subscribe this youtube channel : https://www.youtube.com/channel/UCkE_J-tXiqxzASO6nlB8D6w
Views: 6750 Education Help
Microsoft Excel, SQL & Internet Tips : Creating a Table in MySQL
 
02:02
When creating a table in MySQL, make the table before opening a parenthesis to put in the fields that exist in the table. Make a new table in SQL with tips from a software developer in this free video on using MySQL. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department. Filmmaker: Tim Brown
Views: 3511 eHow
SQL tutorials 18: SQL Foreign Key Constraint By Manish Sharma
 
10:23
SQL Tutorial 18: SQL foreign key constraint. Topic covered in this tutorial 1. Defining SQL foreign key using create table at column level 2. Defining SQL foreign key using create table at table level 1. Defining SQL foreign key using Alter Table statement Links Website article: http://www.rebellionrider.com/sql-foreign-key.htm Primary key tutorial: http://www.rebellionrider.com/sql-foreign-key.htm Create Table Tutorial: http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is SQL Developer. 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 Foreign key is an Input/output data constraint which is also known as referential integrity constraint. Foreign key represent a link or say a relationship between columns of tables. Similar to primary key constraint Foreign Key constraint is also of two types. Simple Foreign key constraint and Composite Foreign key constraint. Constraint which involves only one column in foreign key in child table and one column in reference key in parent table is called Simple Foreign Key. While the constraint which involves more than one column in foreign key in child table and more than one column in reference key in the parent table is called Composite Foreign Key.
Views: 101508 Manish Sharma
MySQL. Урок 3.
 
09:57
Создаем базы данных. Удаляем базы данных. Операторы CREATE DATEBASE, DROP DATABASE, IF EXISTS, IF NOT EXISTS, комментарии. http://kudrenko.info
IIF function in SQL Server
 
04:00
iif function in sql server 2012 iif function in sql server example sql server iif function example In this video we will discuss IIF function in SQL Server. IIF function Introduced in SQL Server 2012 Returns one of two the values, depending on whether the Boolean expression evaluates to true or false IIF is a shorthand way for writing a CASE expression Syntax : IIF ( boolean_expression, true_value, false_value ) Example : Returns Male as the boolean expression evaluates to TRUE DECLARE @Gender INT SET @Gender = 1 SELECT IIF( @Gender = 1, 'Male', 'Femlae') AS Gender Example : Using IIF() function with table data. We will use the following Employees table for this example. SQL Script to create Employees table Create table Employees ( Id int primary key identity, Name nvarchar(10), GenderId int ) Go Insert into Employees values ('Mark', 1) Insert into Employees values ('John', 1) Insert into Employees values ('Amy', 2) Insert into Employees values ('Ben', 1) Insert into Employees values ('Sara', 2) Insert into Employees values ('David', 1) Go Write a query to display Gender along with employee Name and GenderId. We can achieve this either by using CASE or IIF. Using CASE statement SELECT Name, GenderId, CASE WHEN GenderId = 1 THEN 'Male' ELSE 'Female' END AS Gender FROM Employees Using IIF function SELECT Name, GenderId, IIF(GenderId = 1, 'Male', 'Female') AS Gender FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/iif-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/iif-function-in-sql-server_14.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: 32603 kudvenkat
SQL crear tabla solo si no existe (create table only if it does not exists already)
 
12:25
On this channel you can found: 1. Tutorials of any kind, specially of JAVA and C# programming, as well as web development. 2. Psychological concept's and idea's, specially from neuropsychology. 3. Thoughts, proposals and social criticism. Surely you can found something for you on this channel. So, enjoy you stay, and if you like the content, then, please, suscríbe. En este canal puedes encontrar: 1. Tutoriales de todo tipo, especialmente de programación en JAVA, C# y desarrollo de páginas web. 2. ideas acerca de la psicología, y especialmente de la neuropsicología. 3. Reflexiones, propuestas y críticas sociales. Así que divierte y suscríbete si te gusta el contenido, probablemente puedas encontrar algo para ti. Mi página web (visit my webpage): http://adf.ly/1XkllR Mi pagina de facebook: http://adf.ly/1Zdt0E Mi twitter: http://adf.ly/1Zdt70 Mi canal de YouNow: http://adf.ly/1ZdtCS
Views: 1015 neurosistemas
Alert creation in oracle Apps
 
07:43
Overview: You can use alerts simply to notify one person/multiple persons about an event or some data change. There are two type of alerts Event based Alerts Periodic Alerts Event based Alerts: These Alerts are fired/triggered based on some change in data in the database. Ex: If you want to notify your manager when you create an item in the inventory you can use Event based alerts. When you create an item in the inventory it will create a new record in mtl_system_items_b, here inserting a record in the table is an event so when ever a new record is inserted it will send the alert. In same alert you can also send the information related to that particular item. Periodic Alerts: These Alerts are triggered hourly, daily, weekly, monthly or yearly based on your input. Ex: If you want to know list of all items created on that day at the end of day you can use periodic alerts repeating periodically by single day. This alert is not based on any changes to database. This alert will notify you everyday regardless of data exists or not that means even if no items are created you will get a blank notification.
Views: 13793 rajasekhar reddy
Foreign Key in Oracle
 
07:00
Foreign Key in Oracle oracle foreign key WHAT IS A FOREIGN KEY IN ORACLE? 1)A foreign key is a use to make referential integrity in database. 2)Foreign key values in one table must also appear in another table also. 3)The referenced table is called the parent table. 4)Table with the foreign key is called the child table. 5)The foreign key generally reference a primary key in the parent table. CREATE TABLE DEPT --- parent table ( DEPT_ID NUMERIC(10) NOT NULL, EMP_ID NUMERIC(10) NOT NULL, CONSTRAINT DEP_PK PRIMARY KEY (DEPT_ID) ); CREATE TABLE EMPLOYEE -- child table ( EMP_ID NUMERIC(10) NOT NULL, NAME VARCHAR2(50) NOT NULL, CITY VARCHAR2(50), DEPT_NO NUMERIC(10), CONSTRAINT ID_PK PRIMARY KEY (EMP_ID), CONSTRAINT FK_DEP FOREIGN KEY (DEPT_NO) REFERENCES DEPT(DEPT_ID) ); #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 434 Tech Query Pond
SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)
 
06:34
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression. ● What Is Case Expression ● Syntax of Simple Case Expression ● Query 1. Column name of a table as Search expression in CASE ● Query 2. String as Search expression in CASE Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/simple-case-expression ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 37313 Manish Sharma
Check if value exists in the database asp.net c#
 
06:37
In this video tutorial i will give a example of data which is either available or not. Whole process is done through SqlDataReader class. Also available in: -- How to use SqlDataReader class. --How to check data in the database table --How to check availability of data in the database table --How to read particular column from data reader
Views: 16778 ASPNET WEBFORM

Diovan 80 mg novartis rebate
Lopid 600 mg preciosa
Cialis 5 mg price walgreens
OLMESARTAN MEDOXOMIL/HYDROCHLOROTHIAZIDE 40 MG/12.5 MG FILM-COATED TABLETS
Buspar 30 mg twice a day abbreviation