* Cantinho Satkeys

Refresh History
  • j.s.: bom fim de semana  49E09B4F
    23 de Novembro de 2024, 21:01
  • j.s.: try65hytr a todos
    23 de Novembro de 2024, 21:01
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana
    23 de Novembro de 2024, 12:27
  • JPratas: try65hytr A Todos  101yd91 k7y8j0
    22 de Novembro de 2024, 02:46
  • j.s.: try65hytr a todos  4tj97u<z 4tj97u<z
    21 de Novembro de 2024, 18:43
  • FELISCUNHA: dgtgtr  pessoal   49E09B4F
    20 de Novembro de 2024, 12:26
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    19 de Novembro de 2024, 02:06
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    16 de Novembro de 2024, 11:11
  • j.s.: bom fim de semana  49E09B4F
    15 de Novembro de 2024, 17:29
  • j.s.: try65hytr a todos  4tj97u<z
    15 de Novembro de 2024, 17:29
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    15 de Novembro de 2024, 10:07
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    15 de Novembro de 2024, 03:53
  • FELISCUNHA: dgtgtr   49E09B4F
    12 de Novembro de 2024, 12:25
  • JPratas: try65hytr Pessoal  classic k7y8j0 yu7gh8
    12 de Novembro de 2024, 01:59
  • j.s.: try65hytr a todos  4tj97u<z
    11 de Novembro de 2024, 19:31
  • cereal killa: try65hytr pessoal  2dgh8i
    11 de Novembro de 2024, 18:16
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    09 de Novembro de 2024, 11:43
  • JPratas: try65hytr Pessoal  classic k7y8j0
    08 de Novembro de 2024, 01:42
  • j.s.: try65hytr a todos  49E09B4F
    07 de Novembro de 2024, 18:10
  • JPratas: dgtgtr Pessoal  49E09B4F k7y8j0
    06 de Novembro de 2024, 17:19

Autor Tópico: The Complete SQL Course 2020: Become a MySQL Master  (Lida 215 vezes)

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

Online mitsumi

  • Moderador Global
  • ***
  • Mensagens: 117428
  • Karma: +0/-0
The Complete SQL Course 2020: Become a MySQL Master
« em: 24 de Junho de 2020, 15:46 »


The Complete SQL Course 2020: Become a MySQL Master
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 32 lectures (2h 35m) | Size: 1.05 GB
Become a SQL Master and kick Start Your First Job as a High Paid Enigneer!

What you'll learn:
Learn how to create and deal with databases
Learn CRUD operations and how to use them to make use out of your database
Grasp the concept of SQL clauses, functions, data types
How to write simple to complex SQL queries

Requirements
Just a computer

Description
You will learn to write SQL queries like a pro by building a real-world blog database

Here is a list of some of the things you will get after this course:

How to create your first database

How to create and delete your tables

How to perform CRUD operations

How to use SQL complex constraints

Running your first query

learn how to use Alters to tweak your columns and tables

learn and perform functions

create and understand complicated joins and unions and more..

More Specifically :

1-create database

2-create and deleting tables

3-insert

4-update and delete

5-data types

6-Conditional & comparison operators

7-basic queries

8-constraints (primary key, foreign key, and indexes)

9-functions (SUM-MIN-AVG-MAX-COUNT)

10-clauses (WHERE, ORDER by, DISTRICT, IN, GROUP By,)

11-alters

12-aliases

13-joins (INNER-RIGHT-LEFT)

14-UNIONS

15-wild cards

16-views

17-creating functions

18-triggers

Pretty cool huh? I hope you are ready for this journey.

Who this course is for
Anyone interested in learning SQL, MYSQL for software engineering, data analysis or big data
Screenshots


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

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction