Login
Discover
Waves
Communities
Write
Login
Signup
shiraz480
@shiraz480
27
Followers
202
Following
184
Follow
Email digest
Resource Credits
Available
Used
Created
2018-07-04 14:17
RSS Feed
Subscribe
Posts
Blog
Posts
Comments
Communities
Wallet
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
what a Goals
Fifa is my life ▶️ DTube ▶️ IPFS
$ 0.000
2
2
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
web developer bootcamp
There'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 the
$ 0.000
3
2
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
BlockchainOverview
There'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 the
shiraz480
blockchain
8y
!
Low reputation account with an unverified outbound link, Reveal content
The Energy Sector and Blockchain
Most 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 improvements
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Excel-- 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 choose
shiraz480
creation
8y
!
Low reputation account with an unverified outbound link, Reveal content
Excel-- 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 to
shiraz480
bitcoin
8y
!
Low reputation account with an unverified outbound link, Reveal content
Mining Bitcoin 2018
As 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 a
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
conclusion
[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 of course
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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. This is
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 the
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 information
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
625938_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 queries
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 issue commands
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 formalizing
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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. To
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 of
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 Server
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 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 very
shiraz480
technology
8y
!
Low reputation account with an unverified outbound link, Reveal content
Lecture 7-- Locate SQL Server documentation
Having 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 docs.microsoft.com/sql.
Older →
