SQL Basis

In SQL Basics we’ll take a look at what databases are and how you can retrieve information from them. Databases can store massive amounts of information to be retrieved at a later date. Databases act as the memory for dynamic web sites or mobile apps.

What you will learn

• Write SELECT statement to query data from a relational database
• Select specific columns
• Searching tables using `WHERE`
• Filter by comparing values

Steps you will go though during this course

Data, Databases and SQL

We'll take a look at databases, the types of structures inside them, what data is and what SQL is.

Getting Data from a Database

Reading information is the most common operation performed on a database. Whether you're a Business Analyst, Web Developer or Mobile App developer reading from databases is a must have skill.

Finding the Data You Want

Instead of getting all the information back at once isn't always what you want. Finding the information want by writing specialized SQL queries is the way to do it.

Plus, you get an access to all courses and tracks of TreeHouse for an entire year !