SQL Crash Course For Beginners – Learn SQL with PostgreSQL

Description

In this course, you will learn :

• Use SQL to answer real questions
• Write advanced queries, like joins, groups and subqueries
• Become comfortable putting SQL and PostgreSQL on your resume
• Use available functions and operators in SQL
• Understand important database concepts
• Create your own databases

Syllabus :

• Database Introduction - a little Terminology and Setup
• Tables and Inserting Data - with CREATE & INSERT
• Query Data - with SELECT, WHERE, ORDER, LIMIT
• Data Types - Numeric, String, Date, Boolean
• Remove Data & Objects - DROP, TRUNCATE
• Modify Data & Objects - ALTER, UPDATE
• Constraints - for good data & structure
• Normalization - How to structure a database
• Operators - for Arithmetic, Comparison, Logic
• Functions – Built-in Code for Strings, Numbers, Conversion, Dates and more
• Joins – Bringing 2+ tables together
• Subqueries - How to nest queries
• Security - The basics
• Views - A way of storing queries