jcg
Learn one of the most in–demand skills in tech industry in 2021!
SQL, also known as Structured Query Language is a computer language that is designed to store, manage, manipulate, and extract data from a database. Learning SQL is actually one of the top skills in 2021, and can significantly improve your career prospects.
This course is designed in such a way that it will taught effectively, and the concepts you learn here can easily be applied to real–world scenarios.
In this course, you will learn the following:
The Fundamental Statements of SQL like SELECT, SELECT DISTINCT, LIMIT, and much more.
Basic Aggregate functions like SUM, AVG, COUNT, MAX, and MIN.
Basic mathematical, string, and time functions and operators.
Data types, Primary & Foreign Keys, Constraints.
Creating your own tables, inserting values in them, and also modifying the rows and columns of the tables.
GROUP BY statement, and HAVING clause for data analysis
JOINING multiple tables with the help of UNION, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN.
Writing complex queries.
Advanced concepts like CASE,COALESCE, VIEWS etc.
CREATE FUNCTION command.
Window Functions.
Import/Export csv files to/from PostgreSQL server.
We will not only cover the concepts, but also perform practical examples by writing queries on pgAdmin. This will help you a lot in understanding the topics that we will discuss throughout this course. I will also give you assignments throughout this course, which will help you cover all the concepts that we will discuss.
Specification: SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals
|
3 reviews for SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals
Add a review
| Price | $11.99 |
|---|---|
| Provider | |
| Duration | 9 hours |
| Year | 2021 |
| Level | All |
| Language | English ... |
| Certificate | Yes |
| Quizzes | No |
$11.99
Mohsin Qureshi –
It’s a perfect course for beginners. The Instructor explains everything in detail, we just need to practice along with Zaki. I used PostgreSQL Dbms and it was really easy. Thanks a lot.
Warda Shafiq –
The perfect course for people who want to get their hands dirty with SQL. The instructor takes you from scratch and gives you enough examples to practice to make you capable of solving real database problems.
Haider Ali –
I was looking for SQL courses, but the problem with other courses is that they become boring after a while and i could keep up with those courses. Most of the time, I stop watching the videos in other courses. On the other hand this course provided me with good content and unlike other courses I watched it completely. It landed me my first Job as a Database Administrator.