Posts

Showing posts from May, 2019

History of MySQL

MongoDB with .Net Core: https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL got over 100 million downloads and it’s most popular database in history. MySQL is a Relational Database Management System it’s owned by Oracle, but MySQL is open source under GPL and it’s free to use. Some people say my sequel but officially pronounced My Ess Que Ell and some people calling it my sequel. In 1995 a Swedish company called MySQL. MySQL developed by Michael Monty Widenius, David Axmark and Allan Larsson. MySQL named on Monty’s daughter. MySQL released under a GPL (General Public License) and it just gives to public license in 2000. 2001 it had over 2 million active installations. In 2005 Oracle acquired InnoDB, this is the storage back-end of MySQL. MySQL over 8

History of SQL

Hello and welcome to everyone. Today we will learn SQL history. C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ We previously discussed in 1970, Dr. Codd published a paper about the Relational Data Model and it may have ended there. Donald Chamberlin and Raymond Boyce started working on SQL in the 70s. In 1973 Chamberlin and Boyce started working on SQL and what they called SEQUEL. SEQUEL full form is Structured English Query Language. After that, they have changed it to SQL due to a trademark conflict with a UK aircraft company. A lot of people say either SQL or SEQUEL. This organization of work that they were doing on sequel started making a buzz in the industry. Donald Chamberlin and Raymond Boyce started working on a SQL based relational database management system this company is called Relational Software I

Principles Relational Database

Image
Hello and welcome to everyone. Today we will learn about principles of relational database that are proposed by Edgar F. Codd in 1969. C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ Principle of Relational database concepts firstly proposed by Edgar F. Codd in 1969. Database tables used to store data and these tables have relations to other tables in Relational database. When you understanding following principles then it will help you to develop and design a relational database. Following are the E.F. Codd principles of a relational database.  1. Relational Databases use a table to store data and the stored data tables have relations to other tables.  2. Relational Databases are the most used databases in the world such as smartphones, desktops, automobiles, etc. and these all information logica

Types of Database

Hello and welcome to everyone. Today we will learn about MySQL concept like Database types in details. C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ There are different types of databases uses in these days. Following are the different types of database 1.         Relational Databases 2.         Hierarchical Databases 3.         Cloud Databases 4.         Operational Databases 5.         Object-oriented Databases 6.         Network Database 7.         Distributed Databases 8.         Graph Databases 9.         Non-Relational Databases 10.    End-user Databases C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ 1.         R

MySQL – Data and Database

Hello and welcome to everyone. Today we will learn about MySQL concepts like what is Data and Database. C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ Data Data is a collection of information. Data means data can be any information. For example, there is an employee and all the information about the employee like employee id, employee name, employee age, employee phone number, employee address, employee salary, employee designation, this is called data or it’s called data elements. C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ Database The database is a systematic collection of data. The database is a set of related data and how it is s
https://expertwithsagarjaybhay.com/c-interface/
https://expertwithsagarjaybhay.com/c-inheritance/
https://expertwithsagarjaybhay.com/object-in-c/