Top videos | bSocially Watch

Home

Top videos

All Time

Today

This week

This month

This year

TOP 5 BEST LAPTOPS UNDER 30000 ⚡⚡⚡ Best Budget Laptops To Buy In 2019 bsocially 5 Views • 3 years ago

Friends, today we bring you best laptops currently available in Indian market. We are almost at the end of the year and if you are in the market with a budget of around 30,000 rupees these are your best bets. We have ensured that the minimum configurations of these laptops include Core i3 8th Gen, 1 TB HDD, Windows 10 Pre-installed Out Of The Box, 4GB RAM and Min. 14” Screen Size. So Do Watch This Video Till The End and Don’t forget to like and share this video.

Acer Aspire 3 : http://bit.ly/34EdEyf
Asus VivoBook 15 : http://bit.ly/2SaUcpZ
Lenovo Ideapad 330s : http://bit.ly/2Q2lLiQ
Acer Aspire 5s : https://amzn.to/34FZrRg
Lenovo Ideapad S145 : https://amzn.to/2PDOZWa

For enquires or product promotions get in touch with us on Youtube@trak.in

आपको अगर कोई सवाल है तोह जरूर कमैंट्स में हमें बताईये - अगर वीडियो अच्छा लगा तोह लिखे और सब्सक्राइब जरूर कीजियेगा
****************************************************************

Latest Videos on
*****************************************************************
Realme X2 Pro Unboxing & First Impressions ⚡ Other Flagships, Better Watch Out! - https://www.youtube.com/watch?v=_8mkNVPqSn0

ColorOS 7 Update Hands-On & First Look ⚡⚡⚡ Its A Seriously BIG Upgrade - https://www.youtube.com/watch?v=RkUavW6-218

Top 10+ Best Upcoming Mobile Phones in December 2019 ⚡⚡⚡⚡ - https://www.youtube.com/watch?v=6qXQPQPtAgw

Our Recommendations
***************************************************************
*Best Smartphones under 15000*
Asus Zenfone Max Pro M2 - http://fkrt.it/XwbZR2NNNN
Redmi Note 7 Pro - http://fkrt.it/ADKKynuuuN
Redmi Note 7 - http://fkrt.it/u2QoeKNNNN
Honor Play: https://amzn.to/2zM68oN
Huwei Y9 2019: https://amzn.to/2WgqHlK
Samsung Galaxy M30: https://amzn.to/2U9Grtr

Social Media Handles
*****************************************************************
Follow us on:
Web: http://trak.in
Instagram: http://instagram.com/trakintech
Twitter: http://www.twitter.com/trakintech
Twitter personal: http://www.twitter.com/8ap
Facebook: http://www.facebook.com/TrakinTech
English Trakin Tech Youtube Channel - http://www.youtube.com/TrakinTechEnglish
******************************************************************

