Home : Book details : Book description

Description of  Using SQL to Import and Validate Data from CSV Files

Cloud Academy - Using SQL to Import and Validate Data from CSV Files MP4 Video: h264, 1920x1080 Audio: AAC, 44.1 KHz, 2 Ch Difficulty: Intermediate Genre: eLearning Language: English Duration: 11 Lectures (46m) Size: 593 MB This is an intermediate level course suited to DBAs, system analysts, programmers, or anyone wanting to learn how to use SQL to solve business scenarios. It will help to have an understanding of Structured Query Language syntax and functions and regular expressions, or some experience with script-based programming languages. Our learning objectives for this course are to recognize and explain use cases where Structured Query Language, SQL, can be applied in business situations, explain and apply SQL procedures to import and parse text files, define and apply automation processes to parse and sort data to specific databases