SQL for beginners with: Microsoft SQL Server | PostgreSQL

SQL for beginners with: Microsoft SQL Server | PostgreSQL, available at $44.99, has an average rating of 4.6, with 78 lectures, based on 28 reviews, and has 4531 subscribers.

You will learn about Backup a database Restore a database Create stored procedures Write SQL queries with confidence Select data from specific table column Select data from all table columns Join data from multiple tables Insert records into the database Extract data from database using subqueries Delete records Query databases with multiple operators Group data Aggregate data Filter Data from database Sort data from database This course is ideal for individuals who are Beginners to SQL It is particularly useful for Beginners to SQL.

Enroll now: SQL for beginners with: Microsoft SQL Server | PostgreSQL

Summary

Title: SQL for beginners with: Microsoft SQL Server | PostgreSQL

Price: $44.99

Average Rating: 4.6

Number of Lectures: 78

Number of Published Lectures: 78

Number of Curriculum Items: 78

Number of Published Curriculum Objects: 78

Original Price: $54.99

Quality Status: approved

Status: Live

What You Will Learn

Backup a database
Restore a database
Create stored procedures
Write SQL queries with confidence
Select data from specific table column
Select data from all table columns
Join data from multiple tables
Insert records into the database
Extract data from database using subqueries
Delete records
Query databases with multiple operators
Group data
Aggregate data
Filter Data from database
Sort data from database

Who Should Attend

Beginners to SQL

Target Audiences

Beginners to SQL

SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences.

Millions of data points are being generated every minute and raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.

SQL is the most common language for extracting and organising data that is stored in a relational database.

A database is a table that consists of rows and columns. SQL is the language of databases.

It facilitates retrieving specific information from databases that are further used for analysis.

SQL can be used to:

Execute queries against a database
Retrieve data from a database
Insert records into a database
Update records in a database
Delete records from a database
Create new databases, or new tables in a database
Create stored procedures & views in a database
Set permissions on tables, procedures, and views
Backup and restore data
Join data from multiple tables

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other

software applications—which may run either on the same computer or on another computer across a network.

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Overview of SQL

Lecture 2: Introduction

Lecture 3: What is SQL Server

Lecture 4: SQL Server Editions

Lecture 5: Hardware and Software Installation Requirements

Lecture 6: Download SQL Server

Lecture 7: Install SQL Server

Lecture 8: Install SSMS

Lecture 9: Connect SSMS to SQL Server

Lecture 10: Install Sample Database

Lecture 11: Database Concepts

Chapter 2: SQL | Microsoft SQL (T-SQL ) Fundamentals

Lecture 1: What is SQL

Lecture 2: What is Microsoft SQL (T-SQL)

Lecture 3: Creating databases

Lecture 4: Creating tables

Lecture 5: Inserting data into database

Lecture 6: Retrieving data from database

Lecture 7: Creating Views

Lecture 8: Creating stored proedures

Lecture 9: Updating Records

Lecture 10: Backing up database

Lecture 11: Deleting records

Lecture 12: Truncating tables

Lecture 13: Dropping tables

Lecture 14: Dropping database

Lecture 15: Restoring database

Chapter 3: Filtering data from SQL Server

Lecture 1: Introduction

Lecture 2: Filtering data with equality filters

Lecture 3: Filtering data with comparisons

Lecture 4: Filtering data with logical comparisons

Lecture 5: Filtering data with string comparisons

Lecture 6: Filtering data with NULL Comparisons

Chapter 4: Sorting data from SQL Server Database

Lecture 1: ORDER BY Clause

Lecture 2: Sorting by ascending order

Lecture 3: Sorting by descending

Lecture 4: Sorting by multiple columns

Chapter 5: PostgreSQL Setup

Lecture 1: What is PostgreSQL

Lecture 2: Installing PostgreSQL on Windows

Lecture 3: Installing PostgreSQL on Macs

Lecture 4: Installing PostgreSQL on Linux

Lecture 5: Installing PgAdmin on Macs

Lecture 6: Installing PgAdmin on Linux

Lecture 7: Connect PgAdmin to PostgreSQL

Lecture 8: Install Sample database

Chapter 6: SQL Fundamentals with PostgreSQL Database

Lecture 1: Filtering Data

Lecture 2: Getting all data from a table

Lecture 3: Getting data from specific table

Lecture 4: Removing duplicate data

Lecture 5: Sorting data

Lecture 6: Grouping data

Lecture 7: Filtering Groups

Lecture 8: Sub Queries

Chapter 7: SQL: Query data in PostgreSQL using Operators

Lecture 1: Comparison Operators

Lecture 2: Between Operators

Lecture 3: Not Between Operators

Lecture 4: Like Operators

Lecture 5: NOT Operator

Lecture 6: OR Operator

Lecture 7: AND Operator

Lecture 8: Combining AND | OR Operator

Lecture 9: Limit Operator

Lecture 10: IN Operator

Lecture 11: Union Operator

Lecture 12: Union All Operator

Lecture 13: INTERSECT Operator

Lecture 14: EXCEPT Operator

Chapter 8: SQL: Data Aggregation with PostgreSQL

Lecture 1: What are Aggregate Functions

Lecture 2: AVG Function

Lecture 3: COUNT Function

Lecture 4: MAX Function

Lecture 5: MIN Function

Lecture 6: SUM Function

Chapter 9: Joining Data from multiple tables in PostgreSQL

Lecture 1: PostgreSQL Table Joins

Lecture 2: INNER Join

Lecture 3: LEFT Join

Lecture 4: FULL Outer Join

Lecture 5: CROSS Join

Lecture 6: NATURAL Join

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 7 votes
5 stars: 17 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!

Menu