Udemy - All The SQL You Will Need Unless You Are a DBA

seeders: 8
leechers: 8
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ TutGee.com ] Udemy - All The SQL You Will Need Unless You Are a DBA
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction
    • 1. Introduction.mp4 (498.9 MB)
    • 1. Introduction.srt (51.4 KB)
    • 1.1 The Big Four Statements You Are Going To Learn.odp (19.7 KB)
    10. Conclusion
    • 1. A Wrap Up Of The Big Picture.mp4 (55.1 MB)
    • 1. A Wrap Up Of The Big Picture.srt (4.3 KB)
    • 1.1 Conclusion.odp (25.6 KB)
    2. The Relational Database Model
    • 1. A Database Has Many Tables, Each Table Has Many Fields.mp4 (44.6 MB)
    • 1. A Database Has Many Tables, Each Table Has Many Fields.srt (7.4 KB)
    • 1.1 Intro To Relational Databases.odp (22.6 KB)
    • 2. How Tables Relate.mp4 (156.4 MB)
    • 2. How Tables Relate.srt (12.4 KB)
    • 2.1 Relationships.odp (20.6 KB)
    • 3. Creating A Database And First Table.mp4 (54.0 MB)
    • 3. Creating A Database And First Table.srt (4.5 KB)
    • 3.1 CREATE TABLE.odp (20.4 KB)
    • 3.2 CrtStd1.mp4 (175.4 MB)
    • 3.3 Four IDEs For Relational Databases.odp (25.0 KB)
    3. First Action Read Information From A Database Without Changing Anything
    • 1. Basics Of A SELECT Statement.mp4 (72.8 MB)
    • 1. Basics Of A SELECT Statement.srt (7.6 KB)
    • 1.1 Basic SELECT.odp (17.8 KB)
    • 1.2 What You Can Select.odp (21.8 KB)
    • 2. Options For The WHERE Clause.mp4 (135.3 MB)
    • 2. Options For The WHERE Clause.srt (15.5 KB)
    • 2.1 WHERE Clause.odp (19.7 KB)
    • 3. Using Between.mp4 (120.5 MB)
    • 3. Using Between.srt (7.6 KB)
    • 3.1 BETWEEN Clause.odp (25.5 KB)
    • 4. Using LIKE.mp4 (210.8 MB)
    • 4. Using LIKE.srt (15.7 KB)
    • 4.1 LIKE Clause.odp (22.0 KB)
    • 5. Using Sub SELECTs.mp4 (127.5 MB)
    • 5. Using Sub SELECTs.srt (9.4 KB)
    • 5.1 SUBSELECTs.odp (24.8 KB)
    • 6. SELECTing Information Using Functions.mp4 (354.0 MB)
    • 6. SELECTing Information Using Functions.srt (28.1 KB)
    • 6.1 Functions In General.odp (179.3 KB)
    • 6.2 StartingFunctions.mp4 (224.8 MB)
    • 7. Aggregate Functions.mp4 (260.0 MB)
    • 7. Aggregate Functions.srt (19.4 KB)
    • 7.1 Aggregate Functions.odp (39.2 KB)
    • 8. Other Special Techniques.mp4 (40.2 MB)
    • 8. Other Special Techniques.srt (5.4 KB)
    • 8.1 DISTINCT.mp4 (103.2 MB)
    • 8.2 The UNION Statement.odp (29.9 KB)
    4. The DELETE Statement - Be Careful!
    • 1. You Already Know The Most Important Part.mp4 (94.2 MB)
    • 1. You Already Know The Most Important Part.srt (6.2 KB)
    • 1.1 DELETE Statement.odp (21.1 KB)
    • 2. Techniques To Be Safe When You DELETE.mp4 (188.7 MB)
    • 2. Techniques To Be Safe When You DELETE.srt (14.4 KB)
    5. Using the UPDATE Statement
    • 1. Good News Again! You still know the most important part..mp4 (127.9 MB)
    • 1. Good News Again! You still know the most important part..srt (9.8 KB)
    • 1.1 The UPDATE Statement.odp (19.3 KB)
    6. Using The INSERT Statement
    • 1. Inserting A Single Row.mp4 (72.4 MB)
    • 1. Inserting A Single Row.srt (9.1 KB)
    • 1.1 The INSERT Statement.odp (22.5 KB)
    • 2. Inserting Multiple Rows.mp4 (233.0 MB)
    • 2. Inserting Multiple Rows.srt (17.8 KB)
    • 2.1 The INSERT Statement - Multiple Rows.odp (1.6 MB)
    7. Combining Tables Using JOINs
    • 1. Basic JOINs.mp4 (114.9 MB)
    • 1. Basic JOINs.srt (9.6 KB)
    • 1.1 JOINs.odp (47.4 KB)
    • 1.2 JOINs2.mp4 (161.6 MB)
    8. Combine Tables Using VIEWs
    • 1. Basics of VIEWs.mp4 (51.8 MB)
    • 1. Basics of VIEWs.srt (5.0 KB)
    • 1.1 Introductory views.odp (66.7 KB)
    9. SELECTing From Multiple Tables
    • 1. Multi-Table SELECTs.mp4 (219.7 MB)
    • 1. Multi-Table SELECTs.srt (15.3 KB)
    • 1.1 Multi Table SELECTS.odp (27.7 KB)
    • Bonus Resources.txt (0.3 KB)

Description

All The SQL You Will Need Unless You Are a DBA



MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 21 lectures (6h 9m) | Size: 3.36 GB
Learn Relational Database Concepts And How To Manipulate Data With SQL
What you'll learn:
The four actions a user or applications programmer can do to a relational database.
How a relational database works
The major relational databases available to everyone for practicing
Learn how to design a database, tables, and relationships

Requirements
None, just an interest in learning to be more knowledgeable and valuable in the job market.
A relatively modern computer or laptop. Anything from Windows 7 on up. Microsoft Access and Excel would be good to have.

Description
In this course we first get to understand how relational databases work. Relational databases are the backbone of how data is stored in the corporate world. Once we understand that, we focus on the four main SQL statements a business user and/or application programmer are likely to use. These four statements are SELECT(read data from the tables), INSERT(add row(s) to a single table), DELETE(delete rows from a single table), and UPDATE(change data in column(s) for selected records of a selected table). To do this we go into a number of related topics such as JOINs, VIEWs, functions, derived fields and more. The goal of the course is not just for you to learn the syntax of SQL statements. The goal of this course is for you to understand how databases are organized, the logic of them, the bigger picture of what 'relational' means, as well as how you can manipulate the data in them. In the course we will primarily use SQL Server, but reference Access and Excel a lot as most people without experience writing SQL will be more familiar with the concepts using these applications. What you know in Excel is relevant to databases. Functions are relevant. Constructing a formula is relevant. By the end of the class you will be very knowledgeable about relational databases and how to manipulate data using SQL.

Who this course is for
Programmers, students, or business users who want to be able to get information for themselves without having to go to the IT department.
Application programmers or programming students who are interested in integrating a database into a programming language(Python).

https://TutGee.com



Download torrent
3.8 GB
seeders:8
leechers:8
Udemy - All The SQL You Will Need Unless You Are a DBA

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
3.8 GB
seeders:8
leechers:8
Udemy - All The SQL You Will Need Unless You Are a DBA

Torrent hash: A811A6010F0500EC03C837FB84050DE574BDB21D