Complete Microsoft SQL Server Database Design Masterclass
What you’ll learn
Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
Using Microsoft SQL Management Studio
SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
DELETE: How to remove data from a database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Filter groups of data using the HAVING clause
Overall Database Development Best Practices
Creating Relationships and Foreign Keys
How to query related data from multiple tables
Using Aggregate Functions in SQL
How to export Query Results to Excel
How to craft SQL statements based on real scenarios
Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
Backup and Restore Databases
Generate Database Scripts for Automation
How to manage database users and security
Requirements
A Computer
A desire to learn database development
Description
OverviewMicrosoft SQL Server is a powerful and widely-used database management system used by organizations of all sizes to store and retrieve data. This course teaches you how to use Microsoft SQL Server to design, implement, and maintain a database. You will learn key concepts such as database design, query writing, and stored procedure creation. You will have the opportunity to practice your skills through hands-on exercises and projects.This is a zero-to-hero course on Microsoft SQL Database development and querying techniques. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Database Administrator. There are no prerequisites for this course. By the end of this course, you will have a strong understanding of how to use Microsoft SQL Server to manage and manipulate data and will be able to use it effectively in your projects. Whether you are new to database management or have some experience, this course is designed to provide a comprehensive overview of Microsoft SQL Server and help you become proficient in its use.What you’ll learnHow to Install SQL Server and SQL Server Management Studio (Windows or Docker for Mac and Linux)How to Connect to a Database Instance and create Databases and TablesHow to Use SQL Management Studio (SSMS)How to use Azure Data StudioHow to Author queries to Create, Read, Update and Delete data in tables. How to develop entity relationship diagrams using visual design toolsHow to normalize a database and create relationships and foreign keys How to Use Aggregate Functions to do quick mathematical operationsHow to export data to Excel using the Management StudioHow to create and manage Database ViewsHow to create and manage Functions, Table Triggers, and Stored ProceduresHow to Backup and Restore DatabasesHow to manage users and database securityWhy Learn Microsoft SQL ServerMicrosoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.We will explore best practices in database development using SQL Server and will be building a small school management system database. All you need is a capable machine, and we will walk through setting up an environment, creating a database, creating your first table, and writing queries. At the end of this course, you should be comfortable writing queries for multiple situations and reports. Are there any course requirements or prerequisites?A Windows PC (or Docker if using Linux/Mac) Who this course is for:This course is for beginners with absolutely no experience.This course is for you if you are already comfortable with fundamental database operations. This course is for you if you feel a bit ‘rusty’ and need to refresh your knowledge.This course is for you if you want to understand design principles in database development.This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System.This course is for EVERYONE!Content and OverviewThis is a complete course. I take you through various scenarios and techniques to write queries, build a database and further administrate, then we touch on more advanced topics that are in great demand in the workplace. Over 6 hours of premium content, all put together to ensure that; then get up and running with becoming e Developer and Administrator. By the time you finish the course, you will have moved around in Microsoft SQL Manager Studio so much that it will become second nature for you when interacting with your databases on different servers. This will put your newly learned skills into practical use and impress your boss and coworkers.The course has working files and scripts, making it easy to replicate the demonstrated code. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.Clicking the Take This Course button could be the best step to increase your income and marketability quickly! Also, remember that if you think the course is not worth what you spent, you have a full 30 days to get a no questions asked refund!It’s time to take action!See you in the course!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Understanding Types of Data and Storage
Section 2: Environment Setup
Lecture 3 Download and Install SQL Server Express (Windows)
Lecture 4 Install SQL Server on Mac and Linux
Section 3: Understanding The Toolset
Lecture 5 Explore SQL Server Management Studio
Lecture 6 Explore Azure Data Studio
Lecture 7 Explore Draw.io
Section 4: Creating And Manipulating Databases
Lecture 8 Section Overview
Lecture 9 Create Database using Management Studio
Lecture 10 Create a Database using SQL Script
Lecture 11 How to Remove a Database
Lecture 12 How To Change Database Name
Lecture 13 Section Review
Section 5: Managing Tables and Data
Lecture 14 What is a Database Table?
Lecture 15 Create Entity Data Model
Lecture 16 Create a Database Table using Management Studio
Lecture 17 What is SQL?
Lecture 18 Create a Database Table using SQL Script
Lecture 19 Review Table Creation
Lecture 20 Insert Data into the Table using Management Studio
Lecture 21 Insert Data into the Table using SQL Scripts
Lecture 22 Select Data from Tables – Simple Queries
Lecture 23 Select Data from Tables – Adding Filtering
Lecture 24 Select Data from Tables – Exporting Data
Lecture 25 Update Data in Tables
Lecture 26 Delete Data from the Tables
Lecture 27 SQL Transactions
Lecture 28 Review CRUD Operations
Section 6: Normalization, Relationships and Foreign Keys
Lecture 29 What are Relationships, Foreign Keys and Normalization
Lecture 30 Normalizing Our Database
Lecture 31 Creating a Relationship in SQL Server
Lecture 32 Inserting Records in One To Many Related Tables
Lecture 33 Inserting Records in Many To Many Related Tables
Lecture 34 Using Inner Joins To Read Related Data
Lecture 35 Understanding Left, Right and Full Joins
Lecture 36 Foreign Key Cascade Options
Lecture 37 Review
Section 7: Group By and Aggregate Functions
Lecture 38 Grouping Data using SQL GROUP BY Clause
Lecture 39 SQL COUNT Aggregate Function
Lecture 40 SQL AVG (Average) Aggregate Function
Lecture 41 SQL MAX and MIN Aggregate Functions
Lecture 42 SQL SUM Aggregate Function
Lecture 43 Filtering on Aggregate Values
Lecture 44 Aggregate Function Scripts
Section 8: Advanced SQL Server Objects and Concepts
Lecture 45 Section Overview
Lecture 46 Create and Manage Views
Lecture 47 Scalar Valued Functions
Lecture 48 Inline Table Valued Functions
Lecture 49 Multi Statement Table Valued Functions
Lecture 50 Stored Procedures
Lecture 51 Table Triggers
Lecture 52 Generating Database Scripts
Lecture 53 Database Backup and Restore
Section 9: SQL Server Security
Lecture 54 Section Overview
Lecture 55 Create an SQL User Login
Lecture 56 Add Windows Authenticated Login
Lecture 57 Add Server Logins With Script
Section 10: BONUS Lecture
Lecture 58 Bonus Lecture
Beginner Database Developer,Intermediate Database Developers,Potential Database Administrators,Everyone!
Course Information:
Udemy | English | 8h 20m | 3.12 GB
Created by: Trevoir Williams
You Can See More Courses in the Developer >> Greetings from CourseDown.com