Home
Videos uploaded by user “Data Science Center”
How To Uninstall Oracle Database 12c
 
10:14
How To Uninstall Oracle Database 12c i). Delete the environment variable ii). delete registries iii). delete oracle homw directory iv) delete directoy from program file v) delete directoy from start menue vi) clear the temporary file
Views: 27232 Data Science Center
How to start the oracle database,  ORA-01033: ORACLE initialization or shutdown in progress
 
04:40
ORA-01033: ORACLE initialization or shutdown in progress when oracle display error message ORA-01033, its mean that our database is not in working. For that it is very necessary to start the database. for that connect with the sys as sysdba user. and write the command startup open;
Views: 9072 Data Science Center
how to configure and connect oracle 12c database for the first time
 
06:31
how to configure and connect oracle 12c database for the first time, add pluggable database services in tnsname.ora file, connect sys as sysdba, alter session set container = pdborcl, startup open; alter user name_of_user identified by password account unlock;
Views: 3637 Data Science Center
Oracle Listener how to handle error message ORA 12541 TNS no listener
 
07:41
Step to handle the error message ORA-12541: TNS:no listener Right Click on Command Prompt, and click on Run as Administrator, then write following command: lsnrctl start lsnrctl services lsnrctl status lsnrctl start lsnrctl services lsnrctl status
Views: 8754 Data Science Center
Oracle Export Data and Import Data using DataPump
 
20:22
Steps to Import and Export Table Step 1: Create Directory Step 2: Grant Read and Write Permission to Directory Step 3: GRANT ROLL DATAPUMP_EXP_FULL_DATABASE to user Step 04: Use EXPDP and IMPDP to Export and Import data
Views: 5282 Data Science Center
how to connect with oracle sys user  with or without password
 
05:58
Connection with the sys as sysdba with password. Connection with the sys as sysdba without password. to connect without password make follwoing changes in sqlnet.ora file: SQLNET.AUTHENTICATION_SERVICES= (NTS) to connect with password make follwoing changes in sqlnet.ora file: SQLNET.AUTHENTICATION_SERVICES= (NONE)
Views: 3589 Data Science Center
Oracle 12C Installation method 01
 
07:46
Oracle 12c Installation method 01
Views: 266 Data Science Center
How to Reset Oracle Password: Oracle 12C SYS User using Password File
 
11:18
if you forgot sys user password in oracle 12c. check the path where oracle is install using command in command prompt: tnsping orcl after this move to the file file where orapwd file is store, delete check the name of existing password file and remember that name, delete or rename the existing password file. write the following command for creation of password file. orapwd file=name-of-file password=password
Views: 6349 Data Science Center
How to download YouTube Videos without any software
 
09:19
how to download YouTube videos on your PC
Views: 104 Data Science Center
Database Connectivity 01- Connectivity of Oracle database with Java using Netbeans 01
 
30:38
How to Connect Oracle database with Java using Netbeans IDE Database Connectivity, Create database Connection with Java. Oracle Thin Driver, OCI Driver,
Views: 927 Data Science Center
Drop Table and Flashback Table Statements
 
12:59
Drop table And Flashback Table Statements , Purge Table, Recycle bin, RECOVER Table etc...
Views: 143 Data Science Center
Data Warehousing (Creation of Data Warehouse)LECT 01
 
51:16
Creation of Data Warehouse, Master Data File, Log File, File Growth Concept, Sequence Creation, Set Recovery Model, Introduction of Different Dimension Table, Date Diff Function etc...
Views: 417 Data Science Center
Partition Table in SQL Server
 
34:31
Create a filegroup Create a partition function Create a partition scheme Create or modify a table and specify the partition scheme as the storage location. Split Patition
Views: 423 Data Science Center
Select Statements and Capability of Select Statement 01
 
01:21:01
Select Statements and Capability of Select Statement, Projection, Selection, Joining, NVL Function, null value
Views: 132 Data Science Center
Entity Relationship Model 05:  Degree of Relationship
 
