Learn Microsoft SQL Server from scratch

Learn Microsoft SQL Server from scratch, available at $19.99, has an average rating of 4.3, with 20 lectures, based on 23 reviews, and has 92 subscribers.

You will learn about Create Database and its objects,Tables,Views,Procedures,Built in functions Normalization of Data,DML,DDL and DCL Statements Relational Mapping of Data,Cardinalities between tables,Clauses, Predicates and Date Functions This course is ideal for individuals who are Students who are new to database and programming or Students who face difficulties in writing SQL queries or Students who wants to revise and polish their MS-SQL skills It is particularly useful for Students who are new to database and programming or Students who face difficulties in writing SQL queries or Students who wants to revise and polish their MS-SQL skills.

Enroll now: Learn Microsoft SQL Server from scratch

Summary

Title: Learn Microsoft SQL Server from scratch

Price: $19.99

Average Rating: 4.3

Number of Lectures: 20

Number of Published Lectures: 20

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

Create Database and its objects,Tables,Views,Procedures,Built in functions

Normalization of Data,DML,DDL and DCL Statements

Relational Mapping of Data,Cardinalities between tables,Clauses, Predicates and Date Functions

Who Should Attend

Students who are new to database and programming

Students who face difficulties in writing SQL queries

Students who wants to revise and polish their MS-SQL skills

Target Audiences

Students who are new to database and programming

Students who face difficulties in writing SQL queries

Students who wants to revise and polish their MS-SQL skills

Learning SQL from scratch, is a key source to develop skills in database programming, the course will cover from installation of SQL Server till advance query writing and relationship management between data. 

below are the topics covered in this course:

1. Microsoft SQL Server Installation and Introduction

2. What is data and information?

3. Create very first database and table

4. Introduction to T-SQL Statements

5. Clauses 

6. What is primary key and foreign key? (Relationships)

7. What are SQL Constraints?

8. What are SQL Joins?

9. What are SQL Views?

10. What are SQL Stored procedures?

SQL server installation is one one of the most technical and mind boggling process, this course will help you installing MS SQL Server with mandatory features that are required to kick start. Furthermore, in this course you’ll learn database terminologies and there usages in different areas. In this course our focus is on relational databases where data is split in to multiple locations called “TABLES”. The reason of doing so is to have unique and non repetitive data without redundancy. After this course, you will be able to create and design your own databases. This course will also help you to understand different concepts of data handling like DDL, DML & DCL statement, that are used for inserting, updating, retrieving and deletion of  data in database. After this course , you’ll be able to retrieve data from database from different table all together using simple queries.

Course Curriculum

Chapter 1: Introduction To Database

Lecture 1: Data, Information,Database, DBMS & RDBMS

Chapter 2: Installation of MS-SQL Server

Lecture 1: How to install MS SQL

Lecture 2: SQL Server Start Ups

Chapter 3: DDL, DML & DCL Statements

Lecture 1: Data Definition Language (DDL)

Lecture 2: Data Manipulation Language (DML)

Lecture 3: Data Control Language (DCL)

Chapter 4: MS SQL Clauses

Lecture 1: SQL Clauses

Chapter 5: SQL Constraints

Lecture 1: Constraints

Chapter 6: SQL Joins

Lecture 1: JOINS

Chapter 7: SQL Relationships

Lecture 1: How to add relationship in SQL

Chapter 8: Functions In SQL

Lecture 1: Aggregate Functions

Chapter 9: SQL Views

Lecture 1: How to work with views

Chapter 10: SQL Stored Procedures

Lecture 1: How to work with SQL Stores Procedures

Chapter 11: SQL Predicates

Lecture 1: LIKE

Lecture 2: Between

Lecture 3: ALL & ANY

Lecture 4: IN

Chapter 12: SQL Case

Lecture 1: Case Queries

Chapter 13: DATE Functions in SQL

Lecture 1: Date Functions

Chapter 14: Backup & Script Generation

Lecture 1: Database Script and Backup

Instructors

Ali Raza Sardar Ali
Software and Database Instructor

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 8 votes

5 stars: 11 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!