SQL Developer Skills For Beginners

SQL Developer Skills For Beginners, available at $19.99, has an average rating of 4.2, with 47 lectures, based on 22 reviews, and has 108 subscribers.

You will learn about Create Databases Create Tables Write T-SQL Queries Design Databases Design Tables Create Views Create Constraints This course is ideal for individuals who are Anyone interested in learning something new It is particularly useful for Anyone interested in learning something new.

Enroll now: SQL Developer Skills For Beginners

Summary

Title: SQL Developer Skills For Beginners

Price: $19.99

Average Rating: 4.2

Number of Lectures: 47

Number of Published Lectures: 47

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 47

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will Learn

Create Databases
Create Tables
Write T-SQL Queries
Design Databases
Design Tables
Create Views
Create Constraints

Who Should Attend

Anyone interested in learning something new

Target Audiences

Anyone interested in learning something new

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 world
and 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 databases
How to create Tables
How to deseign databases
How to design Tables
How to create flat file database�
How to use SSMS Tool
How to write basic T-SQL Queries

I look forward to seeing on the course.

Thank You

Course Curriculum

Chapter 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

Chapter 2: Setting Up Development Environment

Lecture 1: System Requirements

Lecture 2: Microsoft SQL Server Express 2014 Download

Lecture 3: Microsoft SQL Server Express 2014 Installation

Lecture 4: Download Sample Database

Lecture 5: Install Sample Database

Lecture 6: SSMS Tool

Lecture 7: MSDN Virtual Labs ( No Installation Required )

Chapter 3: Functions

Lecture 1: AVG

Lecture 2: MAX

Lecture 3: MIN

Lecture 4: COUNT

Lecture 5: SUM

Lecture 6: Grouping Data

Chapter 4: Developing Databases and Tables with SQL

Lecture 1: Schemas

Lecture 2: Designing and Creating Databases

Lecture 3: Designing and Creating Tables

Lecture 4: Primary Keys

Lecture 5: Foreign Key

Lecture 6: Views

Lecture 7: Creating Stored Procedures

Chapter 5: Joining Tables

Lecture 1: Intro

Lecture 2: Why are Table Joins Used

Lecture 3: INNER Join

Lecture 4: LEFT OUTER Join

Lecture 5: RIGHT OUTER Join

Lecture 6: Summary

Chapter 6: T-SQL Refresher

Lecture 1: What is T-SQL

Lecture 2: T-SQL INSERT Query

Lecture 3: T-SQL DELETE Query

Lecture 4: T-SQL UPDATE Query

Lecture 5: T-SQL DISTINCT and TOP Query

Lecture 6: Using Aliases

Lecture 7: T-SQL Comments

Lecture 8: T-SQL SELECT Query

Lecture 9: ORDER BY Clause with T-SQL

Lecture 10: Using Comparison Filters with T-SQL

Lecture 11: Using Equality Filters with T-SQL

Lecture 12: Using String Comparison with T-SQL

Lecture 13: Using Logical Operators with T-SQL

Lecture 14: Null Comparisons

Lecture 15: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 7 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!

Menu