{"title":"Oracle databáze - Jazyk SQL","shortDescription":"Potřebujete komunikovat s databázovými specialisty, lépe porozumět data-driven projektům a orientovat se v oblasti relačních databází? <br><strong>Poznejte jazyk SQL</strong>, získejte znalosti potřebné k zadání dotazů, vytvářejte vlastní databázové objekty. Náš kurz vedený zkušenými lektory, kteří <strong>mají a umí co předávat</strong>, je určen právě vám.","description":"<h2>Master the Basics of SQL with Our Expert-Led Course</h2>\n\n<p>Elevate your database skills with our comprehensive SQL course, designed for beginners and those looking to enhance their knowledge. Gain practical insights and hands-on experience in SQL commands essential for database management and data manipulation.</p>\n\n<ul>\n <li><strong>Target Audience:</strong> Beginners in data management, aspiring data analysts, and IT professionals.</li>\n <li><strong>Course Duration:</strong> 3 days.</li>\n <li><strong>Course Format:</strong> Online, with virtual participation options.</li>\n <li><strong>Certification:</strong> Yes, a certificate of completion will be awarded.</li>\n</ul>\n\n<h3>Detailed Course Description:</h3>\n\n<ul>\n <li><strong>Skills Gained:</strong> \n <ul>\n <li>Proficient use of SQL SELECT statements</li>\n <li>Understanding of data manipulation with DML commands</li>\n <li>Ability to perform complex queries using joins and subqueries</li>\n <li>Competence in handling date and numeric functions</li>\n <li>Expertise in managing user access and data dictionary views</li>\n </ul>\n </li>\n <li><strong>Course Outline:</strong>\n <ul>\n <li>Introduction to SQL Commands and SQL*Plus</li>\n <li>Searching Data with SQL SELECT</li>\n <li>Understanding CROSS JOIN</li>\n <li>Sorting Results with ORDER BY</li>\n <li>Using Aggregate Functions</li>\n <li>DATE and Numeric Functions Usage</li>\n <li>Implementing DISTINCT with Group Functions</li>\n <li>Creating and Managing Subqueries</li>\n <li>Using UNION to Consolidate Datasets</li>\n <li>Executing DML: INSERT, UPDATE, DELETE Commands</li>\n <li>Flashback Queries for Data Recovery</li>\n <li>Saving SQL Commands into Scripts</li>\n <li>Managing User Access Control</li>\n <li>Hierarchical Data Retrieval</li>\n <li>Using Regular Expressions</li>\n </ul>\n </li>\n <li><strong>Bonuses:</strong>\n <ul>\n <li>Access to additional learning materials and resources</li>\n <li>1-hour consultation with instructor Lukáš Luska</li>\n </ul>\n </li>\n</ul>\n\n<p>Don't miss out on the opportunity to master SQL! Enroll today and take the first step towards becoming a database professional.</p>","rating":0,"reviewCount":0,"reviews":[]}