Home
Videos uploaded by user “PROGRAMMER'S JUNCTION”
Data Structures and Algorithms FULL LECTURE || Data Structure Lecture || Computer  Engineering
 
06:49:24
How to implement,binary search tree,bst,dfs,bfs,Data structure,heap sort,max heap,min heap,store hierarchical data,Efficient Data structure,data structures types,data structure,linked list,structure types,graph,data structures c++,data structures,examples of data structures, What is data structure,types of data structure,topics in data structures, important data structures What is algorithm and data structure? What is the difference between data structure and #algorithm? What do you learn in a data structures class? Why do we go for data structure? data structures and algorithms course data structures course #data #structures online course credit learn algorithms and data structures c++ data structures and algorithms learn data structure and algorithm online data structures #lessons data structures and algorithms #certification Algorithms + Data Structures = #Programs is a 1976 book written by Niklaus Wirth covering some of the fundamental topics of computer programming, particularly that algorithms and data structures are inherently related. For example, if one has a sorted list one will use a search algorithm optimal for sorted lists Algorithm is a step-by-step procedure, which defines a set of instructions to be executed in a certain order to get the desired output. Algorithms are generally created independent of underlying languages, i.e. an algorithm can be implemented in more than one programming language. From the data structure point of view, following are some important categories of algorithms - Search - Algorithm to search an item in a data structure. Sort - Algorithm to sort items in a certain order. Insert - Algorithm to insert item in a data structure. Update - Algorithm to update an existing item in a data structure. Delete - Algorithm to delete an existing item from a data structure
Views: 5947 PROGRAMMER'S JUNCTION
SUDRA THE RISING शूद्र द राइजिंग
 
01:39:45
sudra,the rising,movie based on st sc, dalit soshan,dalit,sudra definiton, what is sudra,who is sudra,sudra movie, movie sudra, #शूद्र_द_राइजिंग #Shudra_The_Rising
सम्पूर्ण भारतीय इतिहास 89 Complete Indian History  इतिहास के सबसे जरूरी 2400 प्रश्न SSC UPSC IAS IBP
 
10:02
British Conquest of India Decline of Mughal empire Rise of regional politics India in Eighteenth Century Advent of Europeans Factors that led to conquest of India by British Conquest of regional powers Resistance of Indian powers and causes of failure Evolution of British paramountcy over princely states British Administration British colonialism in India British policies in India British Economic Policies and their impact Rise of capitalist class Activities of Christian Missionaries Governors- Generals and administration till 1857 Colonial administration till 1857 Early Resistance to British Rule Tribal revolts Various tribal movements in India- appendix Civil rebellions and peasant revolts Nature and significance of civil rebellions Various peasant movements in India The revolt of 1857 Nationalism in India-I Rise of nationalism in India Social basis of Indian Nationalism Rise and growth of Indian National Congress Policies and programmes of early nationalists Role of literature and news-media in freedom struggle Nationalism in India-II Intensification of nationalist movement Home Rule League Militants and Revolutionaries Gadar movement Indian Freedom Struggle Under Gandhi Gandhi in South Africa Non- cooperation Movement Civil Disobedience Movement Round Table Conference Poona Pact 1939 Tripuri Session August Offer Individual Satyagraha 1940-41 Quit India Movement British Official response to national movement Social Reforms in British India Regeneration, reform and renaissance in India Analysis Social reformers in India Reforms in western India Reforms in south India Role of reformers Nature and limitation of 19th century renaissance Reasons of rise Caste movement in south India Caste movements in northern and eastern India Struggle by the Masses Trade union movement in India Peasant movements in modern India The states people’s movements Socialists and left bloc in congress Indian National Army Naval mutiny of 1946 Partition of India Rise and growth of communalism Partition of India and attainment of freedom R. Formula Wavell Plan Cabinet Mission Plan Mountbatten Plan ------------------------------------------------- #modernhistory #Independence #HistoryofIndia -------------------------------------------------
Microsoft Azure Fundamentals Websites 22 How Do I Set Up and Utilize Redis Cache
 
