* Cantinho Satkeys

Refresh History
  • andre pakete: boas tardes a todos voces e muito obrigados
    Hoje às 15:10
  • M@nolo: Boa Tarde a Todos  49E09B4F
    04 de Junho de 2020, 19:07
  • FELISCUNHA: ghyt74 pessoal  4tj97u<z
    04 de Junho de 2020, 09:27
  • FELISCUNHA: y5r6t j.s. abraço
    02 de Junho de 2020, 11:35
  • FELISCUNHA: ghyt74  Pessoal   49E09B4F
    02 de Junho de 2020, 11:34
  • j.s.: ghyt74 a todos  4tj97u<z
    02 de Junho de 2020, 10:52
  • FELISCUNHA: dgtgtr pessoal   49E09B4F
    01 de Junho de 2020, 12:04
  • delfim: ghyt74 2dgh8i
    31 de Maio de 2020, 11:53
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  101041
    31 de Maio de 2020, 10:01
  • FELISCUNHA: Bom dia  49E09B4F e votos de um bom fim de semana  4tj97u<z
    30 de Maio de 2020, 11:19
  • cereal killa: ghyt74 e bom fim semana  r4v8p
    30 de Maio de 2020, 08:30
  • j.s.: agradecemos aos membros Boavisteiro, Felizcunha e um membro anónimo  a sua contribuição para a manutenção do forum   h7t45
    29 de Maio de 2020, 22:24
  • j.s.: doação 2020 passem por aqui p.f.  [link]
    29 de Maio de 2020, 22:23
  • j.s.: try65hytr a todos
    29 de Maio de 2020, 22:20
  • _Zorro_: boas tardes
    29 de Maio de 2020, 18:13
  • delfim: ghyt74 2dgh8i
    29 de Maio de 2020, 11:45
  • FELISCUNHA: ghyt74 pessoal  49E09B4F
    29 de Maio de 2020, 11:06
  • fm: ghyt74 classic
    29 de Maio de 2020, 10:35
  • boavisteiro: Muito boa tarde  49E09B4F
    28 de Maio de 2020, 13:10
  • FELISCUNHA: j.s. enviei P.M  101041
    28 de Maio de 2020, 11:53

Autor Tópico: Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs  (Lida 8 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Offline mitsumi

  • Moderador
  • ***
  • Mensagens: 30419
  • Karma: +0/-0

Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 39 lectures (3h 42m) | Size: 1.1 GB
Learn to develop, code, & implement stored procedures, transactions, & cursors, in your SQL Server database using T-SQL.

What you'll learn:
Write bits of database code developers can call from other programs
Setup transactions, detect errors, and automatically rollback changes
Create reusable code to save time and make your queries easier to read
Use cursors to access specific rows withing a result.
Learn how to debug, that is troubleshoot, a stored procedure.

You should already be familiar with basic queries, such as SELECT, GROUP BY, and ORDER BY clauses.
Knowledge of basic programming concepts, such as IF/THEN is a plus, but not mandatory.

In this Course you will Learn to:

Use stored procedures to implement business logic.

Develop stored procedures from scratch!

Learn some basic troubleshooting skills.

Know the right way to use cursors.

Apply database transaction techniques to commit or rollback your database changes.

Trap and handle errors.

Nothing is worse than

Being excited to learn something new but not knowing where to start.

Wasting time learning the wrong features.

Being overwhelmed with options and not know which to use.

Imagine Having...

Knowledge - Knowing how to quickly write stored procedures to take your SQL to the next level.

Confidence - Feeling good that you're on the right track.

Accomplishment - Having a sense of accomplishment that you've learned something most cannot.

Fun - Having fun learning about cursors, stored procedures, and triggers!

By the time you've complete this course you'll have an appreciation of developing stored procedures, overcome your fear, and able to write stored procedures that pass parameters, handle errors, and rollback unintended database changes.

Now that's cool!

Who this course is for
Beginner SQL query authors curious about combining SQL statements into transactions.
Developers looking to for a better way to develop and manage database code.
Analysts looking to create advanced data sources from SQL Server from Power BI.
Developers wanting to learn about database cursors.
Anyone who thinks that stored procedures are really scary (they aren't!) :)


Download link:
Só visivel para registados e com resposta ao tópico.

Links are Interchangeable - No Password - Single Extraction