Database design for beginners : Microsoft SQL Server | SSMS

A One Week Comprehensive Introduction to SQL and Microsoft SQL Server Management Studio!

Created by: Curtis Norman
Healthcare Finance and Analytics Consultant

What Will I Learn?

• Master the basics of Microsoft SQL Server Management Studio.
• Understand the basics to SQL - SELECT, INTO, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
• Learn how to INSERT, UPDATE and DELETE data.
• Retrieve and filter data using conditions, sorting, and grouping techniques.
• Learn to join multiple tables and understand relationships between data.
• Create and manage databases, tables, and views in Microsoft SQL Server Management Studio (SSMS).
• The fundamentals of database design and how to ensure efficient data management.
• Hands-on practice with real-world exercises to reinforce SQL skills and build confidence.
• Become a data expert and add SQL to your resume. Gain applicable experience that will elevate your career!

Requirements

• No prior knowledge of SQL or databases is required—this course is designed for beginners.
• A desire to learn and dedicate one hour a day for seven days to master the basics of SQL.
• Basic computer literacy, including familiarity with using files and software applications.
• A Windows-based computer to install and use Microsoft SQL Server Management Studio (SSMS).

Target audience

• Beginners who have no prior experience with SQL or databases but want to learn.
• Students and recent graduates seeking a foundational understanding of SQL to boost their career prospects.
• Career switchers interested in exploring opportunities in data analytics, business intelligence, or database administration.
• Anyone with a busy schedule who wants to learn SQL quickly and efficiently, with just one hour a day.