2024 SQL Introduction Course SQL Crash Course

Using PostgreSQL & applicable to Oracle SQL, Microsoft SQL Server, and MySQL for Data, Apps and Web development.

Created by : Rated :4.5 683 views

Last Updated: 2023-11-29 10:11:45 English Course Type: Self Learning

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.

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.

Computer and internet.
No prior knowledge required for this course

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?

Section 1 : Introduction 4 Lectures 00:10:18
Lecture 1 :
Introduction Preview
Lecture 2 :
PostgreSQL Downloading and Installing
Lecture 3 :
Database Creation
Lecture 4 :
Database Restore
Section 2 : Airline Database Overview 3 Lectures 00:07:35
Lecture 1 :
Overview Part 1
Lecture 2 :
Overview Part 2
Lecture 3 :
Data Types
Section 3 : SQL Basics Part 1 4 Lectures 00:16:58
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 5 Lectures 00:26:46
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 5 Lectures 00:22:06
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 5 Lectures 00:10:49
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 3 Lectures 00:12:40
Lecture 1 :
CASE Clause
Lecture 2 :
NULLIF()
Lecture 3 :
COALESCE() Function in SQL
Section 8 : SQL Time Data Management 4 Lectures 00:17:42
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( )

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?

Temotec Learning Academy,

7257 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!