7905 Hilltop Village Center Dr, Alexandria, VA
SQL Server (latest version is 2016) has a lot to learn and can really help your career. We will teach you the basics well and get you used to the new concepts if you are coming from Access or Excel. Whether you are a user or programmer it is a big adjustment but we will make it easy.
This class starts at the beginning and walks you through the basics of SQL and SQL Server i.e.
=> Which version of SQL Server is best for you?
=> How to get started and create and access tables with SQL Server.
=> The basics of T-SQL queries and how to enter simple queries to fetch and summarize data.
=> Basic SQL queries to update, insert and delete data.
=> How to speed up queries
=> What a stored procedure is, creating them and modifying them.
=> How stored procedures differ from direct SQL queries the advantages and disadvantages.
=> Relational basics. Why ID fields matter and one-to-many and one-to-one and how those lead to many-to-many relationships indirectly.
=> The basic of normal form in Database design.
=> JOINs and how they simplify accessing relational data.
=> How developers use SQL Server to build web applications and for reporting
Also as a bonus we will discuss some essential knowledge on the non-SQL up and coming databases like Hadoop, MongoDB, CouchDB, etc. to give people some perspective on DBMS systems in general. And how these noSQL (or SQL+ as some call them) Databases differ from SQL Server.