List of lectures for the course SQL, 24 quest level on JavaRush

Using \COPY to Load Data from Your Local Computer
SQL SELF
24 level,0 lecture
Learn how to quickly and easily load data from CSV and other files into PostgreSQL right from your own computer using the \COPY command. Detailed comparison with COPY, examples, options, common mistakes, and tips for working efficiently.
Open
Setting Delimiters and Data Formats When Importing
SQL SELF
24 level,1 lecture
Learn how to properly set up delimiters and data formats when bulk loading into PostgreSQL: working with different delimiters, treating empty values as NULL, ignoring blank lines, and common import mistakes.
Open
Checking the Validity of Uploaded Data
SQL SELF
24 level,2 lecture
Learn how to quickly and efficiently check the validity of data loaded from external sources into PostgreSQL. In this material, you'll find out how to spot errors, duplicates, format mismatches, and other issues to keep your database clean and reliable.
Open
Bulk Data Load Optimization
SQL SELF
24 level,3 lecture
Learn how to speed up bulk data loading in PostgreSQL: disabling indexes and triggers, using transactions, tuning memory, prepping and partitioning your data, and automating the load. Real-world tips and examples to boost performance and reliability.
Open
Typical mistakes when bulk loading data
SQL SELF
24 level,4 lecture
Bulk loading data into PostgreSQL is a process that really needs your attention to detail. In this article, you'll learn about the most common mistakes when importing data, how to diagnose and prevent them, and get some practical tips for working with large amounts of info.
Open