Here's how you can master multiple database programming languages to advance in Database Administration.

?? SQL para dominarlos a todos Cada vez que un nuevo Junior entra a mi empresa y me pide opinión sobre por donde empezar, siempre le aconsejo que aprenda SQL y Python, creo que conociendo ambos lenguajes puedes cubrir el 90% del trabajo actual. Creo que lo que ha hecho a estos lenguajes tan populares es que tienen una sintaxis facil de comprender y que en pocas horas ya te resulta familiar. Hay que aprender a escribir querys, pero más importante es saber como se ejecutan, Pongo un ejemplo: SELECT City, Population FROM Countrys WHERE Country = 'Spain' AND Population > 1000000 ORDER BY Population ASC Un plan de ejecución, primero se fijará en el FROM, luego en los JOINS, después en WHERE/AND, luego en SELECT y finalmente en ORDER BY.

There is really very limited no of operations someone need to know for basic sql and over time write in a highly optimized way. 1. Learn basics syntax like SELECT,INSERT,UPDATE,DELETE,CREATE 2. Learn group by,joins,having,order by 3. Learn CTEs(+maybe basic subqueries :P) 4. Data types handling and minor quirks,casting 5. Learn about functions like aggregates,string+json aggregates,intervals,etc. 6. Then go over some basics window function like row number,partition by,(maybe ranking and rolling windowing too if you are feeling adventurous). 7. Keep learning all other extra stuffs over time that will help in even more complex transformation. in addition,knowing query optimization,basics db internals,SQL versioning tools like DBT will help.

SQL (Structured Query Language) is fundamental for working with databases. Understand data manipulation (SELECT, INSERT, UPDATE, DELETE) and data definition (CREATE, ALTER, DROP) statements.

?? MongoDB el rey del NoSQL Cuando llevas muchos a?os trabajando con lenguajes SQL, te das cuenta que son todos muy parecidos, hay algunas diferencias entre TSQL y PLSQL, pero el 99% es idéntico. Cuando das los primeros pasos en lenguajes NoSQL descubres un nuevo mundo que al principio es dificil de comprender, pero conforme vas aprendiendo más y más, te vas dando cuenta de las nuevas posibilidades que se abren frente a tus ojos. Si ya sabes mucho de bases de datos relacionales, habrá muchos conceptos de NoSQL que te resulten familiares, tales como colecciones(tablas), documentos(filas), índices o vistas. Otros tantos son parecidos pero con cambios. Si quieres aprender NoSQL te recomiendo empezar por MongoDB y su MongoDB University.

T-SQL (Transact-SQL) is specific to Microsoft SQL Server. Learn advanced features like stored procedures, triggers, and user-defined functions.

Practice makes perfect; if you practice something, you become good at it. Consistent practice is key to mastering any programming language, including database languages. Establish personal projects or contribute to open-source initiatives to apply what you've learned in real-world scenarios. Create your own databases to experiment with different structures and queries. Engage in online forums or local user groups to solve problems and share knowledge with peers. Regularly reviewing and practicing your skills helps you retain knowledge and stay updated with the latest database technologies and best practices.

Staying current is crucial in the ever-evolving field of database technology. With new languages and features emerging regularly, continuous learning and adaptation are essential. Keep up with industry news, attend webinars, workshops, or conferences related to database technologies. Subscribe to blogs or newsletters from thought leaders and engage with the community on platforms like LinkedIn or Twitter. Staying updated ensures your skills remain relevant and prepares you for future advancements in database management.