• Post category:StudyBullet-6
  • Reading time:5 mins read


Get upto speed with SQL Server 2019

What you will learn

Microsoft SQL Server

Create an SQL Azure Database

T-SQL

sql server

Description

Do you want to learn a skill that is in demand right now? and can help with your career progression or even add a new skill set your CV/Resume? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course is a crash course into SQL server Express 2019 to get you up to speed in hours, you will learn the basic techniques to start creating databases and table.

You will also learn about stored procedures, functions, and views.

You will learn all this by building your own database for a clothing store company, you will also learn how to deploy this database to Microsoft Azure.

I am always improving this course by adding and updating sections.


Get Instant Notification of New Courses on our Telegram channel.


So if you are in a hurry to learn SQL Server then this cause is for you.

Who this course is for:

Anyone who works with data, tables, or databases!

Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.

If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information

English
language

Content

Introduction

Introduction
What you will learn in this course

Installing SQL Server Express, SSMS and Connecting to SQL Server

Installing SQL Express 2019
Installing SQL Server Management Studio
Connecting to SQL Server Express 2019

Section One

Create Your First Database
The GO Keyword
Create Your First Table
Data Types – Part 1
Data Types – Part 2
Data Types – Conclusion
Practice Using Data Types
Using the Select, Concat and Cast Statments
The AS Keyword (Aliasing)
The INSERT Statement
Challenge One

Section Two

Section Introduction
ALTER table
The WHERE Statement
Introduction to Indexing, Primary and Foreign Keys
Demo – Primary and Foreign Keys and Indexing
Database Design
Challenge Two

Section Three

Introduction
Advanced WHERE Search Conditions
Common Table Expressions
INNER JOIN
OUTER JOINS
Offset Fetch Statement
Subquerys and Aggregation
Transactions
Adding Data to The Product Types Table

Section Four

Introduction
Stored Procedures
Functions
Views
Challenge Three

Section Five

Deploy to Azure
Course End