Learn SQL Skills Using PostgreSQL and MS SQL Server
Practical Hands-on SQL with PostgreSQL and SQL Server Databases
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
Who this course is for:
- Beginners to SQL
- Beginners to PostgreSQL and SQL Server