SQL Developer Skills For Beginners
4.4 (6 ratings)
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.
27 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Developer Skills For Beginners to your Wishlist.

Add to Wishlist

SQL Developer Skills For Beginners

Learn SQL Developer Skills
4.4 (6 ratings)
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.
27 students enrolled
Last updated 5/2016
English
Current price: $10 Original price: $120 Discount: 92% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create Databases
  • Create Tables
  • Write T-SQL Queries
  • Design Databases
  • Design Tables
  • Create Views
  • Create Constraints
View Curriculum
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 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

Who is the target audience?
  • Anyone interested in learning something new
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 46 Lectures Collapse All 46 Lectures 05:22:55
+
Database Basics
6 Lectures 26:44


Hierarchical database
04:48

Relational Databases
04:51

RDBMS
04:14

Flat File Databases
05:06
+
Setting Up Development Environment
7 Lectures 40:19
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
+
Functions
6 Lectures 46:22
AVG
07:52

MAX
06:49

MIN
06:50

COUNT
09:24

SUM
07:17

Grouping Data
08:10
+
Developing Databases and Tables with SQL
7 Lectures 49:54
Schemas
04:12

Designing and Creating Databases
06:47



Foreign Key
04:39

Views
09:10

Creating Stored Procedures
11:59
+
Joining Tables
6 Lectures 35:41
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
+
T-SQL Refresher
14 Lectures 02:03:55
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
About the Instructor
Bluelime Learning Solutions
4.2 Average rating
1,061 Reviews
25,733 Students
72 Courses
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.