*Official Giveaway / Contest Rules*
a. All entries need to comply with YouTube Community Guidelines (http://www.youtube.com/t/community_guidelines) and entries which don’t comply will be disqualified.
b. This Giveaway/Contest is wholly compliant & consistent with Youtube Terms of Service
c. This Giveaway/Contest is conducted by TrakinTech and is not sponsored by Youtube
d. Privacy - All the data we collect from participants will be used only for Giveaway / Contest purposes only. We will not share or sell this data to anyone.
e. All Giveaway / Contests are conducted in a fair and impartial manner! - bsocially

Learn PostgreSQL Tutorial - Full Course for Beginners bsocially 10 Views • 3 years ago

Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems.

⭐️ Contents ⭐️
⌨️ (0:03:16) What is a Database
⌨️ (0:05:17) What is SQL And Relational Database
⌨️ (0:09:10) What is PostreSQL AKA Postrgres
⌨️ (0:10:53) PostgreSQL Installation (Mac OS)
⌨️ (0:14:21) PostgreSQL Installation (Windows)
⌨️ (0:17:38) GUI Clients vs Terminal/CMD Clients
⌨️ (0:21:39) Setup PSQL (MAC OS)
⌨️ (0:25:22) Setup PSQL (Windows)
⌨️ (0:30:15) How to Create Database
⌨️ (0:33:35) How to Connect to Databases
⌨️ (0:38:12) A Very Dangerous Command
⌨️ (0:41:37) How To Create Tables
⌨️ (0:45:46) Creating Tables Without Constraints
⌨️ (0:49:12) Creating Tables with Constraints
⌨️ (0:55:55) Insert Into
⌨️ (0:59:14) Insert Into Example
⌨️ (1:02:36) Generate 1000 Rows with Mockaroo
⌨️ (1:12:28) Select From
⌨️ (1:15:18) Order By
⌨️ (1:19:53) Distinct
⌨️ (1:21:59) Where Clause and AND
⌨️ (1:25:29) Comparison Operators
⌨️ (1:29:35) Limit, Offset & Fetch
⌨️ (1:32:43) IN
⌨️ (1:35:43) Between
⌨️ (1:37:45) Like And iLike
⌨️ (1:43:10) Group By
⌨️ (1:46:41) Group By Having
⌨️ (1:52:08) Adding New Table And Data Using Mockaroo
⌨️ (1:55:40) Calculating Min, Max & Average
⌨️ (1:59:48) Sum
⌨️ (2:01:55) Basics of Arithmetic Operators
⌨️ (2:05:59) Arithmetic Operators (ROUND)
⌨️ (2:09:43) Alias
⌨️ (2:12:32) Coalesce
⌨️ (2:16:15) NULLIF
⌨️ (2:20:21) Timestamps And Dates Course
⌨️ (2:23:21) Adding And Subtracting With Dates
⌨️ (2:25:58) Extracting Fields From Timestamp
⌨️ (2:27:28) Age Function
⌨️ (2:29:24) What Are Primary Keys
⌨️ (2:31:23) Understanding Primary Keys
⌨️ (2:36:26) Adding Primary Key
⌨️ (2:40:55) Unique Constraints
⌨️ (2:49:15) Check Constraints
⌨️ (2:54:45) How to Delete Records
⌨️ (3:01:36) How to Update Records
⌨️ (3:05:55) On Conflict Do Nothing
⌨️ (3:11:09) Upsert
⌨️ (3:16:41) What Is A Relationship/Foreign Keys
⌨️ (3:19:48) Adding Relationship Between Tables
⌨️ (3:25:04) Updating Foreign Keys Columns
⌨️ (3:29:30) Inner Joins
⌨️ (3:35:17) Left Joins
⌨️ (3:40:53) Deleting Records With Foreign Keys
⌨️ (3:47:27) Exporting Query Results to CSV
⌨️ (3:50:42) Serial & Sequences
⌨️ (3:57:18) Extensions
⌨️ (3:59:39) Understanding UUID Data Type
⌨️ (4:05:54) UUID As Primary Keys
⌨️ (4:16:30) Conclusion

✏️ Course from Amigoscode.
? Subscribe to Amigoscode YouTube channel | http://bit.ly/2HpF5V8
? Visit Amigoscode.com for more courses | http://bit.ly/2JgGW0w
? Full Playlist Available Here | http://bit.ly/2ClGPdY
? Follow Amigoscode on Instagram | http://bit.ly/2TSkA9w
? Join Amigoscode Closed Facebook Group | http://bit.ly/2FbuIkx

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org

And subscribe for new videos on technology: https://youtube.com/subscripti....on_center?add_user=f - bsocially

How to Fix Road Spaghetti & One Way No No's! - FIX IT Cities: Skylines bsocially 9 Views • 3 years ago

How to Fix your Cities in Cities Skylines - Fixing Road Spaghetti!
➤Want me to FIX your City? 1) Upload the city save to Steam Workshop 2) send me the link here or on Twitter (@Biffa2001) 3) Tell me what you want FIXED! Parks? Industry? Mass Transit? Traffic? Let me know!

➤Want a District or Park Named after you? Support me on Patreon:
- http://www.patreon.com/Biffa2001

➤City made by Stephen Galloway
Pre Fix - https://steamcommunity.com/sha....redfiles/filedetails
Post Fix - https://steamcommunity.com/sha....redfiles/filedetails

➤Buy Cities Skylines Industries via my Affiliate link & support the channel: https://paradoxinteractive.pxf.....io/c/1318251/524451

