Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to SQL and HiveQL
Rating: 3.6 out of 5(35 ratings)
3,778 students

Introduction to SQL and HiveQL

Learn about SQL and how to use SQL on Hive
Created byNarayana Y Kulkarni
Last updated 5/2020
English
English [Auto],

What you'll learn

  • Introduction to SQL and HiveQL on Hive

Course content

1 section • 5 lectures • 43m total length

  • SQL Statements3:46

    Use select and from on the video table to display data, then apply where, in, and like (percent) to filter by state and city.

  • DML statements20:41

    Explore data manipulation language basics in hiveql, including insert into table values, insert with specified columns, update statements, delete statements, and simple selects for data analysis.

  • DDL statements9:23

    Create and modify database tables with data definition language, describe table structures, and explore relational database concepts like primary keys and table relationships.

  • Types of SQL4:40

    Explore the different sql statement types—ddl, dml, and dcl—and learn how to create tables, insert, update, delete data, and grant access in sql and hiveql.

  • What is SQL4:45

    Explore what SQL is and why it powers relational databases. See how structured query language retrieves and manages data across databases like Sybase, SQL Server, and Informix.

Requirements

  • Beginner

Description

Learn basics of Structured Query Languages, SQL along with basics of database, table and HiveQL. SQL used on Hive is HiveQL. These SQL's can be used in any database management systems like Oracle, Sybase, Informix, MS SQL Server etc. In this course we will use Hive for learning HiveQL basics. Anyone can learn it which can be useful in any database related job or analysis of data stored in a database.  You can work on any database which is freely available for trial period or you have access to one at your job place. This course will make sure one understands why SQL and what is SQL.

Who this course is for:

  • anyone who wants to learn SQL basics

Report abuse