SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning
3.9 (16 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,396 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning to your Wishlist.

Add to Wishlist

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.9 (16 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,396 students enrolled
Created by Rico Rodriguez
Last updated 5/2015
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Download and install SQL Management Studio Express 2014
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 24 Lectures Collapse All 24 Lectures 02:10:09
+
Introduction: SQL
3 Lectures 01:55

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

Preview 00:35

Hit the HD button for more conducive learning experience.

Hit The HD Button
00:02

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.

What is a Database and Where Does SQL Fit In
01:18
+
Creating Our First Database and Basic SQL Queries
9 Lectures 51:42

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.

Lets Create our First Database
07:11

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.

Inserting Data Into Tables Using SQL Enterprise Manager
08:41

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

Basic Select Statement
06:25

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

Preview 03:08

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.

Sub-queries in T-SQL
02:37

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.
Preview 06:40

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;

Update Statement in T-SQL
06:17

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.

The Delete Statement
03:50

This is a quick quiz on Updates and Deletes

Quiz on Updates and Deletes
4 questions

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.


More about the Where clause
06:53

Lets review what we learned in Section 2.

Section 2 Understanding
2 questions
+
Joins Group By and Aggregate functions
4 Lectures 30:44

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.

Preview 07:57

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

Inner Join Quiz
3 questions

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.

Left Outer Joins
05:50

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.

Group By Clauses in a SQL Database
08:15

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.
Aggregate Functions
08:42
+
Advanced DB
7 Lectures 43:16

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.

Create Alter Drop
03:35

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.

Scalar UDF
07:48

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.

Preview 05:03

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.

Table UDF
03:54

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.

Views
03:52

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.

Stored Procedure
10:49

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.

Triggers in SQL Management Studio
08:15
+
Random Tips to Make SQL Easier
1 Lecture 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.

Preview 02:33
About the Instructor
Rico Rodriguez
4.1 Average rating
527 Reviews
22,144 Students
8 Courses
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.