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 course contains a lab portion the following week.
Rob Carter | IDMS/Middleware Architect
Rob has been working in central IT in a variety of capacities for the last 33 years. Relational databases have been both his helpmates and his nemesis for at least 30 of them. In his current role as a middleware and identity architect, he routinely deals with data engineering problems, some of which entail or can be resolved with relational databases. In his spare time, he looks after the cats (and the dog) to whom he belongs. He can occasionally be found standing in a river, scaring fish.
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.
- Advanced data and schemas, normalized v. star schema data model, ERD overview and use cases
- Data validation: referential integrity, validating against business rules, validation statuses
- Useful basic RDBMS features: triggers, stored procedures, views
- When to use RDBMS features, standard SQL, or other tools - (Examples: LIKE, stored procedures, Elastic Search/Solr, etc)
- Performance: the cost of queries (read and write, indexes, tuning, explain plan)
- DBA: clusters, replication, key differences in some common RDBMS'
- Security - General concepts: table and row level security, handling sensitive data (control access), default passwords, ACL's, SQL Injection awareness, Privacy: sensitive data (in part or in whole), anonymizing data
- Learn more about schemas and choosing the right one for your data
- Learn about data validation and referential integrity
- Understand useful RDBMS features like triggers, stored procedures, and views
- Know basic performance metrics and tooling
- Database administration
- Be aware of security
Some knowledge of SQL and relational data will help participants get the most out of this course. Basic understanding of client-server computing, while not necessary, may also be helpful for participants.
This class is part of our Databases TrackSee the whole track
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
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
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.Learn More
SQL – Beyond the Basics (1/3)
This course will provide an introduction to intermediate SQL concepts, including data manipulation with built-in arithmetic and date functions, set operations, and nested queries. The skills gained in this course will allow users to answer a variety of questions about their data.Learn More