SQL - Beyond The Basics
Go beyond simple database creation and queries into subqueries, variables, functions and more.
SQL - Beyond The Basics udemy course
Go beyond simple database creation and queries into subqueries, variables, functions and more.
What you'll learn:
- create and interact with SQL databases at an intermediate to advanced level
- utilize subqueries, variables, custom functions and more
Requirements:
- a working knowledge of SQL fundamentals
Description:
In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL. You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking.
This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements. Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL.
Who this course is for:
- students who have taken the introductory SQL course or who have a basic understanding of SQL
- Kali Linux Tutorial For Beginners
- Palo Alto Firewalls Configuration By Example - PCNSE Prep Udemy
- The Ultimate Dark Web, Anonymity, Privacy & Security Course
- Python 3 For Offensive PenTest: A Complete Practical Course
Course Details:
-
4.5 hours on-demand video
-
1 article
-
1 downloadable resource
-
Full lifetime access
-
Access on mobile and TV
-
Certificate of completion
SQL - Beyond The Basics udemy free download
Go beyond simple database creation and queries into subqueries, variables, functions and more.
Demo Link: https://www.udemy.com/course/sql-beyond-the-basics/