|
|
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | | + | ~ Migrated |
| − | <br />
| |
| − | 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''':<br />
| |
| − | This is good to start understanding NoSQL databases and the difference with relational databases: https://www.youtube.com/watch?v=uD3p_rZPBUQ
| |
| − | | |
| − | | |
| − | | |
| − | '''Data Warehouse''':<br />
| |
| − | This is a very good explanation of what a Data Warehouse is: https://www.youtube.com/watch?v=k4tK2ttdSDg
| |
| − | | |
| − | | |
| − | | |
| − | <div style="width:30%">
| |
| − | <div style="margin-left:-50pt">
| |
| − | {{#lst:Mis páginas|databases}}
| |
| − | </div>
| |
| − | </div>
| |
| − | | |
| − | | |
| − | <br />
| |
| − | | |
| − | | |
| − | <div style="width:500px; padding-left:10px">
| |
| − | <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 />
| |
| − | </div>
| |
