Uncategorized
Latest Posts
-
What are the Top Ten Databases?
Everyone has their favorite DBMS, is your favorite one of the top databases? Though some non-relational products have entered the top ten, the relational paradigm remains firmly entrenched in the database world. However specialized database types such document store databases and wide column stores are gaining in popularity to become top databases. Top of the…
-
Ten Things a Junior DBA Should Learn
There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations group, and developers. A DBA must understand concepts from all these facets of IT as well as be able to draw upon knowledge of their production environment to troubleshoot performance, hardware, and software…
-
SQL Tutorial for SQL Server
Welcome to Essential SQL Online SQL Tutorial. Use this page to get started learning SQL. SQL Tutorial Overview Use SQL (Structured Query Language) to query a relational database. You use SQL to “tell” the database what results that you would like to see. Since the database stores its data in tables, which are made up…
-
5 Typical SQL Syntax Mistakes
For a beginner, learning any kind of programming language can be challenging and can cause you to make mistakes quite often. However, this is how we learn. Learning SQL syntax programming involves the same concept. After a while, you will start to see common patterns in those mistakes, and you will learn more as we…
-
70-761 Exam: Newly Added Topics
In the 70-761 exam covers the SQL Server 2016. Since this exam covers the data query, most of the topics that are included in the 70-461 exam are also covered. So, if you are familiar with that exam, then you are in luck! If not, then I would recommend that you check out our study…
-
6 Suggestions About Writing A Resume for Business Intelligence
Whether you are a database administrator, programmer, or an SQL specialist, who is looking for employment, your resume will often be the deciding factor whether or not you get hired. According to The Motley Fool, 40% of employment managers spend less than a minute reading through a resume. They look for elements such as an…
-
Learn SQL Server
“How do I start learn SQL Server?” That is the most popular question I’m asked. Many people just don’t know where to start. I understand! SQL is a simple enough language to write basic queries, but putting together all the pieces to get started isn’t straight forward. So, if you’re looking to get started learning…
-
9 Best Study Tips for 70-761 Certification
Check out these 9 best study tips I came across in to help you with 70-761 certification. If you’re planning on studying for exam 70-761, the I would recommend that you put these good habits into practice today. You’ll see that cramming isn’t effective, so its best to plan ahead. 9 Best Study Tips Whether…
-
EssentialSQL 70-761 Resource Page
To help you get the most out your studying time, I put together this 70-761 resource page to help you succeed in getting ready for your certification. These resources help you prepare to take the 70-761 Querying Microsoft SQL Server Certification exam. Microsoft’s Official 70-761 Resource Page When preparing for the 70-761, your first stop…
-
How to Create a 70-761 Study Plan Today!
Studying and preparing for the 70-761 can be intimidating. There are many topics you need to cover, but with so little time. It can be overwhelming! So why not create a 70-761 study plan and reduce that stress? The plan will help you in understanding what topics to study, the study order, and how many…
-
70-761 Certification and Study Guide
Recently Microsoft released “Exam 70-761: Querying Data with Transact-SQL – Microsoft.” To help you study for this certification, I put together my 70-761 study guide. This guide is an update from the prior, which covered the 70-461 certification. The study guide includes every topic you should study to pass the 70-761. The guide is also…
-
What is a Dynamic Pivot Table?
In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server. A dynamic pivot table is a great way to summarize data. And given that Business Intelligence is a hot topic, knowing how to create one is key. By reading this article you’ll learn to create a dynamic pivot…
-
Learn how to Work Joins and Messy Data
In this puzzle, we are going to learn how to join dirty data using the SQL Server. There are many instances that you are forced to use someone else’s data. Since it is their system and data (not yours), then you can’t always fix the inconsistently formatted data before it is in the database. So…
-
How to Study for the 70-461 Exam
Preparing for the 70-461 Exam In order to be successful studying for the 70-461 exam, you’ll need a good strategy and plan. Before we get into how to study for the 70-461, I want to tell you a quick story. Back in 2002 I heard a piece on National Public Radio talking about normal people,…
-
9 Best Tips for 70-461 Certification
You can do this! Pass exam 70-461. It may seem intimidating, but you can pass Exam 70-461 Querying SQL Server. All it takes is a bit of planning and basic study tips. AsapScience explains in less than four minutes study habits you can use today to get the most out of your exam prep time.…
-
Do Partial Matches Using LIKE
In this lesson you are going to explore how to do pattern matching with the SQL Where clause LIKE operator. Using this phrase allows us perform partial matches of data values and obtain answers to questions which can’t be done with conventional comparisons. The lesson’s objectives are to: learn about the like clause understand wild cards…
-
What is SQLite3?
SQLite3 Review SQLite3 is a compact free database you can use easily create and use a database. Though SQLite3 is not a full-featured database, it supports a surprisingly large set of the SQL standard, and is ideal for those just starting to learn SQL as well for developers that need a simple database engine to…
-
How to Install SQLite and the Sample Database
This is the first in a series of lessons devoted to teaching you SQL. We are going to install SQLite and then move on to the fundamentals , which means learning the command line. Do worry it is not as hard as it seem, and really, the payoff is huge. For once you learn SQL…
