Just another CUNY Academic Commons site
This is not an advert. According to Dice and GitHub, the fastest growing language is Hashicorp Configuration Language (HCL). I don’t think I’ve ever heard of HCL for Terraform. “an open-source infrastructure as code software tool that enables you to safely and predictably create, change, and improve infrastructure” If interested in this language, refer to […]
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 […]
The quote below is neither an endorsement nor an advert. SQL is a language that enables storing, retrieving, and manipulating data in databases… SQL has a lot of career options in the business domain as well as in the data science sector. When data is of interest in the gap analysis, SQL can be used […]
We are finally playing with data. To request data from a table or group of, we need to follow the following structure for the SELECT statement. Any changes in the syntax will break the statement and return an error. SELECT table1.field1, table1.field2… table2.field1, table2.field2… FROM table1 INNER | (OUTER) LEFT | (OUTER) RIGHT table2 ON […]
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 […]
We have started to CREATE database objects using the following base syntax. CREATE database_object object_name AS some_code_to_create_structure Download the class notes for day 7. On a silly note, this is post 486 as in i486.
We are half-way done (fifth class of ten). We will stop covering new material in order to review all the material we have covered so far. You need to understand and know the syntax well as this is the foundation of SQL. We will then continue and cover how to CREATE and ALTER database objects. […]
We have started a new SQL course. As I explained last night, each relational database management systems (RDBMS) vendor has some proprietary syntax and tools. Therefore some code has to be converted when moving code from SQL Server to Oracle, PostgreSQL or SQLite. Some third-parties have released facilities like SQLines. If you have any questions on other systems, do not hesitate to […]
We have covered parameters, functions and procedures. Do not forget that, if you are taking the certification exam, you must know about procedures. Download the class notes for day 6. Note that functions and procedures change from vendor to vendor. In this course, we are looking at Microsoft’s T-SQL for SQL Server. If anyone if […]
