Last updated 8/2020MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 526.31 MB | Duration: 1h 6m

Learn how to write SQL queries from basics to advanced

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

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 eeer. 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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is SQL ?

Lecture 3 SQL Datatypes

Lecture 4 SQL Tables and relations

Lecture 5 CRUD Operations on SQL Tables

Lecture 6 SQL Joins - 1

Lecture 7 SQL Joins - 2

Lecture 8 SQL Operators - 1

Lecture 9 SQL Operators - 2

Lecture 10 SQL Functions - 1

Lecture 11 SQL Functions - 2

Lecture 12 SQL Important Statements/Keywords

Lecture 13 Dynamic Query and Temporary Variables

Lecture 14 Temporary Tables

Lecture 15 Stored Procedure

Lecture 16 Triggers

Bner 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

HomePage: