If you want to build a successful career in Data Science, you’ll need to learn the basics of SQL. Writing an SQL query is very often the first step in an analysis. If you can write a solid SQL query then you’re already well on your way.
In this course you’ll learn how to perform CRUD (Create, Read, Update and Delete) operations on a relational database.
Participants will be able to create and populate tables, perform moderately complex queries, update and delete records on a relational database.
Who should attend?
This course is suitable for anybody who needs to work with data in a relational database.
Using SQL to execute queries against a Relational Database.
- What is SQL?
- SQL syntax
- Code layout
- Retrieving data using
- Grabbing all the fields
- Selecting specific fields
- Selecting specific records
- Just the first few results
- Logical predicates
- Matching portions of strings with
- Checking for set membership with
- Working with missing (
- Sorting with
- Selected functions for aggregations:
- Filtering after aggregation with
- Why normalise?
Using SQL to create the structure of a Relational Database.
- Column types
- Primary and Foreign keys
- Auto increment
- Default values
- Cleaning up
- Dropping a table
- Dropping a database
Using SQL to manipulate data in a Relational Database.
INSERT- Putting data into tables
UPDATE- Changing existing data
DELETE- Removing data
Interactive course material
Our training emphasises practical skills. So, although you’ll be learning concepts and theory, you’ll see how everything is applied in the real world as we work through examples and exercises based on real datasets.
We like questions!
Having a firm understanding of the course content will result in you being able to confidently apply your new skills thereafter. So, if at any point you’re unsure of something, just ask!
Contact us at email@example.com if you have any questions.