Intermediate PostgreSQL

Intermediate PostgreSQL in University of Michigan

Beginner 0(0 Ratings) 0 Students enrolled
Created by University of Michigan Staff Last updated Mon, 28-Feb-2022 English


Intermediate PostgreSQL free videos and free material uploaded by University of Michigan Staff .

Syllabus / What will i 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.


Curriculum for this course
0 Lessons 00:00:00 Hours
+ View more
Description

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.

You need online training / explanation for this course?

1 to 1 Online Training contact instructor for demo :


+ View more

Other related courses
About the instructor
  • 0 Reviews
  • 1 Students
  • 313 Courses
Student feedback
0
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews

Material price :

Free

1:1 Online Training Fee: 1 /-
Contact instructor for demo :