database Archives « Online Class Notes

What are the fundamentals of database management systems and SQL?

Components, Database Management System, Notes / By Tanmay Chakrabarty / June 16, 2023

Fundamentals of Database Management Systems (DBMS) and SQL Database Management Systems (DBMS) and Structured Query Language (SQL) are essential components of modern data storage, retrieval, and management. DBMS provides a framework for creating, organizing, and manipulating databases, while SQL is a standard language used to interact with DBMS and perform various operations. Understanding the fundamentals …

What are the fundamentals of database management systems and SQL? Read More »

What is database? What are the 12 advantages of using database?

Characteristics, Database Management System, Definition / By Tanmay Chakrabarty / May 4, 2023

Database The word data means data and the word base means collection. A database is a collection of data. A database is a collection of interrelated data tables or files. In this age of information and communication technology, every organization stores all its data in the database of that organization.

3 Steps to connect to remote MySQL database using SQLyog instead of PHPMyAdmin through cpanel | MySQL GUI Tools

Computer Programming, How To, MySQL Tutorial, Software Guide, Tutorial / By Tanmay Chakrabarty / June 18, 2023

Welcome, readers! In today’s MySQL tutorial, we will explore remote database administration using SQLyog MySQL GUI tool. While PHPMyAdmin through cPanel is a commonly used method for managing MySQL databases, there may be instances where cPanel access is not available, but you have FTP and MySQL login details. In such cases, how can you connect …

3 Steps to connect to remote MySQL database using SQLyog instead of PHPMyAdmin through cpanel | MySQL GUI Tools Read More »

S	M	T	W	T	F	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30