Database Design with SQL Server Course
City of London , United Kingdom
Tuition Fee
GBP 560
Per course
Start Date
Medium of studying
Fully Online
Duration
1 months
Program Facts
Program Details
Degree
Courses
Major
Database Architecture | Database Management | Database Administrator Studies
Area of study
Information and Communication Technologies
Education type
Fully Online
Timing
Full time
Course Language
English
Tuition Fee
Average International Tuition Fee
GBP 560
About Program
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
SHOW MORE
About University
City University of London
Overview:
City, University of London is a public research university located in London, England. It is known for its focus on business, practice, and the professions, offering a wide range of undergraduate and postgraduate programs. The university is renowned for its strong academic reputation and its commitment to providing students with a high-quality learning experience.
Services Offered:
City University of London provides a comprehensive range of services to its students, including:
Library Services:
Access to extensive library resources, including books, journals, databases, and online resources.Moodle:
An online learning platform for accessing course materials, submitting assignments, and communicating with instructors.Email:
A university-provided email account for official communication.Staff Directory:
A searchable directory of staff members and their contact information.Term Dates:
Information on the academic year and term dates.Room Booking:
A system for booking rooms on campus for meetings, events, and other purposes.Schools and Departments:
Information on the various schools and departments within the university.Student Life and Campus Experience:
City University of London offers a vibrant and diverse student experience, with a strong emphasis on:
London Experience:
The university's location in London provides students with access to a wide range of cultural, social, and professional opportunities.Sports:
A variety of sports clubs and facilities are available for students to participate in, both competitively and non-competitively.Social Activities and Groups:
Numerous student societies and groups cater to diverse interests, providing opportunities for social interaction and personal development.Student Wellbeing:
The university offers a range of support services to ensure students' health and wellbeing, including learning support, personal tutoring, and counseling.Career Development:
The university provides career guidance and support services to help students prepare for their future careers.Key Reasons to Study There:
Strong Academic Reputation:
City University of London is consistently ranked highly in national and international rankings.Focus on Business, Practice, and the Professions:
The university's programs are designed to provide students with the skills and knowledge they need to succeed in their chosen careers.Location in London:
The university's location in the heart of London provides students with access to a wealth of opportunities.Vibrant Student Life:
City University of London offers a diverse and engaging student experience.Excellent Career Support:
The university provides comprehensive career guidance and support services.Academic Programs:
City University of London offers a wide range of academic programs across various disciplines, including:
Business and Management:
Bayes Business School is renowned for its programs in finance, accounting, marketing, and entrepreneurship.Law:
The City Law School is a leading institution for legal education, offering programs in law, international law, and legal practice.Health and Psychological Sciences:
The School of Health & Psychological Sciences offers programs in nursing, midwifery, psychology, and other health-related fields.Science and Technology:
The School of Science & Technology offers programs in computer science, engineering, mathematics, and other STEM fields.Communication and Creativity:
The School of Communication & Creativity offers programs in journalism, media, performing arts, and language studies.Other:
Merger with St George's:
City University of London has merged with St George's, University of London, forming a new institution called City St George's, University of London.Awards and Accreditations:
The university has received numerous awards and accreditations for its teaching, research, and commitment to equality and diversity.Global City:
City University of London is a global institution with a strong international presence.University of London:
City University of London is a member of the University of London, a federation of 18 independent colleges and institutes.Total programs
427
Location
Ambassadors
Gallery
