• Creating the movie data base and a actors table
• Creating the directors table
• Creating the movies table with a foreign key
• Creating the movies_revenues table
• Creating a Junction table with movies and actors tables
• Create a sample Database mydata.
• Deleting tables from a database

• Insert a data into table
• Insert multiple records into a table
• Insert a data that had quotes
• Update data in a table

• Comparison, Logical and Arithmetic operators
• Cambining AND, OR operators
• What goes before and after
• Using Logical operators Using PIN
• Using IS NULL and JS NOT NULL keywords
• Cancatnation techniques
• Cancatenatian with Ill CONCAT and CONCAT_WS

• Boolean
• CHAR VARCHAR and TEXT
• NUMERIC , DECIMALS
• Selecting Numbers data types

• Creating sample database mydata
• Modify Table Structures, Add/Modify Columns

• What is a data type conversion
• Table data conversion

• to_char ,to_number
• to_date

• CREATE DOMAIN - Create a DOMAIN data type, create an address
• CREATE DOMAIN - Create a domain data type for an email validation
• CREATE DOMAIN Create a Enum or Set of values domain data type
• CREATE DOMAIN - Get the list of all DOMAIN data types
• CREATE DOMAIN Create a Enum or Set of values domain data type

• Introduction to constraints ,NOT NULL
• Creating foreign key constraints

• Cambine results sets with UNION
• Intersect with tables

• PostgreSQL Schemas
• Schema search path
• Alter a schema ownership

• Array modification functions
• Modifying array data

• JSON and JSONB data types
• Exploring JSON objects
• Creating a document from data

• Indexes far sorted output
• Rebuilding an index

• Using aggregate functions
• Powerful text searches in PostgreSQL
• Analyzing presidents speaches text data

• Creating our first SQL function
• Function returning a singIe value
• Function returning multiple rows
• Function returning a table

• Introduction to PL/pgSQL language
• PL/pgSQL vs SQL
• Declaring variables

• Functions vs Stored Procedures
• Create a transactions

• Introduction to triggers
• Pros and Cons of triggers

• TP-CC-PostGreSQL.pdf

Well, whilst you may paintings with SQL, it way you don’t should depend upon others sending you information and executing queries for you. You can try this to your own. This lets in you to be impartial and dig deeper into the information to achieve the solutions to questions that would enhance the manner your enterprise does its business. For instance, Database control is the muse for information evaluation and sensible selection making.

100% Placement support will be given.