{"course":{"productid":21394,"modality":1,"active":true,"language":"fr","title":"SQL Standard Intensive Training","productcode":"SQL02","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-SQL02","courseware":{"has_ekit":false,"has_printkit":true,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/training-sql02","objective":"<p>After this training you will be able to query and modify all common relational databases with the standard tools.<\/p>","essentials":"<p>General practical experience with computers, pleasure in analytical thinking as well as abstraction and imagination. Basic knowledge of relational databases is advantageous<\/p>","audience":"<p>Developers, analysts, businessmen and other interested persons who want to work with an SQL-capable database or create applications using the SQL possibilities of the database system. People who want to get well-founded information about SQL, its possibilities, limitations and meaning.<\/p>","contents":"<h5>1. basic terms of relational databases<\/h5><ul>\n<li>Database<\/li><li>Table (entities, attributes)<\/li><li>Data types (value ranges)<\/li><li>primary, foreign key<\/li><li>Relations<\/li><li>Data consistency, referential integrity<\/li><li>View<\/li><li>Index<\/li><\/ul><h5>2. basics about SQL<\/h5><ul>\n<li>History<\/li><li>Application (basic concept)<\/li><li>SQL Properties<\/li><li>SQL Syntaxdiagram<\/li><li>Naming conventions for objects<\/li><\/ul><h5>3. data retrieval, data evaluation and manipulation (DML)<\/h5><ul>\n<li>SELECT<\/li><li>Simple queries<\/li><li>Constant columns, calculated columns, aliases<\/li><li>DISTINCT<\/li><li>ORDER BY<\/li><li>TOP<\/li><li>WHERE<\/li><li>Aggregate functions<\/li><li>GROUP BY \/ HAVING<\/li><li>JOIN (INNER, OUTER, FULL, Self, Cross)<\/li><li>Subqueries<\/li><li>UNION<\/li><li>SELECT INTO<\/li><\/ul><h5>4. add data<\/h5><ul>\n<li>INSERT (VALUES, SELECT)<\/li><li>UPDATE<\/li><li>DELETE<\/li><\/ul><h5>5. data definition language (DDL)<\/h5><ul>\n<li>CREATE DATABASE<\/li><li>CREATE TABLE<\/li><li>Constraints (PRIMARY- , FOREIGN KEY, UNIQUE )<\/li><li>DROP TABLE<\/li><li>CREATE VIEW<\/li><li>ALTER VIEW<\/li><li>DROP VIEW<\/li><li>CREATE PROCEDURE<\/li><\/ul><h5>6. data control language (DCL)<\/h5><ul>\n<li>Transaction Management<\/li><li>COMMIT &amp; ROLLBACK<\/li><li>GRANT &amp; REVOKE<\/li><\/ul>","summary":"<p>In this training you will learn everything you need to know and be able to query your database on the basis of standard SQL-3.<\/p>","objective_plain":"After this training you will be able to query and modify all common relational databases with the standard tools.","essentials_plain":"General practical experience with computers, pleasure in analytical thinking as well as abstraction and imagination. Basic knowledge of relational databases is advantageous","audience_plain":"Developers, analysts, businessmen and other interested persons who want to work with an SQL-capable database or create applications using the SQL possibilities of the database system. People who want to get well-founded information about SQL, its possibilities, limitations and meaning.","contents_plain":"1. basic terms of relational databases\n\n\n- Database\n- Table (entities, attributes)\n- Data types (value ranges)\n- primary, foreign key\n- Relations\n- Data consistency, referential integrity\n- View\n- Index\n2. basics about SQL\n\n\n- History\n- Application (basic concept)\n- SQL Properties\n- SQL Syntaxdiagram\n- Naming conventions for objects\n3. data retrieval, data evaluation and manipulation (DML)\n\n\n- SELECT\n- Simple queries\n- Constant columns, calculated columns, aliases\n- DISTINCT\n- ORDER BY\n- TOP\n- WHERE\n- Aggregate functions\n- GROUP BY \/ HAVING\n- JOIN (INNER, OUTER, FULL, Self, Cross)\n- Subqueries\n- UNION\n- SELECT INTO\n4. add data\n\n\n- INSERT (VALUES, SELECT)\n- UPDATE\n- DELETE\n5. data definition language (DDL)\n\n\n- CREATE DATABASE\n- CREATE TABLE\n- Constraints (PRIMARY- , FOREIGN KEY, UNIQUE )\n- DROP TABLE\n- CREATE VIEW\n- ALTER VIEW\n- DROP VIEW\n- CREATE PROCEDURE\n6. data control language (DCL)\n\n\n- Transaction Management\n- COMMIT & ROLLBACK\n- GRANT & REVOKE","summary_plain":"In this training you will learn everything you need to know and be able to query your database on the basis of standard SQL-3.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 jours"},"pricelist":{"List Price":{"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":1000},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1590},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1590},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1590},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":1360},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":5520},"US":{"country":"US","currency":"USD","taxrate":null,"price":1730},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1920},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":2390}}},"lastchanged":"2025-10-20T09:26:48+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/21394","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/training-sql02"}}