Sqoop, Hive and Impala for Data Analysts (Formerly CCA 159) | Free Udemy Course

As part of Sqoop, Hive, and Impala for Data Analysts (Formerly CCA 159), you will learn key skills such as Sqoop, Hive, and Impala.This comprehensive course covers all aspects of the certification with real-world examples and data sets.Overview of Big Data ecosystemOverview Of Distributions and Management ToolsProperties and Properties Files - General GuidelinesHadoop Distributed File SystemYARN and Map Reduce2Submitting Map ReduceJobDetermining Number of Mappers and ReducersUnderstanding YARN and Map Reduce Configuration PropertiesReview and Override Job PropertiesReviewing Map Reduce Job LogsMap Reduce Job CountersOverview of HiveDatabases and Query EnginesOverview of Data Ingestion in Big DataData Processing using SparkHDFS Commands to manage filesIntroduction to HDFS for Certification ExamsOverview of HDFS and PropertiesFilesOverview of Hadoop CLIListing Files in HDFSUser Spaces or Home Directories in HDFSCreating Directories in HDFSCopying Files and Directories into HDFSFile and Directory Permissions OverviewGetting Files and Directories from HDFSPreviewing Text Files in HDFSCopying or Moving Files and Directories within HDFSUnderstanding Size of File System and FilesOverview of Block Size and ReplicationFactorGetting File Metadata using hdfs fsckResources and ExercisesGetting Started with HiveOverview of Hive Language ManualLaunching and using Hive CLIOverview of Hive PropertiesHive CLI History and hivercRunning HDFS Commands in Hive CLIUnderstanding Warehouse DirectoryCreating and Using Hive DatabasesCreating and Describing Hive TablesRetrieve Matadata of Tables using DESCRIBERole of Hive Metastore DatabaseOverview of beelineRunning Hive Commands and Queries using beelineCreating Tables in Hive using Hive QLCreating Tables in Hive - ordersOverview of Basic Data Types in HiveAdding Comments to Columns and TablesLoading Data into Hive Tables from Local File SystemLoading Data into Hive Tables from HDFSLoading Data - Overwrite vs AppendCreating External tables in HiveSpecifying Location for Hive TablesDifference between Managed Table and External TableDefault Delimiters in Hive Tables using Text FileOverview of File Formats in HiveDifferences between Hive and RDBMSTruncate and Drop tables in HiveResources and ExercisesLoading/Inserting data into Hive tables using Hive QLIntroduction to Partitioning and BucketingCreating Tables using Orc Format - order_itemsInserting Data into Tables using Stage TablesLoad vs. Insert in HiveCreating Partitioned Tables in HiveAdding Partitions to Tables in HiveLoading into Partitions in Hive TablesInserting Data Into Partitions in Hive TablesInsert Using Dynamic Partition ModeCreating Bucketed Tables in HiveInserting Data into Bucketed TablesBucketing with SortingOverview of ACID TransactionsCreate Tables for TransactionsInserting Individual Records into Hive TablesUpdate and Delete Data in Hive TablesOverview of functions in HiveOverview of FunctionsValidating FunctionsString Manipulation - Case Conversion and LengthString Manipulation - substr and splitString Manipulation - Trimming and Padding FunctionsString Manipulation - Reverse and Concatenating Multiple StringsDate Manipulation - Current Date and TimestampDate Manipulation - Date ArithmeticDate Manipulation - truncDate Manipulation - Using date formatDate Manipulation - Extract FunctionsDate Manipulation - Dealing with Unix TimestampOverview of Numeric FunctionsData Type Conversion Using CastHandling Null ValuesQuery Example - Get Word CountWriting Basic Queries in HiveOverview of SQL or Hive QLExecution Life Cycle of Hive QueryReviewing Logs of Hive QueriesProjecting Data using Select and Overview of FromDerive Conditional Values using CASE and WHENProjecting Distinct ValuesFiltering Data using Where ClauseBoolean Operations in Where ClauseBoolean OR vs IN OperatorFiltering Data using LIKE OperatorPerforming Basic Aggregations using Aggregate FunctionsPerforming Aggregations using GROUP BYFiltering Aggregated Data Using HAVINGGlobal Sorting using ORDER BYOverview of DISTRIBUTE BYSorting Data within Groups using SORT BYUsing CLUSTERED BYJoining Data Sets and Set Operations in HiveOverview of Nested Sub QueriesNested Sub Queries - Using IN OperatorNested Sub Queries - Using EXISTS OperatorOverview of Joins in HivePerforming Inner Joins using HivePerforming Outer Joins using HivePerforming Full Outer Joins using HiveMap Side Join and Reduce Side Join in HiveJoining in Hive using Legacy SyntaxCross Joins in HiveOverview of Set Operations in HivePerform Set Union between two Hive Query ResultsSet Operations - Intersect and Minus Not SupportedWindowing or Analytics Functions in HivePrepare HR Database in Hive with Employees TableOverview of Analytics or Windowing Functions in HivePerforming Aggregations using Hive QueriesCreate Tables to Get Daily Revenue using CTAS in HiveGetting Lead and Lag using Windowing Functions in HiveGetting First and Last Values using Windowing Functions in HiveApplying Rank using Windowing Functions in HiveApplying Dense Rank using Windowing Functions in HiveApplying Row Number using Windowing Functions in HiveDifference Between rank, dense_rank, and row_number in HiveUnderstanding the order of execution of Hive QueriesOverview of Nested Sub Queries in HiveFiltering Data on Top of Window Functions in HiveGetting Top 5 Products by Revenue for Each Day using Windowing Functions in Hive - RecapRunning Queries using ImpalaIntroduction to ImpalaRole of Impala DaemonsImpala State Store and Catalog ServerOverview of Impala ShellRelationship between Hive and ImpalaOverview of Creating Databases and Tables using ImpalaLoading and Inserting Data into Tables using ImpalaRunning Queries using Impala ShellReviewing Logs of Impala QueriesSynching Hive and Impala - Using Invalidate MetadataRunning Scripts using Impala ShellAssignment - Using NYSE DataAssignment - SolutionGetting Started with SqoopIntroduction to SqoopValidate Source Database - MySQLReview JDBC Jar to Connect to MySQLGetting Help using Sqoop CLIOverview of Sqoop User GuideValidate Sqoop and MySQL Integration using Sqoop List DatabasesListing Tables in Database using SqoopRun Queries in MySQL using Sqoop EvalUnderstanding Logs in SqoopRedirecting Sqoop Job Logs into Log FilesImporting data from MySQL to HDFS using Sqoop ImportOverview of Sqoop Import CommandImport Orders using target-dirImport Order Items using warehouse-dirManaging HDFS DirectoriesSqoop Import Execution FlowReviewing Logs of Sqoop ImportSqoop Import Specifying Number of MappersReview the Output Files generated by Sqoop ImportSqoop Import Supported File FormatsValidating avro files using Avro ToolsSqoop Import Using CompressionApache Sqoop - Importing Data into HDFS - CustomizingIntroduction to customizing Sqoop ImportSqoop Import by Specifying ColumnsSqoop import Using Boundary QuerySqoop import while filtering Unnecessary DataSqoop Import Using Split By to distribute import using non default columnGetting Query Results using Sqoop evalDealing with tables with Composite Keys while using Sqoop ImportDealing with tables with Non Numeric Key Fields while using Sqoop ImportDealing with tables with No Key Fields while using Sqoop ImportUsing autoreset-to-one-mapper to use only one mapper while importing data using Sqoop from tables with no key fieldsDefault Delimiters used by Sqoop Import for Text File FormatSpecifying Delimiters for Sqoop Import using Text File FormatDealing with Null Values using Sqoop ImportImport Mulitple Tables from source database using Sqoop ImportImporting data from MySQL to Hive Tables using Sqoop ImportQuick Overview of HiveCreate Hive Database for Sqoop ImportCreate Empty Hive Table for Sqoop ImportImport Data into Hive Table from source database table using Sqoop ImportManaging Hive Tables while importing data using Sqoop Import using OverwriteManaging Hive Tables while importing data using Sqoop Import - Errors Out If Table Already ExistsUnderstanding Execution Flow of Sqoop Import into Hive tablesReview Files generated by Sqoop Import in Hive TablesSqoop Delimiters vs Hive DelimitersDifferent File Formats supported by Sqoop Import while importing into Hive TablesSqoop Import all Tables into Hive from source databaseExporting Data from HDFS/Hive to MySQL using Sqoop ExportIntroduction to Sqoop ExportPrepare Data for Sqoop ExportCreate Table in MySQL for Sqoop ExportPerform Simple Sqoop Export from HDFS to MySQL tableUnderstanding Execution Flow of Sqoop ExportSpecifying Number of Mappers for Sqoop ExportTroubleshooting the Issues related to Sqoop ExportMerging or Upserting Data using Sqoop Export - OverviewQuick Overview of MySQL - Upsert using Sqoop ExportUpdate Data using Update Key using Sqoop ExportMerging Data using allowInsert in Sqoop ExportSpecifying Columns using Sqoop ExportSpecifying Delimiters using Sqoop ExportUsing Stage Table for Sqoop ExportSubmitting Sqoop Jobs and Incremental Sqoop ImportsIntroduction to Sqoop JobsAdding Password File for Sqoop JobsCreating Sqoop JobRun Sqoop JobOverview of Incremental Loads using SqoopIncremental Sqoop Import - Using WhereIncremental Sqoop Import - Using Append ModeIncremental Sqoop Import - Create TableIncremental Sqoop Import - Create Sqoop JobIncremental Sqoop Import - Execute JobIncremental Sqoop Import - Add Additional DataIncremental Sqoop Import - Rerun JobIncremental Sqoop Import - Using Last ModifiedHere are the objectives for this course.Provide Structure to the DataUse Data Definition Language (DDL) statements to create or alter structures in the metastore for use by Hive and Impala.Create tables using a variety of data types, delimiters, and file formatsCreate new tables using existing tables to define the schemaImprove query performance by creating partitioned tables in the metastoreAlter tables to modify the existing schemaCreate views in order to simplify queriesData AnalysisUse Query Language (QL) statements in Hive and Impala to analyze data on the cluster.Prepare reports using SELECT commands including unions and subqueriesCalculate aggregate statistics, such as sums and averages, during a queryCreate queries against multiple data sources by using join commandsTransform the output format of queries by using built-in functionsPerform queries across a group of rows using windowing functionsExercises will be provided to have enough practice to get better at Sqoop as well as writing queries using Hive and Impala.All the demos are given on our state-of-the-art Big Data cluster. If you do not have multi-node cluster, you can sign up for our labs and practice on our multi-node cluster. You will be able to practice Sqoop and Hive on the cluster.Who this course is for:Any Big Data Professional or Aspirant who want to learn about Databases and Query Interfaces in Big DataAny Business Intelligence Professional who want to understand Data Analysis in Big Data eco systemAny IT Professional who want to prepared for CCA 159 Data Analyst exam

Course Content:

Sections are minimized for better readability, click the section title to view the course content