Search Results for: visualization

Data Analysis: What to Learn

Francisco Olvera

Applied statistics (not software, but good old math) including general understanding of machine learning (artificial intelligence). R and/or Python with libraries like NumPy and/or pandas. Structured Query Language (SQL) with a broad understanding of extensions (vendor-specific syntax) depending on the relational database management system (RDBMS) that the company (your employer) has like Oracle, MySQL, PostgreSQL […]

Database Administration Fundamentals (SF19SQL1002) – Day 4

Francisco Olvera

As a quick review, SQL is the language to interact with a relational database. to request data (SELECT) from database objects (databases, schemas, tables and views) to create (CREATE) where to store data, database objects (databases, schemas, tables including columns, etc.) to modify (ALTER) database objects to delete (DROP) database objects, automatic COMMIT in SQL Server […]