SQL Database Development

The course covers the full SQL development workflow. You start with database fundamentals and relational theory, then move into Transact-SQL: filtering, sorting, subqueries and built-in functions. From there the course builds into database design, indexing, stored procedures, views and functions. Azure SQL and AI-assisted development are covered as dedicated sections.

• Write T-SQL queries to retrieve, filter and modify data in SQL Server
• Design multi-table architectures with schemas and transaction logs
• Work with indexes, views, stored procedures and In-Memory tables
• Set up and manage Azure SQL Database instances in the cloud
• Use AI tools and prompt engineering to write and refine SQL queries faster

The course concludes with practical skills you can demonstrate directly: real SQL Server work, Azure SQL setup, and AI-assisted query development. Something concrete to show in a job application.

ønsker at opnå IT-specialist viden mangler kompetencer indenfor SQL Database, for at lande drømmejobbet har erfaring med brug af PC Kurset er gratis for dig som ledig, såfremt du opfylder kravene for 6 ugers jobrettet uddannelse via dit jobcenter.

Database Core Conecpte

• Understand how relational databases are structured
• Work with queries, tables and data aggregation
• Build a solid foundation in database theory and design

Database Design and Architecture

• Design multi-table architectures and efficient schemas
• Understand transaction logs and data integrity
• Apply best practices in relational database design

Advanced SQL Techniques

• Create triggers, functions and stored procedures
• Tune database instances and handle complex data types
• Develop robust, production-ready SQL Server databases

Transact-SQL and Data Querying

• Write T-SQL queries against Microsoft SQL Server
• Filter, sort and modify data with precision
• Work with subqueries, predicates and built-in functions

SQL Development and Optimisation

• Work with indexes, views and programmability objects
• Implement In-Memory tables and optimise performance
• Query XML and spatial data in SQL Server

Azure SQL and AI-Assisted Development

• Set up and manage Azure SQL Database instances
• Use AI tools to write and refine SQL queries faster
• Work with prompt engineering for SQL problem-solving

Partner:
Nova Learning skaber adgang til de bedste ressourcer inden for læring: e-learning, mentorordning, eksamenssimulering og virtuelle labs. Alle e-learning kurser er tilpasset og målrettet mod certificeringer og/eller rettet mod jobs inden for de nyeste teknologier. Herunder Artificial Intelligence, Machine Learning & Data Science.

Kurset er på følgende positivlister:

• Hovedstaden
• Syddanmark