Microsoft SQL Server Essentials

Focused View

Obinna Osuji

5:00:19

101 View

1. Introduction

1. Introduction.mp4

02:37

2. What to expect from this course.mp4

02:19

3. Defining a relational database.mp4

03:20

2. Getting Started

1. Installing the required tools.mp4

09:11

2. Creating your first database.mp4

11:02

3. Setting up the Adventure Works database.mp4

07:49

3. Data Definition Language Basics

1. Introduction to Data Definition Language (DDL).mp4

04:21

2. Creating a table using SSMS.mp4

07:24

3. Creating a table using T-SQL.mp4

04:52

4. Table Constraints In SQL Server

1. Intro to table constraints in SQL Server.mp4

04:14

2. Creating a primary key using SSMS GUI & T-SQL.mp4

10:15

3. Creating a foreign key using T-SQL.mp4

13:23

4. Creating a foreign key using SSMS.mp4

06:49

5. Data Manipulation Language Basics

1. Intro to Data Manipulation Language (DML).mp4

03:33

2.1 dml examples.zip

2. Data Manipulation Language Examples.mp4

11:46

6. Filtering Queries In SQL Server

1.1 filter options.zip

1. Filtering queries using the WHERE clause.mp4

08:55

2. Filtering queries using other conditions (Part 1).mp4

09:35

3. Filtering queries using other conditions (Part 2).mp4

06:38

7. All about the JOIN command

1. Introducing the JOIN command.mp4

07:01

2.1 employee script.zip

2. Using the JOIN command (Part 1).mp4

07:51

3.1 join examples.zip

3. Using the JOIN command (Part 2).mp4

06:30

4. Using the JOIN command (Part 3).mp4

09:20

8. Aggregate & Conditional Expressions In SQL Server

1.1 aggregate functions.zip

1. Introducing Aggregate functions in SQL Server.mp4

08:02

2.1 group by + having command.zip

2. Using GROUP BY and HAVING commands.mp4

15:10

3.1 conditional statements.zip

3. Using the IF...ELSE conditional statements.mp4

07:10

4. Using the CASE conditional statement in SQL Server.mp4

06:56

9. Built-In Functions In SQL Server

1.1 date functions.zip

1. Using the DATE functions in SQL Server.mp4

09:29

2.1 string functions.zip

2. Using the STRING functions in SQL Server.mp4

12:03

10. Subqueries, Views & Stored Procedures

1.1 subquery sample.zip

1. Writing your first subquery.mp4

08:43

2.1 stored procedures.zip

2. Working with Stored Procedures (Part 1).mp4

09:10

3. Working with Stored Procedures (Part 2).mp4

11:35

4.1 view example.zip

4. Creating, using and modifying Views in SQL Server.mp4

07:23

11. Advanced SQL Server Concepts

1. Introducing TRIGGERS in SQL Server.mp4

06:48

2.1 after insert trigger.zip

2.2 after update trigger.zip

2. AFTER INSERT and AFTER UPDATE Trigger Examples.mp4

17:03

3. Automating Jobs with SQL Server Agent.mp4

12:24

4. Optimizing Query performance in SQL Server.mp4

07:22

12. Conclusion

1. Conclusion.mp4

02:16

Description

Learn the fundamentals of Microsoft SQL Server Database - No prior knowledge of SQL is required!

What You'll Learn?

Understand the concept of a relational database
Become familiar with Microsoft SQL Server
Create databases from the ground up and work with an existing database
Understand & write T-SQL which is Microsoft’s version of SQL
Get comfortable with SQL Server Management Studio
Master DML & DDL Concepts

Who is this for?

Beginners who are interested in backend programming, database administration and data analytics

What You Need to Know?

No programming experience or database experience needed. You will be taught everything from the ground up

You only need a working PC and access to the internet to download the required tools

More details

Description
Microsoft SQL Server Essentials takes you through the journey of learning about the SQL Server database from Microsoft from the ground up. You will become familiar with concepts such as the Structured Query Language (SQL) and Microsoft's version (T-SQL).

At the end of the course, you should:

- Understand the concept of a relational database
- Become familiar with Microsoft SQL Server
- Work with Microsoft's IDE: SQLÂ Server Management Studio
- Learn how to perform many database tasks using the Graphical User Interface (GUI)
- Understand & write T-SQL which is Microsoftâ€™s version of SQL
- Create databases from the ground up and work with existing database
- Create database tables and define relationships between them
- Understand the concept of table constraints
- Create primary keys, foreign keys etc.
- Get comfortable with SQL Server Management Studio
- Master DDL â€“ Data Definition Language
- Master DML â€“ Data Manipulation Language
- Write simple to complex queries
- Learn how to use the various built-in functions in SQLÂ Server such as DATEÂ and STRING functions
- Learn how to filter queries with various commands
- Learn how to aggregate your query results
- Work with triggers, views and stored procedure
- Learn how to schedule jobs using SQL Server Agent
- Learn how to optimize your database queries for optimal execution

This course is ideal if you are getting started with backend development, data analytics or full stack development. You will learn everything you need to know in order to go from beginner to pro in Microsoft SQLÂ Server.
Who this course is for:
Beginners who are interested in backend programming, database administration and data analytics

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Obinna Osuji

Instructor's Courses

Experience as a DeveloperI have always loved to build things. Back in University, I was introduced to my first programming course, Visual Basic 6, and was fascinated by how much you could build just by typing in a few lines of code and watching your app come to life! I pursued my curiosity further by picking up Java and learning the concepts of object-oriented programming. Upon graduating, I took a full-time job as a software developer in a card payments company where I learned how to program with C++. I also became interested in mobile development and learned how to use cross platform frameworks such as Cordova. Today, I design and build enterprise software primarily using the .NET Core and .NET Framework as well as ASP.NET (Web forms and MVC)Experience as an InstructorI love to teach, for me it is personally satisfying to help someone navigate through the unknown and eventually gain mastery in the chosen area. While I have taught many classes offline and in-person, Udemy gives me an opportunity to bring some of that experience online. A major advantage with me is that I teach from a real-world perspective and this gives my students the best chance at being able to apply the knowledge they gain from my courses practically. This makes it easy for them become productive (if they already work in tech) or positions them to get a job in tech if they are just starting out in their careers.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.