Navegação em Árvore
expandir todos | recolher todos
  • Home
  • Udemy
  • 70-461 Session 6: Querying Microsoft SQL Server (SQL code)
Udemy
70-461 Session 6: Querying Microsoft SQL Server (SQL code)
USD 13,00
Ir para o curso

Precificação

Por Curso

Detalhes do Curso

en
en
Certificado gratuito
Rítmo flexível
Intermediário
6 horas

Instrutores

Sobre este Curso

Sobre este Curso

If you are in UfB, welcome.

If you are not, don’t buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012”.

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets, and in session 5 we learned about ranking and aggregate functions.

We’ll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We’ll be created correlated subqueries, where the results of the subquery depend on the main query. We’ll be looking at Common Table Expressions using the WITH statement, and we’ll be using what we have learned to solve a common business problem.

We’ll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We’ll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We’ll also look at sequences.

No prior knowledge other than what we covered in Sessions 1 to 5 is required. This course builds on the knowledge previously gained in those previous sessions.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write subqueries, functions, sequences and more, and we’ll have expanded on our current knowledge of T-SQL.

Cursos Relacionados

Udemy
Microsoft Access VBA, Design and Advanced Methods Workshop 7
USD 13.00
apenas este curso
Udemy
Excel Pivot Tables with Excel 2016: From Basic to PowerPivot
USD 13.00
apenas este curso
Udemy
Oracle Human Capital Management (HCM/HRMS)
USD 13.00
apenas este curso
Udemy
Microsoft Power BI Intermediate
Lee Hawthorn
4 horas
USD 13.00
apenas este curso
Udemy
MS Access Macros Series 4
ajay parmar
5 horas
USD 13.00
apenas este curso
Udemy
Oracle Data Integrator (ODI) 12c Admin Course
USD 13.00
apenas este curso
Udemy
Power Query for Excel and Power BI (Introductory Level)
USD 14.00
apenas este curso
Udemy
Database modeling with golang & postgresql
VJ Bambhaniya
3 horas
USD 13.00
apenas este curso
Udemy
Apache HBase : Hadoop Column Oriented NoSQL Database
Insculpt Technologies
4 horas
USD 13.00
apenas este curso
Udemy
SQL Foundations
USD 24.99
apenas este curso