05:52
Degree of Relationship The number of entity types that participate in a relationship are called degree of relationship. The most commonly used relationship in E-R Model are Unary, Binary and Ternary relationship. Unary Relationship A relationship among the instances of single entity type Unary relationship are also called recursive relationship Binary Relationship A relationship among the instances of two entity types Ternary Relationship A relationship among the instances of three entity types
How to connect SQL DEVELOPER ORACLE 12C: ORA-01017: invalid user name/password; logon denied
 
03:19
How to connect SQL DEVELOPER ORACLE 12C: ORA-01017: invalid user name/password; logon denied
Views: 5064 Data Science Center
Database Connectivity 02- Connectivity of Oracle database with Java using Netbeans 02
 
32:16
Database Connectivity 02- Connectivity of Oracle database with Java using Netbeans 02 Database Connection, Oracle Prepared Statement, Result Set,
Views: 375 Data Science Center
SSIS : Aggregate Calculation in Data Transformation and storage at Destination System
 
20:25
Calculation of Aggregate from extracted data from source and then store the aggregated data at the destination system
Views: 113 Data Science Center
Creation of new user in new Pluggable database  oracle 12c
 
04:18
How to create new user in pluggable data
Views: 103 Data Science Center
Entity Relationship Model 01:  Entity
 
12:38
ER Model Introduced by Peter Chen in 1976 It is logical representation of the data for an organization E-R Model is expressed in the term of entities, attributes and relationships. Graphical representation of an entity relationship model is called Entity Relationship Diagram (ERD). It is a semantic data model A semantic data model, used for the graphical representation of the conceptual database design. Entity An entity is a person, place, object, event, or concept in the user environment about which organization wish to maintain the data. Entity is used to three different meaning Entity type Entity Instance Entity set
SQL Loader 02
 
13:30
SQL Loader 02 sqlldr command utility for loading data from data file(.csv) to database table complete procedure
How to start working in SQL Developer 12C
 
05:56
How to start working in SQL Developer 12C
Views: 343 Data Science Center
Creation of Pluggable Databases (PDB) using DBCA and Adding Sample Schemas
 
20:10
Creation of Pluggable Databases (PDB) using DBCA and Adding Sample Schema 1) Start DBCA 2) Select the option of Manage Pluggable database 3) Select the option of Create Pluggable Database 4) Select the Container Database name 5) In Create Pluggable database Tab option select the option of Create Pluggable database using PDB File Sets and provide the path of sampleschema.xml file as Metadata file: Path of file is D:\app\OracleHomeUser\product\12.1.0\dbhome_1\assistants\dbca\templates \sampleschema.xml and path of Pluggable datafile backup D:\app\OracleHomeUser\product\12.1.0\dbhome_1\assistants\dbca\templates \sampleschema.xml\sampleschema.dfb 6) Then mention the name of Pluggable database
Views: 120 Data Science Center
Lect Create Table Rules
 
12:28
How to create table in any DBMS, how to set default value for any column, data types. Oracle DBMS Table Creation Method...
Views: 113 Data Science Center
SQL Loader 01
 
07:26
SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. SQL Loader loads data from multiple datafiles during the same load session. into multiple tables during the same load session. Data File SQL*Loader reads data from one or more files specified in the control file. From SQL*Loader's perspective, the data in the datafile is organized as records. It may be in the form of (.csv, .dat, .txt) Data File is in the form of Delimiter Separator or Fixed Position File. Control File Control file used for loading the data. Provide the interface between data file and table The control file tells SQL*Loader where to find the data, how to parse and interpret the data, and where to insert the data. Extension of Control file is .ctl Log File Provide the information about the process of loading from data file to database. Extension of log file is .txt. Bad File BAD specifies the name of the bad file created by SQL*Loader to store records that cause errors during insert or that are improperly formatted. A bad file is not automatically created if there are no rejected records. extension of .bad Discard File Business Logic “When condition of WHERE CLAUSE is not true”. extension of .dsc
Views: 121 Data Science Center
Data Movement in SQL Server, Simple Data Movement, Complex Data Movement
 
