SQL: Beginner to Advanced
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled

SQL: Beginner to Advanced

Learn How to Manage, View, and Store Data in a SQL Database
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled
Created by Alex Javad
Published 5/2018
English
English [Auto]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 downloadable resource
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Manage a SQL Database
  • Know how to model data in SQL
  • Perform basic SQL operations
  • Have an good understanding of Relational Databases
  • Be able to create reports from data
Requirements
  • A Mac or PC
Description

SQL is the language that allows for the management of data in and out of Microsoft SQL databases. 

If you are interested in building a web application, you'll need a database to support your application's data - including transaction information, customer information, product and order information, user information, etc.

SQL databases are industry standards, and can be hosted on Microsoft Azure, AWS or your favorite hosting service such as Godaddy, A2hosting, or Hostgator.

In this course, we will cover the components of the SQL language, and given you a very practical walk-through of using SQL to store, manage, and view your company's data.

Who this course is for:
  • Businessmen, Managers, or Executives
  • Beginner to Intermediate SQL developers
Course content
Expand all 16 lectures 02:42:47
+ Introduction
1 lecture 16:11

Setup your Computer for Local SQL Server Development by following along with the video instructions and using the links below:

  • https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
  • https://www.microsoft.com/en-us/sql-server/sql-server-downloads-free-trial
  • https://www.microsoft.com/en-us/download/details.aspx?id=49502
Preview 16:11
+ SQL Basics
6 lectures 01:00:17
SQL Data Types
11:06
Inserting Data
06:09
Updating Data
08:25

Here we cover extracting data with the SQL SELECT statement, and filtering data using a WHERE clause. 

The WHERE clause is followed by a condition where you would specify that a column's value must meet that condition to be included in the result set. Operators that you can use in your WHERE clause condition are as follows:


OperatorDescription
=Equal
<>Not equal. Note: In some versions of SQL this operator may be written as !=
>Greater than
<Less than
>=Greater than or equal
<=Less than or equal
BETWEENBetween an inclusive range
LIKESearch for a pattern
INTo specify multiple possible values for a column


Extracting Data
13:00
Deleting Data
06:22

Cover Some Basic SQL Questions

SQL Basics
3 questions
+ Relationships Between Sets of Data
2 lectures 19:33

Relational Databases essentially are a set of tables that are conceptually related to one another. This lecture will show you 1) An example of a conceptual relationship between data sets and 2) how to join those data sets for a full picture of your data.

Foreign Keys and Inner Joins
15:40

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

The RIGHT JOIN keyword returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side, when there is no match.

Outer Joins
03:53
+ SQL Aggregations
3 lectures 23:07
Group By and Having
16:17
MIN and MAX
02:58
COUNT, AVG, SUM
03:52
+ Packaging Functionality and Data Sets
3 lectures 35:41
Stored Procedures
11:20
Functions
14:33
Views
09:48