Learn SQL with PostgreSql Database [ SQL In A Lunch Break ] (Udemy.com)
Learn SQL incredibly fast with high quality videos and real-life examples
Created by: AKINCI Training
Produced in 2018
What you will learn
- Create or drop databases
- Create or drop tables
- Insert or delete data into tables
- Select and show table contents
- Select table contents that has a condition
- Select only distinct(unique) items of a table
- Order the result by ascending or descending order
- Understand and use primary and foreign keys
- Create unique or not null table columns
- Set default values automatically to table columns
- Check a condition before inserting data into a table
- Use indexes to have higher performance
- Use AND, OR and NOT operators to have more than one conditions
- Select table values that has a pattern within
- Select values in the given range
- Add, drop or modify table columns
- Update or delete table values
- Show the union of more than one tables
- Group table contents
- Group table contents that has a condition
- Get the minimum or maximum value of a table col
Quality Score
Overall Score : 100 / 100
Course Description
Do you want to learn SQL less than a hour? We designed this course to teach important points of SQL in 1 hour.
Every video on this course is designed for you to teach every topic less than 2 minutes. You'll learn every topic in 1-2 minutes with animations and effects!
SQL, which stands for Structured Query Language, is a programming language that is used to communicate with and manipulate databases.
You'll learn all SQL statements, constraints, operators, clauses and functions on real-life examples. We prepared lots of example queries for you to teach them all.
We'll teach you SQL with real life examples on popular PostgreSQL database.
We don't want to waste your time, because we eliminated unnecessery parts, comments and etc. We focused only the important points of topics. And also we are trying teach slow enough for you to follow easily too.
In addition to them, this course also contains AKINCI Training's quality standards:
- Dubbed by 40-year-experienced voiceover professional, in his professional recording studio,
- All videos has 1920 x 1080 full HD resolution, video animations and effects,
- All videos have closed captions for you to understand easily,
- And contains premium support which means average response time is less than 24 hours
Join us now!Who this course is for:
- This course is for everyone who want to learn and use databases(especially PostgreSql)
- This course focuses on SQL with PostgreSql. But everyone can take and start learning SQL with this course. Only some small points are different for other databases. This course will probably be very helpful for you to understand and use the SQL for other databases too
Instructor Details
- 5.0 Rating
1 Reviews
AKINCI Training
Since its establishment in 2015, AKINCI Training has focused on e-learning, consultancy, software development, web programming and design with its experts who have more than 8 years of professional experience.
AKINCI Training's vision is to become a solution-oriented and reliable global company with highest customer satisfaction.
AKINCI Training has expertise mainly on software engineering, Java and Java Technologies training. Most of these courses were given to large-scale companies and multinational corporations.
AKINCI Training has experienced computer engineers that have worked on large-scaled software development projects at least 8 years, and now gives courses on:
- Java Programming Language (Beginner/Intermediate/Advanced Level)
- Java Design Patterns
- Java 2 Enterprise Edition (including nTier Architecture, Servlets, EJB(Enterprise Java Beans), JTA(Java Transaction API), JDBC, JAXP-SAX, JAXP-DOM)
- Hibernate with MySQL, PostgreSQL, SQL Server Express Edition and Oracle Databases,
- Spring Framework
- UML(Unified Modeling Language)
- JSP(JavaServer Pages)
- JSF(JavaServer Faces)
to share their experiences.
In AKINCI Training, the only important thing is you, and your success. And all of ou
More courses by AKINCI Training
Step By Step Java Programming Complete Course (2021)
4.2 (49 Reviews)
Provider: Udemy
Time: 10.5h
$11.99
More postgresql courses
SQL and PostgreSQL: The Complete Developer's Guide (2021)
4.8 (60 Reviews)
Provider: Udemy
Time: 22h
$11.99
Practical SQL Bootcamp for Data Analysts and Data Scientists (2021)
4.8 (50 Reviews)
Provider: Udemy
Time: 3.5h
$11.99
Python 3 Complete Masterclass - Make Your Job Tasks Easier! (2021)
4.7 (414 Reviews)
Provider: Udemy
Time: 15.5h
$11.99









