password : almutmiz.net

Request course

طلب كورس

 
 
free-tutorials

SQL Mastery: From Zero to Superstar

password : almutmiz.net

   

Request course

طلب كورس

Written by sRT*

password : almutmiz.net

   

Request course

طلب كورس


SQL Mastery From Zero to Superstar

Description

Learning SQL was one of the most valuable skills I learned while building Match.  We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running.  The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.

I want to teach you how to start talking to databases through SQL, the universal language of SQL databases.  We will walk through

  • Basic selection statements
  • Joining multiple tables together
  • Grouping records to get aggregate data
  • Inserting, updating and deleting records
  • Creating tables and indexes
  • Subqueries to create sophisticated reports
  • Table constraints to keep data clean
  • Sequences to create auto incrementing fields
  • CTE – common table expressions that include recursive queries
  • Views to simply accessing complex queries
  • Conditional Expressions for queries
  • Window functions to combine regular queries with aggregate data
  • How to work with date, time and intervals
  • Create SQL Functions to capture complex statements
  • Create PL/pgSQL Functions that allow programming with if/then and loops
  • Triggers
  • Array data types
  • Composite data types
  • Transactions and concurrency control

Who this course is for:

  • Anyone needing to talk to a database
  • Entrepreneurs trying to build their MVP
  • Anyone wanting to learn advanced query expressions

Requirements

  • Basic computer skills
  • Ability to install basic software on your system
  • Computer that can run PostgreSQL database (I will show how to install.)

Last updated 5/2019

Download


Direct Download

SQL Mastery: From Zero to Superstar.zip | Mirror [Size: 5.5 GB]

Download Torrent (Please seed after downloading)


Download Torrent | Mirror

Source: https://www.udemy.com/sql-mastery-from-zero-to-superstar/



password : almutmiz.net

   

Leave a Comment

Facebook
Twitter
Google+0
Linkedin0
Total
0