Sql Developer Skills For Beginners

Learn SQL Developer Skills

What you'll learn
Create Databases
Create Tables
Write T-SQL Queries
Design Databases
Design Tables
Create Views
Create Constraints
Requirements
How to use a computer and Internet
Determination to Learn
Description
SQL Developers are in demand due to the increasing reliance on data.Becoming a SQL developer can be a very rewarding and fulfilling career.
The path is relatively easy compared to other technical careers.
Microsoft SQL Server is among the top 3 relational database management systems in the worldand getting the skills to becoming an SQL Server developer will serve you well and open many job opportunities .
The advantage of this course is the amazing virtual labs facilities that is available for free from Microsoft. The virtual labs comes with Microsoft Server 2012 and also Microsoft SQL Server 2016 and various instances of SQL Server like SQL Server Analysis Server (SSAS), SQL Server Reporting Service (SSRS),SQL Server Integration service  (SSIS). The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.
What you will learn in this course includes:
How to create databasesHow to create TablesHow to deseign databasesHow to design TablesHow to create flat file database How to use SSMS ToolHow to write basic T-SQL Queries
I look forward to seeing on the course.
Thank You

Overview

Section 1: Database Basics

Lecture 1 Introduction

Lecture 2 Database Concepts

Lecture 3 Hierarchical database

Lecture 4 Relational Databases

Lecture 5 RDBMS

Lecture 6 Flat File Databases

Section 2: Setting Up Development Environment

Lecture 7 System Requirements

Lecture 8 Microsoft SQL Server Express 2014 Download

Lecture 9 Microsoft SQL Server Express 2014 Installation

Lecture 10 Download Sample Database

Lecture 11 Install Sample Database

Lecture 12 SSMS Tool

Lecture 13 MSDN Virtual Labs ( No Installation Required )

Section 3: Functions

Lecture 14 AVG

Lecture 15 MAX

Lecture 16 MIN

Lecture 17 COUNT

Lecture 18 SUM

Lecture 19 Grouping Data

Section 4: Developing Databases and Tables with SQL

Lecture 20 Schemas

Lecture 21 Designing and Creating Databases

Lecture 22 Designing and Creating Tables

Lecture 23 Primary Keys

Lecture 24 Foreign Key

Lecture 25 Views

Lecture 26 Creating Stored Procedures

Section 5: Joining Tables

Lecture 27 Intro

Lecture 28 Why are Table Joins Used

Lecture 29 INNER Join

Lecture 30 LEFT OUTER Join

Lecture 31 RIGHT OUTER Join

Lecture 32 Summary

Section 6: T-SQL Refresher

Lecture 33 What is T-SQL

Lecture 34 T-SQL INSERT Query

Lecture 35 T-SQL DELETE Query

Lecture 36 T-SQL UPDATE Query

Lecture 37 T-SQL DISTINCT and TOP Query

Lecture 38 Using Aliases

Lecture 39 T-SQL Comments

Lecture 40 T-SQL SELECT Query

Lecture 41 ORDER BY Clause with T-SQL

Lecture 42 Using Comparison Filters with T-SQL

Lecture 43 Using Equality Filters with T-SQL

Lecture 44 Using String Comparison with T-SQL

Lecture 45 Using Logical Operators with T-SQL

Lecture 46 Null Comparisons

Lecture 47 Thank You

Anyone interested in learning something new