The Complete Beginners Guide. DBMS with Microsoft SQL Server
The Complete Beginners Guide. DBMS with Microsoft SQL Server, available at $69.99, has an average rating of 4.39, with 61 lectures, based on 9 reviews, and has 1031 subscribers.
You will learn about Learn Microsoft SQL Server Database Management SQL commands and SQL Server Management Studio UI Start from the basic to advanced of MSSQL database Combining both SQL commands and MSSQL UI This course is ideal for individuals who are Beginner who wants to learn the basics and advanced level of MSSQL Database It is particularly useful for Beginner who wants to learn the basics and advanced level of MSSQL Database.
Enroll now: The Complete Beginners Guide. DBMS with Microsoft SQL Server
Summary
Title: The Complete Beginners Guide. DBMS with Microsoft SQL Server
Price: $69.99
Average Rating: 4.39
Number of Lectures: 61
Number of Published Lectures: 61
Number of Curriculum Items: 61
Number of Published Curriculum Objects: 61
Original Price: $109.99
Quality Status: approved
Status: Live
What You Will Learn
- Learn Microsoft SQL Server Database Management
- SQL commands and SQL Server Management Studio UI
- Start from the basic to advanced of MSSQL database
- Combining both SQL commands and MSSQL UI
Who Should Attend
- Beginner who wants to learn the basics and advanced level of MSSQL Database
Target Audiences
- Beginner who wants to learn the basics and advanced level of MSSQL Database
Hello and welcome to my new course ‘The Complete Dummies Guide to Microsoft SQL Server’.
You already know that in this information technology age ‘data’ is everything. And a Database is the place where this information is stored in tables. There are two types of database. A structured database and also there is an unstructured or no-sql kind of database. We will see the SQL or the Structured Query kind of database. And the most popular one among the SQL databases is the Microsoft SQL Server.
Here is an overview about the sessions that are included in this course.
In the first session, we will have an introduction to databases. Then we will see the concepts of SQL or Structured Query Language which is used in RDBMS.
Then we will see different types of SQL commands. Then the database objects And in the next session, we will move on to the basics of MSSQL server. We will see how we can install the free version or the express edition of Microsoft SQL server into your computer and then we will download the Microsoft SQL Server Management Studio, which is a tool and an interface. And later we will connect SQL Server Management Studio with our MSSQL Server process that is running in the background.
And then we will proceed with the basic SQL database operation. We will create a database, we will list the database in the server, then we can select a database using the USE command and finally we will try demonstrating deleting a database using the DROP command. There is also an option to take a backup of the database.
And then we will move on with SQL basic table operations. We will have an overview of data types of SQL. Then we will have an overview of different SQL constraints and the difference between a primary key and foreign key. And finally we will start creating a table in our database. We will create it, we will try to delete it. We will try to alter it. And then we will move on to describing the table schema and inserting data into the table. Deleting data from the table, modifying data, then.. fetching the data all these basic table operations will be dealt with in this session.
And then we will go ahead and import a sample database. It’s a free sample database called the Northwind Traders database from Microsoft. We will download it and we will import that into our SQL server. Later we will proceed with basic aggregate functions of SQL. We will see what is an aggregate function and then we will proceed with each and every aggregate function.
And then we will proceed with the basic clauses of SQL. We will see what is a clause and different
clauses. The first, Distinct clause, Group-by, Where clause, then Order-by, Having clause, Select and Grouping-sets. We will also have different examples for each and every clause that we learn. Then we will proceed with the basic operators of SQL server. The basic operators include Comparison operators Union operator, Intersect, In operator, Not, Between, Is Null, Not Null. Then we have the Like, Exists operator. We will try different examples.
Then we will have an elaborate session with the SQL server data-types. The popular ones. Then we will have a detailed session regarding the constraints in SQL server. The constraints include Primary key, then Foreign key, Check then Unique then Default, Not Null constraints. The relationship between these tables and its columns are defined using a standard notation called the ER or Entity Relationship diagram. We will see what is an Entity, then we will see what is an Attribute and also what is the relationship in the ER diagram.
And then we will proceed with the popular string functions or string manipulation functions in SQL server. These functions we can use to process a string inside our SQL server. We will also have an overview about the popular SQL Date and Time functions which are used to manipulate date and time data inside SQL server. And then we will proceed with the popular SQL mathematical operations. And also examples to demonstrate all these functions and then we will proceed with the SQL conversion functions which are used to perform data conversion inside SQL. We will try examples for these functions.
And then we will move on to an important topic called SQL Joins. This join clause in SQL will enable us to connect between different tables which are linked by some common key. The popular ones are Inner join, Outer join, then Cross Join and Self Join We will see detailed examples, demonstrations for each of these joins and then we will proceed with Stored Procedures in SQL server. A block of re-usable SQL statements that are stored in the Server.
We will see an overview about the stored procedure. Then we will see how we can create a stored procedure. Then execute then how we modify, delete the stored procedure and also we will see how we can pass input parameters into. Return the processed parameters from the stored procedure.
And then we will see what is a sub-query inside SQL server. We will see an overview of sub-query. We will try different examples of how we can create a sub-query. And then we will proceed with Views in SQL server. We will see an overview about the views in SQL. Then, how we can create a view. We will try an example and how we can call the already created view. And then we will move on with SQL server triggers. Different types of SQL triggers. DDL trigger, the DML trigger, the two types of DML triggers. We will try them with examples.
And then we will see what is a transaction in SQL server. We will have two states of transactions. We will explain it with the help of a bank ATM scenario and we will try examples of committing a transaction. Rolling back the transaction, the SQL transaction in case of an error. And then we will proceed with normalization of the table which is used to keep everything in order inside the database. We will see what normalization is in DBMS. We will see different types of normalization. Then we will be proceeding with the backup and restore of the database. We will see how we can backup a database. Save that into our computer and then later we can use that backup to restore that database.
And in the final session, we will be discussing how we can secure a database. We will use an inbuilt tool to access the different security risks and the preventive measures that we can take. The steps that we can follow to fix those security risks and finally about the SQL injection technique which hackers use. We will see a few demonstrations how a hacker can include an SQL injection statement into our SQL server and get the data he wants.
And that’s all about the topics which are currently included in this quick course. The sample database and the materials have been uploaded and shared in a folder. I will include the link to download them in the last session or the resource section of this course. You are free to use that with no questions asked.
Also, after completing this course, you will be provided with a course completion certificate which will add value to your portfolio.
So that’s all for now. See you soon in my classroom.
Happy Learning !!
Course Curriculum
Chapter 1: Course Introduction and Table of Contents
Lecture 1: Course Introduction and Table of Contents
Chapter 2: Introduction to Database and Database Management Systems
Lecture 1: Introduction to Database and Database Management Systems
Chapter 3: Introduction to RDBMS and NonRDBMS
Lecture 1: Introduction to RDBMS and NonRDBMS
Chapter 4: Types of SQL Commands
Lecture 1: Types of SQL Commands
Chapter 5: Installing MSSQL
Lecture 1: Installing MSSQL
Chapter 6: Basic DB Operations
Lecture 1: Basic DB Operations – Part 1
Lecture 2: Basic DB Operations – Part 2
Chapter 7: Basic Table Operations
Lecture 1: Basic Table Operations – Part 1
Lecture 2: Basic Table Operations – Part 2
Lecture 3: Basic Table Operations – Part 3
Lecture 4: Basic Table Operations – Part 4
Chapter 8: Sample Databases Import
Lecture 1: Sample Databases Import
Chapter 9: Aggregate Functions in MSSQL
Lecture 1: Aggregate Functions in MSSQL – Part 1
Lecture 2: Aggregate Functions in MSSQL – Part 2
Chapter 10: Clauses in MSSQL
Lecture 1: Clauses in MSSQL – Part 1
Lecture 2: Clauses in MSSQL – Part 2
Lecture 3: Clauses in MSSQL – Part 3
Chapter 11: Grouping Sets Clause
Lecture 1: Grouping Sets Clause – Part 1
Lecture 2: Grouping Sets Clause – Part 2
Chapter 12: SQL Basic Operators
Lecture 1: SQL Basic Operators – Part 1
Lecture 2: SQL Basic Operators – Part 2
Chapter 13: Union and Intersect operators
Lecture 1: Union and Intersect operators
Chapter 14: Popular Datatypes Introduction
Lecture 1: Popular Datatypes Introduction – Part 1
Lecture 2: Popular Datatypes Introduction – Part 2
Chapter 15: Popular Datatypes Example
Lecture 1: Popular Datatypes Example
Chapter 16: Constraints – Primary Key
Lecture 1: Constraints – Primary Key – part 1
Lecture 2: Constraints – Primary Key – part 2
Chapter 17: Constraints – Foreign Key
Lecture 1: Constraints – Foreign Key – Part 1
Lecture 2: Constraints – Foreign Key – Part 2
Chapter 18: NOT NULL and UNIQUE constraints
Lecture 1: NOT NULL and UNIQUE constraints – Part 1
Lecture 2: NOT NULL and UNIQUE constraints – Part 2
Chapter 19: CHECK and DEFAULT constraints
Lecture 1: CHECK and DEFAULT constraints – Part 1
Lecture 2: CHECK and DEFAULT constraints – Part 2
Chapter 20: ER Diagram Overview
Lecture 1: ER Diagram Overview
Chapter 21: SQL Popular String Functions
Lecture 1: SQL Popular String Functions – Part 1
Lecture 2: SQL Popular String Functions – Part 2
Chapter 22: SQL Popular Date Functions
Lecture 1: SQL Popular Date Functions – Part 1
Lecture 2: SQL Popular Date Functions – Part 2
Chapter 23: SQL Popular Mathematical Functions
Lecture 1: SQL Popular Mathematical Functions
Chapter 24: SQL Popular Convert Functions
Lecture 1: SQL Popular Convert Functions
Chapter 25: Joins – Introduction and Table Preparation
Lecture 1: Joins – Introduction and Table Preparation – Part 1
Lecture 2: Joins – Introduction and Table Preparation – Part 2
Lecture 3: Joins – Introduction and Table Preparation – Part 3
Chapter 26: Inner Join
Lecture 1: Inner Join
Chapter 27: Outer Join
Lecture 1: Outer Join
Chapter 28: Self Join
Lecture 1: Self Join
Chapter 29: Cross Join
Lecture 1: Cross Join
Chapter 30: Stored Procedure Basics
Lecture 1: Stored Procedure Basics – Part 1
Lecture 2: Stored Procedure Basics – Part 2
Chapter 31: Stored Procedure Passing Parameters and Return
Lecture 1: Stored Procedure Passing Params and Return
Chapter 32: SQL SubQueries
Lecture 1: SQL SubQueries
Chapter 33: SQL Views
Lecture 1: SQL Views
Chapter 34: SQL Triggers – DDL Triggers
Lecture 1: SQL Triggers – DDL Triggers
Chapter 35: SQL Triggers – DML Trigger
Lecture 1: SQL Triggers DML Trigger – Part 1
Lecture 2: SQL Triggers DML Trigger – Part 2
Chapter 36: SQL Transactions
Lecture 1: SQL Transactions – Part 1
Lecture 2: SQL Transactions – Part 2
Chapter 37: Normalization
Lecture 1: Normalization
Chapter 38: DB Backup and Restore
Lecture 1: DB Backup and Restore
Chapter 39: Securing the Database
Lecture 1: Securing the Database
Chapter 40: Query Source Text File Download
Instructors
-
Abhilash Nelson
Computer Engineering Master & Senior Programmer at Dubai
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 0 votes
- 4 stars: 4 votes
- 5 stars: 4 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024