FileMood

Download Querying Microsoft SQL Server 2012 (Exam 70-461) Course

Querying Microsoft SQL Server 2012 Exam 70 461 Course

Name

Querying Microsoft SQL Server 2012 (Exam 70-461) Course

  DOWNLOAD Copy Link

Trouble downloading? see How To

Total Size

1.3 GB

Total Files

112

Hash

63F5FCBBC2EC0B5168A5DBDA72D8F60B4254E738

/01. Introduction/

01. Welcome.flv

1.9 MB

02. Course Overview.flv

5.4 MB

03. Understanding SQL.flv

7.7 MB

04. Understanding TSQL.flv

5.9 MB

05. SQL Server History.flv

7.1 MB

06. Microsoft SQL Server Certifications.flv

5.7 MB

/02. Getting Set Up/

01. Getting SQL Server 2012.flv

7.4 MB

02. Installing SQL Server 2012.flv

15.9 MB

03. Attaching the Sample Database.flv

8.6 MB

04. Getting SQL Books Online Locally.flv

9.5 MB

05. Code Examples.flv

2.7 MB

/03. SQL Server 2012 Management Studio/

01. SSMS Tour.flv

12.5 MB

02. Graphical Queries.flv

14.0 MB

03. SSMS Options.flv

15.3 MB

04. Query Results Options.flv

17.8 MB

05. Database Diagrams.flv

14.8 MB

/04. Creating Database Objects/

01. Table Design Basics.flv

7.2 MB

02. Creating a Table.flv

30.2 MB

03. Altering Tables.flv

13.8 MB

04. Dropping Tables.flv

8.1 MB

05. Understanding Views.flv

7.7 MB

06. Creating Views pt. 1.flv

15.1 MB

07. Creating Views pt. 2.flv

16.9 MB

08. Dropping Views.flv

6.1 MB

09. Understanding Constraints.flv

9.1 MB

10. Creating Constraints.flv

13.0 MB

11. Understanding Triggers.flv

8.9 MB

12. Trigger Options.flv

7.3 MB

13. Inserted and Deleted Tables.flv

5.2 MB

14. Creating Triggers.flv

14.1 MB

/05. Basic Select Queries/

01. The Basic Select Statement.flv

17.5 MB

02. Select Statement Structure.flv

13.7 MB

03. The FROM Clause.flv

5.9 MB

04. The WHERE Clause.flv

7.7 MB

05. WHERE Clause Example.flv

13.0 MB

06. The ORDER BY Clause.flv

6.8 MB

07. ORDER BY Example.flv

19.9 MB

08. The GROUP BY Clause pt. 1.flv

15.1 MB

09. The GROUP BY Clause pt. 2.flv

16.1 MB

10. The HAVING Clause.flv

15.6 MB

11. The Power of LIKE.flv

11.6 MB

/06. More Advanced Select Statements/

01. Using Distinct.flv

12.7 MB

02. Column Aliasing.flv

17.3 MB

03. Using the Top Option.flv

7.2 MB

04. Top Option Example.flv

12.8 MB

05. Using the OFFSET-FETCH Option.flv

15.9 MB

06. Understanding NULLs.flv

9.1 MB

07. Working with NULLs.flv

12.6 MB

08. Using the Case Statement.flv

16.9 MB

09. SELECT INTO.flv

11.2 MB

10. The UNION Statement.flv

18.4 MB

11. Using INTERSECT.flv

16.5 MB

12. Using EXCEPT.flv

17.6 MB

13. Understanding Synonyms.flv

5.9 MB

14. Creating and Using Synonyms.flv

7.1 MB

15. Using Concatenation.flv

11.1 MB

16. Dynamic Queries pt. 1.flv

11.6 MB

17. Dynamic Queries pt. 2.flv

15.2 MB

18. INSERT Into.flv

11.0 MB

/07. SQL Server 2012 Data Types/

01. Understanding GUIDs.flv

10.0 MB

02. NEWID() vs. NEWSEQUENTTIALID().flv

9.4 MB

03. Using GUIDs.flv

13.0 MB

04. Data Type Basics.flv

15.9 MB

05. Numerical Data Types.flv

8.0 MB

06. Character Data Types.flv

7.6 MB

07. Date and Time Data Types.flv

7.1 MB

08. Binary Data Types.flv

4.7 MB

/08. Using Joins/

01. Understanding Joins.flv

7.2 MB

02. Table Aliasing.flv

7.1 MB

03. Inner Joins.flv

23.1 MB

04. Outer Joins.flv

15.2 MB

05. Cross Joins.flv

12.6 MB

06. The Merge Statement pt. 1.flv

25.0 MB

07. The Merge Statement pt. 2.flv

16.5 MB

/09. Querying Metadata/

01. Catalog Views.flv

21.4 MB

02. Information Schema Views.flv

10.4 MB

03. System Stored Procedures.flv

18.5 MB

/10. Inserts Updates Deletes/

01. The Basic INSERT Statement.flv

18.0 MB

02. INSERT Examples.flv

12.0 MB

03. The Basic UPDATE Statement.flv

4.4 MB

04. UPDATE Examples.flv

10.7 MB

05. The Basic DELETE Statement.flv

5.1 MB

06. DELETE Examples.flv

8.8 MB

07. Using ROWCOUNT.flv

13.7 MB

/11. Subqueries/

01. Scalar Subqueries.flv

9.0 MB

02. Multi-Valued Subqueries.flv

13.1 MB

03. Correlated Subqueries.flv

13.9 MB

/12. Table Expressions/

01. Understanding Temporary Results Sets.flv

6.3 MB

02. Understanding Derived Tables.flv

9.1 MB

03. Understanding Common Table Expressions.flv

5.2 MB

04. Using CTEs.flv

12.7 MB

05. Understanding Temporary Tables.flv

9.4 MB

06. Table Variables.flv

12.8 MB

07. Temporary Table or Table Variable.flv

5.5 MB

/13. Stored Procedures/

01. Understanding Stored Procedures.flv

7.9 MB

02. Creating a Stored Procedure.flv

11.9 MB

03. Using Input Parameters.flv

16.2 MB

04. Stored Procedure Return Codes.flv

10.3 MB

05. Stored Procedure Permissions.flv

5.2 MB

/14. Functions/

01. Understanding Functions.flv

6.2 MB

02. Built-in Functions.flv

12.2 MB

03. Scalar Functions Example.flv

15.8 MB

04. Table Valued Functions Example pt. 1.flv

13.4 MB

05. Table Valued Functions Example pt. 2.flv

16.1 MB

/15. Transactions/

01. Understanding Concurrency.flv

6.7 MB

02. Understanding Transactions.flv

8.0 MB

03. Coding Explicit Transactions.flv

12.3 MB

04. Transactions and Locking.flv

11.7 MB

/16. Conclusion/

01. Course Wrap Up.flv

5.2 MB

/17. Credits/

01. About the Author.flv

3.9 MB

/

Torrent downloaded from demonoid.ph.txt

0.0 KB

/Workfiles/

sqlserverquery70461.zip

1.2 MB

 

Total files 112


Copyright © 2025 FileMood.com