تفاصيل الدورة
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.
تحديث بتاريخ 29 January, 2015IT, Computing and Technology أسئلة ذات صلة
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Diploma in IT Communications John Academy98 درهم
1,396 درهممدة الدورة التدريبية: Upto 19 Hours - 154 درهم
360 درهممدة الدورة التدريبية: 1 To 2 Months - 10,898 درهممدة الدورة التدريبية: 12 Weeks دورة إفتراضية أونلاين