Brochure
Enquire- Course Introduction
- A Few Notes on this Course
SQL & PostgreSQL for Beginners: Become an SQL Expert
BY
Udemy
Acquire a detailed understanding of the principles of SQL and PostgreSQL for writing SQL queries to become certified ...Read more
Online
₹ 649 4099
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
PostgreSQL is a sophisticated object-relational database management system that employs structured query language as well as its procedural language, PL/pgSQL. PostgreSQL is simple to operate and comes with a complete complement of RDBMS database characteristics and data handling capabilities. SQL & PostgreSQL for Beginners: Become an SQL Expert online certification is designed by Jon Avis - SQL Instructor & IT Systems Engineer and is delivered by Udemy.
SQL & PostgreSQL for Beginners: Become an SQL Expert online training incorporates 11.5 hours of self-paced video-based learning materials accompanied by 28 downloadable resources and 2 articles which teach the participants all the necessary techniques to create database databases and perform data analysis using SQL. With SQL & PostgreSQL for Beginners: Become an SQL Expert online classes, participants will be taught about data manipulation, data analysis, grouping data, database relationships, SQL queries, subqueries, and much more.
The highlights
- Certificate of completion
- Self-paced course
- 11.5 hours of pre-recorded video content
- 2 articles
- 28 downloadable resources
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
₹ 649 ₹4,099
certificate availability
Yes
certificate providing authority
Udemy
Who it is for
What you will learn
Database knowledge
Sql knowledge
After completing the SQL & PostgreSQL for Beginners: Become an SQL Expert certification course, participants will gather detailed knowledge of the concepts involved with PostgreSQL and SQL for activities like database design, data analysis, and data manipulation. In this SQL course, participants will explore the methodologies involved with SQL queries, subqueries, joins, aggregate functions, and grouping data. In this PostgreSQL certification, participants will also acquire an understanding of the concepts like database relationships.
The syllabus
Course Introduction
Introduction to Databases, SQL and PostgreSQL
- What is a Database?
- Relational Databases and SQL
- Installing PostgreSQL for Mac
- Installing PostgreSQL for Windows
SQL & PostgreSQL : Data Definition Language - Creating Our Movie Database
- Section Introduction
- Database Tables
- Data Types Explained
- Primary Keys and Foreign Keys
- Unique, Not Null and Check Constraints
- Creating Our First Table
- Creating the Actors Table
- Creating a Table with a Foreign Key
- Creating the Movie Revenues Table
- Creating a Junction Table
- Modifying Tables Part 1: Adding Columns
- Modifying Tables Part 2: Changing a Columns Data Type
- Deleting Tables from a Database
- Challenge: Data Definition Language
- Solution: Data Definition Language
- Section Summary
SQL & PostgreSQL: Data Manipulation Language
- Section Introduction
- Inserting Data into a Table
- Updating Data in a Table
- Deleting Data from a Table
- Inserting Data into Our Movie Data Database
- Challenge: Data Manipulation Language
- Solution: Data Manipulation Language
- Section Summary
SQL & PostgreSQL : Retrieving Data from a Table - Select Queries
- Section Introduction
- Select Queries
- Where Clauses
- Logical Operators
- Challenge 1: Select Queries
- Solution 1: Select Queries
- In, Not In
- Like
- Between
- Challenge 2: Select Queries
- Solution 2: Select Queries
- Order By
- Limiting the Number of Results
- Fetch
- Distinct Values
- Challenge 3: Select Queries
- Solution 3: Select Queries
- Null Values
- Setting a Column Name Alias
- Concatenation
- Challenge 4: Select Queries
- Solution 4: Select Queries
- Section Summary
SQL & PostgreSQL : Aggregate Functions and Grouping Data
- Section Introduction
- Aggregate Functions Explained
- Count Aggregate Functions
- Sum Aggregate Function
- Min and Max Aggregate Functions
- Average Aggregate Functions
- Challenge 1: Aggregate Functions
- Solution 1: Aggregate Functions
- Grouping Data
- Having Clauses
- Challenge 2: Aggregate Functions
- Solution 2: Aggregate Functions
- Mathematical Operators
- Section Summary
Database Relationships
- Section Introduction
- What Are Database Relationships?
- One to One Relationships
- One to Many Relationships
- Many to Many Relationships
- (Optional) Challenge: Database Relationships
- Solution: Database Relationships
- Section Summary
SQL & PostgreSQL: Joining Tables
- Section Introduction
- SQL Joins Explained
- Inner Joins Part 1
- Inner Joins Part 2
- Inner Joins Part 3
- Challenge 1: Joins
- Solution 1: Joins
- Left Joins
- Right Joins
- Full Joins
- Challenge 2: Joins
- Solutions 2: Joins
- Joining More Than Two Tables
- Challenge 3: Joins
- Solution 3: Joins
- Union
- Union All
- Challenge 4: Joins
- Solution 4: Joins
- Intersect
- Except
- Challenge 5: Joins
- Solution 5: Joins
- Section Summary
SQL & PostgreSQL: Subqueries
- Section Introduction
- Subqueries Explained
- Uncorrelated Subqueries Part 1
- Uncorrelated Subqueries Part 2
- Challenge 1: Subqueries
- Solution 1: Subqueries
- Correlated Subqueries
- Challenge 2: Subqueries
- Solution 2: Subqueries
- Summary
SQL & PostgreSQL: String Functions
- Section Introduction
- Cloning a Database
- Upper and Lower String Functions
- Initcap Function
- Left and Right String Functions
- Reverse Function
- Challenge 1: String Functions
- Solution 1: String Functions
- Substring Function
- Replace Function
- Split Part Function
- Using the Cast Operator to Apply String Functions to Non-String Data Types
- Challenge 2: String Functions
- Solution 2: String Functions
- Summary
Bonus Material
- Bonus Lecture
Instructors
Mr Jon Avis
IT Systems Engineer
Udemy
Articles
Popular Articles
prev
next
Latest Articles
prev
next
