Lynda - SQL Essential Training (2019)

SQL Essential Training

English | 3h | Video 720p | Subtitles

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.


Download

 

 

This course was created by Bill Weinman. We are pleased to offer this training in our library.

Topics include:

 

How databases are organized

Selecting rows and columns

Creating new tables

Inserting and updating data

Sorting and filtering

Accessing related tables with JOIN

Working with strings

Understanding numeric types

Using aggregate functions and transactions

Automating data with triggers

Creating views

Using CRUD functions

 

Homepage:

https://www.lynda.com/SQL-tutorials/SQL-Essential-Training-REVISION-Q1-2020/2825374-2.html

 

Lynda - SQL Essential Training (2019)

Download


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.


Udemy - Turkce Gorsel Ogrenme Setleri
Videohive Wow Pack Series


rss