08:13
What is Microsoft Azure? Azure is a cloud computing platform which was launched by Microsoft in February 2010. It is an open and flexible cloud platform which helps in development, data storage, service hosting, and service management. The Azure tool hosts web applications over the internet with the help of Microsoft data centers. In this tutorial, you will learn: What is Cloud Computing? What is Microsoft Azure? Types of Azure Clouds Azure key Concepts Azure Domains (Components) Traditional vs. Azure Cloud Model Applications of Azure Advantages of Azure DisAdvantages of Azure Types of Azure Clouds There are mainly three types of clouds in Microsoft Azure are: PAAS SAAS IASS Compute It offers computing operations like app hosting, development, and deployment in Azure Platform. It has the following components: Virtual Machine: Allows you to deploy any language, workload in any operating system Virtual Machine Scale Sets: Allows you to create thousands of similar virtual machines in minutes Azure Container Service: Create a container hosting solution which is optimized for Azure. You scale and arrange applications using Kube, DC/OS, Swarm or Docker Azure Container Registry: This service store and manage container images across all types of Azure deployments Functions: Let's you write code regardless of infrastructure and provisioning of servers. In the situation when your functions call rate scales up. Batch: Batch processing helps you scale to tens, hundreds or thousands of virtual machines and execute computer pipelines. Service Fabric: Simplify microservice-based application development and lifecycle management. It supports Java, PHP, Node.js, Python, and Ruby. Storage Azure store is a cloud storage solution for modern applications. It is designed to meet the needs of their customer's demand for scalability. It allows you to store and process hundreds of terabytes of data. It has the following components: Blob Storage: Azure Blob storage is a service which stores unstructured data in the cloud as objects/blobs. You can store any type of text or binary data, such as a document, media file, or application installer. Queue Storage: It provides cloud messaging between application components. It delivers asynchronous messaging to establish communication between application components. File Storage: Using Azure File storage, you can migrate legacy applications. It relies on file shares to Azure quickly and without costly rewrites. Table Storage: Azure Table storage stores semi-structured NoSQL data in the cloud. It provides a key/attribute store with a schema-less design Can't get enough of the Microsoft Azure Fundamentals series? You're in luck! In this fourth course, the ever-popular Bob Tabor (of LearnVisualStudio.NET) explores Microsoft infrastructure as a service (IaaS) offerings by examining virtual machines (VMs) and virtual networks (Vnets). Learn to create and connect to a VM, create an image from a VM, create a cloud-only Vnet, and much more. Continue with a look at Azure products which didn't fit neatly into the other courses but which are just as exciting, including Microsoft Azure Mobile Services, Azure File Storage Service, Azure HDInsight, Azure Machine Learning, and Azure Media Services. Don't miss this chance to learn Azure fundamentals from a leading expert! The beginner section will help you to get a better understanding of Microsoft cloud platform. Here you will learn about Cloud Computing, Microsoft Cloud Infra, Microsoft Azure Offerings and Services, Advantages of Cloud Computing etc. By the end of this section, you will have a strong foundation in Cloud Computing and Microsoft Azure. The intermediate section will help you to learn how to develop cloud-based applications using ASP.NET MVC, ASP.NET Core and JavaScript based frameworks like Angular, React and Vue using Web Apps, API Apps, Mobile Apps, Azure Functions. Moreover, you will learn how to manage cloud Iaas offerings like Virtual Machines, Storage and Networking etc. What is Cloud Computing? Cloud computing is a term referred to storing and accessing of data over the internet. It doesn't store any data on the hard disk of your personal computer. In cloud computing, you access data from a remote server.
Oracle Administration 14 = Background processes of the Oracle Instance
 
18:22
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Using jQuery to Retrieve JSON via AJAX   19
 
16:53
Features of JavaScript #JavaScript is a object-based scripting language. Giving the user more control over the browser. It Handling dates and time. It Detecting the user's browser and OS, It is light weighted. JavaScript is a #scripting language and it is not java. JavaScript is #interpreter based scripting language. JavaScript Objects in Detail JavaScript Prototype in Plain, Detailed Language JavaScript Variable Scope and Hoisting Explained Understand JavaScript Closures With Ease Understand JavaScript Callback (Higher-Order) Functions Understand JavaScript’s “this” With Clarity, and Master It JavaScript’s Apply, Call, and Bind Methods are Essential Learn HTML5, CSS3, and Responsive WebSite Design Object Oriented JavaScript (OOP in JavaScript) Learn Node.js Completely and With Confidence Or Learn Meteor.js Properly JavaScript Custom Events with PubSub (coming soon) Unit Testing Your JavaScript Applications is Essential DOM (Document Object Model) and BOM (Browser Object Model) ECMAScript 3 and 5 The Best JavaScript Front-end Frameworks You Should be Using Preventing and Handling JavaScript Errors and Debugging Your Code BONUS: JavaScript Design Patterns that Every JavaScript Developer Should Know (coming soon)
सम्पूर्ण भारतीय इतिहास 23 Complete Indian History  इतिहास के सबसे जरूरी 2400 प्रश्न SSC UPSC IAS IBP
 
