Brochure
Enquire
- Intro Video
- Some Additional Resources!!
- Bonus: Learning Paths
- Get the materials
- Your Shortcut To Becoming A Better Data Scientist!
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
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
Who it is for
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
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
Data Scientist
Udemy
Mr Ilya Eremenko
Business Analyst
Freelancer
Other Bachelors
Articles
Popular Articles
prev
next
Latest Articles
prev
next
