Quantcast

Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

On-the-Job Training

This course will be retired in 292 days. If you have questions, please contact us.

Regardless of which database platform you use -- Oracle, SQL Server, MySQL, SQLite, PostgreSQL, and more -- learning industry-standard SQL query syntax will give your database efforts a real boost.

This Don Jones training shows you how to write simple and complex queries in industry-standard SQL syntax, adapt syntax to vendor-specific SQL variants, defend against attacks like SQL injection, understand and optimize database designs, and even help optimize query performance through indexing.

Every CBT Nuggets course -- whether it's certification track or, like this one, solely on-the-job training -- gives you the hands-on skills you need to be a more effective IT professional.

All trademarks and copyrights are the property of their respective holders....
Regardless of which database platform you use -- Oracle, SQL Server, MySQL, SQLite, PostgreSQL, and more -- learning industry-standard SQL query syntax will give your database efforts a real boost.

This Don Jones training shows you how to write simple and complex queries in industry-standard SQL syntax, adapt syntax to vendor-specific SQL variants, defend against attacks like SQL injection, understand and optimize database designs, and even help optimize query performance through indexing.

Every CBT Nuggets course -- whether it's certification track or, like this one, solely on-the-job training -- gives you the hands-on skills you need to be a more effective IT professional.

All trademarks and copyrights are the property of their respective holders.
 show less
1. Introduction (8 min)
2. Database and Querying Concepts and Overview (20 min)
3. SELECT: The Basics (21 min)
4. Filtering Data with WHERE (20 min)
5. SELECT: Using Functions (19 min)
6. SELECT: Aggregates, GROUP BY, and HAVING (22 min)
7. SELECT: Advanced Tricks (26 min)
8. INSERT, DELETE, and UPDATE Queries (18 min)
9. SELECT: Multiple Tables (18 min)
10. SELECT: Advanced MUlti-Table Queries (16 min)
11. Common SQL Functions (18 min)
12. Transactions (15 min)
13. Data Definition (19 min)
14. Understanding Relational Data (23 min)
15. Speeding Up Queries, and Slowing them Down: Indexes (23 min)
16. CAUTION: SQL Injection Attacks (22 min)
17. Tools for working with SQL (17 min)
18. Cursors (20 min)
19. Database Design Principles (28 min)
20. Advanced Database Capabilities (21 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
7 hrs 20 videos

COURSE RATING

Training Features


Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Bookmarks
Included in this course
Pick up where you left off watching a video.

Notes
Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.