{"title":"PostgreSQL - Programování v PL/pgSQL a pokročilé techniky vývoje ","shortDescription":"Tento kurz je určen pokročilejším vývojářům, kteří chtějí zvládnout efektivní vývoj v PostgreSQL, který se neobejde bez uložených procedur. PostgreSQL podporuje jak SQL procedury, tak i tzv. externí procedury. K dispozici je několik jazyků od SQL až po PL/Perl. Každý jazyk nabízí jiné možnosti a po absolvování kurzu by se vývojář měl dokázat rozhodnout pro jeden konkrétní jazyk, který pro dané zadání nabízí největší možnosti. Důraz je kladen na procvičení látky ve formě praktického workshopu. ","description":"<h2>Mastering PL/pgSQL: Advanced PostgreSQL Programming Techniques</h2>\n\n<p>This comprehensive course empowers you with the essential skills and knowledge to effectively program in PL/pgSQL, ensuring that you can leverage advanced PostgreSQL functionalities to optimize your database solutions.</p>\n\n<h3>Structured Information</h3>\n<ul>\n <li><strong>Target Audience:</strong> Database professionals, software developers, and IT enthusiasts looking to enhance their PostgreSQL programming abilities.</li>\n <li><strong>Course Duration:</strong> 2 days</li>\n <li><strong>Course Format:</strong> Online (Virtual participation available)</li>\n <li><strong>Certification:</strong> Yes</li>\n</ul>\n\n<h3>Detailed Course Description</h3>\n<ul>\n <li><strong>Skills Gained:</strong> \n - Mastery of PL/pgSQL syntax \n - Proficient in creating and managing stored procedures \n - Understanding dynamic SQL and triggers \n - Performance optimization techniques \n - Advanced indexing methods \n - Efficient handling of large tables and temporary tables \n </li>\n \n <li><strong>Course Outline:</strong> \n - Fundamentals of stored procedures \n - Inline procedures in SQL \n - Introduction to PL/pgSQL \n - CREATE FUNCTION syntax \n - PL/pgSQL Execution flow diagram \n - Essential PL/pgSQL commands \n - Dynamic SQL usage \n - Design and use of triggers \n - Best practices for PL/pgSQL development \n - Internal workings of PostgreSQL system \n - Planner and optimizer functions \n - Performance measurement methods \n - Caching query results \n - Comprehensive view on using views \n </li>\n \n <li><strong>Bonuses:</strong> \n - Additional course materials \n - Expert consultations from experienced instructors at ICT Pro \n </li>\n</ul>\n\n<p>Join us and take the next step in your database programming journey! Elevate your skills, improve your projects, and earn a recognized certification. Don't miss this opportunity to become an expert in PL/pgSQL!</p>","rating":0,"reviewCount":0,"reviews":[]}