SQL & Database Design A-Z': Learn MS SQL Server + PostgreSQL

5.0 /5

(2 Ratings)

Offered byUDEMY

SQL & Database Design A-Z': Learn MS SQL Server + PostgreSQL
at
UDEMY
Overview

Enhance Your Data Analytics Career With Real World Data Science Exercises

Duration	13 hours
Total fee	₹455
Mode of learning	Online
Credential	Certificate

SQL & Database Design A-Z': Learn MS SQL Server + PostgreSQL
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Learn from 5 articles
Comes with 30 days money back guarantee and full lifetime access

SQL & Database Design A-Z': Learn MS SQL Server + PostgreSQL
at
UDEMY
Course details

Skills you will learn

Windows installation Installation Sales Data Science

Who should do this course?

For Anybody who wants to learn PostgreSQL
For Anybody who wants to better understand how databases work
For Anybody who wants to enhance their Data Science career

What are the course deliverables?

Create basic SQL Queries
Create Left, Right, Inner and Full Outer joins
Normalize Databases
Create advanced SQL Queries
Create new tables, alter existing tables in Databases
Understand database design

More about this course

SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request
Learn how to create queries in a popular variation of SQL called PostgreSQL
The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design

SQL & Database Design A-Z': Learn MS SQL Server + PostgreSQL
at
UDEMY
Curriculum

Installation

Updates on Udemy Reviews

Installation: PostgreSQL & PgAdmin 4 for Windows

Installation: PostgreSQL & PgAdmin 4 for MAC OS

Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows

Preparation

Welcome to this section! This is what you will learn

The challenge: Investigating Consumer Complaints

Upload Consumer Complaints

Getting To Know The Pgadmin

Upload Consumer Complaints MS SQL

Getting to know MS SQL Server

Basic of SQL

Welcome to this section! This is what you will learn

Theory Select Query

Adding a filter using WHERE in PostgreSQL

Logical conditions AND, OR in PostgreSQL

Using wildcards % and _ (advanced tutorial)

Comments in SQL

Working with Data

Welcome to this section! This is what you will learn

The challenge: Analyzing Console Games Sales

Uploading Console Games Dataset

Working with arithmetic data types

Implicit Data Conversion in SQL

Fundamentals of Database Theory

Welcome to this section! This is what you will learn

Structured vs Unstructured Data

Elements Of a Database

Relational Keys

Relational Database

Functional Dependency

SQL & Database Design A-Z': Learn MS SQL Server + PostgreSQL
at
UDEMY
Faculty details

Kirill Eremenko

Professionally, Kirill come from the Data Science consulting space with experience in finance, retail, transport and other industries

Ilya Eremenko

Ilya is a studying a Bachelor of Corporate Systems Management at one of the leading Universities of Australia. He has also recently completed an internship as a Business Analyst for a major financial institution