About this course
SQL is the standard language used to communicate with relational database management systems such as Oracle, Microsoft SQL Server, Sybase, and Informix. It is the backbone of all relational databases and offers a flexible interface for databases of all shapes and sizes. It is used as the basis for all user and administrator interactions with the database. With SQL, you can build databases, enter data into the database, manipulate data, and query the database data.
- Introduction to RDBMS
- Introduction to PostgreSQL
- Understanding SQL with PostgreSQL
- Data types, DDL statements in PostgreSQL
- DML statements in PostgreSQL
- Using sub queries, Using views, Operators
- Functions, PostgreSQL Advanced features
- Authentication and encryption