Burs kazanma şansı yakalayın!

İstediğiniz dersi ücretsiz alın ve para kazanın
Şu anda izleniyor
158 Öğrenciler
45 Ders
Başlangıç seviyesi

Ne Öğreneceksiniz?

  • The basics of coding in SQL How to write commands and queries Data types, tables and the rest of the core concepts of SQL

Müfredat

Bölüm 1: Manipulation
Lecture 1: Introduction
Lecture 2: Relational Databases
Lecture 3: Statements & creating tables
Lecture 4: Insert
Lecture 5: Select
Lecture 6: Alter
Lecture 7: Update
Lecture 8: Delete
Lecture 9: Constraints
Lecture 10: Summary
Bölüm 2: Queries
Lecture 1: Intro
Lecture 2: Select
Lecture 3: Aliases
Lecture 4: Distinct
Lecture 5: Where
Lecture 6: Like I
Lecture 7: Like II
Lecture 8: Is Null
Lecture 9: Between
Lecture 10: And
Lecture 11: Or
Lecture 12: Order By
Lecture 13: Limit
Lecture 14: Case
Lecture 15: Summary
Bölüm 3: Aggregate functions
Lecture 1: Intro
Lecture 2: Count
Lecture 3: Sum
Lecture 4: Min and Max
Lecture 5: Average
Lecture 6: Round
Lecture 7: Group By (Part 1)
Lecture 8: Group By (Part 2)
Lecture 9: Having
Lecture 10: Summary
Bölüm 4: Multiple tables
Lecture 1: Intro
Lecture 2: Combining Tables Manually
Lecture 3: Combining Tables
Lecture 4: Inner Join
Lecture 5: Left Join
Lecture 6: Primary Key vs Foreign Key
Lecture 7: Cross Join
Lecture 8: Union
Lecture 9: With
Lecture 10: Summary

Tanım

Gereksinimler

  • No pre-knowledge is required - enthusiasm is all you need! A PC or Mac is required. Mobile not supported yet; No special software is required in advance of the course.

Eğitmen hakkında

Yorumlar 696
Öğrenciler 275,476
Geniş kitle
Dersler 2