Learn SQL from scratch and become a database developer-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.
94 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL from scratch and become a database developer-Part2 to your Wishlist.

Add to Wishlist

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.
94 students enrolled
Last updated 6/2014
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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
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.
Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 46 Lectures Collapse All 46 Lectures 02:23:00
+
Joining Multiple Tables-Details
7 Lectures 18:42



EXCEPT-INTERSECT
01:47

MySQL SYNTAX
01:23

Advanced Stuff
04:13

Conclusions
01:10
+
Common SQL Functions
8 Lectures 22:32

GETDATE
02:04

GETUTCDATE
01:25

DATEPARTS
02:24

DATE OPERATIONS
03:28

STRING FUNCTIONS
04:51

MATH FUNCTIONS
06:12

CONCLUSIONS
00:45
+
Transactions
7 Lectures 13:59

TRANSACTIONS OVERVIEW
02:31

TRANSACTION EXAMPLE
05:06

MySQL SYNTAX
01:42

NESTED TRANSACTIONS
00:59

CAVEATS
01:23

CONCLUSIONS
01:09
+
Data Definitions
6 Lectures 26:28
INTRODUCTION
01:05

CREATE TABLE
08:36

PhPMyAdmin
06:22

DATA TYPES
05:06

ALTER-DROP
04:19

CONCLUSIONS
01:00
+
Understanding Relational Data
8 Lectures 38:42
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
+
Indexes
4 Lectures 10:39
INTRODUCTION
00:31

BENEFITS AND CAVEATS
06:55

MANAGING INDEXES
02:31

CONCLUSIONS
00:42
+
Tools For Working With SQL
6 Lectures 11:58
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
About the Instructor
Cristian Astalos
4.1 Average rating
34 Reviews
1,380 Students
4 Courses
BI-DB Developer, Founder of EasyWaySQL.com and My-Car.co

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

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.