Intermediate PostgreSQL
This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database. You’ll also take a look at how PostgreSQL handles and indexes text data.
Specifically, students will do assignments that alter table schemas, create stored procedures, construct advanced queries, explore sorting and grouping query data, and techniques for working with text in databases including regular expressions.
What you'll learn
- Utilize SQL commands for editing tables in a PostgreSQL database and produce properly normalized tables from CSV files.
- Appropriately handle text and dates in databases and create stored procedures.
- Identify hashtag algorithm and their attributes.
- Construct regular expressions to select rows that match a pattern.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 4 weeks |
Effort | 4 weeks, 2–4 hours per week |
Starts | On Demand (Start anytime) |
Cost | $49 |
From | The University of Michigan via edX |
Instructor | Charles Severance |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Programming |
Tags | Computer Science |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Learn-to-Swim Instructor $45k
Learn iOS Development $53k
Learn Android Development $66k
Epic LEARN Administrator 2 $104k
Content Editor - Creative Cloud Learn Contractor $119k
Senior Content Editor - Creative Cloud Learn $157k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 4 weeks |
Effort | 4 weeks, 2–4 hours per week |
Starts | On Demand (Start anytime) |
Cost | $49 |
From | The University of Michigan via edX |
Instructor | Charles Severance |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Programming |
Tags | Computer Science |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course