Master the power of Microsoft SQL Server and T-SQL in this comprehensive bootcamp. You'll start with the fundamentals of SQL and relational databases, learning key concepts such as database setup, environment configuration, and the significance of SQL in data management. By the end of the introductory modules, you’ll have a strong grasp of SQL’s role in modern data-driven applications.



The Ultimate T-SQL And Microsoft SQL Server Bootcamp

Instructeur : Packt - Course Instructors
Inclus avec
Expérience recommandée
Ce que vous apprendrez
Master SQL queries for retrieving, filtering, and manipulating data efficiently
Understand database design principles and enforce data integrity with constraints
Develop and manage stored procedures, triggers, and user-defined functions in T-SQL
Handle transactions, locking mechanisms, and concurrency control in SQL Server
Compétences que vous acquerrez
- Catégorie : Database Design
- Catégorie : Data Manipulation
- Catégorie : Stored Procedure
- Catégorie : Transact-SQL
- Catégorie : Relational Databases
- Catégorie : Transaction Processing
- Catégorie : Microsoft SQL Servers
- Catégorie : Database Management
- Catégorie : Databases
- Catégorie : SQL
- Catégorie : Database Administration
- Catégorie : Query Languages
- Catégorie : Database Architecture and Administration
- Catégorie : Data Integrity
Détails à connaître

Ajouter à votre profil LinkedIn
avril 2025
13 devoirs
Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

Il y a 14 modules dans ce cours
In this module, we will meet our instructor and gain insights into their experience with SQL Server and T-SQL. We will explore the main goals of the course, setting expectations for what we will achieve throughout our learning journey.
Inclus
1 vidéo1 lecture
In this module, we will address fundamental questions about SQL and Microsoft SQL Server. We will explore why learning SQL is crucial for database management and career growth, along with examining alternative database technologies to provide a broader understanding of the field.
Inclus
4 vidéos1 devoir
In this module, we will go through the step-by-step process of setting up our SQL Server environment. Whether using Windows, Mac, or Linux, we will install SQL Server and the necessary management tools to ensure we are ready to start working with databases efficiently.
Inclus
4 vidéos1 devoir
In this module, we will focus on setting up a working database using Adventure Works. We will gain hands-on experience in creating, configuring, and understanding the database structure to build a strong foundation for data management and querying.
Inclus
3 vidéos1 devoir
In this module, we will explore Data Definition Language (DDL) commands that define the structure of a database. We will learn how to create, modify, and delete tables, enforce constraints, and ensure our database schema remains optimized and efficient.
Inclus
7 vidéos1 devoir
In this module, we will focus on retrieving data using SQL queries. We will learn how to filter, sort, and manipulate data efficiently while exploring advanced querying techniques such as JOINs, UNIONs, and aggregation to extract meaningful insights.
Inclus
13 vidéos1 devoir
In this module, we will build on our querying skills by exploring subqueries, CTEs, and window functions. We will also learn how to handle NULL values and refine our SQL queries to improve performance and readability.
Inclus
7 vidéos1 devoir
In this module, we will focus on inserting data into tables using different methods. We will explore full and partial inserts, work with related data, and use the SELECT INTO statement to streamline data insertion processes.
Inclus
5 vidéos1 devoir
In this module, we will learn how to update and delete records in a database while maintaining data integrity. We will explore best practices for modifying data, preventing accidental deletions, and handling cascading relationships.
Inclus
4 vidéos1 devoir
In this module, we will explore the creation of views and functions to enhance database management. We will learn to simplify queries using views and create reusable functions to improve efficiency in data manipulation and reporting.
Inclus
5 vidéos1 devoir
In this module, we will introduce control-of-flow statements that allow us to add logic to our SQL scripts. We will explore how to use loops, conditional statements, and branching techniques to make our queries more dynamic and efficient.
Inclus
5 vidéos1 devoir
In this module, we will explore the creation of advanced T-SQL routines such as stored procedures, triggers, and cursors. We will learn how to automate tasks, improve performance, and handle complex database operations efficiently.
Inclus
4 vidéos1 devoir
In this module, we will focus on managing database transactions to ensure data consistency and reliability. We will explore different transaction types, learn about locking mechanisms, and simulate concurrency scenarios to optimize performance.
Inclus
5 vidéos1 devoir
In this module, we will summarize our learning journey and review the key concepts covered in the course. We will discuss best practices for ongoing development and explore how to apply our SQL knowledge in professional environments.
Inclus
1 vidéo1 devoir
Obtenez un certificat professionnel
Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.
Instructeur

Offert par
En savoir plus sur Data Management
Coursera Instructor Network
Coursera Project Network
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?





Ouvrez de nouvelles portes avec Coursera Plus
Accès illimité à 10,000+ cours de niveau international, projets pratiques et programmes de certification prêts à l'emploi - tous inclus dans votre abonnement.
Faites progresser votre carrière avec un diplôme en ligne
Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne
Rejoignez plus de 3 400 entreprises mondiales qui ont choisi Coursera pour les affaires
Améliorez les compétences de vos employés pour exceller dans l’économie numérique
Foire Aux Questions
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.
Plus de questions
Aide financière disponible,