Basic SQL Queries (Simple SQL for Different Database Systems)

This is a beginner-level course on how to write SQL code to "talk" to a relational database system (e.g., MySQL, Oracle, Microsoft Access). I eventually get into showcasing a hands-on demonstration of creating SQL queries using Microsoft Access, which you can use this knowledge to also apply to more serious database systems like: MySQL, Oracle, PostgreSQL, Microsoft SQL Server, IBM Db2, and so forth. However, before I get to that portion, I initially explain some general concepts and I give a slide-based overview of how to write various SQL syntax.

To be clear, even if you are learning to use another relational database system, you still will benefit from watching my video as I clearly identify how things work on Microsoft Access as opposed to other database systems.

My mini-bio: My name is William Paul Liggett and I am currently a Software Engineering Professor at both Northern Virginia Community College and at a non-profit educational institution called Year Up. I have been programming, building/taking computers apart, and studying cybersecurity since the year 2000. I am a speaker at various tech conferences (e.g., Hackers On Planet Earth [HOPE] and LibrePlanet) and I love teaching others about technology! So come geek out with me!

This lecture is approximately 2.5 hours as I go over lots of aspects, such as:

• General orientation to database terminology and concepts. For example:
• Simple acronyms: DB, RDBMS, SQL, and DBA.
• A "query" is a "question" you are asking a database with SQL.
• SEQUEL vs. SQL (Hint: They are both the same!)
• SQL/PSM Overview ("Stored Procedures", PL/SQL, PL/pgSQL, Transact-SQL [T-SQL])
• Why most programmer's don't really care about SQL/PSM.

• Multiple examples of how to write different SQL queries:
• Matching exact text values.
• Matching partial text values.
• Searching data for specific numbers or dates.
• Searching data for a range of numbers or dates.
• AND vs. OR logic.
• Finding NULL values.
• Sorting a query in different ways (e.g., ASC vs. DESC).

I hope you enjoy the video. Please like & subscribe for more!

[christianpadilla]

Lol. That joke from the start. Professor, I just subscribed. More videos, please.