Learn SQL Skills Using PostgreSQL and MS SQL Server
What you'll learn
- Install PostgreSQL
- Install SQL Server
- Create a database
- Create a table
- Create a view
- Write a subquery
- Perform basic CRUD operations
- Create a stored procedure
- Create a trigger
- Use operators
- Use aggregate functions
- Use analytic functions
- Implement table joins
Requirements
- You should be comfortable using a computer
- You should be able to navigate the internet
Description
SQL stands for structural query language. It is the language used to communicate and interrogate databases.
In this course we will be using SQL on PostgreSQL and Microsoft SQL Server.
Microsoft SQL Server is a relational database management system. (RDBMS)
supports a wide variety of transaction processing.
Supports business intelligence.
Supports analytics applications in corporate IT environments.
It's one of the three market-leading database technologies.
SQL server is used in a lot of countries and companies.
PostgreSQL is commonly known as Postgres and it is also open source database.
There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common relational database and data science tasks, including writing advanced queries,data analysis , finding, exploration, and extraction within relational databases.
What you will learn includes:
- Installing PostgreSQL
- Installing SQL Server
- Database Concepts
- Introduction to Updatable Views
- Creating Updatable Views
- Introduction to Materialized Views
- Creating Materialized Views
- Introduction to Stored Procedures
- Row Number Functions
- Using various types of Operators
- Installing PostgreSQL
- Postgresql INNER JOIN
- Postgres LIKE Operator
- Postgresql OR Operator
- Retrieving all Data from Table
- Loading sample database
- SQL Server Rank functions
- PostgreSQL FULL OUTER JOIN
- PostgreSQL CROSS JOIN
- PostgreSQL combining AND | OR Operator
- PostgreSQL AND Operator
- PostgreSQL NATURAL JOIN Operator
- PostgreSQL Left Join
- PostgreSQL IN Operator
- How to create database
- How to create a table
- How to create a view
- Table joins
- Operators
- Aggregate functions
- Analytic functions
- Stored procedures
- Triggers
CRUD operations
Who this course is for:
- Beginners to SQL
- Beginners to PostgreSQL and SQL Server
Instructor
- 4.1 Instructor Rating
- 44,402 Reviews
- 781,271 Students
- 469 Courses
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.