Database Design with SQL Server Course

Program Overview

This five-week online course introduces the fundamentals of database design with SQL Server. It covers relational database theory, design principles, implementation, querying, and programming with T-SQL and Visual Studio. Ideal for beginners, it provides a solid foundation for careers in database administration, data analysis, and business intelligence.

Program Outline

Outline:

• Introduction to Relational Database Theory: This section introduces the fundamental concepts of relational database theory, including database models, data integrity, and normalization.
• Database Design: This section covers the principles of database design, including entity-relationship modelling, data dictionary creation, and index design.
• Implementing the Design: This section focuses on the practical aspects of implementing database designs using SQL Server Management Studio.
You will learn how to create, update, and delete databases and tables.
• Querying Data: This section focuses on learning SQL, the language used to interact with databases.
You will learn how to use the SELECT statement, filter data with WHERE clause, join tables, sort data, and aggregate data. You will also learn about boolean logic and advanced SQL concepts like nested queries, correlated queries, derived queries, and UNIONS.
• Introduction to programming SQL Server with T-SQL and the .NET Framework: This section introduces T-SQL, a programming language used to extend the functionality of SQL Server.
You will learn how to use T-SQL to control program flow, perform calculations, and interact with other systems.
• Introduction to Client programming with Visual Studio: This section introduces the basics of client-side programming with Visual Studio.
You will learn how to create simple applications that interact with SQL Server databases.

Assessment:

• Continuous assessment through weekly design and querying exercises.
• No formal accreditation.

Teaching:

• Led by an expert tutor with extensive experience in teaching database design with SQL.
• Accessible online classes.

Careers:

• Ideal for beginners looking to learn how databases work and generate and acquire data using MS SQL servers.
• Potential career paths include database administrator, data analyst, and business intelligence specialist.

Other:

• Five-week course taking place over five consecutive Saturdays.
• Offered online.
• Fee: £560 (unconfirmed).
• Certificate awarded upon completion of the course with over 70% attendance.
• The course schedule and start date are subject to confirmation.

Testimonials:

• "I would recommend the course to anyone who works with SQL Server on a regular basis.
I think it's easily the best classroom based SQL Database Course currently available in London due to its combination of Content, Duration and Price."
• Stephen Foy
• "The course was very well presented with engaging style that provided much in the way of real world examples to apply knowledge" - Danella Welds
• "This class was the perfect beginning to understanding and applying SQL database design and querying to my own work."
• Christopher Rentsch