I have a two day advanced PostgreSQL training in Bangalore on 26th and 27th of November and will pay INR 50,000/- total for the program. Anyone who had good experience in SQL and has trained on it can reach me at 9731657840. The Topics to be covered are below. It is a full day training on two days and dates are fixed.
• SQL UNION
• SQL UNION ALL
• SQL INTERSECT
• SQL MINUS
• SQL LIMIT
• SQL TOP
• SQL Subquery – Correlated and Uncorrelated
• SQL EXISTS
• SQL CASE
• SQL DECODE
• SQL AUTO INCREMENT
• SQL Accessing Forwarding and Preceding rows (Lead & Lag)
• SQL Window functions (Rolling windows, Cumulative calculations, Moving Averages)
• Pivoting data
• Hierarchical Queries
• Cursors
• Dynamic SQL
• Materialized Views
• Query Optimization
• Rank
• Median
• Running Totals
• Percent To Total
• Regular Expression Functions
• Datatype conversions
Will give all SQL level training mentioned and we can cover the other sql topics as well. Along with this we can discuss some PLSQL and other languages supported by PostgreSQL.
Hello!
I am experienced with SQL and Postgresql due to my work for 3 years now as a backend developer who also has to use a lot of SQL in his day-to-day job. I can teach you these subjects on these 2 days you specified, and I will be happy to use my knowledge and experience to do so in the best way possible so you can understand them better. Feel free to contact me and we will sort things out!
P.S. when I say I deliver in 2 days I mean in the 2 days you specified.
PostgreSQL DBA with 6 Years of Experience and 3 Years of Experience as SQL DBA. Expertise in Transact – Postgresql(DDL, DML) and in design of the database tables. PostgreSQL Query Tuning, Performance Monitoring. Backups and Restore of the Database. Setup Replications and maintenance, scripts on Linux Bash. Seeking a successful, challenging and rewarding career that provides the opportunity to innovate and grow along with organization.