{"title":"Oracle database - SQL language","shortDescription":"Do you need to communicate with database specialists, better understand data-driven projects, and navigate the area of relational databases? <br><strong>Get to know SQL</strong>, gain the knowledge necessary to submit queries, create your own database objects. Our course led by experienced instructors who <strong>have and can share their knowledge</strong> is designed for you.","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":[]}