10:02
British Conquest of India Decline of Mughal empire Rise of regional politics India in Eighteenth Century Advent of Europeans Factors that led to conquest of India by British Conquest of regional powers Resistance of Indian powers and causes of failure Evolution of British paramountcy over princely states British Administration British colonialism in India British policies in India British Economic Policies and their impact Rise of capitalist class Activities of Christian Missionaries Governors- Generals and administration till 1857 Colonial administration till 1857 Early Resistance to British Rule Tribal revolts Various tribal movements in India- appendix Civil rebellions and peasant revolts Nature and significance of civil rebellions Various peasant movements in India The revolt of 1857 Nationalism in India-I Rise of nationalism in India Social basis of Indian Nationalism Rise and growth of Indian National Congress Policies and programmes of early nationalists Role of literature and news-media in freedom struggle Nationalism in India-II Intensification of nationalist movement Home Rule League Militants and Revolutionaries Gadar movement Indian Freedom Struggle Under Gandhi Gandhi in South Africa Non- cooperation Movement Civil Disobedience Movement Round Table Conference Poona Pact 1939 Tripuri Session August Offer Individual Satyagraha 1940-41 Quit India Movement British Official response to national movement Social Reforms in British India Regeneration, reform and renaissance in India Analysis Social reformers in India Reforms in western India Reforms in south India Role of reformers Nature and limitation of 19th century renaissance Reasons of rise Caste movement in south India Caste movements in northern and eastern India Struggle by the Masses Trade union movement in India Peasant movements in modern India The states people’s movements Socialists and left bloc in congress Indian National Army Naval mutiny of 1946 Partition of India Rise and growth of communalism Partition of India and attainment of freedom R. Formula Wavell Plan Cabinet Mission Plan Mountbatten Plan ------------------------------------------------- #modernhistory #Independence #HistoryofIndia -------------------------------------------------
सम्पूर्ण भारतीय इतिहास 22 Complete Indian History  इतिहास के सबसे जरूरी 2400 प्रश्न SSC UPSC IAS IBP
 
10:02
British Conquest of India Decline of Mughal empire Rise of regional politics India in Eighteenth Century Advent of Europeans Factors that led to conquest of India by British Conquest of regional powers Resistance of Indian powers and causes of failure Evolution of British paramountcy over princely states British Administration British colonialism in India British policies in India British Economic Policies and their impact Rise of capitalist class Activities of Christian Missionaries Governors- Generals and administration till 1857 Colonial administration till 1857 Early Resistance to British Rule Tribal revolts Various tribal movements in India- appendix Civil rebellions and peasant revolts Nature and significance of civil rebellions Various peasant movements in India The revolt of 1857 Nationalism in India-I Rise of nationalism in India Social basis of Indian Nationalism Rise and growth of Indian National Congress Policies and programmes of early nationalists Role of literature and news-media in freedom struggle Nationalism in India-II Intensification of nationalist movement Home Rule League Militants and Revolutionaries Gadar movement Indian Freedom Struggle Under Gandhi Gandhi in South Africa Non- cooperation Movement Civil Disobedience Movement Round Table Conference Poona Pact 1939 Tripuri Session August Offer Individual Satyagraha 1940-41 Quit India Movement British Official response to national movement Social Reforms in British India Regeneration, reform and renaissance in India Analysis Social reformers in India Reforms in western India Reforms in south India Role of reformers Nature and limitation of 19th century renaissance Reasons of rise Caste movement in south India Caste movements in northern and eastern India Struggle by the Masses Trade union movement in India Peasant movements in modern India The states people’s movements Socialists and left bloc in congress Indian National Army Naval mutiny of 1946 Partition of India Rise and growth of communalism Partition of India and attainment of freedom R. Formula Wavell Plan Cabinet Mission Plan Mountbatten Plan ------------------------------------------------- #modernhistory #Independence #HistoryofIndia -------------------------------------------------
DATA STRUCTURE IN C GATE 2004 QUESTION
 
05:19
dbms,rdbms,for gate 2020,ugc net 2019,gate computer science,ugc net computer science, database management system,types of keys in database,super key,candidate key,foreign key, primary key,alternate key,joins in database,database normalizaton,second normal form, third normal form,bcnf,boyce codd normal form,attribute closure,closure of a functional dependency What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
DATABASE NORMALIZATION   BOYCE CODD NORMAL FORM BCNF   EXAMPLE   02
 
12:10
What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
Oracle Administration 03 = Data Control LanguageDCL   System Privileges Concepts
 
