Overview

Class Central Tips

This course offers a deep dive into SQL Server, starting with an introduction to the basics of databases and data types. You'll be guided through setting up SQL Server on various platforms, including Windows, Mac, and Linux, ensuring a smooth start to your learning journey. By exploring SQL Server Management Studio and Azure Data Studio, you’ll gain familiarity with the essential tools for database management. Next, the course covers foundational skills such as creating, manipulating, and removing databases using both graphical tools and SQL scripts. You’ll also delve into key concepts like normalization, foreign keys, and table relationships to ensure your databases are optimized and efficient. Moreover, you’ll learn about CRUD operations, transactions, and SQL query techniques like filtering, aggregation, and joining tables to handle large datasets and complex queries effectively. Finally, the course transitions into more advanced topics, including views, functions, and stored procedures. You’ll also learn how to implement security measures such as user logins and authentication, rounding off your knowledge with crucial skills for real-world database management. By the end, you’ll have a solid foundation in SQL Server and be equipped with the tools to manage databases confidently. This course is designed for database administrators, software developers, and IT professionals looking to enhance their SQL Server skills. Prior knowledge of basic databases is helpful but not required.

Syllabus

Introduction

In this module, we will introduce you to the world of SQL Server and databases. You'll gain an understanding of how data is stored, categorized, and managed, providing you with the basic tools needed to navigate SQL databases.

Environment Setup

In this module, we will walk through the installation process of SQL Server Express on Windows, Mac, and Linux platforms. By the end, you'll have your environment set up and ready for development.

Understanding the Toolset

In this module, we will explore key tools used to interact with SQL Server, including SQL Server Management Studio and Azure Data Studio. You'll also learn how to visualize your database structures using Draw.io.

Creating and Manipulating Databases

In this module, we will guide you through creating, modifying, and removing databases. You’ll use different methods to manage databases efficiently, helping you get hands-on experience with SQL Server.

Managing Tables and Data

In this module, we will cover everything from creating tables to manipulating data using SQL. You’ll also learn about the core operations: CRUD (Create, Read, Update, Delete) and practice querying data using SQL scripts.

Normalization, Relationships, and Foreign Keys

In this module, we will delve into normalization techniques and relationships within a SQL Server database. You'll learn how to efficiently structure data and manage relationships between tables, enhancing database integrity.

GROUP BY and Aggregate Functions

In this module, we will focus on grouping data and using aggregate functions to perform calculations. You'll explore how to apply these functions in your queries for meaningful data summaries.

Advanced SQL Server Objects and Concepts

In this module, we will explore advanced SQL Server objects, including functions, triggers, and stored procedures. You will also learn how to generate scripts for database management, backups, and restoration.

SQL Server Security

In this module, we will focus on securing your SQL Server environment. You'll learn how to create user logins, add Windows-authenticated logins, and manage access to your server using secure methods.