SQL: Beginner to Advanced
- 2.5 hours on-demand video
- 1 downloadable resource
- 1 Practice Test
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- A Mac or PC
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.
- Businessmen, Managers, or Executives
- Beginner to Intermediate SQL developers
Setup your Computer for Local SQL Server Development by following along with the video instructions and using the links below:
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:
|<>||Not equal. Note: In some versions of SQL this operator may be written as !=|
|>=||Greater than or equal|
|<=||Less than or equal|
|BETWEEN||Between an inclusive range|
|LIKE||Search for a pattern|
|IN||To specify multiple possible values for a column|
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.