Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn SQL in an hour
Rating: 4.3 out of 5(16 ratings)
44 students

Learn SQL in an hour

Learn how to write SQL queries from basics to advanced
Created byTushar Bhalla
Last updated 8/2020
English

What you'll learn

  • SQL Basics as well as advanced topics
  • SQL Datatypes
  • SQL Operators
  • SQL Tables and Joins
  • CRUD Operations on SQL Tables
  • SQL Functions
  • SQL Important Keywords/Statements
  • Dynamic Query
  • Temporary Tables
  • Temporary Variables
  • Stored Procedure
  • Triggers

Course content

1 section • 16 lectures • 1h 5m total length

  • Introduction1:30

    Explore the basics and advanced concepts of SQL, including data types, variables, joins, CRUD operations, functions, dynamic temporary tables and variables, and stored procedures and triggers.

  • What is SQL ?1:23
  • SQL Datatypes6:39
  • SQL Tables and relations4:51

    Create and relate two SQL tables, customers and sales, using a primary key and a foreign key on customer_id, then define columns and constraints.

  • CRUD Operations on SQL Tables4:16

    Learn to perform create, read, update, and delete operations on SQL tables by adding a new email column, updating specific records, inserting new rows, and deleting rows.

  • SQL Joins - 11:21
  • SQL Joins - 23:55
  • SQL Operators - 13:14
  • SQL Operators - 24:11
  • SQL Functions - 12:25
  • SQL Functions - 26:52

    Apply SQL functions such as lower, length, and date extraction; sort, top n rows, group by city, and compute max, average, and is null checks to analyze a retail database.

  • SQL Important Statements/Keywords9:15
  • Dynamic Query and Temporary Variables3:43
  • Temporary Tables5:17

    Create temporary tables and common expressions to perform on-the-fly calculations inside stored procedures, merge multiple columns into a single address field, and query or delete the results.

  • Stored Procedure3:26
  • Triggers3:24

    Explore triggers in sql, including dma and ddl triggers, and learn to create after triggers that alert admins on inserts.

Requirements

  • No Basic Requirements. All you need is a SQL workbench (MySQL, Microsoft SQL Server, SQL Lite, etc.) installed on your machine. I will also guide you how to install the SQL workbench on your local computer..

Description

Learn SQL in an hour:

  • Are you a fresh Data / business analyst who wants to learn a new skill ?

  • Are you thinking about entering into Analytics / Data Science world ?

  • Do you want to become a professional Software / Web Application Developer and increase your income Exponentially ?

  • Are you a University Student Working Towards a Computer Science or Information Technology Degree ?

Then, this is the right place for you. I have been working for SQL for more than 5 years now and currently working as a data engineer. This course will give you an understanding of how powerful SQL is and will make you knowledgeable enough to start writing SQL queries, apply functions, create stored procedures, do complex calculations, etc.

After learning this course, you will be ready to perform the duties of a SQL developer as well as a data analyst who analyzes large amount of data within Milliseconds.

Who this course is for:

  • Beginner Data Science Students
  • Data / Business Analysts
  • Business and IT students who want to work with data
  • Anyone who wants to become a business analyst or data visualization analyst
  • Data Visualization Analysts

Report abuse