SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning

Microsoft SQL is one of the most used enterprise databases. In this course I break down how to become a database expert
3.8 (11 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.
2,372 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 24
  • Length 2 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 12/2014 English

Course Description

  • Do you work with SQL every day and not understand it?
  • Do you see people who know SQL and make more money than you ?
  • Do you have an Interview coming up where you know SQL would look amazing on your resume?

I taught myself SQL overnight 15 years ago for a job interview, and have made it my career ever since. My career went from rags to riches because of what I teach you in this course. I have a real passion for SQL server and how to use it to make your applications more productive. I have taught people how to use SQL for the passed 10 years and I am here to teach you .

I designed this course to teach everyone how to use it to Query and Manipulate mass amounts of data. I teach you from the basics to very complex SQL statements. If you have never used SQL before I will teach you the basics from start to finish. If you use SQL every day I will teach you some of my pro tips that will help you get your job done faster and make you look like a amazing developer.

I will cover everything from creating a database to using aggregate functions and triggers and why you should use them.

I am committed to delivering the best product possible If you love my course give me a great review. If you are not satisfied with my course please request a refund and I will happily give it I want to make you a more powerful developer and if i didn't do that It is my duty to give you a refund. Along with your refund request please tell me why you are not happy with my course and what I could have done better to teach you.

What are the requirements?

  • Download and install SQL Management Studio Express 2014

What am I going to get from this course?

  • Create a Database From Scratch
  • Understand Almost All SQL Syntax
  • Be able to write both Basic and Complex SQL Statements without help
  • Insert Update and Delete Data in a SQL Database

What is the target audience?

  • This SQL Course is for everyone from those woh have never seen SQL Management Studio to the guys who need help remembering what to do in SQL
  • Do you know Crystal Reports and you want to make your reports faster
  • Is your application slow and you don't understand how you can speed it up.

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: Introduction: SQL
00:35

Welcome to Bill Sims online tutorial!
Here we listed down all the interesting topics that we will have for the whole course.

SQL Server is one of the most powerful Enterprise relational databases out there. In this course I will break down

  • What is a database
  • How do you create a database
  • What is a database used for

Then we will get into the query language SQL and I will show you from the basics of creating a Select statement all the way to creating triggers and stored procedures.

Lets Get Started...

Article

Hit the HD button for more conducive learning experience.

01:18

Hey guys! Today’s lesson is all about the introduction to databases and SQL.

In learning the basics, you’ll able to understand how to maximize the utilization of database and insinuate SQL to manage your data.

In this course we break down what a Database is.

Database:

A database is an organized collection of data. The data is typically organized to model aspects of reality in a way that supports processes requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. (this is from Wikipedia)

Databases do a few things for us. They allow us to store data for retrieval later in a fast manner. Think about storing 100 text files with different names on the. When that gets too big you start putting them into folder structures. When that gets big you would probably step into some sort of database.

A database gives us a super organized way to store data and get it out, along with that it gives us super tools to compare data and do mathematical calculations on that data.

Section 2: Creating Our First Database and Basic SQL Queries
07:11

I remember when I created my first database it seemed like a daunting task, but it doesn't have to be. I created my first database in a Enterprise scenario. For the purpose of this course just think of it like you are creating a file folder. You can't hurt anything so lets play.

In SQL Management studio right click on the "Databases" icon and click "New Database"

Lets set a name and we have our first Database Created. Now we have to start creating some tables.

Right click on the tables Folder and lets create our first Table.

Keep on following along and we will have all the tables created.

08:41

In this part, we will learn how to insert data into tables [See Lecture 4 for review]. This 8-minute video will guide you to indicate certain queries using SQL Enterprise Manager. We identify 4 major columns in our table, the ID, description, cost and price. In order for you to do a faster execution, the INSERT INTO can provide you with a template wherein you can set some VALUES for each column.

Inserting Data into Tables

This is probably the safest way to experiment with data. When you insert data into a table, it is like breathing life into your database. Without data your database may as well not exist.

Knowing your data is the first rule to Databases. You will hear administrators talk about this all the time. If you don't know your data then you have no use in the database and you will probably do more harm than good.

In this section I show you how to insert 1 record and also multiple records at one time.

Play the video and you’ll discover more exciting short cuts for your convenience.

06:25

Your basic Select statement is like the road down a never ending path of knowledge. The whole idea behind the select statement is you are asking the Database a question. In this case the question you are asking is "What data do you have that meets these requirements?

The SELECT statement will help you retrieve data results determined by your instructions by activating this declaration. This SQL tutorial will help you through with different strategic ways of using this statement, from simple to complex ways on how to extract your data sets from your table.

If you think about it like a search function. This is what I am searching for, what do you have that meets these requirements.

Select <- Is like the search command

* <- This is kind of like What data do you want to display

FROM [Table] <- is like the folder location you are searching from.

Where FileName = 'xyz' <- this is what information you are searching for

03:08

In this case, we will learn how to identify and discuss the anatomy of a SELECT statement.

This syntax below will select specific columns from your data table.

SELECT col_name, col_name
FROM table_name;

While, this SELECT statement below syntax will select all your data queries from your table.

SELECT * FROM Customers;

Anatomy

Select <- Is like the search command

* <- This is kind of like What data do you want to display

FROM [Table] <- is like the folder location you are searching from.

Where FileName = 'xyz' <- this is what information you are searching for

02:37

Sub-queries

Sub-queries can be on SELECT statements or on JOINTS. Sub-queries by definition is a query that is nested inside different SQL statements such as SELECT, INSERT, UPDATE and DELETE embedded in the WHERE statement. It is sometimes called as inner query and the one that contains subquery are known to be outer query.

We have to think of sub-queries as nested Select statements. A sub-query is a precision tool to simply pulling out exactly what data you want in the select statement. It is a precision instrument that is the first step into becoming a SQL Pro. A lot of people make the mistake of learning up to sub queries and then never taking another step. But we are going to teach you way more than this. If you are a crystal reports developer you will get a lot of use out of sub queries.

06:40

By testing our data, let’s proceed with this portion of our class wherein we will be able to learn how to use and manage our window in our database. We will be doing the T-SQL activity for our purchase order inorder for us to compare or join data queries.

The CASE expression has two formats: [https://msdn.microsoft.com]

  • The simple CASE expression compares an expression to a set of simple expressions to determine the result.
  • The searched CASE expression evaluates a set of Boolean expressions to determine the result.
06:17

The Update Statement

Have you ever had your home address in 1000 documents on your computer and you wish there was an easy way to change it in all those documents. Well if those documents were stored as data in a database we could definitely help you with that problem.

Basically the update statement is a way to change data in the database. you can change a value from one thing to another using an update statement.

Update statement is one of the most helpful statement in SQL but at the same time, you need to be very specific and careful on using this statement for it can eventually ruin your database. Use this statement with a WHERE clause, this is to identify your data queries properly. It manages your data by modifying a specific data sets from your table/s, multiple set of queries, down to the whole data sets of your table in a snap. Cool, right?

See Update syntax below.

UPDATE table_name
SET col=val1, col2=val2, col3=val3…
WHERE some_col=some_value;

03:50

The Delete Statement

Have you ever had a girlfriend or 20 you wanted to remove from your memory :). If you have and your brain was a database accessible through SQL you could solve that problem right now.

The Delete statement removes data from a database never to return unless you insert it again.

DELETE statement is powerful yet one of the most decisive statement in SQL. So see to it to check your all your data records first, decide the unwanted queries before running the DELETE statement.

We’ll be giving you an example on how to delete a certain data from your table. Hit this play button and we’ll discuss it to you.

4 questions

This is a quick quiz on Updates and Deletes

06:53

The Where Clause

This part of our SQL tutorial we will discuss another clause, the WHERE clause. This is used to identify the specific records by filtering and using indicated condition. If the given condition is satisfied, then it will provide you with a return value.

The where clause is the single most used part of a SQL statement. It is the brain of your statements. It is important to understand how to form a good where clause and that's why we are revisiting it here.


2 questions

Lets review what we learned in Section 2.

Section 3: Joins Group By and Aggregate functions
07:57

Inner Joins

Inner joins in SQL. This keyword will help you select all rows or specified rows from 2 or more tables and displays it as long as they match together else no data will be retrieved. This complex idea will eventually help you manage your database properly and when a situation arises it comes in handy.

We talk about how to take data from 1 table and data from another table and relate them to each other. Basically with an inner join you get to say

Take Table 1

and Take Table 2

If table1.XYZ = Table2.XYZ then these 2 records are related and lets connect them together.

In this lecture I show you how this works.

3 questions

Inner Joins are the most common join used in SQL lets make sure we understand them.

05:50

Now after the quiz, Let’s proceed with Left outer joins. We know now how Inner joins works, what it means that Left outer joins works the same conception but in a different method. Left outer joins returns row/s of data sets from the left table, matching rows in the right else the data will be NULL.

Go and check our example.

08:15

Group by Clauses in a SQL Database goes with a SELECT statement. It is used to identify specific groups of data sets from our database. This clause temporarily creates table to discover other sets of groups arranged based on this condition you provided to retrieve a certain data results. For a clear example, play this video.

08:42

Another SQL function that we will discuss in this course is the Aggregate Functions. This function performs calculations on a specific set of values and returns a value. The following listed below are few examples of aggregate functions that we can go and try it out.

  • MIN
  • MAX
  • AVG
  • COUNT
  • SUM
  • And etc.
Section 4: Advanced DB
03:35

In this instance, we will show you how TO CREATE, ALTER and DROP. The CREATE will produce view, ALTER is basically same as updating the view while DROP is like deleting and it can remove indexes, tables and databases.

07:48

SQL UDF stands for User-Defined Functions, its purpose is to specify acceptable parameters, do mathematical calculations and definitely return a value. In this case, we’ll pass strings and retrieve strings by using our sample database in a faster execution.

This video will provide you with a solid example on how to set data values and returning them using the concept of UDF.

Scalar and Table differ in terms of their return value, scalar retrieves 1 value while table retrieves all data tables.

05:03

Subquery can be used with a JOIN process to generalize our data. We will able to learn how to maximize the usage of our database by using a Subquery that temporarily returns a table and is given with an alias for us to use it on the outer select statement.

In this case, we will use the inner join in our database of products pull out the prices and purchased quantities and purchased IDs, orders from our sub-query and do some math.

03:54

This video will show you how to create an In-Line Table UDF, then naming the UDF and based on the given sub-query with some restrictions on the parameters.

We could change our subquery with UDF but in this scenario sub-query is more powerful that UDF unless if you decide to hardcode the User-defined functions.

03:52

Views, is one of the powerful tools that we can use in the SELECT statement. The data fields in the view are actually fields from one or more tables that we can reuse over and over again.

10:49

Stored procedures are the ability to pass parameters and it can store templates that handle requests in order to accept one or more parameter values.

If you want to run the stored procedure you need to run the exact statement.

This video will show you how to use stored procedures by doing some increase in the cost of the given products. [from 10% to 20%], so sit back and learn more about it.

08:15

Triggers on database will help you manage your queries. Here we will show you how to insert snippets. Snippets are actually small sets of reusable codes that you can edit and incorporate to a larger module of codes in our database. Triggers execute in a manner that you can do some transactions and reflect it on to creating SQL, alter SQL and drop SQL.

There are many ways to do it to a point that we’ll extract data on paper towels and verify logs base on the data’s time stamp as an example.

Section 5: Random Tips to Make SQL Easier
02:33

We will show you how to use templates to store SQL with no sweat. It is where you can add a few of your scripts that you can reuse anytime. SQL provided you some templates already, but if you plan to add your personal folder and template of scripts, follow the steps we provided you in this video.

Thanks for watching.
Let us know if you have any questions.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rico Rodriguez, SQL Architect, Senior Software Developer, Project Manager

I have spent my life teaching others how to be better developers and master the art that is Software Engineering.

I have designed many Enterprise level applications as well as IOS and Android Applications. The skills I teach in my courses is the same skills that I use every day to do everything from running my teams to consulting on Enterprise level projects.

In my career I have found classes like this to be helpful in advancing my career and I wanted to make courses for people that really showed you end to end classes that weren't as simple as "Hello World". My goal as an instructor is to drive you to the next level in your careers, and if you want to do that, it takes 3 things. Knowledge, Leadership, Ingenuity. These are the 3 skills that i have used to take my career to the next level.

I have also been a father for 9 years. Throughout those years I have learned so much about myself and raising children. I have been on both sides of the fence from raising step-children and now raising my own son. It has been the experience of a lifetime and I would love to share any of my experiences with you so that you don't have to go through all the same learning curves that I did.

Ready to start learning?
Take This Course