SQL Beginner to Advanced Level Data Analytics

SQL Beginner to Advanced Level – Data Analytics, available at $79.99, has an average rating of 4.31, with 137 lectures, based on 313 reviews, and has 988 subscribers.

You will learn about 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. This course is ideal for individuals who are Anyone who wants to learn SQL from Beginner level to becoming proficient in SQL It is particularly useful for Anyone who wants to learn SQL from Beginner level to becoming proficient in SQL.

Enroll now: SQL Beginner to Advanced Level – Data Analytics

Summary

Title: SQL Beginner to Advanced Level – Data Analytics

Price: $79.99

Average Rating: 4.31

Number of Lectures: 137

Number of Published Lectures: 137

Number of Curriculum Items: 137

Number of Published Curriculum Objects: 137

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

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.

Who Should Attend

Anyone who wants to learn SQL from Beginner level to becoming proficient in SQL

Target Audiences

Anyone who wants to learn SQL from Beginner level to becoming proficient in SQL

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: SQL Course Introduction

Lecture 2: Instructor Introduction

Lecture 3: Course Requirement & Prerequisite

Lecture 4: Course Curriculum

Lecture 5: Course Structure

Lecture 6: Udemy Review System

Lecture 7: Application Downloads & Installation

Lecture 8: Windows Applications Download & Installation

Lecture 9: Mac book Applications Download & Installation

Lecture 10: Microsoft SQL Server Environment Review

Chapter 2: Data, Databases & Database Management system

Lecture 1: Section Introduction

Lecture 2: What is Data?

Lecture 3: What are Databases?

Lecture 4: Introduction to Database Management System (DBMS)

Lecture 5: Relational Database Management System (RDBMS)

Lecture 6: How to Create a database

Lecture 7: Saving Queries in SQL Server

Lecture 8: Selecting a Database

Lecture 9: Delete a Database

Chapter 3: Introduction to SQL (Structured Query Language)

Lecture 1: Section Introduction

Lecture 2: What is SQL ?

Lecture 3: SQL Dialect

Lecture 4: SQL Naming Convention

Chapter 4: Data Types in SQL

Lecture 1: Section Introduction

Lecture 2: SQL Data Types

Lecture 3: Numeric Data Type

Lecture 4: String Data Type

Lecture 5: Importance of Data Types

Chapter 5: Tables in SQL

Lecture 1: Section Introduction

Lecture 2: Introduction to Tables

Lecture 3: Create Tables

Lecture 4: Insert Data into Tables

Lecture 5: Retrieve Data from Tables

Lecture 6: Delete a Table

Chapter 6: Data Definition Language (DDL)

Lecture 1: Section Introduction

Lecture 2: CREATE, DROP, ALTER

Lecture 3: Adding comments to query

Lecture 4: Null & Not Null – SQL Constraint

Lecture 5: Add a Default Constraint

Lecture 6: Add a Unique Constraint

Lecture 7: Primary Key Constraint

Lecture 8: Using IDENTITY in SQL

Chapter 7: Data Query Language (DQL)

Lecture 1: Section Introduction

Lecture 2: SELECT statement

Lecture 3: WHERE clause

Chapter 8: Data Manipulation Language (DML)

Lecture 1: Section Introduction

Lecture 2: UPDATE command

Lecture 3: DELETE command

Lecture 4: Adding Aliases

Lecture 5: Decimal Data Type – Numeric Data Type

Chapter 9: String Functions

Lecture 1: Section Introduction

Lecture 2: String Functions

Lecture 3: CONCAT Function

Lecture 4: CONCAT_WS Function

Lecture 5: LEFT Function

Lecture 6: RIGHT Function

Lecture 7: LEN Function

Lecture 8: UPPER Function

Lecture 9: LOWER Function

Lecture 10: LTRIM, RTRIM, TRIM Functions

Lecture 11: REVERSE Function

Lecture 12: REPLACE Function

Lecture 13: SUBSTRING Function

Chapter 10: Sorting Records

Lecture 1: Section Introduction

Lecture 2: Insert character value with apostrophe/single quote

Lecture 3: Order By

Lecture 4: DISTINCT Statement

Lecture 5: TOP Clause

Lecture 6: OFFSET & FETCH

Lecture 7: % Percentage Wildcard

Lecture 8: Underscore Wildcard

Chapter 11: Aggregate Functions

Lecture 1: Section Introduction

Lecture 2: COUNT Function

Lecture 3: GROUP BY

Lecture 4: AVERAGE Function

Lecture 5: SUM Function

Lecture 6: MAX Function

Lecture 7: MIN Function

Lecture 8: HAVING Clause

Lecture 9: IN Operator

Lecture 10: Sub Queries

Chapter 12: Date & Time Data Type

Lecture 1: Section Introduction

Lecture 2: Date & Time Data Type

Lecture 3: Extract Part of Date Values

Lecture 4: GETDATE Function

Lecture 5: CURRENT_TIMESTAMP

Lecture 6: DATEPART Function

Lecture 7: DATEDIFF Function

Instructors

Alexander Shafe
Information Security Consultant

Rating Distribution

1 stars: 0 votes

2 stars: 5 votes

3 stars: 22 votes

4 stars: 117 votes

5 stars: 169 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!