05:24
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Oracle Administration 01 = How to Creating a User in Oracle THEORY
 
17:11
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
DATABASE NORMALIZATION  SECOND NORMAL FORM 2NF   DEFINTION + EXAMPLE   01
 
16:31
What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
PL SQL Lec 23 Explicit cursors in PL SQL blocks Theory
 
28:13
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL
Oracle Administration 36 =  Redo Log Files Theory
 
22:34
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
ENGG MATHS    MATRIX    CS,GATE 2004
 
07:33
gate matrix questions,linear algebra shortcuts for gate, rank of a matrix,chapterwise gate mathematics solved papers, gate matrix questions with solutions,matrix algebra questions and answers, engineering mathematics matrices questions and answers, calculus gate questions
श्री रामचरितमानस भाग- 10 || प्रथम सोपन - बाल कांड ( 270-304 ) || सम्पूर्ण पाठ संगीत-भाषा सहित
 
41:45
ram charit manas,ramcharitmanas,ramayan,chaupai,doha,sortha,chhand, rola,baal kand,sundar kand,lanka kand,sopan,sopaan,uttar kand, shiv parvati samvaad,garud kagbhusundi samvaad,ram laxman samvaad, ravan ram samvaad,ravan angad samvaad,ashok vatika,aranya kand,ayodhya kand
सम्पूर्ण भारतीय इतिहास 66 Complete Indian History  इतिहास के सबसे जरूरी 2400 प्रश्न SSC UPSC IAS IBP
 
10:02
British Conquest of India Decline of Mughal empire Rise of regional politics India in Eighteenth Century Advent of Europeans Factors that led to conquest of India by British Conquest of regional powers Resistance of Indian powers and causes of failure Evolution of British paramountcy over princely states British Administration British colonialism in India British policies in India British Economic Policies and their impact Rise of capitalist class Activities of Christian Missionaries Governors- Generals and administration till 1857 Colonial administration till 1857 Early Resistance to British Rule Tribal revolts Various tribal movements in India- appendix Civil rebellions and peasant revolts Nature and significance of civil rebellions Various peasant movements in India The revolt of 1857 Nationalism in India-I Rise of nationalism in India Social basis of Indian Nationalism Rise and growth of Indian National Congress Policies and programmes of early nationalists Role of literature and news-media in freedom struggle Nationalism in India-II Intensification of nationalist movement Home Rule League Militants and Revolutionaries Gadar movement Indian Freedom Struggle Under Gandhi Gandhi in South Africa Non- cooperation Movement Civil Disobedience Movement Round Table Conference Poona Pact 1939 Tripuri Session August Offer Individual Satyagraha 1940-41 Quit India Movement British Official response to national movement Social Reforms in British India Regeneration, reform and renaissance in India Analysis Social reformers in India Reforms in western India Reforms in south India Role of reformers Nature and limitation of 19th century renaissance Reasons of rise Caste movement in south India Caste movements in northern and eastern India Struggle by the Masses Trade union movement in India Peasant movements in modern India The states people’s movements Socialists and left bloc in congress Indian National Army Naval mutiny of 1946 Partition of India Rise and growth of communalism Partition of India and attainment of freedom R. Formula Wavell Plan Cabinet Mission Plan Mountbatten Plan ------------------------------------------------- #modernhistory #Independence #HistoryofIndia -------------------------------------------------
Oracle Administration 13 =Background processes of the Oracle Instance
 
22:25
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Data Structures and Algorithms 23 || Data Structure Lecture || Computer Science and Engineering
 
10:15
What is algorithm and data structure? What is the difference between data structure and #algorithm? What do you learn in a data structures class? Why do we go for data structure? data structures and algorithms course data structures course #data #structures online course credit learn algorithms and data structures c++ data structures and algorithms learn data structure and algorithm online data structures #lessons data structures and algorithms #certification Algorithms + Data Structures = #Programs is a 1976 book written by Niklaus Wirth covering some of the fundamental topics of computer programming, particularly that algorithms and data structures are inherently related. For example, if one has a sorted list one will use a search algorithm optimal for sorted lists Algorithm is a step-by-step procedure, which defines a set of instructions to be executed in a certain order to get the desired output. Algorithms are generally created independent of underlying languages, i.e. an algorithm can be implemented in more than one programming language. From the data structure point of view, following are some important categories of algorithms − Search − Algorithm to search an item in a data structure. Sort − Algorithm to sort items in a certain order. Insert − Algorithm to insert item in a data structure. Update − Algorithm to update an existing item in a data structure. Delete − Algorithm to delete an existing item from a data structure
DATA STRUCTURE IN C TREE TRAVERSAL GATE 2007 QUESTION
 
