Microsoft SQL Server Development for Everyone

Microsoft SQL Server Development for Everyone

Instructor: Packt - Course Instructors

What you'll learn

Install and configure SQL Server on various operating systems
Create and modify databases using SQL Server tools and scripts
Write and optimize SQL queries with aggregation, filtering, and joins
Implement security measures, including user authentication and permissions

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 9 modules in this course

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.

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.

What's included

2 videos1 reading

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.

What's included

2 videos

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.

What's included

3 videos

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.

What's included

6 videos1 assignment

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.

What's included

15 videos

15 videosTotal 156 minutes

What Is a Database Table?4 minutesPreview module
Create Entity Data Model11 minutes
Create a Database Table Using Management Studio19 minutes
What Is SQL?2 minutes
Create a Database Table Using SQL Script9 minutes
Review Table Creation7 minutes
Insert Data into the Table Using Management Studio6 minutes
Insert Data into the Table Using SQL Scripts16 minutes
Select Data from Tables - Simple Queries10 minutes
Select Data from Tables - Adding Filtering16 minutes
Select Data from Tables - Exporting Data17 minutes
Update Data in Tables12 minutes
Delete Data from the Tables9 minutes
SQL Transactions6 minutes
Review CRUD Operations3 minutes

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.

What's included

9 videos

9 videosTotal 100 minutes

What Are Relationships, Foreign Keys, and Normalization?9 minutesPreview module
Normalizing Our Database11 minutes
Creating a Relationship in SQL Server17 minutes
Inserting Records in One-to-Many Related Tables14 minutes
Inserting Records in Many-to-Many Related Tables8 minutes
Using Inner Joins to Read Related Data20 minutes
Understanding Left, Right, and Full Joins9 minutes
Foreign Key Cascade Options7 minutes
Section Review2 minutes

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.

What's included

6 videos1 assignment

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.

What's included

9 videos

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.