SQL - Beyond The Basics Training Video

Courses For Success

AU$ 189 - (133 )

Informazioni importanti

  • Corso
  • Online
  • Quando:

A Practical Training Course That Teaches Real World Skills In this project-based SQL - Beyond The Basics video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality SQL - Beyond The Basics training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex SQL - Beyond The Basics subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of SQL - Beyond The Basics tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 4.25 hours to complete this course 44 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course 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...

Informazioni importanti

Requisiti: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...


Dove e quando

Inizio Luogo

Cosa impari in questo corso?

Skills and Training


  • 01. The Warm Up
    • About This SQL Advanced Title
    • About The Author
    • Relational Databases And Key Terms Explained
    • Recap Of SQL SELECT Command
    • Overview Of The Other DML Statements
    • 0106 How To Access Your Working Files
    • Installing The Sample Data And Using The Working Files
  • 02. Useful Skills
    • 0201 Converting Datatypes
    • 0202 Creating A Temporary Table
    • 0203 The DISTINCT And TOP Keywords In Action
    • 0204 Indexing To Speed Up Your Life
    • 0205 Declaring And Using Variables
  • 03. The Subquery
    • 0301 What Is A Subquery?
    • 0302 Subquery Vs Joins
    • 0303 Using Correlated Subqueries
    • 0304 Using The EXISTS Keyword
    • 0305 Finding Duplicate Records
  • 04. The CASE Statement
    • 0401 Getting Started With The CASE Statement
    • 0402 Using The CASE Statement With Criteria On Multiple Columns
    • 0403 Multiple Criteria Within The CASE Statement
    • 0404 CASE In WHERE, ORDER BY, And GROUP BY Clauses
    • 0405 CASE In UPDATE And INSERT Statements
    • 0406 CASE Within Subqueries
  • 05. Numbering And Ranking
    • 0501 Numbering Or Ranking Records In A SELECT Statement
    • 0502 Filtering Results Based On Numbering Ranking
    • 0503 Using Numbering Within Groups
    • 0504 Filtering A Ranked Group To Determine Top N
  • 06. Functions
    • 0601 Using Built In Functions
    • 0602 Creating And Using Your Own Functions (UDF)
    • 0701 Creating A View
    • 0702 Example Views And Views In Views
    • 0703 Using The UNION Clause
  • 08. Stored Procedures
    • 0801 What Is A Stored Procedure?
    • 0802 Creating A Stored Procedure
    • 0803 Running A Stored Procedure
    • 0804 Stored Procedures Within Stored Procedures
    • 0805 The Global Variables @@Identity And @@Rowcount
    • 0806 Looping With WHILE And IF
    • 0807 Dynamically Build SQL Statements
    • 0808 TRY And CATCH For Error Trapping
    • 0809 Cursors In Use - Part 1
    • 0810 Cursors In Use - Part 2
    • 0811 Use Of Transactions
  • 09. Conclusions
    • 0901 Wrap Up

Ulteriori informazioni

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...