SQL Server Fundamentals – SQL Database for Beginners

Master SQL Server Databases: Your Beginner's Guide to SQL Server on Windows and Linux Platforms

Created by: Artemakis Artemiou
Award-Winning Database & AI Expert, Trainer, Author, Speaker

What Will I Learn?

• What is SQL Server and what you can do with it.
• How to download, install and get started with SQL Server on both Windows and Linux.
• How to create databases, tables, views, functions, stored procedures and run queries.
• How to import/export data in SQL Server.
• Available editions of SQL Server. What is free and what is not.
• Basic SQL Server security concepts such as: logins, database users, surface area configuration and more.
• How to use SQL Server Management Studio for connecting to SQL Server and working with it.
• How to use Azure Data Studio on both Windows and Linux.

Requirements

• No prior knowledge of SQL Server is required.
• It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.

Target audience

• IT Professionals that just started using SQL Server, either for development or administration.
• IT Professionals that want to enhance their technical skills and knowledge and enrich their resume.
• Learners that want to start using SQL Server and need guidance to learn the basics.
• Technology enthusiasts that want to explore new technology topics!
• Programmers curious about databases and SQL Server