Comprehensive SQL Bootcamp: Beginner to Advanced
 |
| Ratings | Students Enrolled |
This course includes:
- 8.5 hours on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
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
Who this course is for:
- Beginners to SQL
- Beginners to PostgreSQL
Requirements
- No prior experience required
Description
SQL is a standard language for accessing and manipulating databases.
SQL is one of the most in-demand tech skills used across many industries.
What is SQL?
SQL stands for Structured Query Language
What can SQL do?
- SQL lets you access and manipulates databases
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can filter data returned from a database
- SQL can sort data returned by a database.
- SQL can be used to truncate and drop tables.
- PostgreSQL is a powerful, open-source object-relational database system.
- PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.
- PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.
- PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.
Comments