36:15
Simple Data Movement, Complex Data Movement, Import and Export Data Wizard, SSDT (SQL Server Data Tool) SSIS (SQL Server Integration Services) Control Flow, Data Flow, Connection Manager
Views: 233 Data Science Center
Entity Relationship Model 04:  Relationship
 
13:42
Relationship A meaningful association among entity types. Relationship is the association among the instance of one or more entity types. Relationship are the glue that holds together the various component of E-R model. Example STUDENT Completes COURSES Associative Entity An entity type that associates the instances of one or more entity types and contain attributes that are belonging to the relationship between those entity instances.
Replication in SQL Server
 
01:00:09
Replication Architecture in SQL Server, Distributor , Publisher , Subscriber Concept of Artical Types Of SQL Server Replication Agents, Snapshot Agent Log Reader Agent Distribution Agent Replication Types Snapshot Replication Transaction Replication. Merge Replication
Views: 739 Data Science Center
Foreign Key Constraint
 
37:57
How to assign a foreign Key, Rules for Referential Integrity, Deletion Operation with Foreign Key, On DELETE CASCADE, ON DELETE SET NULL, SAFTY CHECKS etc....
Views: 104 Data Science Center
Entity Relationship Model 02:  Types of Entity Type
 
06:09
Type of Entity Type Weak Entity Type An entity type whose existence depends on some other entity type. An entity type whose instances cannot exist without being linked with the instances of some other entity types. A weak entity type has no business meaning in an E-R diagram without the entity on which it depends. They cannot exist independently It has a partial identifiers. Strong Entity Type An entity type that exists independently of other entity types. An entity type whose instances can exist independently The entity type have there own identity It always have a identifier It is also called Identifying owner
Views: 111 Data Science Center
SSIS: Slowly Changing Dimensions (SCD)
 
16:03
Slowly changing dimension, types of slowly changing dimension, Fixed Attributes, Changing Attributes, Hierarchical Attribute
Views: 122 Data Science Center
Entity Relationship Model 03:  Attributes
 
21:55
Attribute A properties associated with entity type A property or characteristic of an entity type or relationship that is of interest to the organization. Attribute may be associated with relationship Example STUDENT Student_ID, Student_Name, Phone_Number, Email EMPLOYEE Employee_ID, Ename, Job, Hiredate Naming Attribute Initial capital letter followed by lowercase letters e.g. Ename If attribute consist of two word then use the underscore character to connect the words and start each word with capital letter e.g. Student_Name
SSIS: Merge Transformation
 
17:47
Extract data from 2 different sources , then in transformation step we merge data from two different sources, before merging data we must sort data and then perform merging of data. at the end we have to load data to destination.
Joining of Table  01
 
31:18
Concept of Join, Natural Join Clause, Using Clause
Views: 107 Data Science Center
Restracting  Data in Oracle
 
01:37:54
Limit Rows using Selection, Where Clause, Comparison Operator, Between and And, Like, In, IS NULL Pattern Matching using Like, Logical Operator,
Materilized view2
 
08:00
Materilized view Creation on Demand
User Assess Control in Oracle 12C, System Security, Data Security,
 
52:17
Creation of New User, Assign and Take back Different Privileges, Grant, Revoke, With Grant Option
Materilized view 01
 
17:01
How to CREATE MATERIALIZED View, MATERIALIZED VIEW LOG
How to Get YouTube Exposure : 4,000 Hours Watch Time in short time
 
03:06
Youtube change the the monetization program, instead of 10,000 view in life time now 1000 subscriber and 4000 hours in last 12 months. This video explain four steps to achieve the target in short time
Joining of Table 02
 
25:47
Oracle 12c Joining, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Self Join, Non Eque Join,
Alter Table Statements
 
37:10
How to alter table, Add new column in a table, Drop any column, Add Constraints, Drop Constraint, Read only table, read and write table..
Views: 118 Data Science Center
Group Function 02 Oracle
 
01:04:18
Having Clause, Group Function, Group By Clause

dating 365
online dating forum advice
dating your older brother's friend
dating website fsm
dating criteria list