Difference between revisions of "Databases"
Adelo Vieira (talk | contribs) |
Adelo Vieira (talk | contribs) |
||
| Line 25: | Line 25: | ||
<br /> | <br /> | ||
| + | |||
| + | |||
| + | <section begin=databases /> | ||
| + | <div class="resaltar"><ul style="padding-left:67px;"><li class="entre-li-n4 entre-li-n4-first"> <html> <a href="Database design"> <p class="desplaza"> <span style="font-weight:bold;">Database design</span> </p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:89px;"><li class="entre-li-n4"> <html> <a href="Database design#Conceptual design"> <p class="desplaza">Conceptual design</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="Database design#Entity relationship modelling"> <p class="desplaza">Entity relationship modelling</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="Database design#The Enhanced Entity-Relation Model"> <p class="desplaza">The Enhanced Entity-Relation Model</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:89px;"><li class="entre-li-n4"> <html> <a href="Database design#Logical design"> <p class="desplaza">Logical design</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="Database design#Relational Model"> <p class="desplaza">Relational Model</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="Database design#Normalisation"> <p class="desplaza">Normalisation</p> </a> </html> </li></ul></div> | ||
| + | |||
| + | <div class="resaltar"><ul style="padding-left:67px;"><li class="entre-li-n4"> <div style="text-align:left"> <html> <a style="pointer-events: none;" href="RDBMS"> <p class="desplaza"> <span style="color: black; font-weight:bold;">RDBMS</span> </p> </a> </html> </div> </li></ul></div> | ||
| + | <div class="mw-collapsible mw-collapsed" data-expandtext="+/-" data-collapsetext="+/-"> | ||
| + | <div class="resaltar"><ul style="padding-left:89px;"><li class="entre-li-n4"> <html> <a href="MySQL"> <p class="desplaza">MySQL</p> </a> </html> </li></ul></div> | ||
| + | <div class="mw-collapsible-content"> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Backup and Restore MySQL/MariaDB Databases"> <p class="desplaza">Backup and Restore MySQL/MariaDB Databases</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Import a CSV file into a MySQL database"> <p class="desplaza">Import a CSV file into a MySQL database</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Reset the MySQL/MariaDB Password"> <p class="desplaza">Reset the MySQL/MariaDB Password</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Databases Authentication and Authorization"> <p class="desplaza">Authentication and Authorization</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#SQL Practice Lab 1"> <p class="desplaza">SQL Practice Labs</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Stored Procedures"> <p class="desplaza">Stored Procedures</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Stored Functions"> <p class="desplaza">Stored Functions</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Triggers"> <p class="desplaza">Triggers</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Events"> <p class="desplaza">Events</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Cursors"> <p class="desplaza">Cursors</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Transactions"> <p class="desplaza">Transactions</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:112px;"><li class="entre-li-n4"> <html> <a href="MySQL#Exception Handling"> <p class="desplaza">Exception Handling</p> </a> </html> </li></ul></div> | ||
| + | </div> | ||
| + | </div> | ||
| + | <div class="resaltar"><ul style="padding-left:89px;"><li class="entre-li-n4"> <html> <a href="PostgreSQL"> <p class="desplaza">PostgreSQL</p> </a> </html> </li></ul></div> | ||
| + | |||
| + | <div class="resaltar"><ul style="padding-left:67px;"><li class="entre-li-n4"> <div style="text-align:left"> <html> <a style="pointer-events: none;" href="GUI DB administration tools"> <p class="desplaza"> <span style="color: black; font-weight:bold;">GUI DB administration tools</span> </p> </a> </html> </div> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:89px;"><li class="entre-li-n4"> <html> <a href="MySQL#MySQL Workbench"> <p class="desplaza">MySQL Workbench</p> </a> </html> </li></ul></div> | ||
| + | <div class="resaltar"><ul style="padding-left:89px;"><li class="entre-li"> <html> <a href="PostgreSQL#Connecting_to_Postgres_from_SQLectron"> <p class="desplaza">SQLectron</p> </a> </html> </li></ul></div> | ||
| + | <section end=databases /> | ||
Revision as of 10:21, 26 February 2026
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. https://en.wikipedia.org/wiki/Database
A very basic and nice explanation of the types of DBMS: https://www.youtube.com/watch?v=FR4QIeZaPeM&feature=emb_logo
NoSQL databases:
This is good to start understanding NoSQL databases and the difference with relational databases: https://www.youtube.com/watch?v=uD3p_rZPBUQ
Data Warehouse:
This is a very good explanation of what a Data Warehouse is: https://www.youtube.com/watch?v=k4tK2ttdSDg
