Learning SQL Video Tutorial

Accra Metropolitan, Greater Accra Added at 05:47, 18 January 2017, Ad ID: 1001298975

Offer from Individual
 

LEARNING SQL
In this SQL training course, expert author Guy Vaccaro teaches you how to use SQL to manage data that is held in relational databases. This training course is designed for beginners who have no previous experience with SQL of any kind.

You will start by learning how to use SQL (Structured Query Language) to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. Guy then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types.

Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons.

SQL - BEYOND THE BASICS
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. Working files are included, allowing you to follow along with the author throughout the lessons.

Contents Include:
Learning SQL
01. Getting Started With Databases And SQL
02. Using SQL To Select And Filter Data
03. Functions, Grouping And Summarizing
04. Joining Tables
05. Data Modification
06. Creating And Altering Database Objects
07. SQL Summary
08. Conclusion

SQL Beyond The Basics
01. The Warm Up
02. Useful Skills
03. The Subquery
04. The CASE Statement
05. Numbering And Ranking
06. Functions
07. Views
08. Stored Procedures
09. Conclusions

 Share via Email
Views:25

Contact advertiser

Show other Ads of this user
Send message
Accra Metropolitan, Greater Accra Show on the map

Kwadwo On site since Jun 2016 See their other ads Kwadwo has verified:

  • Mark as Favourite
  • Print
  • Edit
  • Report