Microsoft SQL Server

Microsoft via Coursera Professional Certificate

Go to class Write review

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

Build skills for in-demand data roles with the Microsoft SQL Server Professional Certificate. This comprehensive program equips you with essential skills for database administration, data analysis, and business intelligence positions, which are among the most sought-after technical jobs. Starting with SQL query fundamentals and advancing to sophisticated database management, you’ll gain hands-on experience with Microsoft SQL Server, a leading database platform. Across five courses, you'll learn to write efficient SQL queries, design databases, implement security measures, optimize performance, and integrate business intelligence tools. This program is unique with its practical approach and cutting-edge AI integration. You’ll leverage generative AI for query optimization and development, working on real-world projects that simulate workplace scenarios. Each course concludes with a comprehensive project to build your SQL Server skills portfolio. Database skills are foundational in many industries, with SQL consistently ranking as a valuable technical competency for data professionals. No prior experience with databases or SQL is required. If you are detail-oriented, enjoy solving data-related problems, and wish to develop enduring technical skills, this program will provide you with the foundation needed for a successful data career.

Syllabus

Course 1: SQL Foundations
Course 2: Data Manipulation and Transactions in SQL Server
Course 3: Relational Database Design and Advanced Querying
Course 4: Indexing, Performance Optimization & Functions in SQL Server
Course 5: Security, Maintenance & Integration with BI Tools

Courses

0 reviews
15 hours 25 minutes
View details

Build on your foundational SQL knowledge by learning data manipulation techniques in SQL Server. This course focuses on using INSERT, UPDATE, and DELETE statements to modify database contents while maintaining data integrity through proper transaction management. You'll learn to implement transaction control mechanisms, understand isolation levels, and prevent common concurrency issues. Through practical examples, you'll implement error handling strategies and explore the principles of ACID compliance essential for reliable database operations. The course also demonstrates how generative AI can help optimize complex SQL operations and troubleshoot transaction issues. By the end, you'll confidently perform data modifications while ensuring database consistency—crucial skills for any database professional.
0 reviews
19 hours 17 minutes
View details

Learn the techniques that make SQL Server databases perform at their best. This course focuses on database performance tuning through proper indexing strategies, query optimization techniques, and execution plan analysis. You'll learn to identify bottlenecks using SQL Server's performance tools, implement appropriate index types, and rewrite inefficient queries. The course also covers stored procedures, user-defined functions, and views for encapsulating complex logic and improving maintainability. Through hands-on exercises, you'll analyze real-world performance scenarios and implement solutions that dramatically improve query response times. The integration of AI-assisted optimization techniques shows how modern tools can complement traditional performance tuning methods. By course completion, you'll be able to transform slow-running queries into high-performance database operations.
0 reviews
19 hours 41 minutes
View details

Develop expertise in relational database design principles and implementation using SQL Server. This course teaches normalization techniques, entity-relationship modeling, and schema optimization to create efficient database structures. You'll use DDL (Data Definition Language) statements to build and modify database objects while enforcing data integrity through constraints. The advanced querying section covers complex joins, subqueries, CTEs, and aggregate functions that enable sophisticated data analysis. You'll also explore data warehousing concepts and learn to leverage GenAI to assist with complex query development from natural language descriptions. By the end of this course, you'll be able to design normalized databases from scratch and write advanced queries that extract meaningful insights from complex data structures.
0 reviews
21 hours 32 minutes
View details

Learn the fundamentals of SQL with Microsoft SQL Server in this introductory course. You'll learn to write basic and intermediate queries to extract and analyze data while understanding relational database concepts. Through hands-on exercises with SQL Server Management Studio, you'll practice filtering data with WHERE clauses, sorting results with ORDER BY, and transforming data with built-in functions. This course also introduces you to database schemas, tables, and views, providing a foundation for understanding data structure. Additionally, you'll explore how generative AI tools can assist with SQL query development, reflecting modern workplace practices. By completing this course, you'll build confidence writing T-SQL queries and be prepared for more advanced data manipulation techniques.
0 reviews
13 hours 3 minutes
View details

Develop essential database administration skills focusing on security, maintenance, and business integration. This final course teaches you to implement SQL Server security through authentication, authorization, and data encryption while ensuring data integrity through validation constraints and auditing. You'll learn critical maintenance tasks including backups, recovery, and index maintenance to ensure database reliability and performance. The course also covers integrating SQL Server with Power BI for creating interactive dashboards and reports that transform raw data into actionable insights. Additionally, you'll explore modern application integration patterns and API connectivity. By completing this course, you'll possess the comprehensive skill set needed to securely manage database environments and bridge the gap between data storage and business intelligence.