Comprehensive SQL Bootcamp : Beginner to Advanced
Learn SQL from scratch and become an expert
What you’ll learn
-
Understand PostgreSQL Database Objects
-
Perform CRUD Operations
-
Creating a database using PostgreSQL GUI
-
Creating tables with PostgreSQL GUI and SQL Commands
-
Use SQL to insert records in a database
-
Use SQL to execute queries against a database
-
Use SQL to retrieve data from a database
-
Use SQL to update records in a database
-
Use SQL to delete records from a database
-
Use SQL to create stored procedures in a database
-
Use SQL to create views in a database
-
Use SQL to filter and sort data returned from a database
-
Query and eliminate duplicate records
-
Joining and querying data from multiple tables
-
Using various aggregate functions and grouping data
-
Using various Operators to query data
-
Using various Analytic Functions
Requirements
-
No prior experience required
Who this course is for:
- Beginners to SQL
- Beginners to PostgreSQL
