Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
2 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
2 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- Using Real World PostgreSQL Database Airlines Database.
- Use SQL to create databases.
- Use SQL to Query & retrieve data from databases.
- Use SQL to Sort records after retrieving from databases.
- Use SQL to Filter data by using where clause.
- Use SQL to Group data by specific conditions.
- SQL Challenge to test what you are learning.
Course Overview
Looking to master PostgreSQL and improve your data querying skills? Look no further than this comprehensive course!
Through real-world examples and challenging exercises, you'll learn everything you need to know about PostgreSQL, including:
- Using the Airlines Database to query real-world data
- Installing and creating tables in PostgreSQL
- Understanding SELECT statements, WHERE clauses, and operators
- Advanced techniques like GROUP BY, HAVING, and Aggregation Queries
- Handling time and date data in SQL
But why bother learning SQL in the first place? For starters, SQL is a declarative language that enables non-IT professionals to query data without needing to ask a programmer for help. By learning SQL, you'll develop new mental models for thinking about data, which is a powerful skill in today's data-driven world.
Plus, PostgreSQL is free, open, and unlimited, making it the perfect tool to learn about relational databases. It has exhaustive and detailed documentation, and its advanced implementation of SQL is very close to the SQL standard, making your knowledge transferable to other SQL databases.
But perhaps the most compelling reason to learn SQL is its relevance to today's job market. Having PostgreSQL knowledge on your resume and online profile can make you a highly attractive candidate to recruiters, opening up new career opportunities and possibilities for advancement.
So what are you waiting for? Enroll in this course today and take your PostgreSQL skills to the next level!
May also be the ultimate reply when your development stalls – which isn’t precisely comforting, but a lot better than knowing there is no viable answer.
Relational databases are nonetheless the workhorses of the laptop industry. PostgreSQL has an advanced implementation of SQL and is very close to the SQL standard. So your know-how would be of use as it is transferable, so different SQL databases are reachable to you.
It’s correct for your thought – and your career!
Still want convincing that gaining knowledge of SQL is worth it?
Well, in addition to developing new neural pathways in your brain, it could do wonders for your profession possibilities as it will make you a applicable candidate. Having “PostgreSQL knowledge” in your CV and on-line profile will almost clearly attract the attention of recruiters.
Pre-requisites
- Computer and internet.
- No prior knowledge required for this course
Target Audience
- Are you want to learn more about SQL & PostgreSQL?
- Are you ready for willing to master SQL basics?
- Are you ready for willing to use SQL in web development?
- Are you ready for willing to use SQL to build a database to facilitate your business?
Curriculum 33 Lectures
-
Section 1 : Introduction
- Lecture 2 :
- PostgreSQL Downloading and Installing
- Lecture 3 :
- Database Creation
- Lecture 4 :
- Database Restore
-
Section 2 : Airline Database Overview
- Lecture 1 :
- Overview Part 1
- Lecture 2 :
- Overview Part 2
- Lecture 3 :
- Data Types
-
Section 3 : SQL Basics Part 1
- Lecture 1 :
- SELECT Statement
- Lecture 2 :
- SELECT FOR ALL
- Lecture 3 :
- SQL Select Challenge Solution
- Lecture 4 :
- SQL Distinict
-
Section 4 : SQL Basics Part 2
- Lecture 1 :
- Where Clause
- Lecture 2 :
- Operators used with Where Clause
- Lecture 3 :
- Where Clause + AND & Where Clause + OR
- Lecture 4 :
- Where Clause + LIKE
- Lecture 5 :
- (Where Clause + BETWEEN & IN) & AS
-
Section 5 : SQL Basics Part 3
- Lecture 1 :
- LIMIT & ORDER BY
- Lecture 2 :
- FETCH vs LIMIT
- Lecture 3 :
- NOT IN
- Lecture 4 :
- ISNULL & IS NOT NULL
- Lecture 5 :
- CAST
-
Section 6 : SQL Aggregations
- Lecture 1 :
- COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE
- Lecture 2 :
- SUM( ) Function
- Lecture 3 :
- MIN( ) , MAX( ) & AVG( ) Functions
- Lecture 4 :
- GROUP BY & HAVING
- Lecture 5 :
- Deep dive in Count
-
Section 7 : SQL Control Flow
- Lecture 1 :
- CASE Clause
- Lecture 2 :
- NULLIF()
- Lecture 3 :
- COALESCE() Function in SQL
-
Section 8 : SQL Time Data Management
- Lecture 1 :
- Overview of Time Functions in PostgreSQL
- Lecture 2 :
- TIMESTAMP EXTRACT()
- Lecture 3 :
- DATE_TRUNC() & DATE_PART()
- Lecture 4 :
- Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( )
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
-
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
2520 Course Views
13 Courses
Hello there! With over 350,000 happy students enrolled in my courses, I'm thrilled to be sharing my programming and data science expertise with you.
As a programmer and data scientist, I've mastered several programming languages, including Python, SQL, JavaScript, R Programming, as well as tools like Excel, Tableau, Jupyter Notebook, Apache Cassandra, Apache Spark, Apache Airflow, Apache Kafka, AWS, and R Studio. I'm passionate about teaching and sharing my knowledge with the community.
When I'm not coding, you can usually find me hiking or reading a good book. I believe that lifelong learning is essential for personal development, and my courses are designed to encourage students to continue learning outside of formal education.
I update my courses every month to add new sections based on your feedback and requests. So don't wait – enroll in my courses now and start your journey towards mastering programming, web development, data science, data Engineering and Machine Learning!
View More...
