Trang chủ

IT Certifications

SQL

Complete SQL Beginner to Advanced Level - Data Analytics

Complete SQL Beginner to Advanced Level - Data Analytics

Loại khoá học: IT Certifications

Learn SQL using Microsoft SQL Server Environment

50.000 VND

1.049.000 VND

Đầy Đủ Bài Giảng

Học Online Tiện Lợi

Kích Hoạt Nhanh 2-5 Phút

Thanh toán tự động

Được phép tải xuống

Mô tả

Learn SQL from the beginning to becoming an expert analyzing data in SQL. This course takes you from having little or no knowledge of SQL to becoming highly proficient querying with SQL.

Knowing SQL is highly important if you intend working with data and the demand for SQL skills is ever growing.

You will learn SQL in a server environment which is most likely how you would use SQL in the real world. This course is designed to cut through the chase and teach you what you need to become successful.

This course is hands on with lots of practice tasks which allows you get comfortable and familiar with querying in SQL.

My goal is to make your learning efficient, smooth and equip you with the skill set you need to start or transition into any data related field.

Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. All applications necessary for learning the course would be downloaded free from the internet.

Who is this course for?

Anyone looking to work with data personally or professionally.

Starting or transitioning into a career as Data Scientist, Data Analyst, Business Analyst, Database Administrator, Report Analyst, ETL Specialist, BI Consultant, Data Engineer or any Data related field.

Bạn sẽ học được gì

Learn how to code in SQL from the beginning to advance level - Write, Read and Analyze with SQL.

Learn to work with databases in SQL Server.

Query SQL within a Server.

Yêu cầu

No course requirement or prerequisites

Nội dung khoá học

18 sections

Introduction

9 lectures

SQL Course Introduction

01:44

Instructor Introduction

00:36

Course Requirement & Prerequisite

02:19

Course Curriculum

03:11

Course Structure

02:19

Application Downloads & Installation

00:39

Windows Applications Download & Installation

04:52

Mac book Applications Download & Installation

21:19

Microsoft SQL Server Environment Review

10:05

Data, Databases & Database Management system

9 lectures

Section Introduction

00:31

What is Data?

01:25

What are Databases?

01:06

Introduction to Database Management System (DBMS)

01:06

Relational Database Management System (RDBMS)

03:40

How to Create a database

03:44

Saving Queries in SQL Server

02:07

Selecting a Database

03:02

Delete a Database

02:39

Introduction to SQL (Structured Query Language)

4 lectures

Section Introduction

00:27

What is SQL ?

02:03

SQL Dialect

06:25

SQL Naming Convention

02:24

Data Types in SQL

5 lectures

Section Introduction

00:25

SQL Data Types

01:39

Numeric Data Type

02:13

String Data Type

02:44

Importance of Data Types

03:46

Tables in SQL

6 lectures

Section Introduction

00:26

Introduction to Tables

01:24

Create Tables

08:51

Insert Data into Tables

12:23

Retrieve Data from Tables

03:18

Delete a Table

02:06

Data Definition Language (DDL)

8 lectures

Section Introduction

00:29

CREATE, DROP, ALTER

10:43

Adding comments to query

04:56

Null & Not Null – SQL Constraint

17:45

Add a Default Constraint

06:11

Add a Unique Constraint

06:30

Primary Key Constraint

08:18

Using IDENTITY in SQL

05:50

Data Query Language (DQL)

3 lectures

Section Introduction

01:08

SELECT statement

07:04

WHERE clause

06:19

Data Manipulation Language (DML)

5 lectures

Section Introduction

00:49

UPDATE command

11:40

DELETE command

09:57

Adding Aliases

06:56

Decimal Data Type – Numeric Data Type

10:48

String Functions

13 lectures

Section Introduction

00:18

String Functions

03:35

CONCAT Function

15:26

CONCAT_WS Function

04:41

LEFT Function

10:45

RIGHT Function

07:16

LEN Function

06:27

UPPER Function

04:25

LOWER Function

03:39

LTRIM, RTRIM, TRIM Functions

13:10

REVERSE Function

04:28

REPLACE Function

05:50

SUBSTRING Function

06:53

Sorting Records

8 lectures

Section Introduction

00:20

Insert character value with apostrophe/single quote

04:59

Order By

10:17

DISTINCT Statement

09:02

TOP Clause

07:07

OFFSET & FETCH

10:46

