SQL Selecting, Ordering, & Filtering
SQL Server 2014
| Beginner
- 9 videos | 55m 15s
- Includes Assessment
- Earns a Badge
Manipulating databases is a necessary skill. Explore Structured Query Language (SQL) and dive into the architecture. Discover efficient and easily manageable databases using features like SELECT, data types, UPDATE, and ORDER BY.
WHAT YOU WILL LEARN
-
Use the select statement in sql queries
Use select to retrieve data from more than one table in sql
Use sql to create several data types
Use delete to remove data from a table in sql
Use update to change data in sql -
Use order by with results to sort data in sql
Use where to filter data and retrieve requested results in sql
Use all data management components in an example in sql
Describe sql and the query while demonstrating how to create a table and manipulate it
IN THIS COURSE
-
6m 55sFind out how to use the SELECT statement in SQL queries. FREE ACCESS
-
6m 30sIn this video, find out how to use the SELECT statement to retrieve data from more than one table in SQL. FREE ACCESS
-
3. Query Your Data Types in SQL4m 38sIn this video, you will learn how to use SQL to create several data types. FREE ACCESS
-
4. Deleting a Record Using a DELETE Query4m 42sIn this video, you will use the DELETE command to remove data from a table in SQL. FREE ACCESS
-
5. Introduction to Using UPDATE4m 50sIn this video, you will learn how to use UPDATE to change data in SQL. FREE ACCESS
-
6. Ordering Results with ORDER BY6m 10sTo sort data in SQL using ORDER BY, first find the results you want, then use ORDER BY to specify how you want them sorted. FREE ACCESS
-
7. Filter Results with WHERE Clause9m 21sLearn how to use the WHERE clause to filter data and retrieve the requested results in SQL. FREE ACCESS
-
8. Use Case Example Using Data Management Components7m 14sIn this video, learn how to use all data management components in an example using SQL. FREE ACCESS
-
9. Exercise: SQL Main Components and Why They're Used4m 56sAfter completing this video, you will be able to describe SQL and the query while demonstrating how to create a table and manipulate it. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