08:43
dbms,rdbms,for gate 2020,ugc net 2019,gate computer science,ugc net computer science, database management system,types of keys in database,super key,candidate key,foreign key, primary key,alternate key,joins in database,database normalizaton,second normal form, third normal form,bcnf,boyce codd normal form,attribute closure,closure of a functional dependency What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
Oracle Administraton 06 = Object Privileges LIVE DEMO
 
25:54
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
सुन्दरकाण्ड 04 || श्री रामचरितमानस || रामचरितमानस अर्थ सहित सम्पूर्ण
 
21:37
sunderkand,sunderkand full in hindi,sunderkand lyrics,sunder kand se labh,sunder kand ke fayde, sunderkand in hindi,sunderkand chaupai,sunderkand full in hindi,sweet sunder kand,hanuman chailsa, sunderkand in hindi,रामचरितमानस,सुन्दरकाण्ड,sunderkand paath in hindi with meaning,sunderkand lyrics in avadhi
BCNF  EXAMPLE 06  ||  DATABASE NORMALIZATION ||  DATABASE MANAGEMENT SYSTEM
 
14:08
dbms,rdbms,for gate 2020,ugc net 2019,gate computer science,ugc net computer science, database management system,types of keys in database,super key,candidate key,foreign key, primary key,alternate key,joins in database,database normalizaton,second normal form, third normal form,bcnf,boyce codd normal form,attribute closure,closure of a functional dependency What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
THIRD NORMAL FORM  FORMAL DEFINITION  EXAMPLE   01
 
28:27
dbms,rdbms,for gate 2020,ugc net 2019,gate computer science,ugc net computer science, database management system,types of keys in database,super key,candidate key,foreign key, primary key,alternate key,joins in database,database normalizaton,second normal form, third normal form,bcnf,boyce codd normal form,attribute closure,closure of a functional dependency What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
PL SQL Lec 15 LOOP  END LOOP statement Theory
 
22:41
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL
सुन्दरकाण्ड 05 || श्री रामचरितमानस || रामचरितमानस अर्थ सहित सम्पूर्ण
 
21:58
sunderkand,sunderkand full in hindi,sunderkand lyrics,sunder kand se labh,sunder kand ke fayde, sunderkand in hindi,sunderkand chaupai,sunderkand full in hindi,sweet sunder kand,hanuman chailsa, sunderkand in hindi,रामचरितमानस,सुन्दरकाण्ड,sunderkand paath in hindi with meaning,sunderkand lyrics in avadhi
आधुनिक भारत का इतिहास 01 || Modern History of india || SSC UPSC IAS IBPS RAILWAYS PCS SSC CGL
 
10:42
British Conquest of India Decline of Mughal empire Rise of regional politics India in Eighteenth Century Advent of Europeans Factors that led to conquest of India by British Conquest of regional powers Resistance of Indian powers and causes of failure Evolution of British paramountcy over princely states British Administration British colonialism in India British policies in India British Economic Policies and their impact Rise of capitalist class Activities of Christian Missionaries Governors- Generals and administration till 1857 Colonial administration till 1857 Early Resistance to British Rule Tribal revolts Various tribal movements in India- appendix Civil rebellions and peasant revolts Nature and significance of civil rebellions Various peasant movements in India The revolt of 1857 Nationalism in India-I Rise of nationalism in India Social basis of Indian Nationalism Rise and growth of Indian National Congress Policies and programmes of early nationalists Role of literature and news-media in freedom struggle Nationalism in India-II Intensification of nationalist movement Home Rule League Militants and Revolutionaries Gadar movement Indian Freedom Struggle Under Gandhi Gandhi in South Africa Non- cooperation Movement Civil Disobedience Movement Round Table Conference Poona Pact 1939 Tripuri Session August Offer Individual Satyagraha 1940-41 Quit India Movement British Official response to national movement Social Reforms in British India Regeneration, reform and renaissance in India Analysis Social reformers in India Reforms in western India Reforms in south India Role of reformers Nature and limitation of 19th century renaissance Reasons of rise Caste movement in south India Caste movements in northern and eastern India Struggle by the Masses Trade union movement in India Peasant movements in modern India The states people’s movements Socialists and left bloc in congress Indian National Army Naval mutiny of 1946 Partition of India Rise and growth of communalism Partition of India and attainment of freedom R. Formula Wavell Plan Cabinet Mission Plan Mountbatten Plan ------------------------------------------------- #modernhistory #Independence #HistoryofIndia -------------------------------------------------
Visual Basic Fundamentals for Absolute Beginners 20 Enumerations and the switch Decision Statement
 
