SQL for Data Scientists: Baseline coverage of most important SQL concepts (1/2)

Baseline coverage of most important aspects of SQL. Participants will learn the basics of schemas, data types, constraints, and how to debug SQL queries. The goal of this class is to provide a strong foundation for learning more advanced SQL in the future.

Instructor:
Aleksandr Podolyanskiy
Jeremy Bandini | Enterprise Web and Mobile Applications | ITSO Embedded Security Consultant
Jeremy is an experienced application developer who has worked with the full stack from the front end to the back end. Jeremy has worked professionally with a variety of SQL backends and earned valuable experience that he is excited to share. Many years of programming experience have given Jeremy insight into writing SQL for a variety of business cases. Jeremy loves to talk about technology and solving problems pragmatically.

This class will be hosted via Zoom. You will receive an email with the Zoom link a day before the class. Attendance will be taken and the session will be recorded.

About Course

Outline

  • Data Dictionaries, basic schema design
  • Data Types: best practices, gotchas
  • Data Integrity, constraints: system defined, user defined, constraints for security purposes like SQL injection
  • Basic syntax: writing good SQL queries, range variables, basic operators and expressions, basics of joins
  • Debugging SQL queries

Objectives

  • Learn about SQL schemas
  • Data type and constraints: why are they important?
  • Basic syntax for writing SQL queries
  • Debugging SQL that does not work as expected

Prerequisites

Basic understanding of databases and data is helpful but not necessary. Participants who are comfortable with technology and aware of databases and why they are useful will get the most out of this class.

This class is part of our Databases Track

See the whole track

Suggested Courses

Course Graphic

Intro to mySQL

Take this class to learn more about databases. This course will provide students with a basic introduction to the popular open source Database Management System (DBMS) named “MySQL”.

Learn More
Course Graphic

Intro to Databases

Come to this course to learn about databases and their importance across a multitude of fields. This class will provide students with a basic introduction to what databases are and how to interact with them.

Learn More
Course Graphic

SQL for Data Scientists: Advanced concepts, RDBMS features, related technologies

Baseline coverage of most important SQL concepts, deeper dive into some core concepts, examine some related concepts such as security, DBA, performance. This is part 2 of a 2-part course.

Learn More