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

BY
Udemy

Learn the concepts involved in SQL and database design by utilising the MySQL and Microsoft SQL Server features.

Mode

Online

Fees

₹ 499 3499

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

In corporate IT environments, Microsoft SQL Server is a relational database management system that supports a broad range of processing transactions, business intelligence, and analytics applications. SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL online certification is created by KirillnEremenko - Data Scientist, IIya Eremenko - Business Analyst Professional & Ligency | Team- an educational platform that helps data scientists and data analysts gain advanced skills, which Udemy offers.

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL online training is a self-paced training program that comprises more than hours of digital lessons along with 5 articles that are intended for candidates who want to comprehend the fundamentals of SQL. SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL online course revolve around database design, database normalization, and SQL queries as well as discusses the methodologies for arranging databases, adding data to them, and removing them upon request.

The highlights

  • Certificate of completion
  • Self-paced course
  • 12.5 hours of pre-recorded video content
  • 5 articles 
  • Learning resources

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 499  ₹3,499
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Database knowledge Sql knowledge

After completing the SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL certification course, candidates will gain a deeper understanding of the fundamental theory of databases and acquire a detailed knowledge of the principles of SQL for database design. In this database design course, candidates will explore the tools and methodologies associated with Microsoft SQL Server and PostgreSQL. In this database design certification, candidates will also learn about strategies involved with database normalization, tables, and SQL queries.

The syllabus

Introduction

  • Intro Video
  • Some Additional Resources!!
  • Bonus: Learning Paths
  • Get the materials
  • Your Shortcut To Becoming A Better Data Scientist!

Installation

  • Welcome to this section! This is what you wil learn
  • 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

Basics of SQL

  • Welcome to this section! This is what you will learn
  • Theory Select Query
  • Time to write your first query in PostgreSQL
  • Adding a filter using WHERE in PostgreSQL
  • Logical conditions AND, OR in PostgreSQL
  • Using wildcards % and _ (advanced tutorial)
  • Comments in SQL
  • Getting to write your first query MS SQL
  • Where MS SQL
  • Logical conditions, AND OR MS SQL
  • Using wildcards MS SQL
  • Comments in SQL MS SQL
  • Basics of SQL quiz

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
  • Order By
  • Working With Varchars
  • Working With Dates
  • Implicit Data Conversion in SQL
  • Working With Null
  • Uploading Console Games DATASET MS SQL
  • Working with arithmetic data types MS SQL
  • Order By MS SQL
  • Working with VARCHAR MS SQL
  • Working with Dates MS SQL
  • Implicit DATA conversion MS SQL
  • Working With Data quiz

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

Joining tables in SQL

  • Welcome to this section! This is what you wil learn
  • Types of Joins
  • Duplicates in Joins
  • Joining on multiple fields
  • The challenge: The Vet's Clinic
  • Upload the data
  • Your First Left Outer Join
  • Joins Tips & Tricks
  • Inner Join
  • Full Outer join
  • Joining on Multiple Fields (Practice)
  • Complex Joins
  • Cleaning up your Join
  • Cross Join (advanced tutorial)
  • Upload The Data - MS SQL
  • Your First Left Outer Join - MS SQL
  • Joins Tips & Tricks - MS SQL
  • Inner Join - MS SQL
  • Full Outer Join - MS SQL
  • Joining on Multiple Fields (Practice) - MS SQL
  • Complex Joins - MS SQL
  • Cleaning Up Your Join - MS SQL
  • Cross Join (advanced tutorial) - MS SQL

Creating Tables in SQL

  • Welcome to this section! This is what you will learn
  • Create Database
  • Create Table
  • Insert Data
  • Alter Table
  • Drop Table
  • Create Database MS SQL
  • Create Table MS SQL
  • Insert Data MS SQL
  • Alter Table MS SQL
  • Drop Table MS SQL
  • Creating Tables in SQL quiz

Database Design

  • Welcome to this section! This is what you wil learn
  • MS SQL Server: What is Database Normalization?
  • Prime and non-prime attributes
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • The challenge: Online Clothing Store (OLTP Database)
  • Upload the data
  • Normalization 1NF Investigation
  • Normalization 2NF Investigation
  • Normalization 2NF Modification
  • Normalization 3NF Investigation
  • Normalization 3NF Modification
  • Upload The Data - MS SQL
  • Normalization 1NF Investigation - MS SQL
  • Normalization 2NF Investigation - MS SQL
  • Normalization 2NF Modification - MS SQL
  • Normalization 3NF Investigation - MS SQL
  • Normalization 3NF Modification - MS SQL
  • Thank You bonus video

Bonus Lectures

  • ***Your Special Bonus***

Instructors

Mr Kirill Eremenko

Mr Kirill Eremenko
Data Scientist
Udemy

Mr Ilya Eremenko
Business Analyst
Freelancer

Other Bachelors

Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books