{"course":{"productid":21410,"modality":1,"active":true,"language":"en","title":"SQL Server for .NET Application Developers","productcode":"SQL04","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-SQL04","courseware":{"has_ekit":false,"has_printkit":true,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/training-sql04","objective":"<p>You know the basics of the various Windows databases and learn how to develop stable, secure applications in SQL Server 2019.<\/p>","essentials":"<p>Programming knowledge<\/p>","audience":"<p>Application developers, .NET specialists and software developers<\/p>","contents":"<h5>Basics<\/h5><ul>\n<li>Repetition of the database basics<\/li><li>Various database types and products<\/li><li>Database design<\/li><li>Software Architecture<\/li><li>NoSQL databases<\/li><\/ul><h5>SQL<\/h5><ul>\n<li>Repetition interrogation techniques<\/li><li>Stored Procedures in TSQL und C#<\/li><li>SQL Server as .NET runtime environment<\/li><\/ul><h5>Database access techniques<\/h5><ul>\n<li>Transactions<\/li><li>Entity Framework<\/li><li>Other OR\/Mapper<\/li><\/ul><h5>Tooling<\/h5><ul>\n<li>SQL Server Management Studio<\/li><li>Visual Studio \/ Data Tools<\/li><li>tips and tricks<\/li><li>ALM in applications (FTS)<\/li><\/ul><h5>Database<\/h5><ul>\n<li>The main administrative points<\/li><li>DB interfaces (views, stored procedures, ...)<\/li><li>Data quality<\/li><li>Monitoring<\/li><li>Operation<\/li><\/ul><h5>Performance und Security<\/h5><ul>\n<li>Performance measurements\/analysis<\/li><\/ul><h5>Performance improvements<\/h5><ul>\n<li>Indexe<\/li><li>Administratives<\/li><li>Query optimizations<\/li><li>Infrastructure Aspects<\/li><li>In-memory techniques<\/li><\/ul><h5>Brief introduction of new techniques in SQL Server 2019<\/h5><ul>\n<li>Big Data<\/li><li>Data Science<\/li><li>AI<\/li><\/ul>","summary":"<p>Become a full stack developer. This course teaches you the essential basics and skills that will help you as a .NET developer to build more stable, faster, and secure solutions using SQL Server.<\/p>","objective_plain":"You know the basics of the various Windows databases and learn how to develop stable, secure applications in SQL Server 2019.","essentials_plain":"Programming knowledge","audience_plain":"Application developers, .NET specialists and software developers","contents_plain":"Basics\n\n\n- Repetition of the database basics\n- Various database types and products\n- Database design\n- Software Architecture\n- NoSQL databases\nSQL\n\n\n- Repetition interrogation techniques\n- Stored Procedures in TSQL und C#\n- SQL Server as .NET runtime environment\nDatabase access techniques\n\n\n- Transactions\n- Entity Framework\n- Other OR\/Mapper\nTooling\n\n\n- SQL Server Management Studio\n- Visual Studio \/ Data Tools\n- tips and tricks\n- ALM in applications (FTS)\nDatabase\n\n\n- The main administrative points\n- DB interfaces (views, stored procedures, ...)\n- Data quality\n- Monitoring\n- Operation\nPerformance und Security\n\n\n- Performance measurements\/analysis\nPerformance improvements\n\n\n- Indexe\n- Administratives\n- Query optimizations\n- Infrastructure Aspects\n- In-memory techniques\nBrief introduction of new techniques in SQL Server 2019\n\n\n- Big Data\n- Data Science\n- AI","summary_plain":"Become a full stack developer. This course teaches you the essential basics and skills that will help you as a .NET developer to build more stable, faster, and secure solutions using SQL Server.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":3,"formatted":"3 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":2390},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":2390},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":2390},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":2095},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":8290},"US":{"country":"US","currency":"USD","taxrate":null,"price":2600},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2610},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":3590}}},"lastchanged":"2025-10-20T09:26:48+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/21410","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/training-sql04"}}