BlogHide Resteemsshiraz480 (27)in technology • 6 years agowhat a GoalsFifa is my life ▶️ DTube ▶️ IPFSshiraz480 (27)in technology • 6 years agoweb developer bootcampThere's a new technology to store and manage data across the internet and other computing networks, it's called blockchain or distributed ledger technology, DLT, and it was created as a result of…shiraz480 (27)in technology • 6 years agoBlockchainOverviewThere's a new technology to store and manage data across the internet and other computing networks, it's called blockchain or distributed ledger technology, DLT, and it was created as a result of…shiraz480 (27)in blockchain • 6 years agoThe Energy Sector and BlockchainMost of us take energy for granted. We turn on a light and it works. It powers our homes and the economies of the world. Over the past century, low-cost electricity has powered the biggest…shiraz480 (27)in technology • 6 years agoExcel-- Hide and unhide columns and rows(quick)(upbeat music) - [Narrator] If there's data taking up space in your sheet that you don't want to see, but you don't want to delete it, then you can hide it. Right-click on a column or row header and…shiraz480 (27)in creation • 6 years agoExcel-- Encrypt a workbook with a password (Quick trick)(upbeat music) - [Narrator] Protecting an Excel file with a password is a good way to prevent unauthorized people from accessing the data in your workbook. To password protect an Excel document, go…shiraz480 (27)in bitcoin • 6 years agoMining Bitcoin 2018As you saw earlier, transactions on the Bitcoin network get confirmed by computers that compete to solve cryptographic puzzles. This process is called mining, because whoever solves the problem gets…shiraz480 (27)in technology • 6 years agoconclusion[Instructor] You should now have a good idea of what it's like to work with databases in SQL Server 2017. We touched on many of the basic concepts but there's always more to learn. Here's a couple…shiraz480 (27)in technology • 6 years agoLecture 18-- Create a view of the data[Instructor] Because our data tables are related together using primary and foreign key fields, we can pull information out of multiple tables and piece it together again into a single location.…shiraz480 (27)in technology • 6 years agoLecture 17-- Add data with an INSERT statement[Instructor] New records can be added in to your data tables using the Transact-SQL key word, Insert. To use it, we'll specify the columns that we want to insert data into, and then supply a list of…shiraz480 (27)in technology • 6 years agoLecture 16-- Write an UPDATE statement[Instructor] Using a query, we can update data that's stored in the data tables. This will require the use of a new keyword that we haven't seen yet called Update. First, I want to review the…shiraz480 (27)in technology • 6 years ago625938_04_02_XR15_Functions[Instructor] Besides pulling information out of our database in an organized fashion, queries will also help us out to view a bigger picture of what's going on within the organization. We can use…shiraz480 (27)in technology • 6 years agoLecture 14--Create a SELECT statement[Instructor] When it's time to start retrieving information that's stored in your tables, you'll turn to an activity called querying the database. In order to query the database, you'll need to…shiraz480 (27)in technology • 6 years agoLecture 13-- Join tables together with keys[Narrator] Because we're using primary key columns in our data tables to uniquely identify individual records, we can use this information in other tables to make relationships between them. By…shiraz480 (27)in technology • 6 years agoLecture 12--Create a database table[Instructor] In order to store data in a database, we need to create a table. The structure of a table is critical in creating a database that's easy to navigate and retrieve information from later.…shiraz480 (27)in technology • 6 years agoLecture 11-- Understand SQL data types[Instructor] Before we can start storing information in our database, we need to understand a little bit about how tables are structured and the types of data that can be stored. Tables are made up…shiraz480 (27)in technology • 6 years agoLecture 10-- Create a new database on the server[Instructor] Installing an example database is a good start, but what you probably want to know is how to create a database for your own personal projects or organization. Creating databases in SQL…shiraz480 (27)in technology • 6 years agoLecture 9-- Install a sample database[Instructor] Microsoft produces sample databases for a SQL server that are commonly used in training courses and tutorials that you're sure to come across in your journey towards becoming a database…shiraz480 (27)in technology • 6 years agoLecture 8-- Tour the SSMS interface[Instructor] Management Studio, or SSMS, will serve as the main interface when you're working with SQL Server. After logging into the server, using my Windows Authentication Account, we'll see this…shiraz480 (27)in technology • 6 years agoLecture 7-- Locate SQL Server documentationHaving official documentation at your fingertips will be invaluable as you start your journey into learning SQL server. You can find the docs for SQL server 2017 by visiting the url…