SQL Developer Skills For Beginners

Learn SQL Developer Skills
5.0 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
13 students enrolled
$19
$145
87% off
Take This Course
  • Lectures 46
  • Length 5.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2016 English

Course 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 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

What are the requirements?

  • How to use a computer and Internet
  • Determination to Learn

What am I going to get from this course?

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

What is the target audience?

  • Anyone interested in learning something new

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Database Basics
Introduction
Preview
02:48
Database Concepts
Preview
04:57
Hierarchical database
04:48
Relational Databases
04:51
RDBMS
04:14
Flat File Databases
05:06
Section 2: Setting Up Development Environment
System Requirements
04:52
Microsoft SQL Server Express 2014 Download
04:04
Microsoft SQL Server Express 2014 Installation
04:55
Download Sample Database
04:58
Install Sample Database
06:06
SSMS Tool
04:40
MSDN Virtual Labs ( No Installation Required )
10:44
Section 3: Functions
AVG
07:52
MAX
06:49
MIN
06:50
COUNT
09:24
SUM
07:17
Grouping Data
08:10
Section 4: Developing Databases and Tables with SQL
Schemas
04:12
Designing and Creating Databases
06:47
Designing and Creating Tables
Preview
08:17
Primary Keys
Preview
04:50
Foreign Key
04:39
Views
09:10
Creating Stored Procedures
11:59
Section 5: Joining Tables
Intro
00:27
Why are Table Joins Used
00:49
INNER Join
10:36
LEFT OUTER Join
12:26
RIGHT OUTER Join
09:30
Summary
01:53
Section 6: T-SQL Refresher
What is T-SQL
10:27
T-SQL INSERT Query
10:34
T-SQL DELETE Query
07:53
T-SQL UPDATE Query
09:18
T-SQL DISTINCT and TOP Query
06:42
Using Aliases
07:12
T-SQL Comments
06:07
T-SQL SELECT Query
12:53
ORDER BY Clause with T-SQL
03:02
Using Comparison Filters with T-SQL
06:07
Using Equality Filters with T-SQL
13:35
Using String Comparison with T-SQL
11:22
Using Logical Operators with T-SQL
14:08
Null Comparisons
04:35

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bluelime Learning Solutions, Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Ready to start learning?
Take This Course