All The SQL You Will Need Unless You Are A DBA

Learn Relational Database Concepts And How To Manipulate Data With SQL

In this course we first get to understand how relational databases work.  Relational databases are the backbone of how data is stored in the corporate world.  Once we understand that, we focus on the four main SQL statements a business user and/or application programmer are likely to use.  These four statements are SELECT(read data from the tables), INSERT(add row(s) to a single table), DELETE(delete rows from a single table), and UPDATE(change data in column(s) for selected records of a selected table).  To do this we go into a number of related topics such as JOINs, VIEWs, functions, derived fields and more.  The goal of the course is not just for you to learn the syntax of SQL statements.  The goal of this course is for you to understand how databases are organized, the logic of them, the bigger picture of what ‘relational’ means, as well as how you can manipulate the data in them.  In the course we will primarily use SQL Server, but reference Access and Excel a lot as most people without experience writing SQL will be more familiar with the concepts using these applications.  What you know in Excel is relevant to databases.  Functions are relevant.  Constructing a formula is relevant.  By the end of the class you will be very knowledgeable about relational databases and how to manipulate data using SQL.

What you’ll learn

  • The four actions a user or applications programmer can do to a relational database..
  • How a relational database works.
  • The major relational databases available to everyone for practicing.
  • Learn how to design a database, tables, and relationships.

Course Content

  • Introduction –> 1 lecture • 1hr 13min.
  • The Relational Database Model –> 3 lectures • 28min.
  • First Action: Read Information From A Database Without Changing Anything –> 8 lectures • 2hr 31min.
  • The DELETE Statement – Be Careful! –> 2 lectures • 32min.
  • Using the UPDATE Statement –> 1 lecture • 13min.
  • Using The INSERT Statement –> 2 lectures • 32min.
  • Combining Tables Using JOINs –> 1 lecture • 10min.
  • Combine Tables Using VIEWs –> 1 lecture • 6min.
  • SELECTing From Multiple Tables –> 1 lecture • 19min.
  • Conclusion –> 1 lecture • 4min.

All The SQL You Will Need Unless You Are A DBA

Requirements

  • None, just an interest in learning to be more knowledgeable and valuable in the job market..
  • A relatively modern computer or laptop. Anything from Windows 7 on up. Microsoft Access and Excel would be good to have..

In this course we first get to understand how relational databases work.  Relational databases are the backbone of how data is stored in the corporate world.  Once we understand that, we focus on the four main SQL statements a business user and/or application programmer are likely to use.  These four statements are SELECT(read data from the tables), INSERT(add row(s) to a single table), DELETE(delete rows from a single table), and UPDATE(change data in column(s) for selected records of a selected table).  To do this we go into a number of related topics such as JOINs, VIEWs, functions, derived fields and more.  The goal of the course is not just for you to learn the syntax of SQL statements.  The goal of this course is for you to understand how databases are organized, the logic of them, the bigger picture of what ‘relational’ means, as well as how you can manipulate the data in them.  In the course we will primarily use SQL Server, but reference Access and Excel a lot as most people without experience writing SQL will be more familiar with the concepts using these applications.  What you know in Excel is relevant to databases.  Functions are relevant.  Constructing a formula is relevant.  By the end of the class you will be very knowledgeable about relational databases and how to manipulate data using SQL.