21:02
The DOT NET Framework’s Base Class Library offers user interface, database connectivity, data access, cryptography, web application development, numeric algorithms, network communications etc. Programmers produce software by combining their own source code with the DOT NET Framework and other libraries. The DOT NET Framework is projected to be used by most new applications created for the Windows platform. Microsoft also produces an integrated largely for DOT NET software called Visual Studio. The DOT NET is a software framework. It is developed by Microsoft. It includes a large library and also provides language inter-operability across some programming languages. Language inter-operability refers the capability of two different languages to interact and operate on the same kind of data structures. The programs written for DOT NET execute in a software environment. The name of the software environment is Common Language Runtime (#CLR). It is the virtual machine component. The compiled code is converted into machine code at first. Then it is executed by computer’s CPU. The CLR provides additional services like exception handling, memory management, type safety, garbage collection, thread management etc. Design Features of DOT NET #Framework Visual Basic .NET (VB .Net) is the advance form of the Visual Basic Programming language. It hosts a number of features that helps web developers to create bug-free custom web application in an easiest manner. Some of the important features of VB .Net are mentioned below: • VB .Net includes features like in-place menu editor, automatic control anchoring and docking etc, all of which aid web programmers to create web application easily and quickly. • This programming language provides automatic formatting of code, improved object browser, XML designer and lots more. • By using this computer language, VB.Net web developers can easily create web application including features like event log, performance counters, file system etc. • Since VB.Net is an object oriented programming language, web programmers can create enterprise-class code using full object-oriented constructs. • It provides support for language features like implementation inheritance, encapsulation and polymorphism etc • Visual Basic .NET provides a visual forms designer to help web developers create web forms easily. Besides this, developers can use “drag and drop” feature to place elements according to their business requirements. • #VB.NET supports COM interoperability and enables developers to control the existing code for web application. It offers interoperability with other computer languages supporting .NET framework. #Interoperability Common Language Runtime engine (CLR) Language independence Base Class Library #Simplified deployment #Security #Portability
सुन्दरकाण्ड 06 || श्री रामचरितमानस || रामचरितमानस अर्थ सहित सम्पूर्ण
 
21:47
sunderkand,sunderkand full in hindi,sunderkand lyrics,sunder kand se labh,sunder kand ke fayde, sunderkand in hindi,sunderkand chaupai,sunderkand full in hindi,sweet sunder kand,hanuman chailsa, sunderkand in hindi,रामचरितमानस,सुन्दरकाण्ड,sunderkand paath in hindi with meaning,sunderkand lyrics in avadhi
ARMSTRONG AXIOMS || INFERENCE RULE || PROPERTIES OF FUNCTIONAL DEPENDENCIES
 
18:44
dbms,rdbms,for gate 2020,ugc net 2019,gate computer science,ugc net computer science, database management system,types of keys in database,super key,candidate key,foreign key, primary key,alternate key,joins in database,database normalizaton,second normal form, third normal form,bcnf,boyce codd normal form,attribute closure,closure of a functional dependency What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
Oracle SQL 02  Database Management System DBMS   Part 02 THEORY
 
13:17
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL
Oracle SQL Tutorials 43 ll Subqueries in Oracle Hands On
 
26:06
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL
Microsoft Azure Fundamentals 06 Creating an Organizational Account and Subscription
 
17:43
What is Microsoft Azure? Azure is a cloud computing platform which was launched by Microsoft in February 2010. It is an open and flexible cloud platform which helps in development, data storage, service hosting, and service management. The Azure tool hosts web applications over the internet with the help of Microsoft data centers. In this tutorial, you will learn: What is Cloud Computing? What is Microsoft Azure? Types of Azure Clouds Azure key Concepts Azure Domains (Components) Traditional vs. Azure Cloud Model Applications of Azure Advantages of Azure DisAdvantages of Azure Types of Azure Clouds There are mainly three types of clouds in Microsoft Azure are: PAAS SAAS IASS Compute It offers computing operations like app hosting, development, and deployment in Azure Platform. It has the following components: Virtual Machine: Allows you to deploy any language, workload in any operating system Virtual Machine Scale Sets: Allows you to create thousands of similar virtual machines in minutes Azure Container Service: Create a container hosting solution which is optimized for Azure. You scale and arrange applications using Kube, DC/OS, Swarm or Docker Azure Container Registry: This service store and manage container images across all types of Azure deployments Functions: Let's you write code regardless of infrastructure and provisioning of servers. In the situation when your functions call rate scales up. Batch: Batch processing helps you scale to tens, hundreds or thousands of virtual machines and execute computer pipelines. Service Fabric: Simplify microservice-based application development and lifecycle management. It supports Java, PHP, Node.js, Python, and Ruby. Storage Azure store is a cloud storage solution for modern applications. It is designed to meet the needs of their customer's demand for scalability. It allows you to store and process hundreds of terabytes of data. It has the following components: Blob Storage: Azure Blob storage is a service which stores unstructured data in the cloud as objects/blobs. You can store any type of text or binary data, such as a document, media file, or application installer. Queue Storage: It provides cloud messaging between application components. It delivers asynchronous messaging to establish communication between application components. File Storage: Using Azure File storage, you can migrate legacy applications. It relies on file shares to Azure quickly and without costly rewrites. Table Storage: Azure Table storage stores semi-structured NoSQL data in the cloud. It provides a key/attribute store with a schema-less design Can't get enough of the Microsoft Azure Fundamentals series? You're in luck! In this fourth course, the ever-popular Bob Tabor (of LearnVisualStudio.NET) explores Microsoft infrastructure as a service (IaaS) offerings by examining virtual machines (VMs) and virtual networks (Vnets). Learn to create and connect to a VM, create an image from a VM, create a cloud-only Vnet, and much more. Continue with a look at Azure products which didn't fit neatly into the other courses but which are just as exciting, including Microsoft Azure Mobile Services, Azure File Storage Service, Azure HDInsight, Azure Machine Learning, and Azure Media Services. Don't miss this chance to learn Azure fundamentals from a leading expert! The beginner section will help you to get a better understanding of Microsoft cloud platform. Here you will learn about Cloud Computing, Microsoft Cloud Infra, Microsoft Azure Offerings and Services, Advantages of Cloud Computing etc. By the end of this section, you will have a strong foundation in Cloud Computing and Microsoft Azure. The intermediate section will help you to learn how to develop cloud-based applications using ASP.NET MVC, ASP.NET Core and JavaScript based frameworks like Angular, React and Vue using Web Apps, API Apps, Mobile Apps, Azure Functions. Moreover, you will learn how to manage cloud Iaas offerings like Virtual Machines, Storage and Networking etc. What is Cloud Computing? Cloud computing is a term referred to storing and accessing of data over the internet. It doesn't store any data on the hard disk of your personal computer. In cloud computing, you access data from a remote server.
FINDING CANDIDATE KEY USING ATTRIBUTE CLOSURE   EXAMPLE 01
 
26:05
dbms,rdbms,for gate 2020,ugc net 2019,gate computer science,ugc net computer science, database management system,types of keys in database,super key,candidate key,foreign key, primary key,alternate key,joins in database,database normalizaton,second normal form, third normal form,bcnf,boyce codd normal form,attribute closure,closure of a functional dependency What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
श्री रामचरितमानस भाग- 01 || प्रथम सोपन - बाल कांड ( 01-25 ) || सम्पूर्ण पाठ संगीत-भाषा सहित
 
42:41
ram charit manas,ramcharitmanas,ramayan,chaupai,doha,sortha,chhand, rola,baal kand,sundar kand,lanka kand,sopan,sopaan,uttar kand, shiv parvati samvaad,garud kagbhusundi samvaad,ram laxman samvaad, ravan ram samvaad,ravan angad samvaad,ashok vatika,aranya kand,ayodhya kand
TRIVIAL    NON TRIVIAL    COMPLETE NON TRIVIAL FUNCTIONAL DEPENDENCY
 
12:05
What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
Series Introduction   01 Javascript Fundamentals Development for Absolute Beginners
 
11:20
turn on JavaScript,use of JavaScript, enable JavaScript,meaning of Java Script, javascript,javascript introduction,javascript operator, object,object constructor, #object methods,javascript array, javascript object properties,object prototype nested objects, object keys, javascript function,#function object, function #onclick,function return string, call javascript function from html Features of JavaScript #JavaScript is a object-based scripting language. Giving the user more control over the browser. It Handling dates and time. It Detecting the user's browser and OS, It is light weighted. JavaScript is a #scripting language and it is not java. JavaScript is #interpreter based scripting language.
Visual Basic Fundamentals for Absolute Beginners 07 Branching with the If  Then  Else Decision State
 
21:53
The DOT NET Framework’s Base Class Library offers user interface, database connectivity, data access, cryptography, web application development, numeric algorithms, network communications etc. Programmers produce software by combining their own source code with the DOT NET Framework and other libraries. The DOT NET Framework is projected to be used by most new applications created for the Windows platform. Microsoft also produces an integrated largely for DOT NET software called Visual Studio. The DOT NET is a software framework. It is developed by Microsoft. It includes a large library and also provides language inter-operability across some programming languages. Language inter-operability refers the capability of two different languages to interact and operate on the same kind of data structures. The programs written for DOT NET execute in a software environment. The name of the software environment is Common Language Runtime (#CLR). It is the virtual machine component. The compiled code is converted into machine code at first. Then it is executed by computer’s CPU. The CLR provides additional services like exception handling, memory management, type safety, garbage collection, thread management etc. Design Features of DOT NET #Framework Visual Basic .NET (VB .Net) is the advance form of the Visual Basic Programming language. It hosts a number of features that helps web developers to create bug-free custom web application in an easiest manner. Some of the important features of VB .Net are mentioned below: • VB .Net includes features like in-place menu editor, automatic control anchoring and docking etc, all of which aid web programmers to create web application easily and quickly. • This programming language provides automatic formatting of code, improved object browser, XML designer and lots more. • By using this computer language, VB.Net web developers can easily create web application including features like event log, performance counters, file system etc. • Since VB.Net is an object oriented programming language, web programmers can create enterprise-class code using full object-oriented constructs. • It provides support for language features like implementation inheritance, encapsulation and polymorphism etc • Visual Basic .NET provides a visual forms designer to help web developers create web forms easily. Besides this, developers can use “drag and drop” feature to place elements according to their business requirements. • #VB.NET supports COM interoperability and enables developers to control the existing code for web application. It offers interoperability with other computer languages supporting .NET framework. #Interoperability Common Language Runtime engine (CLR) Language independence Base Class Library #Simplified deployment #Security #Portability
PL SQL Lec 25 %TYPE and %ROWTYPE attributes
 
22:08
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL
DATABASE NORMALIZATION  THIRD NORMAL FORM 3NF DEFINITION +  EXAMPLE   01
 
25:02
What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples What is Normalization? Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. In this tutorial, you will learn- Database Normal Forms 1NF Rules What is a KEY? What is Composite Key 2NF Rules Database - Foreign Key What are transitive functional dependencies? 3NF Rules Boyce-Codd Normal Form (BCNF) The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form, and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form. Theory of Data Normalization in SQL is still being developed further. For example, there are discussions even on 6th Normal Form. However, in most practical applications, normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below- Database Normal Forms Now let's move into 1st Normal Forms 1NF (First Normal Form) Rules Each table cell should contain a single value. Each record needs to be unique. The above table in 1NF ---------------------------- #2NF #Normalization #3NF #NormalForms #BCNF
Oracle SQL 15  How to Insert data into a table
 
26:51
USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions." sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic, PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure ,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan, PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL
Visual Basic Fundamentals for Absolute Beginners 04 Dissecting the First Visual Basic Program You Cr
 
35:12
Visual Basic .NET (VB .Net) is the advance form of the Visual Basic Programming language. It hosts a number of features that helps web developers to create bug-free custom web application in an easiest manner. Some of the important features of VB .Net are mentioned below: • VB .Net includes features like in-place menu editor, automatic control anchoring and docking etc, all of which aid web programmers to create web application easily and quickly. • This programming language provides automatic formatting of code, improved object browser, XML designer and lots more. • By using this computer language, VB.Net web developers can easily create web application including features like event log, performance counters, file system etc. • Since VB.Net is an object oriented programming language, web programmers can create enterprise-class code using full object-oriented constructs. • It provides support for language features like implementation inheritance, encapsulation and polymorphism etc • Visual Basic .NET provides a visual forms designer to help web developers create web forms easily. Besides this, developers can use “drag and drop” feature to place elements according to their business requirements. • #VB.NET supports COM interoperability and enables developers to control the existing code for web application. It offers interoperability with other computer languages supporting .NET framework. #Interoperability Common Language Runtime engine (CLR) Language independence Base Class Library #Simplified deployment #Security #Portability
सुन्दरकाण्ड 03 || श्री रामचरितमानस || रामचरितमानस अर्थ सहित सम्पूर्ण
 
18:32
sunderkand,sunderkand full in hindi,sunderkand lyrics,sunder kand se labh,sunder kand ke fayde, sunderkand in hindi,sunderkand chaupai,sunderkand full in hindi,sweet sunder kand,hanuman chailsa, sunderkand in hindi,रामचरितमानस,सुन्दरकाण्ड,sunderkand paath in hindi with meaning,sunderkand lyrics in avadhi