➤Join My Discord:
- https://discord.gg/joinbiffa

➤Where to FOLLOW Me:
- Indie Games: https://www.youtube.com/BiffaPlaysIndie
- Strategy Games: https://www.youtube.com/BiffaPlaysStrategy
- Minecraft: https://www.youtube.com/BiffaPlaysMinecraft
- Livestream: http://www.twitch.tv/biffa2001
- Twitter: @biffa2001

➤Mods & Assets List for this series (no time to add to a collection yet, if myself or someone else does it I'll add that link here too):
https://pastebin.com/Wq5YPEug

➤Kerrisdale Bay Map by Sidai:
https://steamcommunity.com/sha....redfiles/filedetails

PLAYLISTS:

➤Current Series (Kerrisdale Map): https://www.youtube.com/playli....st?list=PLR5G_Kc9r-J

➤Cities Skylines Project Dam Snow: https://www.youtube.com/playli....st?list=PLR5G_Kc9r-J
➤Cities Skylines Industries: https://www.youtube.com/playli....st?list=PLR5G_Kc9r-J
➤Cities Skylines Real Time: https://www.youtube.com/playli....st?list=PLR5G_Kc9r-J
➤Cities Skylines Parklife: https://www.youtube.com/playli....st?list=PLR5G_Kc9r-J
➤Cities Skylines Maximum Disasters: https://www.youtube.com/playli....st?list=PLR5G_Kc9r-J
➤Cities Skylines Green Cities: https://goo.gl/pB28pS
➤Cities Skylines Gameplay Mass Transit: https://goo.gl/LIldsj
➤Cities Skyline Natural Disaster Comedy Short
"DISASTER STRIKES LONDON!":
https://youtu.be/ysY0glb22x4
➤Cities Skyline Natural Disaster (inc Scenarios): https://goo.gl/hgXj4c
➤Cities Skylines Unlimited Mods: https://goo.gl/LBzkua
➤Cities Skylines: Snowfall DLC: https://goo.gl/jD8g5G
➤Cities Skylines: After Dark DLC: https://goo.gl/MCNlgW
➤Cities Skylines: Heavenly Island Map: https://goo.gl/bVZGsE
➤Cities Skylines: https://goo.gl/iO3cjK

Enjoy my Cities Skylines Gameplay. Industries is the latest expansion for Cities: Skylines, the award-winning city-building game, adding new ways for players to build earth-friendly towns.

In one of the most in-depth expansions in Cities: Skylines history, Industry becomes a larger and more meaningful part of the game with this expansion. Players can customize their industrial areas with supply chains for the four different resource types and unique factories. Well managed industry areas will level up and become more efficient. Aside from production chains, there is a new city service for handling mail and the cargo airport eases import and export of factory goods. There are FIVE new maps, new policies, new city services, new buildings (including resource extractors, manufacturers, warehouses and unique factories) and more.

Key Features:

- MAKE IT HAPPEN
Follow your products from harvesting to processing, storage and production, then transport them to commercial zones or export to other cities.

- CAPTAIN YOUR OWN INDUSTRIES
Define an area with the industry area tool and place highly specialized industrial buildings to build and manage the production chain from raw material extraction up to final end product. Industry Areas are divided into four types based on the natural resource they are processing: Farming, Forest, Ore and Oil. These areas can level up upon reaching productions goals and staffing requirements.

- BUILD IT UP, BUTTERCUP
New industrial buildings include Extractors, Warehouse Facilities, Processing and Auxiliary Buildings, Industrial Props and Roads. Unique Factories, such as Food, Toy, Furniture, Car and Electronics produce luxury products, and require a large number of workers, water and electricity as well as input from your industries.

- SHIP IT
Manage traffic and logistics with industrial warehouses and the use of the new Cargo Services including a cargo airport.
GO POSTAL
Boost your citizens’ well-being with mail delivery and collection services. Post sorting facilities handle mail between outside connections and the post offices, and new Post Van and Truck vehicles enable the carriage.

- WONK HARD
Three new Industry Policies and four City-wide Policies, including Workers’ Union, Sorting, Tolls, Wi-Fi, Logistics, Work Safety and Automation.

#citiesskylines #biffaplays #CSFixIt - bsocially