% Percentage Wildcard

11:26

Underscore Wildcard

06:57

Aggregate Functions

10 lectures

Section Introduction

00:26

COUNT Function

13:35

GROUP BY

11:44

AVERAGE Function

04:50

SUM Function

03:39

MAX Function

08:10

MIN Function

05:25

HAVING Clause

09:51

IN Operator

09:45

Sub Queries

09:38

Date & Time Data Type

12 lectures

Section Introduction

00:23

Date & Time Data Type

10:56

Extract Part of Date Values

04:00

GETDATE Function

13:45

CURRENT_TIMESTAMP

03:12

DATEPART Function

07:15

DATEDIFF Function

07:47

DATEADD Function

04:29

DATE Format

17:22

TIME Format

02:32

DATE&TIME Format

08:11

CAST & CONVERT - More Date & Time Format

15:15

Comparison Operators

8 lectures

Section Introduction

00:28

Understanding Comparison Operators

14:29

Equal

05:08

Not Equal

04:10

Greater Than

03:20

Less Than

03:25

Greater Than or Equal

03:31

Less Than or Equal

02:34

Logical Operators

6 lectures

Section Introduction

00:16

AND

11:13

OR

07:40

BETWEEN

05:15

LIKE & NOT LIKE

03:03

Case Statement

17:00

Data Relationships

6 lectures

Section Introduction

00:23

Understanding Data Relationship

08:07

One to One Relationship

02:54

One to Many Relationship

04:55

Many to Many Relationship

02:10

Normalization

08:17

Create One to Many Relationship

9 lectures

Section Introduction

00:28

Creating A One to Many Relationship

03:11

Foreign Keys

02:28

One to Many Schema

11:27

Introduction to JOIN

02:54

INNER JOIN

22:14

LEFT JOIN

09:24

RIGHT JOIN

09:12

FULL JOIN

06:36

Create Many to Many Relationship

14 lectures

Section Introduction

00:27

Creating a Many to Many Relationship

05:16

Creating Many to Many Schema

24:38

Insert Records into Schema

01:39

Many to Many Task 1

07:07

Many to Many Task 2

05:40

Many to Many Task 3

04:07

Many to Many Task 4

09:27

Many to Many Task 5

03:52

Many to Many Task 6

04:21

Many to Many Task 7

05:00

Many to Many Task 8

02:38

Many to Many Task 9

18:28

Many to Many Task 10

05:45

Conclusion

1 lectures

What Next?

00:36

Đánh giá của học viên

Chưa có đánh giá

Course Rating

5

0%

4

0%

3

0%

2

0%

1

0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Email

Nội dung

Khoá học liên quan

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

C++ Data Structures & Algorithms + LEETCODE Exercises

C++ Data Structures & Algorithms + LEETCODE Exercises

From Wire to PLC , A Bootcamp In Industrial Automation

From Wire to PLC , A Bootcamp In Industrial Automation

Complete React, Next.js & TypeScript Projects Course 2024

Complete React, Next.js & TypeScript Projects Course 2024

AWS Certified Cloud Practitioner (Tiếng Việt)

AWS Certified Cloud Practitioner (Tiếng Việt)

Khám phá thế giới ngầm của các Hacker

Khám phá thế giới ngầm của các Hacker

Lập trình Java cho người mới học

Lập trình Java cho người mới học

Microcontroller Embedded C Programming: Absolute Beginners

Microcontroller Embedded C Programming: Absolute Beginners

Lập trình Kotlin cơ bản đến nâng cao

Lập trình Kotlin cơ bản đến nâng cao

Complete Linux Training Course to Get Your Dream IT Job 2024

Complete Linux Training Course to Get Your Dream IT Job 2024

Deep Learning cho người mới bắt đầu

Deep Learning cho người mới bắt đầu

Lập trình C# cơ bản

Lập trình C# cơ bản

GCP Associate Cloud Engineer - Google Cloud Certification

GCP Associate Cloud Engineer - Google Cloud Certification

AWS Cloud for beginner (Vietnamese)

AWS Cloud for beginner (Vietnamese)

YOLOv7 YOLOv8 YOLO-NAS: Object Detection, Tracking & WebApp

YOLOv7 YOLOv8 YOLO-NAS: Object Detection, Tracking & WebApp

AWS Certified Solutions Architect Professional SAP-C02

AWS Certified Solutions Architect Professional SAP-C02

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi