Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
SQL Tutorial - Full Database Course for Beginners
In this course I ’m going to teach you everything you need
to know to get started using SQL
...
And I’m also going to show you guys
some more advanced techniques to getting information out
of a database
...
We 're going to talk about
how databases are used, why we use databases
...
Let ’s learn SQL which is one of the most popular
languages for not only jobs
...
In essence, a database is a collection of related
information that can be stored in different ways
...
You can store information
on a computer
...
So , that really, in essence, is everything you
need to know about databases
...
com keeps track of products, reviews, purchase
orders, credit cards, users, media, etc
...
With
the shopping list, we need to store 10 or 20 pieces of data
...
Or
it could be like an Excel file, or an Microsoft Excel file
...
It makes it really easy for us to manage large
amounts of information
...
The database
management system is creating and storing and keeping
track of a database
...
U
...
CRUD represents the four main
operations that we 're going to be doing with the database
...
A relational database organizes data into one or more
tables
...
A non-relational database is basically
just any type of database that is not a relational database
...
We kind of talked about
how relational databases store data in tables
...
And relational database management
systems use something called Structured Query Language ,
or SQL
...
This would store information
inside of little objects or documents
...
They
can also be stored in graphs and key value hash
...
Unlike
relational databases we can have non-relationally database
management systems
...
So, generally, the
database management system will implement their own
language
...
A database is any collection of related information
...
Database management systems make it easy
to create and maintain a database
...
Relational databases use SQL and they store data in tables
with rows and columns
...
We 'll talk about different tables can
be related to each other and how we can define
relationships between tables
...
It has to uniquely
identify the specific row
...
And therefore
we can differentiate between the two rows