FreeTutorials Us microsoft sql server 2012 certification 70 461 | 61CC84B1FB9501EF4D0DB9C40B3B9439C5DD0753

FreeTutorials Us microsoft sql server 2012 certification 70 461

Name	[FreeTutorials.Us] microsoft-sql-server-2012-certification-70-461	DOWNLOAD Copy Link
Total Size	1.6 GB
Total Files	151
Hash	61CC84B1FB9501EF4D0DB9C40B3B9439C5DD0753

/.../001-important-download-these-first-working-files/
MicrosoftSQLServer2012CertificationTrainingExam70461WorkingFiles.zip	255.4 MB
/01-introduction/
001-important-download-these-first-working-files.html	0.4 KB
002-what-to-expect-from-this-course.mp4	2.2 MB
003-course-overview.mp4	3.1 MB
004-understanding-databases.mp4	7.6 MB
005-transactsql-basics.mp4	6.1 MB
006-microsoft-sql-certification.mp4	5.2 MB
007-how-to-access-your-working-files.mp4	10.2 MB
/02-course-setup/
008-sql-server-2012-evaluation.mp4	5.9 MB
009-sql-server-2012-installation.mp4	8.0 MB
010-windows-8-server-2012-interface.mp4	6.5 MB
011-windows-7-interface.mp4	6.1 MB
012-sql-server-sample-database.mp4	4.4 MB
013-attaching-the-sample-database.mp4	14.0 MB
014-getting-help.mp4	17.8 MB
015-installing-sql-books-online.mp4	21.9 MB
/03-sql-server-2012-interface/
016-management-studio-basics.mp4	13.8 MB
017-connecting-to-sql-server.mp4	14.4 MB
018-customizing-ssms.mp4	18.9 MB
019-utilizing-diagrams.mp4	14.1 MB
020-saving-diagrams.mp4	8.4 MB
021-text-and-graphical-tools.mp4	10.0 MB
022-using-sample-code-files.mp4	7.2 MB
023-about-the-semicolon.mp4	3.6 MB
/04-database-objects-and-data/
024-0401-what-are-objects.mp4	10.5 MB
025-0402-understanding-tables.mp4	12.9 MB
026-0403-understanding-data-integrity.mp4	5.0 MB
027-0404-understanding-data-types.mp4	6.1 MB
028-0405-understanding-primary-keys.mp4	5.6 MB
029-0406-understanding-constraints.mp4	5.0 MB
030-0407-understanding-null.mp4	5.0 MB
031-0408-understanding-views.mp4	11.7 MB
032-0409-understanding-stored-procedures.mp4	14.5 MB
033-0410-understanding-triggers.mp4	2.8 MB
034-0411-understanding-synonyms.mp4	6.6 MB
/05-working-with-tables/
035-0501-creating-a-table.mp4	23.9 MB
036-0502-graphical-table-creation.mp4	7.8 MB
037-0503-changing-a-table.mp4	10.1 MB
038-0504-graphical-table-alterations.mp4	16.3 MB
039-0505-deleting-a-table.mp4	11.7 MB
040-0506-graphical-table-deletion.mp4	6.8 MB
041-0507-creating-a-primary-key.mp4	12.0 MB
/06-sql-query-basics/
042-0601-four-basic-queries.mp4	4.0 MB
043-0602-thinking-in-sql.mp4	5.4 MB
044-0603-options-and-more-options.mp4	5.4 MB
045-0604-good-query-structure.mp4	5.6 MB
046-0605-comments.mp4	7.1 MB
047-0606-the-use-command.mp4	5.5 MB
048-0607-the-go-command.mp4	7.2 MB
/07-the-basic-select-statement/
049-0701-select-basics.mp4	4.0 MB
050-0702-select-structure.mp4	3.9 MB
051-0703-using-where.mp4	9.2 MB
052-0704-using-top-to-limit-rows.mp4	13.0 MB
053-0705-ordering-results.mp4	13.1 MB
054-0706-working-with-nulls.mp4	8.8 MB
055-0707-tsql-concatenation.mp4	10.5 MB
/08-advanced-select-statements/
056-0801-column-aliasing.mp4	10.2 MB
057-0802-using-distinct.mp4	13.5 MB
058-0803-using-sum.mp4	13.0 MB
059-0804-using-avg.mp4	9.3 MB
060-0805-using-count.mp4	12.2 MB
061-0806-using-group-by.mp4	13.0 MB
062-0807-using-having.mp4	9.7 MB
063-0808-select-into.mp4	11.8 MB
064-0809-using-like-and-in.mp4	12.3 MB
065-0810-understanding-union.mp4	12.0 MB
066-0811-intersect-and-except.mp4	10.8 MB
067-0812-using-synonyms-part-1.mp4	11.9 MB
068-0813-using-synonyms-part-2.mp4	9.3 MB
069-0814-offsetfetch.mp4	10.6 MB
070-0815-what-is-ranking.mp4	4.9 MB
071-0816-using-ranking.mp4	13.6 MB
072-0817-more-ranking-examples.mp4	18.0 MB
/09-using-joins/
073-0901-understanding-joins.mp4	6.5 MB
074-0902-join-query-structure.mp4	7.2 MB
075-0903-creating-inner-joins-part-1.mp4	10.2 MB
076-0904-creating-inner-joins-part-2.mp4	9.2 MB
077-0905-join-creation-through-gui.mp4	11.0 MB
078-0906-creating-outer-joins.mp4	9.6 MB
079-0907-creating-cross-joins.mp4	9.8 MB
/10-modifying-data/
080-1001-the-insert-statement.mp4	16.6 MB
081-1002-using-insert-part-1.mp4	12.5 MB
082-1003-using-insert-part-2.mp4	9.1 MB
083-1004-the-update-statement.mp4	17.4 MB
084-1005-using-update.mp4	13.6 MB
085-1006-the-delete-statement.mp4	2.8 MB
086-1007-using-delete-part-1.mp4	10.0 MB
087-1008-using-delete-part-2.mp4	6.5 MB
/11-using-subqueries/
088-1101-understanding-subqueries.mp4	5.1 MB
089-1102-subquery-versus-join.mp4	3.9 MB
090-1103-creating-a-scalar-subquery.mp4	7.6 MB
091-1104-creating-a-multivalued-subquery.mp4	8.9 MB
092-1105-creating-a-correlated-subquery.mp4	11.8 MB
/12-advanced-table-utilization/
093-1201-utilizing-memory.mp4	2.6 MB
094-1202-what-is-a-derived-table.mp4	6.5 MB
095-1203-creating-a-derived-table.mp4	13.4 MB
096-1204-table-variables-part-1.mp4	8.3 MB
097-1205-table-variables-part-2.mp4	15.0 MB
098-1206-common-table-expressions.mp4	9.3 MB
099-1207-temporary-tables.mp4	7.2 MB
/13-programmability/
100-1301-programmability-in-tsql.mp4	5.7 MB
101-1302-what-is-a-stored-procedure.mp4	10.1 MB
102-1303-why-use-stored-procedures.mp4	5.0 MB
103-1304-a-simple-stored-procedure.mp4	9.5 MB
104-1305-input-parameters.mp4	12.7 MB
105-1306-multiple-input-parameters.mp4	8.8 MB
106-1307-output-parameters-part-1.mp4	10.2 MB
107-1308-output-parameters-part-2.mp4	10.5 MB
108-1309-using-case-logic-part-1.mp4	11.2 MB
109-1310-using-case-logic-part-2.mp4	11.8 MB
110-1311-handling-errors.mp4	9.7 MB
111-1312-stored-procedure-security.mp4	4.3 MB
112-1313-working-with-functions.mp4	3.1 MB
113-1314-using-builtin-functions.mp4	11.7 MB
114-1315-creating-a-scalar-function.mp4	10.3 MB
115-1316-creating-a-table-valued-function.mp4	10.2 MB
116-1317-what-is-dynamic-sql.mp4	3.3 MB
117-1318-dynamic-sql-example.mp4	10.4 MB
118-1319-understanding-guids.mp4	5.0 MB
119-1320-guid-examples-part-1.mp4	6.6 MB
120-1321-guid-examples-part-2.mp4	9.3 MB
/14-triggers/
121-1401-using-triggers.mp4	4.7 MB
122-1402-inserted-and-deleted-tables.mp4	3.7 MB
123-1403-trigger-examples-part-1.mp4	10.8 MB
124-1404-trigger-examples-part-2.mp4	10.4 MB
/15-transactions-in-tsql/
125-1501-what-are-transactions.mp4	4.6 MB
126-1502-understanding-concurrency.mp4	6.6 MB
127-1503-explicit-and-implicit-transactions.mp4	4.5 MB
128-1504-cross-platform-concerns.mp4	3.1 MB
129-1505-transaction-and-locking-example.mp4	13.1 MB
/16-under-the-hood/
130-1601-using-metadata.mp4	7.3 MB
131-1602-using-catalog-views.mp4	12.3 MB
132-1603-using-information-schema-views.mp4	9.1 MB
133-1604-using-system-stored-procedures.mp4	10.5 MB
/17-working-with-xml/
134-1701-xml-basics.mp4	5.5 MB
135-1702-outputting-xml-from-queries.mp4	4.6 MB
136-1703-using-for-xml-raw.mp4	13.2 MB
137-1704-using-for-xml-auto.mp4	11.9 MB
138-1705-using-for-xml-path.mp4	12.8 MB
/18-optimizing-queries/
139-1801-optimization-basics.mp4	5.7 MB
140-1802-query-execution-plans-part-1.mp4	3.9 MB
141-1803-query-execution-plans-part-2.mp4	15.1 MB
142-1804-sql-server-extended-events-part-1.mp4	2.9 MB
143-1805-sql-server-extended-events-part-2.mp4	13.4 MB
144-1806-sql-server-profiler.mp4	12.8 MB
/19-taking-the-exam/
145-1901-exam-basics.mp4	5.3 MB
146-1902-taking-your-exam.mp4	6.0 MB
147-1903-when-it-is-over.mp4	3.9 MB
/20-conclusion/
148-2001-wrapup.mp4	2.9 MB
/
[FreeTutorials.Us].txt	0.1 KB
Freetutorials.Us.url	0.1 KB
Total files 151