SQL Fundamentals for beginners

SQL Fundamentals for beginners

What you’ll learn

• Installing PostgreSQL relational database management system
• Connecting to a database
• Loading a sample database
• Creating database and table
• Using constraints to ensure data intergrity
• Using SQL SELECT Statement to retrieve data
• Using SQL CREATE Statement to create a table
• Using SQL UPDATE Statement to modify data
• Using SQL DELETE to remove data
• Using SQL DISTINCT to filter duplicate data
• Filter data using SQL WHERE Clause
• Sort data using SQL ORDER BY
• Manipulating data with various operators
• Retrieve and combine data from multiple tables
• Manipulating data using Aggregate Functions