Just another CUNY Academic Commons site
We have covered basic SELECT statements joining (INNER|LEFT|RIGHT JOIN) multiple tables, filtering data (WHERE) and organizing the output (ORDER BY) as well grouping values (GROUP BY) when using aggregate functions. Now we are having fun with SQL.
Download the class notes for day 3.
After enjoying some cookies on day 1, we can now work with code. Always keep in mind that your SQL code is read by an interpreter looking at each line and making sure that these lines are in order. Breaking the correct order will return an error.
Download the class notes for day 2.
We start a new class having chocolate cookies, but no coffee.
Download the class notes for day 1.
The quote below is neither an endorsement nor an advert.
Learning Python is a great way to get started with programming. Learning how to code is a skill that will benefit you throughout your life. You’ll be more efficient at work, get better grades in school, take more control over the technology around us, and be a crucial member of the growing tech industry. Since it’s such a common language, learning Python will help you understand how other coding languages work, too. Being able to understand and read other people’s code is invaluable.
https://copyassignment.com/free-python-course-loved-by-over-7-7-million-people/
It seems that many people agree that Python is the new BASIC (1964-now).
10 PRINT "Hello world! ";
20 GOTO 10
Python is the language that everyone should learn in order to learn other languages.
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 to find gaps in data such as dates or number sequences. A thorough gap analysis is a critical piece of any business analysis; therefore, a good understanding of SQL can be an essential tool for Business Analysts.
https://www.analyticsinsight.net/why-programmers-need-to-learn-sql-if-you-want-a-job-in-data/
The article is loosely written, but the potential student can get the idea what SQL is for and how to use it.
SQL is the only language to access relational databases like PostgreSQL, Oracle, MySQL and its fork MariaDB, SQL Server and others. The only difference between vendors is the subset of language (different statements and/or syntax not included in the latest version, SQL:2016 or ISO/IEC 9075-1:2016) that each vendor adds to the language, referred to as extensions — PL/pgSQL, PL/SQL, MySQL, T-SQL and others.
This is neither an endorsement nor an advert.
Once upon a time, the world of computer programming was a mysterious and exclusive place. Only a select handful of people were considered computer programmers with cutting-edge coding skills. Today, many IT jobs require a solid grasp of the top programming languages, and yes, we mean more than one.
https://www.simplilearn.com/best-programming-languages-start-learning-today-article
The following is the list by simplilearn.com.
Yet another reason to learn Python
“The 10 most popular programming languages remain the same, but numbers toward the bottom of that group are shifting, with PHP dropping and assembly language continuing to rise.”
https://www.techrepublic.com/article/python-remains-atop-the-tiobe-index-for-november-while-php-shows-signs-of-decline/
Thank you for taking class SF21JOB#2.
Download the class notes for day 10.
Thank you for taking class SF21SQL1001. See you in the intermediate class.
Download the class notes for day 10.
