Learn SQL from scratch and become a database developer-Part2

Become the next greatest DB Dev, administrator or report developer by learning SQL from scratch, the easy way. Part2
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.
86 students enrolled
$25
Take This Course
  • Lectures 46
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • 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 6/2014 English

Course Description

Updates:

  • Course last updated: May 2016
  • Over 60 happy students
  • Most complete course on SQL Language on Udemy and growing
  • Full, Free lifetime access
  • All future extra lectures and upgrades are always included for FREE
  • Unconditional Udemy 30 money-back guarantee

Learn SQL language from scratch, the easy way, is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. This is the second part of a 2 parts course which covers the following topics:

• More ways of getting data from multiple tables

• Common SQL Functions

• Transactions

• Data Definitions

• Relational Data

• Indexes

• Tools for working with SQL

• Pointers

• Data Normalization

For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out. There are 2 sample databases provided with this course. SQLMain is used throughout the demonstrations. The second one is a Microsoft developed sample database that you can have fun with after you finish the course.

Besides the video tutorials and sample databases, this course includes a 186 pages PDF book about SQL that I have written. Some of the concepts covered in the book will be demonstrated in this course. I myself started learning on my own with no mentor and no place where to get the exact information that I needed. This is one of the reasons this course is structured in such a way that you can start writing SQL code in hours with ease.


I recommend taking one lecture once every 2 or 3 days. This way you will have time to get used with the terminology and also have time to practice what you learned on your own.

This course is not going to make you a SQL guru overnight. It takes practice and patience to get there.

Let's get started and learn SQL language together. The easy way.

Good to know:

  • In order to have a better learning experience please watch the videos in HD.
  • 30 days money back guarantee. No questions asked.

What are the requirements?

  • It is recommended that you take the first part of this course before starting this one
  • Desire to learn new things.
  • SQL Server 2012 Express

What am I going to get from this course?

  • Understand basic/intermediate database concepts
  • Insert,Extract, Alter and Delete data from a database
  • Perform data manipulation and transformation
  • Use and maintain relational data
  • Understand and build database designs
  • Know how to perform all of the above using multiple tables

What is the target audience?

  • This course can be used by technology professional as well as individuals who wish to become database developers/administrators/designers or report developers or those that have a passion about data and wish to know how they can play with it.

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: Joining Multiple Tables-Details
Introduction
Preview
00:38
UNIONS
Preview
03:22
UNION-UNION ALL
Preview
06:09
EXCEPT-INTERSECT
01:47
MySQL SYNTAX
01:23
Advanced Stuff
04:13
Conclusions
01:10
Section 2: Common SQL Functions
Introduction
Preview
01:23
GETDATE
02:04
GETUTCDATE
01:25
DATEPARTS
02:24
DATE OPERATIONS
03:28
STRING FUNCTIONS
04:51
MATH FUNCTIONS
06:12
CONCLUSIONS
00:45
Section 3: Transactions
INTRODUCTION
Preview
01:09
TRANSACTIONS OVERVIEW
02:31
TRANSACTION EXAMPLE
05:06
MySQL SYNTAX
01:42
NESTED TRANSACTIONS
00:59
CAVEATS
01:23
CONCLUSIONS
01:09
Section 4: Data Definitions
INTRODUCTION
01:05
CREATE TABLE
08:36
PhPMyAdmin
06:22
DATA TYPES
05:06
ALTER-DROP
04:19
CONCLUSIONS
01:00
Section 5: Understanding Relational Data
INTRODUCTION
00:41
RELATIONAL DATA OVERVIEW
04:26
PRIMARY KEYS
09:00
FOREIGN KEYS
06:29
DEFAULT CONSTRAINTS-NOT NULL CONSTRAINTS
05:18
CHECK CONSTRAINTS
10:01
INDEX CONSTRAINTS
01:47
CONCLUSIONS
01:00
Section 6: Indexes
INTRODUCTION
00:31
BENEFITS AND CAVEATS
06:55
MANAGING INDEXES
02:31
CONCLUSIONS
00:42
Section 7: Tools For Working With SQL
INTRODUCTION
00:39
MS SQL SERVER MANAGEMENT STUDIO
03:45
CROSS PLATFORM
01:51
MySQL TOOLS
03:10
COMMAND LINE
01:18
CONCLUSIONS
01:15

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Cristian Astalos, BI - DB Developer, Writer, Founder of EasyWaySQL

I am a young but experienced and highly passionate BI Reporting Specialist and Database Developer,writer and founder of EasyWaySQL.

I also have a Bachelor's degree in Business Administration and a Master's degree in Economic Decision Support Systems.

Other than that I am dedicated to share my knowledge with others and learn new technologies on the way.

Ready to start learning?
Take This Course