NUGGET ALERT:

New Series Release

Microsoft Visio 2010 for IT Professionals

		Member Sign In 1-888-507-6283

		Time Remaining
1-888-507-6283

Database Various SQL Languages

On-the-Job Training

IT TRAINING
The 24-Hour Solution

Try it out,
24 hrs for $24

Prepare for an upcoming exam. Make corporate training decisions without risk. Access all of our IT training for 24 hours. Learn More

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 series -- 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.

Videos
Purchase Options

	Title	Duration
	Introduction Overview of the series, what variations of SQL this series works with	00:08:23
	Database and Querying Concepts and Overview Terminology, ANSI standards, what is "null," default values, auto-incrementing columns	00:20:29
	SELECT: The Basics Querying data, selecting columns, basic filtering, basic sorting	00:21:01
	Filtering Data with WHERE Comparison operators, IN and BETWEEN operators, Boolean operators, IS operator, string and date delimiters, special functions like SOUNDEX and DIFFERENCE	00:20:19
	SELECT: Using Functions How to use common functions in the SELECT statement	00:19:32
	SELECT: Aggregates, GROUP BY, and HAVING Aggregate/set functions, COUNT, MAX, MIN, SUM, AVG, and so on, GROUP BY and HAVING clauses	00:22:09
	SELECT: Advanced Tricks TOP/LIMIT, sub-queries, table and column aliasing, DISTINCT, CASTing data types	00:26:52
	INSERT, DELETE, and UPDATE Queries Adding data, deleting data, and changing data; using SELECT in an INSERT, using TOP/LIMIT and WHERE	00:18:04
	SELECT: Multiple Tables CROSS JOIN, NATURAL JOIN, INNER JOIN, and OUTER JOINs	00:18:27
	SELECT: Advanced MUlti-Table Queries UNION operator, UNION JOIN, INTERSECT and EXCEPT operators	00:16:19
	Common SQL Functions Numeric functions, String functions, Date/Time functions	00:18:02
	Transactions START TRANSACTION / BEGIN WORK / BEGIN TRANSACTION, COMMIT, ROLLBACK, and transaction concepts	00:15:46
	Data Definition CREATE TABLE, common data types, ALTER TABLE, DROP TABLE	00:19:47
	Understanding Relational Data Creating primary keys, creating foreign key constrains, creating NOT NULL constraints, create UNIQUE constrains, creating CHECK constraints, understanding constraints' impact on relational data	00:23:47
	Speeding Up Queries, and Slowing them Down: Indexes Index concepts, CREATE INDEX, rebuilding/reorganizing indexes, DROP INDEX	00:23:34
	CAUTION: SQL Injection Attacks How they work, how to prevent them (escaping data and stored procedures)	00:22:06
	Tools for working with SQL phpMyAdmin, SQL Server Management Studio, MySQL Query Analyzer, Other Tools	00:17:31
	Cursors Introduction and concepts, OPEN and CLOSE, FETCH, downsides of cursors	00:20:12
	Database Design Principles First, Second, and Third Normal form; denormalization	00:28:42
	Advanced Database Capabilities Platform-specific features, triggers, XML data manipulation, background jobs, and so on.	00:21:06

RELATED SERIES
Cloud Computing Microsoft Scripting Advanced Windows PowerShell V2 Intuit Quickbooks Python Programming Python Language Agile Development and Project Management Java Programming For Developers Web Development Administering Internet Information Services 7.0 and 7.5 IIS Microsoft Programming Visual Basic 6.0 Distributed Applications

Which option is right for you?

Buy a Single Series

"Focus your training on one series, for one month, for one low price."

StreamOne SUBSCRIPTION

StreamOne is your monthly option for streaming access to Database Various SQL Languages. One multi-user license gives you and a small team access to one full series. Cancel at any time. A StreamOne subscription gives you plenty of time to explore the benefits of CBT Nuggets, while paying for just the specific series you want.

MULTI-USER

$199

per license

$499

Download

Download Database Various SQL Languages.

$499

DVD

Have Database Various SQL Languages delivered on DVD.

Buy an Annual Subscription to Everything IT

"Eliminate your limitations. An IT Nuggets streaming subscription puts our complete IT training library at the fingertips of IT pros."

All topics. From admin to programming.

IT Nuggets

Productivity for Companies and IT Advancement for Professionals

Get access to better training, and never lose it, with an IT Nuggets subscription. IT Nuggets is a multi-user product that supports all levels of your IT department, even as employees come and go. One locked-in rate gets you access to our IT training catalog, which is updated regularly and automatically at no additional charge. As long as your subscription is maintained, the rate won't change, and neither will your budget. Our full IT library is designed for Pros to keep current for career advancement and companies that want their IT Pros to reach their full potential.

YEARLY
MULTI-USER

$1999

per license

Bookmarks

NUGGET ALERT:

New Series Release

Database Various SQL Languages

On-the-Job Training

No Bookmarks