Exegetic Analytics is a Data Science consultancy specialising in data acquisition and augmentation, data preparation, predictive analytics and machine learning. Our services are used by a range of industries from Education to Security, Food Delivery to Politics. Our consultants are based in Durban and Cape Town and we engage with clients all over the world. Our products and services are used by a multitude of industries including Aerospace, Education, Finance, Food and Transport.
Exegetic Analytics also offers training, with experienced and knowledgeable facilitators. Our courses focus on practical applications, working through examples and exercises based on real-world datasets.
All of our training packages include access to:
- our online development environment and
- detailed course material which participants will have continued access to even once the training has concluded.
For more information about what we do, you can refer to our website.
These are some of the companies who have benefitted from our trainning:
Take a look at our full list of courses to see what other training we have on offer.
If this proposal is of interest to you or you would like to hear more about what we do you can get in touch on firstname.lastname@example.org or +27 73 805 7439.
2. Course Description
|Who should attend?||The course is suitable for anybody who needs to work with data in a relational database.|
|Objectives||In this course you’ll learn how to perform CRUD (Create, Read, Update and Delete) operations on a relational database.|
|Outcomes||Participants will be able to create and populate tables, perform moderately complex queries, update and delete records on a relational database.|
|Requirements||Familiarity with spreadsheets will be helpful but not essential.|
Return to our list of courses.
3. Course Outline
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